[Lynda.com] The 5-Day Excel Challenge [2015, ENG]

Содержание

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

Скриншоты