Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

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.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.

Useful Excel functions Excel includes dozens and dozens of functions, all of which can prove useful in specific situations. For this section, I will go over three useful Excel functions that are ...

Learn how 5 powerful Excel functions can enhance data analysis, financial modeling, and reporting with practical solutions.

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Build a custom Excel function library in minutes! Learn how to use VBA, create a personal macro workbook, and design a custom ribbon tab.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.