2015
Lynda
Dennis Taylor
0:40
English

Take this fun and fast 5-day Excel challenge to test and build your Excel skills. The challenges are based on the questions that Excel expert Dennis Taylor encounters most often, and they grow progressively harder each day. For every challenge, Dennis offers a few different solutions, as well as useful time-saving shortcuts and tips.

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
Conclusion
Next steps

Download File Size:150.44 MB

---