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.

Learn how to use MINVERSE and MMULT functions in Excel. MINIVERSE returns the matrix inverse of an array,. MMULT function returns matrix product of two arrays.

Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis ...

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

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

While I'll always argue that SUM is my favorite and most-used Excel formula, there are plenty of other powerful functions included in the software. These features go far past using Excel as a digital ...

This newish function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx file.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF () function. Here's how. Illustration: Lisa Hornung, Getty Images/iStockPhoto ...

The SUM function can handle text-based calculations by integrating functions like SEARCH and ISNUMBER, allowing analysis of text-heavy datasets and quantifying qualitative data.