برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Excel: Power Pivot for Beginners (2022)

24mIntermediate2022-07-12

Authors

Joshua Rischin

Company Director of Axium Solutions

Course details

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. He then shows how to analyze the data and present your results using PivotTables and PivotCharts.

Skills covered

SpreadsheetsMicrosoft ExcelBusiness Software and ToolsMicrosoftDeep Dive (X:Y)

Concepts

0. Introduction

01 - Doing more in Excel with Power Pivot

1. Understanding Power Pivot

02 - Become familiar with the Power Pivot interface

2. Building a Basic Data Model

03 - Get started by connecting with source data
04 - Create and manage data relationships
05 - Enhance your data by adding calculations
06 - Generate insights on the fly by creating measures

3. Presenting Your Data

07 - Analyze results using PivotTables
08 - Wow stakeholders with KPIs
09 - Illustrate results using PivotCharts

Conclusion

10 - Where to learn more about Power Pivot