Resources in Excel challenges
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!
2 min
Excel Challenge 19: Using Advanced Logic to Return Different Results
What Excel functions do you use when multiple combinations could lead to different outcomes? Share it with us by working on our latest Excel challe...
2 min
Excel Challenge 18: Perform a Two-Way Lookup and Approximate Match
How do you use two lookup values to return a single value in Excel? Join this month's Excel challenge to find out!
2 min
Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts
Can you summarize large pieces of data with an informative, interactive chart? Test your skills with this Excel challenge by using PivotTables and ...
2 min
Excel Challenge 16: Techniques for Manipulating Text
Practice splitting and re-formatting text using time-saving techniques in Excel!
3 min
Excel Challenge 15: Track Expenses with Data Visualization
For this Excel challenge, let's use conditional formatting to make this monthly expense sheet more visually appealing!
2 min
Excel Challenge 14: Perform a Lookup From Multiple Sources
Test your Excel skills with this multi-source, sequential lookup challenge!
2 min
Excel Challenge 13: Use Partial Match to Find Multiple Criteria
Can you filter in Excel using multiple criteria and wildcards? Test your skills by stepping up to this challenge!
2 min
Excel Challenge 12: Methods for Splitting Cell Values
In this challenge, we are experimenting with different methods of splitting data in Excel. How many methods do you know? Which method is most effic...
2 min
Excel Challenge 11: Design an Interactive Selection Form
Can you use data validation to minimize or eliminate selection errors? Test your skills with this Excel challenge!
2 min
Excel Challenge 10: Automating Repetitive Tasks With Macros
In this challenge, you get to build your first simple macro in Excel by automating a repetitive report! Can you solve this challenge?
2 min
Excel Challenge 9: Making Use of Advanced Sorting Techniques in Excel
Think sorting data in Excel is simple enough? Well, try this challenge and let's see if you still think so.
3 min
Excel Challenge 8: Create a Performance Incentive Worksheet
Use the VLOOKUP and IF functions to solve this new Excel challenge that takes you into a contact center. Take the challenge to learn real-world Exc...
2 min
Excel Challenge 7: Create an Expandable Dropdown List
Help this book store owner solve this Excel data management challenge using the XLOOKUP function.