Dump Excel, it's useless for this kind of analysis.
A TRUE multi-dimensional spreadsheet was Lotus Improv (http://en.wikipedia.org/wiki/Lotus_Improv). Brilliant software, easy to use, but killed by corporate stupidity - Lotus was afraid that it might interfere with their sales of 1-2-3...
Quantrix Modeler (http://www.quantrix.com/) is the modern replacement, definitely deserves wider recognition.
Incidentally, Improv came with a demonstration animation explaining its concept and advantages; you get one of those rare 'aha!' moments while watching it! It really was a revolutionary, next-generation product.
Contact me if you're not sure where to obtain Improv... ;-)