★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]
★ Download the example file★
[ Ссылка ]
★ 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:
[ Ссылка ]
[2] Cube Formulas - The best Excel formulas you're not using - Macrodinary: [ Ссылка ]
[3] An intro to Cube functions for PowerPivot - BI Gorilla: [ Ссылка ]
[4] How to use PivotTable - GetPivotData - Contextures: [ Ссылка ]
[5] Excel GETPIVOTDATA function: Excel Jet: [ Ссылка ]
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]
★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]
#MsExcel
Ещё видео!