The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Instead of typing direct cell references (such as B2) into your formula, if you click cell B2, Excel will insert the column name into the formula to create a structured reference.

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.