Learn Excel Online

How to Use the Excel ISERROR Function

Figure out whether an input will result in an error in advance with the Excel ISERROR Function.

Your Guide to VLOOKUP Table Array

Learn the most useful tips and best practices for using VLOOKUP Table Array, from Microsoft Excel expert Claudia Buckley.

Excel Challenge 24: Extract Unique Values From a Dataset

Can you leverage the power of combining Excel dynamic array formulas? Take this Excel challenge to return unique values and non-contiguous columns!

Easy VBA Message Box Tutorial

Improve the interactivity of your worksheet by adding a message box to your macro's VBA code. Learn how to create a VBA message box with this easy tutorial.

How to Divide in Excel

As simple as division may seem, learning how to divide in Excel is key to mastering some of the most complex functions and formulas.

How to Freeze Panes in Excel

Once you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting.

How To Do a Mail Merge in Excel

Looking to do mail merge in Excel? Get a step-by-step guide to mail merge in Microsoft Word using an Excel source list. See how to save time with this tool.

Excel Challenge 23: How to Break Ties When Ranking

Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?

Pivot Table Filter in Excel

Excel pivot table filters help you to display select portions of data at your discretion and zero in on a special segment.

Lookup Multiple Criteria or Return Multiple Results in Excel

Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.

Excel Challenge 22: Create a Dynamic Excel Chart Range

Can you create a dynamic chart range in Excel? Take our latest Excel challenge to prove it, and check out our solution!

The Ultimate Guide to Data Analysis in Excel

Excel is all about data! Learn these simple but essential data analysis tools in Excel.