Excel 365 Power Pivot

Course Description

This course takes a look at the free Power Pivot add-in for Microsoft 365 Excel. Its aim is for all users of Power Pivot to get a good grasp of how works and its feature set. It covers different features of the interface, techniques for manipulating and visualizing Power Pivot data, how to create Power Pivot reports, the structure of DAX functions, and ways to distribute Power Pivot data.
1 days
Contact us for pricing
 

Prerequisites

To ensure your success, we recommend you first take at least our Excel Intermediate course, but ideally Advanced or have equivalent knowledge.

Getting started

Enable and Navigate Power Pivot
Import Data from Various Sources
Refresh Data from a Data Source
Create Linked Tables

Manipulating Power Pivot Data

Managing Tables
Creating Calculated Columns
Sort and Filter Power Pivot Data
Create and Manage Table Relationships

Visualizing Power Pivot Data

Create PivotTables
Create PivotCharts
Create Key Performance Indicators (KPIs)
Filter Data Using Slicers
Create Sparklines
Apply Conditional Formatting

Using DAX Functions In Power Pivot

Diagram view
Auto-detection
Manually creating

Pivot tables

Manipulate Power Pivot Data Using DAX Functions
Extract Data from Tables Using Functions
Work with Time Dependent Data

Distributing Power Pivot Data

Protect Data
Saving Data in Different File Formats
PowerPivotExcelDAXPower Pivot