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

Microsoft Power Pivot provides you with the tools needed to substantially increase Excel’s already very powerful Pivot Tables by combining different kinds of data from multiple sources. It even allows you to create custom functions inside calculated columns using the Data Analysis Expression language (DAX). With Power Pivot for Excel you can analyze your data in ways you've never before thought possible.

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.

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