Introduction
Welcome
()
Using the exercise files
()
Day 1: Payday Chart
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
()
Day 2: Employee List
Challenge: Reorder names in an employee list
()
Solution: Reorder names in an employee list
()
Day 3: Regional Sales Chart
Challenge: Create a chart that updates automatically
()
Solution: Create a chart that updates automatically
()
Day 4: Store Sales
Challenge: Analyze sales data using a formula-free PivotTable
()
Solution: Analyze sales data using a formula-free PivotTable
()
Day 5: Salary Lists
Challenge: Match data across different lists using VLOOKUP
()
Solution: Match data across different lists using VLOOKUP
()
Ex_Files_5DayExcelChallenge.zip
(892 KB)