The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

How to use UNIQUE () in Excel The dynamic array function, UNIQUE () has been around for a while, so it’s possible that you already know how to use it.

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.

Array: An array, an array formula, or a reference to range of cells to which you want the number of rows. How to use the ROW function in Microsoft Excel Launch Microsoft Excel. Type into the cell ...

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...