The 5-Day Excel Challenge

Description

The challenges will ask you to:

• Generate a list of future dates
• Clean up a list of employee data
• Create a dynamic chart
• Create a pivot table to analyze sales data
• Match data across multiple lists

Syllabus :

1. Payday Chart

• Challenge: Complete a payday chart using Auto Fill and year-to-date formulas

 

2. Employee List

• Challenge: Reorder names in an employee list

 

3. Regional Sales Chart

• Challenge: Create a chart that updates automatically

 

4. Store Sales

• Challenge: Analyze sales data using a formula-free PivotTable

 

5. Salary Lists

• Challenge: Match data across different lists using VLOOKUP

Show more