Free Excel Tutorials & Practice
Free Excel Tutorials & Practice
Everything you need to know to get started with Microsoft Excel.
Trusted by more than 10,000 teams worldwide
Start for freeResources
How to Use the COUNT Function in Excel
Excel is all about large quantities of data. Learn how to use the COUNT function in Excel to count your data in various ways.
What is INDEX MATCH in Excel?
Learn about INDEX MATCH in Excel. Combining INDEX and MATCH is a great way to overcome the limitations of VLOOKUP and a clever way to perform a two-way lookup.
How to Count Unique Values in Excel with the UNIQUE Function
To help you count unique values in Excel, try the UNIQUE function. Learn all about it in this beginner's guide.
Excel Goal Seek Explained (Step by Step Guide)
The Excel Goal Seek feature is a useful what if analysis tool. Learn all about it in this beginner's guide!
How to Use the Excel AVERAGEIF Function
Learn all about the Excel AVERAGEIF function in this comprehensive beginner's guide.
How to Use Conditional Formatting in Excel
Learn how to use conditional formatting in Excel to easily visualize your data.
A Beginner's Guide to What If Analysis in Excel
To help you do a what if analysis in Excel, there are three tools. Learn how to use them all in this guide - Goal Seek, Scenario Manager, and data tables.
How to Calculate Weighted Average in Excel
Explore this guide on how to calculate a weighted average in Excel using the SUMPRODUCT function.
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).
How to Calculate Averages in Excel (7 Simple Ways)
Learn how to calculate averages in Excel using the AVERAGE, MEDIAN, and MODE functions. Includes a video walkthrough and exercise file.
How to Create Pivot Table Calculated Fields
Want to level up your pivot table skills? Learn how to add and modify a pivot table calculated field with this how-to guide.
The SUMIFS Excel Function
Learn how to use the SUMIFS Excel function to add values that meet multiple specific criteria with this step-by-step tutorial.