Use the FIND function in Excel to find the position of a substring in a string.

Excel stores and calculates floating point numbers. Sometimes, the result of a formula is a very close approximation.

Formula auditing in Excel allows you to display the relationship between formulas and cells.

The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table.

This example teaches you how to get the date of a holiday for any year (2020, 2021, etc).

To get the number of days, weeks or years between two dates in Excel, use the DATEDIF function.

Use the ‘Insert Hyperlink’ dialog box in Excel to create a hyperlink to an existing file, a web page or a place in this document.

Use comparison operators in Excel to check if two values are equal to each other, if one value is greater than another value, if one value is less than another value, etc.

What’s compound interest and what’s the formula for compound interest in Excel?

Use the CONCATENATE function in Excel to concatenate (join) strings. Instead of using CONCATENATE, simply use the & operator.

This example illustrates two functions to chop off decimals in Excel.

To compare two columns, use the IF, ISERROR and the MATCH function in Excel.

This example teaches you how to create a box and whisker plot in Excel.

By default, the VLOOKUP function performs a case-insensitive lookup.

The ABS function in Excel returns the absolute value of a number.