All   >   Excel – Intro to Power Pivot (2024)

Excel – Intro to Power Pivot (2024)

Learn how to transform Excel into your big data power tool
Excel - Intro to Power Pivot (2024)

Course details

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.  

 

 

Topics covered include: 

  • 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 

 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains style!

 

Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion. 

Course Contents:

#  Lesson  Length 
1  Enable and Navigate Power Pivot  4:57 
2  Managing Data Relationships  9:04 
3  Creating a Power Pivot Report  9:10 
4  Creating Calculations in Power Pivot  7:52 
5  Creating Key Performance Indicators  5:29 
6  Creating a Date Table  6:20 
7  Working with Dates and Time  8:57 

Course details

Related Course Recommendations

Microsoft Sway Essentials (2025)

Microsoft Sway Essentials (2025)

Brain Bites – Unlocking Your Emotional Intelligence Potential

Unlocking Your Emotional Intelligence Potential

Leading Through Change

Leading Through Change

Systems Thinking and Process Improvement

Systems Thinking and Process Improvement

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

I am getting training for…