Overview
-
Take this fun and fast 5-day Excel challenge to test your Excel skills.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- Challenge: Complete a payday chart using Auto Fill and year-to-date formulas
- Solution: Complete a payday chart using Auto Fill and year-to-date formulas
- Challenge: Reorder names in an employee list
- Solution: Reorder names in an employee list
- Challenge: Create a chart that updates automatically
- Solution: Create a chart that updates automatically
- Challenge: Analyze sales data using a formula-free PivotTable
- Solution: Analyze sales data using a formula-free PivotTable
- Challenge: Match data across different lists using VLOOKUP
- Solution: Match data across different lists using VLOOKUP
- Next steps
