Member Since: 20th Jan 2012
I am a chartered accountant (England & Wales) who has worked in business intelligence for over 20 years. For much of that time I have designed and developed financial planning and analysis solutions using OLAP tools that have tight Excel integration. I have also authored training courses used to train the users of these solutions.
I have presented at various Excel and BI-related seminars and conferences, and am a Microsoft IT Certified Professional (BI).
I operate an Excel/BI information-and-products web site: http://www.excelcraft.com
21st May 2015
If you re-engineer in Excel (2010 or higher) take a look at Power Pivot. There is a learning curve, but it is a more robust platform on which to build your consolidation model, and your are still in Excel.
4th May 2014
Prototype in Excel
I concur with FC2013 and Rick Deckard. Excel offers a great deal of functionality in this arena and a great way to dump a lot of data into Excel (to use Rick's words) is to dump it into Power Pivot, from which you can build PivotTables, cube formula reports, and Power View reports. There is a bit of a learning curve and that's where I highly recommend Simon Hurst's tutorials. I consider myself somewhat Excel savvy but have learned a lot from Simon. And if you end up going with another visualisation tool, Excel is a good place to prototype your initial designs.