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.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

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

Excel ROW function will return the row number of a reference. ROWS will return the number of rows in a column. Learn how to use the Row and Rows function in Excel.

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

However, the MOD function is rarely used on its own—its true value really comes to the fore when it's used alongside other Excel functions and tools.