Mastering the CUBE Functions in Excel 2013

on YouTube ↗01h 00m

" summary

Covers the seven CUBE functions in Excel 2013 and shows working examples: converting a pivot to formulas, building a sales KPI summary with slicers, sparklines and an embedded Apps for Office gauge, and combining two models (ResellerSales and WarrantySales) into one worksheet. Demonstrates cell-by-cell MDX queries, template formulas using absolute/relative refs, macro-driven top‑N generation, SharePoint/Excel Services publishing with parameters, and warns about performance hit from many queries, 255‑char expression limits, cache refreshes and rank errors.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 1:45CUBE functions overview
3. 2:27CUBE functions use cases
4. 3:53Pivot table to CUBE conversion
5. 11:01Sales report with CUBE
6. 17:01SharePoint publishing
7. 18:04Multi-data model report
8. 36:24Sparklines and charts in CUBE
9. 44:43When to use CUBE functions
10. 47:30Best practices for CUBE reports
11. 50:21Advanced macros and layouts
12. 54:13CUBE with add-ins and apps
13. 58:38Upgrading CUBE workbooks
14. 59:19Conclusion and Q&A

" related talks

• 01h 05mDynamic Presentation Using Excel CUBE FormulasBob Phillips · PASS Business Analytics Conference 2015
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 43mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure Virtual 2021
• 47mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure 2021
• 02h 15mIncreased Margins, Period: Modern Excel and the Bottom LineRob Collie · PASS Business Analytics Conference 2015
• 01h 01mHow to Create Value and Present Data to Business Executives in SharePointMatt Allington · PASS Business Analytics Conference 2015
• 02h 06mMrExcel's Most Productive Analysis TechniquesBill Jelen · PASS Business Analytics Conference 2015
• 57mTop 10 Excel Formulas for AnalystsPurna Duggirala · PASS Business Analytics Conference 2015