Learn Excel Online

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!

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!

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!

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.

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.

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.

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.

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.

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.

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.

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.

Excel Challenge 52: Data Analysis With PivotTables

Use PivotTables to perform data analysis with this sales performance Excel challenge.