
Advanced Excel for Business
- Introduction
- Lesson 1: Names
- Lesson 2: Debugging
- Lesson 3: Dates and Times
- Lesson 4: Charts
- Lesson 5: Conditional Formatting and Data Validation
- Lesson 6: External Data Acquisition
- Lesson 7: Data Tables and Lists
- Lesson 8: Arrays
- Lesson 9: Circular References, Goal Seek, and Solver
- Lesson 10: PivotTables
- Lesson 11: Financial Formulas: Part 1
- Lesson 12: Financial Formulas: Part 2
- Lesson 13: Counting and Summing
- Lesson 14: Lookups
- Lesson 15: Text
- Lesson 16: Megaformulas
- Lesson 17: Importing and Cleaning Data
- Lesson 18: VBA: Basics
- Lesson 19: VBA: Control Flow
- Lesson 20: VBA: Debugging, Errors, and Help
- Lesson 21: VBA: Creating Functions Practice
- Lesson 22: Miscellaneous Calculations
- Lesson 23: Monte Carlo Simulations
- Lesson 24: Power Pivot