Microsoft Excel Advanced Pivot Tables

Course Description

This course has been developed for people wanting to use more complex functionality of PivotTables within Microsoft Excel, including the PowerPivot add-in which allows you to analyse multiple files.

Performance Based Objectives

• Create and modify existing PivotTables
• Work with calculated fields and summary tools
• Analyse multiple data sources with the PowerPivot add-in
• Create simple dashboards

Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course, including working with named ranges. A basic knowledge of how to create a simple PivotTable will be advantageous.