Free Resources

The COUNTIFS function in Excel counts the number of cells in a range if one or more conditions are true.

The SUMIFS function on Excel sums a range if one or more conditions are true.

The IFERROR function gives a value if the original output is correct, and an alternate value if there is an error.

The XLOOKUP function is a must-know for anyone looking to level up their Excel skills.

Strikethrough is an excel formatting feature that puts a horizontal line through a cell’s value.

Learn all about rows and columns in Excel, from hiding to inserting and deleting them.

Learn the easy way to perform an INDEX MATCH with multiple criteria in Excel.

Learn how to quickly unhide columns and rows in Excel with real examples and suggested alternatives.

Learn how to freeze rows and columns in Excel with our simple guide featuring simple, step-by-step breakdowns and real examples.

Learn how the “plus” (+) sign is used in Excel. Explore its common use cases with real examples and references.

Discover the power of the “and” (&) sign in Excel. Explore its common use cases and how it can enhance your spreadsheet formula writing.

Learn how to use the ROUNDUP function in Excel with usage directions, input definitions, and example use cases.

What’s the difference between XLOOKUP and VLOOKUP in Excel?

Walk through our top 8 Excel skills for finance, featuring common formulas and functions used by business, finance, and investment professionals.

Learn how to use Excel Data Validation to restrict the type of values you can enter in your Excel spreadsheet.

Learn how to use the Excel Text to Columns tool to split text into one or more cells.

Learn how to use the Excel SORT function to sort your data lists, ranges, and arrays.

Learn how to use the Excel FILTER function to filter your data lists, ranges, and arrays.