Financial Services, Consulting and BusinessMarketing, Sales and CommunicationsSocial Impact, Education and GovernmentTechnology, Data and Science

The 5-Day Excel Challenge

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.

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

Starter and solution files for Excel 2010, 2013, 365, and Excel for Mac 2011 are provided in the exercise files, so you can follow along with your version of Excel.

Learn More