Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

The TRANSLATE function in Excel enables you to translate text into over 100 languages, covering a wide range of commonly spoken languages worldwide. This function is particularly useful for ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

The DELTA function in Microsoft Excel is an engineering function, and its purpose is to test whether two values are equal. Learn how to use it.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

In this tutorial, we will explain how to create a bulleted list using the CHAR function in Microsoft Excel. Bullets are black circle points but can also be any symbol.

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

The keyword Function tells Excel that it should show up in the User Defined Functions category and run when summoned through a worksheet cell formula. I gave the function a name, commission () , that ...