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.
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.