Stream Processing with a Spreadsheet [pdf]
hirzels.com
hirzels.com
Here is my blog for it – http://spreadsheets-on-steroids.tumblr.com
My idea is however to create programming environment from scratch based on the same principles, so that it doesn't have limitations imposed by Excel.
Did you investigate using LibreOffice Calc instead of Excel?