Creating Outstanding Spreadsheet Models

on YouTube ↗53m

" summary

Argues that good spreadsheet models use information/transformation/presentation separation, favor formulas over VBA run buttons because code hides logic and often slows or breaks transparency, and reduce tabs/images to cut file size; shows replacing OFFSET/INDIRECT with INDEX and using INDEX/MATCH or a lookup table instead of nested IFs for clarity and speed, uses IFERROR and Go To Special to find faults, prefers incremental file versions (v1, v2...) and modern ETL tools like Power Query/Power Pivot; warns to avoid volatile functions and keep descriptive names for ranges and files.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 1:03Challenge spreadsheet conventions
3. 2:27Three pillars of good models
4. 3:49Data visualization pitfalls
5. 8:40Layout and design best practices
6. 14:20Model layouts and error propagation
7. 20:03Formula readability mechanics
8. 27:09Natural formulas vs nested IFs
9. 31:20Data visualization and presentation
10. 43:44Q&A
11. 50:56Power Pivot, file size, and volatile functions

" related talks

• 16mEXCELsioR!Cesaire Tobias · satRday Johannesburg 2019
• 01h 01mDark Matter: Domain Experts & Nextgen Spreadsheets Are Our FutureRob Collie · PASS Business Analytics Conference 2013
• 18mBold indicates negative?Luis D. Verde Arregoitia · posit::conf(2025)
• 01h 00mMastering the CUBE Functions in Excel 2013Peter Myers · PASS Business Analytics Conference 2013
• 59mSelf-Service Data ModelingMarco Russo · PASS Business Analytics Conference 2013
• 48mBest practices for developing Power BI reportsGregor Brunner · SQLBits 2024
• 49mData Modelling Showdown: Unravelling the Mysteries of Different Data Modelling ApproachesUST OLDFIELD · SQLBits 2024
• 01h 03mFrom Data to Insight – Views from Microsoft FinanceMarc Reguera · PASS Business Analytics Conference 2013