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
PDF Downloads
Exercise Solutions
excel2-1_challenge1.txtexcel2-1_challenge2.txtexcel2-1_challenge3.txtexcel2-2_challenge1.txtexcel2-2_challenge2.txtexcel2-2_challenge3.txtexcel2-3_challenge1.txtexcel2-3_challenge2.txtexcel2-3_challenge3.txtexcel2-4_challenge1.txtexcel2-4_challenge2.txtexcel2-4_challenge3.txtexcel2-5_challenge1.txtexcel2-5_challenge2.txtexcel2-5_challenge3.txtexcel2-6_challenge1.txtexcel2-6_challenge2.txtexcel2-6_challenge3.txtexcel2-7_challenge1.txtexcel2-7_challenge2.txtexcel2-7_challenge3.txtexcel2-8_challenge1.txtexcel2-8_challenge2.txtexcel2-8_challenge3.txtexcel2-9_challenge1.txtexcel2-9_challenge2.txtexcel2-9_challenge3.txtexcel2-10_challenge1.txtexcel2-10_challenge2.txtexcel2-10_challenge3.txt