Free Excel Tutorials & Practice

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.

Excel Challenge 29: Make a Progress Bar in Excel

Challenge your ability to create a functional progress bar in Excel with this workout, then check out our expert's solution!

10 Most Common Excel Errors (and How to Fix Them)

Understand and solve common Excel errors, such as #DIV/0!, #N/A, #NAME? with this comprehensive guide and handy tips for error checking and formula auditing.