GETPIVOTDATA vs CUBE functions | Extracting data from a PivotTable | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Download the example file★ https://exceloffthegrid.com/getpivotdata-vs-cube-functions/ ★ About this video ★ We’ve been able to create PivotTables in Excel since the mid-1990s. Ever since then, people have been asking how to extract data from PivotTables using formulas. In this video I will show you 3 options for this: 1) Standard cell references 2) GETPIVOTDATA 3) CUBE functions This is not an in-depth look into any one approach but intended to highlight the differences so you can make the best decisions for your scenario. 0:00 Introduction 1:03 Example Data 2:36 Option #1: Standard cell references 4:24 Option #2: GETPIVOTDATA 8:20 Option #3: CUBE functions 16:20 Which is the best option to use? ★ Useful links ★ [1] Tips & Tricks for Writing CUBEVALUE Formulas - Excel Campus: https://www.excelcampus.com/cubevalue-formulas/ [2] Cube Formulas - The best Excel formulas you're not using - Macrodinary: https://macrordinary.ca/2020/08/19/cube-formulas-the-best-excel-formulas-youre-not-using/ [3] An intro to Cube functions for PowerPivot - BI Gorilla: https://gorilla.bi/excel/cube-functions/ [4] How to use PivotTable - GetPivotData - Contextures: https://www.contextures.com/xlpivot06.html [5] Excel GETPIVOTDATA function: Excel Jet: https://exceljet.net/excel-functions/excel-getpivotdata-function ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter: https://twitter.com/exceloffthegrid #MsExcel