Free Resources

Learn how to separate names in Excel into different columns using 3 different methods.

Learn to Count Unique Values in Excel with 3 different methods

The GROUPBY function summarises data by grouping rows and aggregating values.

The XMATCH function in Excel returns the position of an item in an array.

Cell locking is a security feature that limits access to specific cells in Excel.

Learn how to highlight duplicates in Excel.

Autofit in Excel automatically makes your columns and rows fit your data.

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.