Microsoft Excel 2016 PowerPivot

Welcome to the Microsoft Excel 2016 PowerPivot course. PowerPivot is a free add-in that expands and combines the features and capabilities of PivotTables with advanced calculations. It also includes the ability to import and work with large amounts of data from a variety of data sources both inside and outside Excel.

 

After completing this course, students will be able to:

Navigate the PowerPivot application

Manipulate PowerPivot data

Create PowerPivot reports

Use DAX functions

Distribute PowerPivot data using different file formats

–

Prerequisites

 

This course is intended to help all new PowerPivot users get up to speed on how it works and its feature set. The course will cover different features of the interface, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data.

 

Topics

 

Module 1: Getting Started with PowerPivot

Module 2: Manipulating PowerPivot Data

Module 3: Creating PowerPivot Reports

Module 4: Using DAX Functions in PowerPivot

Module 5: Distributing PowerPivot Data