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