Resources in Excel challenges
3 min
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.
5 min
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.
3 min
Excel Challenge 37: Keeping Track of Inventory
Use Excel to keep track of inventory with this challenge, guided by Microsoft MVP Deb Ashby.
4 min
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.
5 min
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.
4 min
Excel Challenge 34: Advanced Data Validation
Flex your data validation and worksheet protection skills with this month's Excel challenge.
3 min
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 ...
3 min
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.
4 min
Excel Challenge 31: Data Analysis with Power Query and Pivot Tables
Find out the solution to Excel Challenge #31!
3 min
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!
3 min
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!
3 min
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...
3 min
Excel Challenge 27: Create a Dataset Using Random Selection
Take this Excel challenge to create a database using randomly-selected values from a list!
3 min
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?
2 min
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!
2 min
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!
2 min
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?
2 min
Excel Challenge 22: Create a Dynamic Excel Chart Range
Can you create a dynamic chart range in Excel? Take our latest Excel challenge to prove it, and check out our solution!
2 min
Excel Challenge 21: Unpivoting Data Within a Table
Can you decide on the best method for extracting data using multiple criteria from this Excel table? Test your skills with this Excel challenge!
2 min
Excel Challenge 20: Calculate Years Between Two Dates
Choose the best Excel date function to calculate the number of years between two dates with this Excel challenge!