Resources in Excel challenges
![Excel Challenge 22: Create a Dynamic Excel Chart Range](https://www.goskills.com/blobs/blogs/628/ac167272-3664-401b-afaf-2fd3d0defc58-thumb.jpg)
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!
![Excel Challenge 21: Unpivoting Data Within a Table](https://www.goskills.com/blobs/blogs/618/60942d11-4b22-430e-a3a1-65ae87036ee0-thumb.jpg)
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!
![Excel Challenge 20: Calculate Years Between Two Dates](https://www.goskills.com/blobs/blogs/603/4ec55367-3f28-455f-b3ba-9ae5e63a233a-thumb.png)
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!
![Excel Challenge 19: Using Advanced Logic to Return Different Results](https://www.goskills.com/blobs/blogs/596/9c498656-5d85-4a9a-bc46-3b354b78dc39-thumb.jpg)
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...
![Excel Challenge 18: Perform a Two-Way Lookup and Approximate Match](https://www.goskills.com/blobs/blogs/592/c58c5d1d-8776-4571-a2a7-84b1b384691d-thumb.jpg)
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!
![Excel Challenge 17: Summarize Data with Interactive PivotTables and Charts](https://www.goskills.com/blobs/blogs/582/adb78b11-f79e-457b-ba4a-7c94b6edea62-thumb.jpg)
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 ...
![Excel Challenge 16: Techniques for Manipulating Text](https://www.goskills.com/blobs/blogs/576/ba1b1d7c-eb38-4381-90b7-487d9190cd12-thumb.jpg)
2 min
Excel Challenge 16: Techniques for Manipulating Text
Practice splitting and re-formatting text using time-saving techniques in Excel!
![Excel Challenge 15: Track Expenses with Data Visualization](https://www.goskills.com/blobs/blogs/571/d653cd8e-b751-4bda-ae3f-63b3906ad9b8-thumb.jpg)
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!
![Excel Challenge 14: Using Multiple Sources for a Dropdown List](https://www.goskills.com/blobs/blogs/568/de13488c-d9b4-4f99-80a3-76ed5c36be5c-thumb.jpg)
2 min
Excel Challenge 14: Using Multiple Sources for a Dropdown List
Test your Excel skills with this multi-source, sequential lookup challenge!
![Excel Challenge 13: Use Partial Match to Find Multiple Criteria](https://www.goskills.com/blobs/blogs/562/5c020517-76ba-4f64-8711-44f0ea3b2389-thumb.jpg)
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!
![Excel Challenge 12: Methods for Splitting Cell Values](https://www.goskills.com/blobs/blogs/559/8ff5824c-bd2b-4fb6-aef8-602e0d141c02-thumb.jpg)
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...
![Excel Challenge 11: Super-Challenge! Create an Interactive Worksheet](https://www.goskills.com/blobs/blogs/555/b18934b3-1571-4ab2-8e81-caec4882e698-thumb.jpg)
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!
![Excel Challenge 10: Automating Repetitive Tasks With Macros](https://www.goskills.com/blobs/blogs/545/4f1d0e18-8533-48ac-975b-f58d032dc3ac-thumb.jpg)
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?
![Excel Challenge 9: Making Use of Advanced Sorting Techniques in Excel](https://www.goskills.com/blobs/blogs/539/b31782ce-4f63-4113-8bf9-08ba212c1542-thumb.jpg)
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.
![Excel Challenge 8: Create a Performance Incentive Worksheet](https://www.goskills.com/blobs/blogs/531/b9e438ad-a8fd-4ebe-bb22-0c224cbcb0a8-thumb.jpg)
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...
![Excel Challenge 7: Create an Expandable Dropdown List](https://www.goskills.com/blobs/blogs/522/c2c204e1-0f33-413b-98fe-d91efc22ed04-thumb.jpg)
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.
![Excel Challenge 6: Using Basic Logical Functions](https://www.goskills.com/blobs/blogs/506/71a6b584-3941-4e2f-9812-078e9858ef27-thumb.jpg)
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?
![Excel Challenge 5: Formula Super Challenge](https://www.goskills.com/blobs/blogs/468/6f9dfcce-b9b7-4832-86c5-39798a61f03f-thumb.jpg)
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).
![Excel Challenge 4: Analyze Data With Power Query](https://www.goskills.com/blobs/blogs/454/8c41c50f-34f5-4d06-8957-91b686f01d0c-thumb.jpg)
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).
![Excel Challenge 3: Power Query and Pivot Tables](https://www.goskills.com/blobs/blogs/437/fe4f40fd-fe0e-42f0-a58f-53c0b2e87e47-thumb.jpg)
2 min
Excel Challenge 3: Power Query and Pivot Tables
Use power query and pivot tables to solve this GoSkills Excel challenge by Alan Murray.