ESTIMATED AVERAGE TIME:

13hrs 15mins

​

POWERPIVOT COURSE OUTLINED:

This course takes a look at the free PowerPivot add-in for Microsoft Excel 2016. Its aim is for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data.

​

 FREE DOWNLOAD LESSON 1 

​

Lesson 1: Getting Started with PowerPivot

Average time 2hrs: 41mins

This initial lesson shows you how to: explore the PowerPivot application, import data from sources, refresh data, and create linked tables.
 

Lesson 2: Manipulating PowerPivot Data

Average time 3hrs:19mins

You will then move on to learning how to: organize and format tables, create calculated columns, sort and filter PowerPivot data, and create and manage table relationships.
 

Lesson 3: Creating PowerPivot Reports

Average time 3hrs: 59mins

In this lesson, you build upon what you have learned by being shown how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually.
 

Lesson 4: Using DAX Functions in PowerPivot

Average time 2hrs: 12mins

Here, you will learn how to: manipulate PowerPivot data using DAX functions, extract data from tables using functions, and work with time dependent data.
 

Lesson 5: Distributing PowerPivot Data

Average time 1hrs: 02mins

This course wraps up with a look at how to protect reports and how to save reports in different file formats.

​

​

​