I wonder if there's an opportunity for a product that introduces a more powerful programming language and steps away from doing all the calculations on a grid, but that keeps the intuitiveness of Excel.
So the reason excel won as the common mans programming language is that it doesn't force you to learn everything all at once. It starts you off as just a table of sorts (useful on its own), then you can graph stuff (useful), then you learn about sum(a1:a30) (useful), and you just keep going down the rabbit hole until you've mastered everything.
The only thing that I really hate about Excel is that Procs cannot be run in parallel, otherwise so many other cool things would be possible.
last time I checked, at least.
I think Excel 2007 and further, Excel 2010 improved on that. Pivot tables, formula calculations and many other addins (not sure about Solver) use multi-threading.
In the programmability space there's also SIAG (Scheme in a Grid).
For analysis you might also look at Quantrix and SuperTable for inspiration.