Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

The purpose of the Bin2Hex engineering function in Excel is to convert a binary or decimal to hexadecimal. Learn how to use it properly.

Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

In Microsoft Excel, the SIGN number is a math and trigonometry function that returns the sign of a number. Learn how to use it.

Excel provides a range of automated functions for working with these stored data values, including the chart function.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...