Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

The 5-Day Excel Challenge

via LinkedIn Learning

Overview

Syllabus

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

Taught by

Dennis Taylor

Reviews

4.7 rating at LinkedIn Learning based on 77 ratings

Start your review of The 5-Day Excel Challenge

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.