Resources in Excel challenges
![Excel Challenge 42: Prepare an Excel Worksheet for Printing](https://www.goskills.com/blobs/blogs/809/86f6465d-aa89-4527-acf5-3018b5787872-thumb.jpg)
4 min
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](https://www.goskills.com/blobs/blogs/802/c8d12f96-e36e-4f47-b306-3ffd83cbea50-thumb.jpg)
4 min
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](https://www.goskills.com/blobs/blogs/798/7449af1c-e703-422d-a90f-dc2a69cd4e2d-thumb.jpg)
3 min
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](https://www.goskills.com/blobs/blogs/785/bfbfe281-455b-42e5-806d-03d0388c2049-thumb.jpg)
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.
![Excel Challenge 38: Data Lookup From Multiple Sources](https://www.goskills.com/blobs/blogs/780/27fed59b-d01b-48e4-97a2-b4b660692769-thumb.jpg)
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.
![Excel Challenge 37: Keeping Track of Inventory](https://www.goskills.com/blobs/blogs/773/341c1e7e-7a0e-40c5-8f5d-e0cd13e34148-thumb.jpg)
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.
![Excel Challenge 36: Calculate and Maximize Commission With What-If Analysis](https://www.goskills.com/blobs/blogs/764/d9ea8114-dc35-4574-b5a5-1b6e99ba2f29-thumb.jpg)
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.
![Excel Challenge 35: Create an Invoice Tracker](https://www.goskills.com/blobs/blogs/756/88fea6bb-d5cf-43ca-9b39-bf74d4e0077f-thumb.jpg)
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.
![Excel Challenge 34: Advanced Data Validation](https://www.goskills.com/blobs/blogs/746/8cdf7ceb-30c5-4df6-8516-364ae97cc301-thumb.png)
4 min
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](https://www.goskills.com/blobs/blogs/743/894d5c6e-ee0f-4a09-8bcb-c976adbaadd1-thumb.jpg)
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 ...
![Excel Challenge 32: Counting Values That Meet Conditions](https://www.goskills.com/blobs/blogs/739/fee22bf9-a276-4d5d-af08-9f75ae6238ba-thumb.png)
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.
![Excel Challenge 31: Data Analysis with Power Query and Pivot Tables](https://www.goskills.com/blobs/blogs/732/50da7650-9562-4ec6-8405-94ab138caea9-thumb.jpg)
4 min
Excel Challenge 31: Data Analysis with Power Query and Pivot Tables
Find out the solution to Excel Challenge #31!
![Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria](https://www.goskills.com/blobs/blogs/715/49a3dea0-e9ab-4a0c-be6f-534382f13f6d-thumb.jpg)
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!
![Excel Challenge 29: Make a Progress Bar in Excel](https://www.goskills.com/blobs/blogs/703/2f411e4d-5b45-48ed-8b8b-b89da2e59166-thumb.jpg)
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!
![Excel Challenge 28: Create a Column Chart With Conditional Formatting](https://www.goskills.com/blobs/blogs/695/4b763ca7-df1e-402b-89da-01bf5a41ab9e-thumb.jpg)
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...
![Excel Challenge 27: Create a Dataset Using Random Selection](https://www.goskills.com/blobs/blogs/677/006e5725-7429-4c1c-9267-5b19dd88e7e6-thumb.jpg)
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!
![Excel Challenge 26: VLOOKUP With Duplicates](https://www.goskills.com/blobs/blogs/666/093ab1bb-ecbc-4e73-aac5-a196186ce75b-thumb.jpg)
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?
![Excel Challenge 25: Convert Dates Stored as Text](https://www.goskills.com/blobs/blogs/653/b5b9fbbf-c907-44c1-a1d7-9532ebf8d3f6-thumb.jpg)
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!
![Excel Challenge 24: Extract Unique Values From a Dataset](https://www.goskills.com/blobs/blogs/640/19516c2c-5056-4273-932a-7fbafd97c835-thumb.jpg)
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!
![Excel Challenge 23: How to Break Ties When Ranking](https://www.goskills.com/blobs/blogs/633/8776b9e4-69e7-40d0-b240-5cad969f4e12-thumb.jpg)
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?