# How to Use Find function in Excel

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

# How to Use Floating Point Errors in Excel

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

# How to Use Formula Auditing in Excel

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

# How to use FREQUENCY function in Excel

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

# How to Use holidays function in Excel

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

# How to use the DATEDIF function

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

# How to use the HYPERLINK Function In Excel

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.

# How to Use Comparison Operators In Excel to check if two values

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.

# How to use Compound interest formula In Excel

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

# How to use Concatenate function In Excel

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

# How To Add or Remove decimal In Excel

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

# How to Compare Two Columns in Excel

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

# How To Create a Box and Whisker Plot In Excel

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

# How To Create a Case Sensitive Lookup In Excel

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

# How to Get an Absolute Value In Excel

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