Welcome to ONLC Training Centers

Power Pivot in Excel Level 1 Course Outline

 (2 days)
Version 2013

PowerPivot is a add-in for Excel that greatly extends the pivot table. PowerPivot offers improved data summarization and cross-tabulation as well as expanded data capacity, and advanced calculations. As a result, PowerPivot falls under Microsoft's Business Intelligence offerings. This product brings the power of advanced analytics to the average Excel user.

Excel Versions
PowerPivot is an add-in program for Excel 2010 and Excel 2013. Its features are also integrated into Excel 2016. This course is taught using Excel 2013 software but the concepts are identical with Power Pivot implementations found in Excel 2010 and 2016 (or Office 365).

Target Student
This course is for individuals whose job responsibilities include complex Excel reports and advanced analytics.

Excel Introduction or equivalent skills. Previous experience with pivot tables is helpful but not required.

Lesson 1 Understanding Power Pivot
     What is Power Pivot
     Why use Power Pivot
     Excel versus Power Pivot
     Pivot Table Examples with Excel Data
     Power Pivot Examples with a Data Model

Lesson 2 Working with Data
     Working with an Excel List
     Using Vlookup to add Helper Columns
     Working with an Excel Table
     Cleaning up Tables
     Working with Normalized Tables

Lesson 3 Importing Data into Power Pivot
     Understanding Acceptable Data Types
     Adding Excel Tables to Power Pivot
     Importing Access Tables
     Saving the File
     Adding and Maintaining Data in Power Pivot

Lesson 4 Creating the Data Model
     What is a Data Model
     Understanding Key Fields
     Creating Relationships between Tables in the Model
     Managing Relationships
     Create and Use Linked Tables
     Create and Use Hierarchies

Lesson 5 Using Calculations in Power Pivot
     Types of Calculations in Power Pivot
     Creating a Calculated Column
     Creating a Calculated Field (Measures)
     Implicit Calculated Field
     Explicit Calculated Field
     Understanding DAX Measure Rules and Best Practices
     Choosing Between Calculated Columns and Measures
     Creating a Key Performance Indicator (KPI)

Lesson 6 - Using Data Analysis Expressions
     Understanding Data Analysis Expressions (DAX) Formulas
     Where to use DAX formulas
     Understanding the DAX syntax
     How to create DAX formulas
     Types of operations you can perform with DAX

Lesson 7 Working with DAX Formulas
     Working with Filter Function
     Working with Time Intelligence Functions
     Using Multiple Functions is a Formula
     Using Multiple Data Tables

Lesson 8 Data Analysis with Pivot Tables and Pivot Charts
     Creating Pivot Tables
     Filtering Data using Slicers
     Add Visualizations to a Pivot Table
     Creating Pivot Charts
     Formatting Pivot Charts
     Using Multiple Charts and Tables

View outline in Word


Attend hands-on, instructor-led Power Pivot in Excel Level 1 training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Analytics Courses and select the one that's right for you.

Microsoft Gold Partner
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail


Class Format
Class Policies
Student Reviews

Bookmark and Share

First Name

Last Name