Excel – Intro to Power Pivot

Excel: Intro to Power Pivot

# of Lessons

7

Duration

1:00:27

Skill Level

Intermediate

MSRP

$20

Instructor(s)

Barbara Evers

Available Captions

Not Captioned

Also Included

Handout, Practice Files, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

Learn how to transform Excel into your big data power tool

 

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, we’ll show you everything you need to know in order to install and start using Power Pivot in Excel.  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 navigate 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

 

Quickly search for and find skills you want to master– then just point, click, and learn.

 

High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!

Course Contents:

# Lesson Length
1 Enable and Navigate Power Pivot 5:57
2 Managing Data Relationships 10:54
3 Creating a Power Pivot Report 11:43
4 Creating Calculations in Power Pivot 8:19
5 Creating Key Performance Indicators 5:41
6 Creating a Date Table 6:33
7 Working with Dates and Time 11:20

Related Course Recommendations:

Excel: Creating Dashboards
Excel: Data Analysis with PivotTables
Excel: Power Functions

Catalog Request

Login Logo