Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Power Pivot for Beginners

via LinkedIn Learning

Overview

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

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.

Syllabus

Introduction
  • Doing more in Excel with Power Pivot
1. Understanding Power Pivot
  • What is Power Pivot?
2. Building a Basic Data Model
  • Source your data
  • Create and manage data relationships
  • Add calculations
  • Create measures
3. Presenting Your Data
  • Analyze results using PivotTables
  • Create and manage KPIs
  • Illustrate results using PivotCharts
Conclusion
  • Next steps

Taught by

Joshua Rischin

Related Courses

Reviews

Start your review of Excel: Power Pivot for Beginners

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free