Introduction:

This program is designed for advanced Microsoft Excel users 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.

What Will You Learn:

Upon successful completion of this program, learners will be able to:

• become familiar with the PowerPivot application and import data;
• manipulate data in a PowerPivot worksheet;
• create reports using PowerPivot data;
• use DAX functions in PowerPivot;
• distribute PowerPivot Data.

Target Group:

This program is designed for advanced Microsoft Excel users 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.

Pre-requisite: 

Before attending this program, learners need to be able to:

1. good knowledge of Microsoft Excel;
2. basic knowledge of Database Relationships (preferable but not unnecessary);
3. good knowledge of Excel formula/function to manipulate data;
4. understand the features of PivotTables, such as the areas designed for fields.