The Power Pivot feature in Microsoft Excel for Windows allows you to import, merge, and analyze data from many sources. Many people assume Power Pivot is a complex feature reserved for advanced users. Not so! In this short course, instructor Josh Rischin debunks myths around Power Pivot, explaining what it is and the best way to use it. Josh walks you through building a basic data model by identifying your data sources and creating data relationships. Then he shows how to analyze the data and present your results using PivotTables and PivotCharts.
Doing more in Excel with power pivot
- Understanding Power Pivot
What is power pivot?
- Building a Basic Data Model
Source your Data
Create and manage data relationships
- Presenting Your Data
Analyze results using PivotTables
Create and manage KPIs
Illustrate results using PivotCharts