Excel CUBE Functions can do everything a PivotTable does and more!

Подробнее о видео

Get started with Excel CUBE Functions the EASY way! Download the practice workbook here:

CUBE Function List and Reference Guide:

0:00 Introduction
0:21 Creating PivotTables Suitable for CUBE Functions
0:36 Converting PivotTables to CUBE Functions
1:45 CUBEVALUE Formulas
2:40 Slicer Names
3:17 CUBEMEMBER Formulas
4:25 Nesting CUBE Functions
5:42 Dynamic CUBE Formulas
6:40 Error Proofing Dynamic CUBE Formulas

Learn DAX and Power Pivot with Mynda:

Connect with me on LinkedIn: