Excel: Power Pivot for Beginners

Excel: Power Pivot for Beginners
Excel: Power Pivot for Beginners
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 0h 25m | 93 MB

The Power Pivot feature in Microsoft Excel 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.

Table of Contents

1 Doing more in Excel with Power Pivot

Understanding Power Pivot
2 What is Power Pivot

Building a Basic Data Model
3 Source your data
4 Create and manage data relationships
5 Add calculations
6 Create measures

Presenting Your Data
7 Analyze results using PivotTables
8 Create and manage KPIs
9 Illustrate results using PivotCharts

10 Next steps