Excel will continue to provide the dominant paradigm for end-user BI consumption. For Excel specifically, the number one analytic tool by far with a home on hundreds of millions of personal desktops, Microsoft has invested significantly in ensuring its continued viability as we move past its second decade of existence, and its adoption shows absolutely no sign of abating any time soon. With Excel 2010’s arrival, this includes significantly enhanced charting capabilities, a server-based mode first released in 2007 called Excel Services, being a first-class citizen in SharePoint, and the biggest disruptor, the launch of PowerPivot, an extremely fast, scalable, in-memory analytic engine that can allow Excel analysis on millions of rows of data at sub-second speeds. While many vendors have tried in vain to displace Excel from the desktops of the business user for more than two decades, none will be any closer to succeeding any time soon. Microsoft will continue to make sure of that.Excel remains my preferred financial modeling and risk analysis platform for all the reasons cited above (although the copy of Excel on my computer has been "souped-up" for professional use). Visit my website linked elsewhere on this page to learn more.
Visual Basic for Applications (VBA) 7.0