Excel: Power Pivot for Beginners

Get a short, beginner-friendly introduction to the robust Power Pivot feature in Microsoft Excel for Windows.

Introduction

• Doing more in Excel with Power Pivot

1. Understanding Power Pivot

• Become familiar with the Power Pivot interface

2. Building a Basic Data Model

• Get started by connecting with source data
• Create and manage data relationships
• Enhance your data by adding calculations
• Generate insights on the fly by creating measures

3. Presenting Your Data

• Analyze results using PivotTables
• Wow stakeholders with KPIs
• Illustrate results using PivotCharts

Conclusion

• Where to learn more about Power Pivot