Excel 2010 PowerPivot & Advanced Business Intelligence Tools


This course takes up where the Optima Train Excel 2010 Pivot Tables and Pivot Charts course leaves off. It has two primary themes, each ultimately related to data analysis with pivot tables. First, it teaches you a number of methods for importing external data (from a database, text files, or other sources) into Excel for analysis. Second, it devotes considerable time to the PowerPivot add-in introduced with Excel 2010. To learn Excel PowerPivot and Business Intelligence Tools quickly and effect