In QA's Microsoft Excel 2010 Intermediate/Advanced Level courses, we show you how to create and manage PivotTables, Slicers and PivotCharts: some of Excel's most powerful features for analysing data. This course takes PivotTables to the next level, teaching you how to use PowerPivot: a free add-in available for Microsoft Excel 2010. PowerPivot links in with PivotTables, however, the data used can be manipulated and managed as though you were using a Relational Database (such as SQL or Access).
This course is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce 'Business Intelligent' type dashboard reports.
PowerPivot will not work on Microsoft Excel 2003 or 2007, it is designed for Microsoft Excel 2010 or later versions only.