Productivity Revolution in Excel

on YouTube ↗58m

" summary

Demo shows four concrete Excel techniques: sparklines, conditional formatting, panel charts and slicer‑driven interactive charts built from a 2,664‑row monthly summary (sourced from millions of transactions) to make big data readable. Workflow uses PowerPivot to import Excel tables, create relationships instead of VLOOKUPs, define portable DAX measures (previous‑year and YoY %), and refresh with one click. Files stay compact; examples run on 60k rows but claim support for millions/hundreds of millions and publish to Power BI / SharePoint.

AI-written summary · about

" chapters (5)

1. 0:00Introduction and welcome
2. 4:43Small charts for big data
3. 10:50Excel visualization techniques
4. 22:57Power pivot for analytics
5. 44:28Q&A and concluding remarks

" related talks

• 02h 06mMrExcel's Most Productive Analysis TechniquesBill Jelen · PASS Business Analytics Conference 2015
• 01h 01mHow to Create Value and Present Data to Business Executives in SharePointMatt Allington · PASS Business Analytics Conference 2015
• 01h 04mThe Art of Prototyping AnalyticsKen Raetz · PASS Business Analytics Conference 2015
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 01h 05mDynamic Presentation Using Excel CUBE FormulasBob Phillips · PASS Business Analytics Conference 2015
• 59mSelf-Service Data ModelingMarco Russo · PASS Business Analytics Conference 2013
• 58mBig Data Analytics with Excel 2013Peter Myers · PASS Business Analytics Conference 2013
• 01h 01mExcel Charting TipsWayne Winston · PASS Business Analytics Conference 2013