Microsoft Excel Resources

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.

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.

How to Add Error Bars in Excel

Error bars display the degree of variability associated with the data presented. Learn how to use them in Excel to make your charts clearer and more accurate.

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!