Resources in Excel challenges
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: Using Multiple Sources for a Dropdown List
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: Super-Challenge! Create an Interactive Worksheet
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.
3 min
Excel Challenge 6: Using Basic Logical Functions
It’s coming up to the end of the year and there’s a scramble to take vacation days. Can you help your HR department solve this challenge?
2 min
Excel Challenge 5: Formula Super Challenge
It's time for some more fun with Excel! Try solving this Excel formula challenge from Excel MVP Alan Murray (aka. Computergaga).
3 min
Excel Challenge 4: Analyze Data With Power Query
Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).
2 min
Excel Challenge 3: Power Query and Pivot Tables
Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).
2 min
Excel Challenge 2: Clean and Transform Data with Power Query
Ready for some fun with Power Query in Excel? Try your hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga) now!
2 min
Excel Challenge 1: Use Raw Data to Create Dynamic Reports
Think you’re pretty good at Microsoft Excel? Prove it by solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga). Download the ...