MrExcel's Most Productive Analysis Techniques
summary
Covers concrete Excel shortcuts and fixes: create a ready-to-use chart in one keystroke (Alt+F1), save it as a template and set it as default, paste new data onto a chart to update it, use double-click fill handle to copy formulas, define custom lists for custom sorts, and paste-values via keyboard/menu shortcuts. Shows pivot tricks (only ~10% of 750M Excel users build pivots) including Show Report Filter Pages to auto-create one sheet per filter, toggling GETPIVOTDATA, and vlookup debugging (use FALSE, TRIM, or an INDEX/MATCH or the two-TRUE lookup speed hack). Ends with formula-auditing tips and a “speak cells on enter” prank.
AI-written summary · about
chapters (13)
- 0:00Excel productivity tips
- 1:05Seminar format and engagement
- 8:24Basic chart creation
- 15:22Pie chart formatting updates
- 23:52Custom lists for data entry
- 36:30Joining text and copying formulas
- 41:50Clean data sets for analysis
- 51:16Sorting data and subtotals
- 1:03:30Mastering pivot tables
- 1:24:35VLOOKUP techniques
- 1:47:42Data visualization with conditional formatting
- 1:55:05Auditing spreadsheets
- 2:01:30Fun Excel tricks and recap
related talks
58mProductivity Revolution in Excel
01h 01mExcel Charting Tips
01h 00mMastering the CUBE Functions in Excel 2013
45mMagnificent 7 - Simple Tricks to boost your Power BI Development
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
47mFrom Power BI to Excel - The best of two worlds
43mFrom Power BI to Excel - The best of two worlds
49mVisualizing Data: the Good, the Bad, and the Ugly