There’s no SUBSTRING function in Excel.

This example shows the difference between the SUBSTITUTE function and the REPLACE function.

This example shows you how to create an array formula that sums every nth row in Excel.

This example shows you how to create an array formula that sums the largest numbers in a range.

This example shows you how to create an array formula that sums a range with errors.

Summing with Or criteria in Excel can be tricky. This article shows several easy to follow examples.

This example teaches you how to use the SWITCH function in Excel 2016 or later instead of the IFS function.

This example shows you how to solve a system of linear equations in Excel.

This example teaches you how to calculate the tax on an income using the VLOOKUP function in Excel.

When joining text and a number, use the TEXT function in Excel to format that number.

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.

Calculating the difference between two times in Excel can be tricky.

This example teaches you how to create a simple timesheet calculator in Excel.

To enter today’s date in Excel, use the TODAY function. To enter the current date and time, use the NOW function.

This example teaches you how to lookup a value in a two-dimensional range.