Excel 365 Power Pivot

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.

Duration
1 day
Format
Instructor-led, in person or live online

What the course covers

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

Course dates

There are no public dates for this course yet. We also run it on request for teams. Contact us to arrange a date.