Microsoft Excel : Learn How to use Power Pivot in Excel

How to use Power Pivot in Excel Quick Short Course. Step by Step Course about using Power Pivot in Microsoft Excel

In this step-by-step Quick Short Course, Learn How to use Power Pivot in Microsoft Excel.

What you’ll learn

  • How to enable Power Pivot Ad-in. How to create a Data Model in excel using Power Pivot..
  • Learn about Relationships, Calculations and Measures..
  • How to Insert PivotTable from data model..
  • Learn about KPIs, PivotChart and Slicers.

Course Content

  • Using Power Pivot in Microsoft Excel –> 9 lectures • 37min.

Auto Draft

Requirements

  • Microsoft Excel.

In this step-by-step Quick Short Course, Learn How to use Power Pivot in Microsoft Excel.

 

Power Pivot is a data modeling technology that lets you create data models, establish relationships,

 

and create calculations. With Power Pivot you can work with large data sets, builds extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.

 

Power Pivot: Powerful data analysis and data modeling in Excel

 

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 both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.

 

For this course project you need to download the attach sample files.

 

Then we will do a brief overview of those sample files. And then you need to perform the following task in your Excel.

 

Project Task :-

 

Enable Power Pivot add-in

Create a data model

Define relationships, Calculations and Measures

Insert PivotTable from data model

Also do Practice for KPIs, PivotChart and Slicers