TOIT Training

Excel – Intro to Power Pivot (2024)

Excel – Intro to Power Pivot (2024)
  • Overview
  • Curriculum
  • Reviews

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. 

In this course, Microsoft certified trainer Barbara Evers will show you everything you need to know to install and start using Power Pivot in Excel. You’ll learn how to add tables to data models, create and use KPIs, work with dates, and use the powerful DAX functionality. Then, you’ll view the results of your work in familiar PivotTables. 

We strongly recommend you take our “Mastering Excel” courses before you proceed with Power Pivot, unless you are comfortable with advanced Excel topics including basic Pivot Tables.  

  • 7 Sections
  • 52m Duration
Expand All

Enable and Navigate Power Pivot

Managing Data Relationships

Creating a Power Pivot Report

Creating Calculations in Power Pivot

Creating Key Performance Indicators

Creating a Date Table

Working with Dates and Time

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Enabling the Power Pivot add-in and navigating its interface 
  • Managing data relationships 
  • Creating a Power Pivot Report 
  • Creating calculations in Power Pivot 
  • Creating a Key Performance Indicator 
  • Working with dates and time in Power Pivot 

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Excel – Intro to Power Pivot (2024)
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)