EXC13PP: Power Pivot for Excel 2013

Start Date Time Days Price GTR Availability
July 18, 2017 09:00 (EST) 1 $450.00 Register
July 18, 2017 09:00 (EST) 1 $450.00 Register
September 05, 2017 09:00 (EST) 1 $450.00 Register
October 24, 2017 09:00 (EST) 1 $450.00 Register

Duration: 1 Day

Course Description

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models.  Power Pivot models run in-memory so that users can analyze 100’s of millions of rows of data with lightning fast performance.


Course prerequisites include taking Excel 2013 Level 3 or an equivalent in working knowledge of the software. 

Course Objectives

Upon successful completion of this course, students will be able to become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use DAX functions in PowerPivot.


This course is for Excel Power Users, Business & Data Analysts, Financial Managers and Analysts, Planning Analysts, and Marketing Analysts.

Course Details

Explore the PowerPivot Application

  • Accessing the Power Pivot add-in
  • Navigating the interface

Working with Data

  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Manipulating PowerPivot Data
  • Sort and Filter PowerPivot Data

Working with Tables

  • Create Linked Tables
  • Organize and Format Tables
  • Create Calculated Columns
  • Extract Data from Tables Using Functions
  • Create and Manage Table Relationships

Creating PowerPivot Reports
Using DAX Functions in PowerPivot
Manipulate PowerPivot Data Using DAX Function

Power View and Power Pivot are available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.