Resources in Excel challenges
9 min
The Complete GoSkills Excel Challenges List
Browse 55+ free Excel challenges from GoSkills. Tackle real-world scenarios by skill, topic, or date — it’s totally up to you!
9 min
Free Excel Practice Exercises: Our 60th Challenge Milestone
Sharpen your spreadsheet skills with 15 free Excel practice exercises. Celebrate Excel Challenge #60 with fun, hands-on learning!
3 min
Excel Challenge 59: Consolidate Data From Multiple Sheets
Learn how to consolidate data from multiple sheets in Excel with this challenge. Use formulas only to build a dynamic multi-sheet summary report.
3 min
Excel Challenge 58: Customer Segmentation Using One Formula!
Create a customer segmentation report in Excel with one formula. Use dynamic arrays to group customers and label them Gold, Silver, or Bronze.
3 min
Excel Challenge 57: Consolidate Data from Multiple Files
Consolidating data in Excel from multiple workbooks? Learn how in this scenario-based challenge! Join our group of learners for Excel practice ever...
3 min
Excel Challenge 56 (Beginner-Friendly): Conditional Functions
Practice conditional formulas in Excel in a real-world scenario with this beginner-friendly challenge from Microsoft MVP Ilgar Zarbaliyev.
2 min
Excel Challenge 55: Analyze Sales With SUMIF & SUMIFS
Learn how to use conditional formulas SUMIF and SUMIFS in Excel to analyze sales performance in this fun Excel challenge.
3 min
Excel Challenge 54: Clean Up Messy Data With Power Query
Use Power Query to transform messy, unmanageable data into analysis-ready insights with this month's Excel challenge from GoSkills.
3 min
Excel Challenge 53: Dependent Dropdown Lists
Practice creating dependent dropdown lists in Excel with this fun challenge! Learn how our expert solved it in the easy-to-follow solution tutorial.
3 min
Excel Challenge 52: Data Analysis With PivotTables
Use PivotTables to perform data analysis with this sales performance Excel challenge.
3 min
Excel Challenge 51: Build an Amortization Schedule
Build an interactive Excel tool to track loans and payments! Master finance functions to create your own amortization schedule template.
3 min
Excel Challenge 50: Break-Even Analysis Using Data Tables
Master break-even analysis in Excel! Use data tables and conditional formatting to identify profit and loss scenarios. Take on this challenge now!
3 min
Excel Challenge 49: Create a Dynamic Lookup Tool With Images
Build a dynamic lookup tool in Excel to retrieve player details—including images! Plus, create an interactive PivotTable with slicers for easy anal...
3 min
Excel Challenge 48: Build a Library Book Tracker
Flex your Excel formula skills with this library book tracker challenge! Tackle real-world tasks and sharpen your data analysis expertise.
3 min
Excel Challenge 46: Inventory Optimization With Excel Solver
In this Excel practice exercise, optimize inventory levels across stores and warehouses! Using Solver, balance stock levels, meet demand, and minim...
3 min
Excel Challenge 45: Create an Interactive Sales Chart
If you're creating a dashboard in Excel, an interactive chart will most likely be one of the elements. Learn how to create one in this fun scenario!
4 min
Excel Challenge 44: Build an Employee Performance Review Sheet
Create a performance review sheet in Excel with weighted scores, conditional formulas, and a radar chart. Test your skills in GoSkills’ Excel Chall...
3 min
Excel Challenge 43: Assign Random Values From a List
Test your skills with this Excel challenge: create random schedules for athletes and display dynamic rosters. Dive in, explore our resources, and g...
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!
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...