Excel Advanced
- 1. Dynamic Arrays & Modern Formulas
- 2. Advanced Lookups & Data Validation
- 3. PivotTables & PivotCharts in Depth
- 4. Power Query
- 5. Power Pivot & the Data Model
- 6. Recording Your First Macro
- 7. VBA Fundamentals
- 8. Automating Real Tasks with VBA
- 9. Auditing & Troubleshooting Formulas
- 10. Capstone — Self-Updating Sales Dashboard