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
Excel VBA Array Tutorial
Understanding Excel VBA Array is crucial in mastering Microsoft Excel.
Top 12 Excel Lookup Functions (+ Free Cheatsheet!)
Learn how to use the top 12 Excel lookup functions and download a free cheatsheet to keep for easy reference.
Understanding Excel VBA If Then Else Statements
Get a comprehensive overview of the If Then Else statement in Excel VBA and its different syntaxes.
Excel Challenge 34: Advanced Data Validation
Flex your data validation and worksheet protection skills with this month's Excel challenge.
How to Use the Excel FILTER Function
Learn how to use the dynamic FILTER function in Excel from scratch.
Formula Auditing Tools in Excel
Learn how to use formula auditing tools in Excel, like trace precedents & trace dependents, to identify and troubleshoot any formula errors.
Excel Challenge 33: What-If Analysis to Calculate Monthly Payments
Can you use Excel to calculate monthly loan payments using a what-if analysis? Do you know of any other methods? Take the challenge and share your solution!
Understanding Number Formats in Excel
Excel has built-in number formats to control how cells with numeric data appear in Excel. Learning how they work will help you represent your data correctly.
Excel Challenge 32: Counting Values That Meet Conditions
Explore ways to count values with specific criteria and flex your problem-solving skills with this month's Excel challenge.
Excel Challenge 31: Data Analysis with Power Query and Pivot Tables
In this Excel Challenge you’ll practice Data Analysis skills with Power Query and Pivot Tables. Solve a data challenge that’s based on a real-world scenario.
Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria
Take this free Excel challenge to test your ability to make dropdown lists and dynamic charts! Learn real-word skills in data management.
How to Use the OFFSET Function in Excel
The Excel OFFSET function returns a cell or range of cells based on a reference point. It can be used to bring about dynamic behavior, even in legacy Excel.