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,
👉 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
👉 Some interesting Business Cases