### Functions

# How to use Substitute vs Replace in Excel

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

# How to use Sum Every nth Row in Excel

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

# How to use Sum Largest Numbers in Excel

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

# How to use Sum Range with Errors in Excel

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

# How to use Sum with Or Criteria in Excel

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

# How to use Switch function in Excel

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

# How to use System of Linear Equations in Excel

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

# How to use Tax Rates in Excel

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

# How to use Text Function in Excel

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

# How to use Text to Columns in Excel

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

# How to use Time Difference in Excel

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

# How to use Time Sheet in Excel

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

# How to use Today's Date in Excel

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

# How to use Two-way Lookup in Excel

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