How to Use Excel Power Pivots

Live Online Learning (1 Hour)

If you already use Pivot Tables, the incredible Excel Power Pivots add-in will let you create data models that allow you to relate and combine data like never before.

Our expert trainer will show you how to create an Excel Power Pivots table from these data models, allowing you to explore, extract and calculate data in new exciting ways.

This How to Use Excel Power Pivots training session is suitable for users of Excel 2013 and 2016.

What will I learn?

Get started with Excel Power Pivots - Discover how to enable the Power Pivot Add-in for Excel 2013 and 2016.

What Power Pivot can do - Learn about this incredible new tool, what it can do and when you should use it.

How to use Excel Power Pivots - Find out how to set up your data ready to use for Power Pivot.

How to change Power Pivot views - Use the Power Pivot Toolbar to view your data tables in different views.

How to link and manage tables - Add tables into the data model, and then write formulas to create calculated columns.

How to create an Excel Pivot Table using Power Pivot - Use related table information to create Pivot Tables and perform powerful data analysis.


You should have a very good understanding of using Microsoft Excel, and know how to create standard Pivot Tables, and use the Excel Lookup function.

What Are Live Online Sessions?

Live Online gives you all the benefits of classroom training, but from the comfort of your home or office. Sessions take place on a shared online screen, where your friendly trainer will guide you and your class through the learning topic.

These interactive sessions also give you the opportunity to practice what you’ve learnt, as you take control and demonstrate your new skills to your trainer. Two-way text or voice chat is always available, for when you want to discuss a topic, need help, or want to ask any questions.


£95 per person, per session

Maximum Group Size:

6 people

Request Training

t: 0203 941 4100 | e:

Course Content

  • How to enable the PowerPivot add-in in Excel 2013 and 2016
  • What is Power Pivot
  • What can Power Pivot do
  • When can Power Pivot be used
  • How to set up your data to use Power Pivot
  • What is the Power Pivot Toolbar
  • How to use Power Pivot Toolbar to change your table view
  • How to add tables in to the data model
  • How to write formulas to create calculated columns
  • How to perform data analysis using related table information
  • How to use a timeline to filter your data