Excel: Intro to PowerPivot

Excel: Intro to PowerPivot

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, Microsoft certified trainer Barbara Evers will show you everything you need to know 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.

Over 60 minutes of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Objectives. You will be able to:

· Enable the Power Pivot add-in and navigate its interface

· Manage data relationships

· Create a Power Pivot report

· Create calculations in Power Pivot

· Create a Key Performance Indicator

· Work with dates and time in Power Pivot

Organizing A Lot of Data? This is the power tool you need to manage it.

Url: View Details

What you will learn

• Enable the Power Pivot add-in and navigate its interface
• Manage Data Relationships
• Create a Power Pivot Report

Rating: 4.16667

Level: Intermediate Level

Duration: 1 hour

Instructor: Bigger Brains