Excel – Intro to Power Pivot (2024)
- 7 Sections
- 52m Duration
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
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.