Featured post

Excel Challenge 41: Transforming Data With Excel Functions

Read more

Resources in Excel challenges

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...

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!

Join 458,117 serial learners

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

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?

Excel Challenge 25: Convert Dates Stored as Text

Excel Challenge 25: Convert Dates Stored as Text

What are your options when dates in Excel are stored as text? Take this Excel challenge for a spin, then check out our solution!

Excel Challenge 24: Extract Unique Values From a Dataset

Excel Challenge 24: Extract Unique Values From a Dataset

Can you leverage the power of combining Excel dynamic array formulas? Take this Excel challenge to return unique values and non-contiguous columns!

Excel Challenge 23: How to Break Ties When Ranking

Excel Challenge 23: How to Break Ties When Ranking

Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?