Microsoft Excel: Learn How to use Power Pivot in Excel

Microsoft Excel: Learn How to use Power Pivot in Excel
Microsoft Excel: Learn How to use Power Pivot in Excel

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. 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.

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

Requirements: Microsoft Excel

Course content
Intro
—————
How to enable Power Pivot Add-In
—————
Overview of Sample Files
—————
How to Create Data Model
—————
What is Relationships
—————
Learn about Calculations
—————
Use of Measures
—————
Insert PivotTable from data model
—————
KPIs, PivotChart and Slicers

Source: https://www.udemy.com/course/microsoft-excel-learn-how-to-use-power-pivot-in-excel/