Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell ...

Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

How to Do a T-Test on Excel for the Mac. Microsoft Excel for Mac computers contains many of the same functions as Excel found on Windows computers, including the t-test function.

How to calculate depreciation for fixed assets with the straight-line method, the sum of the years’ digits method, and others, using Microsoft Excel ...

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