Formulas Referencing Pivot Table Cells
Dynamic range for Pivot tables using formula & named ranges|Dynamic data source for Pivot table
Understanding the GetPivotData Formula in Excel
How to Write Formulas in Pivot Table quickly
Creating a Dynamic Range for a Pivot Table Using the Offset Function
Dynamic GETPIVOTDATA Formulas for Power Pivot - the PROPER way!
Referencing Dynamic Arrays with Tables
99% people don't know this trick of Pivot Table | Dynamic Range in Excel Pivot Table
Dynamic Pivot Table | Dynamic Range for a Pivot Table using the Offset Function
How to add a calculated field to a pivot table
I don't use OFFSET Anymore! I Use Another Function Instead.
No GETPIVOTDATA when clicking on Excel PivotTables
Excel - How to find Pivot Table's source data
Easier Table References in Excel - EQ 92
Filter your PivotTables by a list of values
Excel GETPIVOTDATA Function to Pull Data from a PivotTable
Excel CUBE Functions can do everything a PivotTable does and more!
Excel Pivot Table: How To Add a Percentage Column
How to use Vlookup for Giving range to numbers? | Easy Excel Tricks
I don't use PIVOT tables anymore... I use this other thing instead!