Featured post

Excel Challenge 41: Transforming Data With Excel Functions

Read more

Resources in Excel challenges

Excel Challenge 45: Create an Interactive Sales Chart

Excel Challenge 45: Create an Interactive Sales Chart

If you're creating a dashboard in Excel, an interactive chart will most likely be one of the elements. Learn how to create one in this fun scenario!

Excel Challenge 44: Build an Employee Performance Review Sheet

Excel Challenge 44: Build an Employee Performance Review Sheet

Create a performance review sheet in Excel with weighted scores, conditional formulas, and a radar chart. Test your skills in GoSkills’ Excel Chall...

Excel Challenge 43: Assign Random Values From a List

Excel Challenge 43: Assign Random Values From a List

Test your skills with this Excel challenge: create random schedules for athletes and display dynamic rosters. Dive in, explore our resources, and g...

Excel Challenge 42: Prepare an Excel Worksheet for Printing

Excel Challenge 42: Prepare an Excel Worksheet for Printing

In this Excel challenge, reformat and prep a messy sales worksheet for printing. Join our Slack community; you might learn a trick or two!

Excel Challenge 41: Transforming Data With Excel Functions

Excel Challenge 41: Transforming Data With Excel Functions

Take this Excel challenge to convert data in different formats using Excel functions. Which formulas will you use to organize this group of maratho...

Join 465,945 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

Excel Challenge 40: Create a Custom Excel Calculator

Excel Challenge 40: Create a Custom Excel Calculator

Would you like to build your own Excel calculator? It might be easier than you think! Take the challenge and see how our community members solved it.

Excel Challenge 39: Generate Unique Random Values

Excel Challenge 39: Generate Unique Random Values

What is the best way to generate random values in Excel? Better yet, can you make them unique? Put your skills to the test with this Excel challenge.

Excel Challenge 38: Data Lookup From Multiple Sources

Excel Challenge 38: Data Lookup From Multiple Sources

Take this Excel challenge by showing us what to do when XLOOKUP or VLOOKUP alone isn't enough to extract the values you want.

Excel Challenge 37: Keeping Track of Inventory

Excel Challenge 37: Keeping Track of Inventory

Use Excel to keep track of inventory with this challenge, guided by Microsoft MVP Deb Ashby.

Excel Challenge 36: Calculate and Maximize Commission With What-If Analysis

Excel Challenge 36: Calculate and Maximize Commission With What-If Analysis

Can you apply what-if analysis to a real-world situation? Take this Excel challenge to find out.

Excel Challenge 35: Create an Invoice Tracker

Excel Challenge 35: Create an Invoice Tracker

Challenge yourself to create a tracker in Excel that updates automatically when invoices are due soon or overdue.

Excel Challenge 34: Advanced Data Validation

Excel Challenge 34: Advanced Data Validation

Flex your data validation and worksheet protection skills with this month's Excel challenge.

Excel Challenge 33: What-If Analysis to Calculate Monthly Payments

Excel Challenge 33: What-If Analysis to Calculate Monthly Payments

Can you use Excel to calculate monthly loan payments using a what-if analysis? Do you know of any other methods? Take the challenge and share your ...

Excel Challenge 32: Counting Values That Meet Conditions

Excel Challenge 32: Counting Values That Meet Conditions

Explore ways to count values with specific criteria and flex your problem-solving skills with this month's Excel challenge.

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

In this Excel Challenge you’ll practice Data Analysis skills with Power Query and Pivot Tables. Solve a data challenge that’s based on a real-world...

Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria

Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria

Take this free Excel challenge to test your ability to make dropdown lists and dynamic charts! Learn real-word skills in data management.

Excel Challenge 29: Make a Progress Bar in Excel

Excel Challenge 29: Make a Progress Bar in Excel

Challenge your ability to create a functional progress bar in Excel with this workout, then check out our expert's solution!

Excel Challenge 28: Create a Column Chart With Conditional Formatting

Excel Challenge 28: Create a Column Chart With Conditional Formatting

This Excel Challenge asks you to create a column chart that applies conditional formatting and other advanced elements. This isn't your everyday Ex...

Excel Challenge 27: Create a Dataset Using Random Selection

Excel Challenge 27: Create a Dataset Using Random Selection

Take this Excel challenge to create a database using randomly-selected values from a list!

Excel Challenge 26: VLOOKUP With Duplicates

Excel Challenge 26: VLOOKUP With Duplicates

In this Excel challenge, some of the lookup values are duplicated in the source data set. Can you get Excel to find the right one?