The course includes mini-lessons from the Excel University series, as follows.
3 Ways to Improve Recurring-Use Workbooks (20:34)
- • Better summing
- • Identify duplicates
- • Store expanding data
3 Excel Myths Busted (16:13)
- • Little blank columns
- • Merge to center
- • Clean data manually
How to Build Bulletproof Workbooks (27:30)
- • Formula consistency
- • As it comes
- • 5 workbook design principles