Skip to main content

Resources

Resources

GoSkills blog

Tips, resources, and strategies you need to grow.

Recommended 3 minute read

Excel Challenge 63: Build a Vacation Tracker in Excel

Take on this GoSkills Excel Challenge and build a vacation tracker in Excel. Practice real-world HR scenarios and level up your spreadsheet skills!

Read more
Recommended 2 minute read

Excel Challenge 62: How to Calculate Days Between Dates in Excel

Can you calculate the number of days between two dates in Excel, excluding weekends and public holidays? Show us how in this fun Excel challenge!

Read more
Recommended 3 minute read

Excel Challenge 61: Using Conditional Logic for Employee Vacation

This exercise challenges you to write conditional formulas in Excel using a combination of conditions. The scenario is fun — employees' annual family vacation. Give it a go!

Read more
Recommended 9 minute read

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!

Read more
Recommended 9 minute read

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!

Read more
Recommended 3 minute read

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.

Read more
Recommended 3 minute read

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.

Read more
Recommended 6 minute read

What is a LAMBDA Function in Excel?

Learn how to use the LAMBDA function in Excel to create custom functions without VBA. See beginner-friendly examples and key differences from the LET function.

Read more
Recommended 3 minute read

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 every month.

Read more
Recommended 3 minute read

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.

Read more
Recommended 2 minute read

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.

Read more
Recommended 3 minute read

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.

Read more