2 Day(s)


In the Microsoft Excel PowerPivot training course, we show you how to create and manage PivotTables, Slicers and PivotCharts: some of Excel's most powerful features for analysing data.

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.

Skills Gained

  • Use a wide variety of data sources within PowerPivot
  • Create calculations within PowerPivot
  • Manage various PivotTables creates by PowerPivot


Before attending this course, students need to be able to:

  • Demonstrate a good working knowledge of Microsoft Windows
  • Demonstrate a good working knowledge of Microsoft Excel 2010
  • Demonstrate a basic knowledge of Database Relationships (if relevant to your work)
  • Understand formula/function writing to manipulate data
  • Understand basic features of PivotTables, such as the areas designed for fields

To ensure your success, we recommend the following courses have been undertaken, or equivalent knowledge gained:

  • Microsoft Office Excel 2010: Level 2 (Intermediate)

Course Specifics

Course Outline

Module 1 - Introduction and Welcome

Module 2 - PivotTable Review

  • Why Use a PivotTable?
  • PivotTable Hints and Tips
  • Connecting to External Data with PivotTables

Module 3 - Introduction to PowerPivot

  • PowerPivot Overview
  • Where do I get PowerPivot from?
  • Identifying PowerPivot

Module 4 - Connecting to Single Table Data Sources

  • Connecting to Data Different Sources
  • Pasting data into PowerPivot
  • Checking PowerPivot can Produce Results
  • Excel (flat-file database) as a Data Source
  • Importing Data from SharePoint Lists to PowerPivot

Module 5 - Working with Multiple Table Data Sources

  • Excel (linked tables) as a Data Source
  • PowerPivot Relationships
  • Access Tables (relational database) as a Data Source
  • SQL Databases as a Data Source
  • Creating a Perspective to make Field Lists Manageable
  • Filtering Data during Importing External Data
  • Database Tables as a Data Source Writing SQL Statements

Module 6 - The Diagram View

  • The Diagram View in PowerPivot
  • Managing Relationships and Tables in the Diagram View
  • Working with Hierarchies

Module 7 - Measures, Calculations and KPIs

  • Measures Overview
  • Create a Calculated Column
  • Creating a Measure
  • AutoSum Measures
  • User Created Measures
  • Working with Dates in a PowerPivot Environment
  • Creating a KPI
  • Adding a KPI to a PivotTable

Module 8 - Working with DAX (Data Analysis Expressions)

  • Sample DAX Functions
  • Writing DAX Functions
  • Time Intelligent Functions

Module 9 - Working with Slicers

  • Layout Styles
  • Using Slicers
  • Additional Slicer Settings
  • Locking a Slicer to a PivotTable

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
2 1790 £1790 2018-09-17
2 1345 £1345 2018-05-21
2 1345 £1345 2018-01-22
2 1345 £1345 2018-01-15
2 1790 £1790 2017-12-06
2 1790 £1790 2017-11-02
2 1790 £1790 2017-10-31
2 1790 £1790 2017-09-25