Master Class on Power Pivot

Course Fee - INR 500

Why it's important!

Have you ever heard about POWER PIVOT, a more powerful tool than Pivot? This feature is mostly unexplored but through its use, one can establish relationships between multiple database, can import millions of lines, avoid lookup formulas and work upon them in Excel itself.

Note: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Microsoft 365, Office Professional 2016, etc.). It is not compatible with Mac. Before starting, ensure that you have the Power Pivot Add-in installed and the Power Pivot Menu visible in the main Excel window.

To know more on how to install it,

COURSE CURRICULUM

Master Class on Power Pivot
  • Master Class on Power Pivot
Downloadable Working Files
  • Downloadable Working FIles

Salient Features of the Course

👉 Power Pivot - When to use and concept

👉  Creating Tables and understanding Data Model

👉   Importing Database in Data Model

👉  Creating relationship between Database

👉  How to avoid VLOOKUP in millions of cells and to make file calculation fast and efficient     
       Understanding DAX formulas

 👉 Concept of RELATED and RELATED TABLE  DAX Concepts Understanding COUNT and
       DISTINCT COUNT

 👉 Some interesting Business Cases

  1. DashBoard Building with Multiple Data Base
  2. Dynamic updates in Dashboard by changing source files/Datar

👉 Q/A

SUBSCRIBE

CONNECT WITH US