Great Canadian Training Company color logo

Microsoft Excel Power Pivot Complete
(2013, 2016, 2019, 2021, 365)

What You'll Learn in Microsoft Excel Power Pivot Complete

Course Length:

12 hours (2 days)

Learning Objectives

In this course, you will become familiar with Power Pivot and its advanced selection of features. You will learn how to import multiple data sets, refresh that data, and create meaningful and powerful Pivot Tables and charts to enable you to analyze your data with ease. You will also learn about DAX and how to use it. You will:

  • Combine multiple data sources into a single consolidated report
  • Import and refresh new data
  • Add calculated columns to your tables and manage table relationships
  • Create Pivot Tables and Pivot Charts
  • Organize, format, sort and filter your Power Pivot data
  • Manipulate Power Pivot data Using DAX functions
  • Extract data from tables using functions
  • Protect your reports and save them in different formats

Target Student

This course is for individuals who are familiar with the basics of Excel and who wish to learn how to add the power of Power Pivot to their arsenal.

Course Outline

Section 1: Getting Started with Power Pivot

Enable and Navigate

Import Data from Various Data Sources

Refresh Data from a Data Source

Create Linked Tables

Section 2: Manipulating Power Pivot Data

Organize and Format Tables

Create Calculated Columns

Sort and Filter Power Pivot Data

Create and Manage Table Relationships

Section 3: Creating Power Pivot Reports

Create Pivot Tables

Create Pivot Charts

Create Power Views

Filter Data Using Slicers

Present Pivot Table Data Visually

Section 4: Using DAX Functions in Power Pivot

Manipulate Power Pivot Data Using DAX Functions

Extract Data from Tables Using Functions

Work with Time Dependent Data

Section 5: Distributing Power Pivot Data

Protect Reports

Save Reports in Different File Formats

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Microsoft Excel Power Pivot Complete

Upcoming Classes

All Public classes are held online
with a live instructor
Dates Price Qty
June 10-11, 2024
9:00 AM to 4:00 PM ET
$895.00 Online
November 20-21, 2024
9:00 AM to 4:00 PM ET
$895.00 Online
March 17-18, 2025
9:00 AM to 4:00 PM ET
$895.00 Online
* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training

Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference