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.

Functions perform a mathematical calculation on a range of cells in Excel. The most common Functions are SUM, AVERAGE, COUNT, MIN, and MAX.

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.

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.

Speak with confidence at your next financial meeting by calculating your gross profit with Microsoft Excel. Excel provides several built-in functions and operators to calculate total cost, revenue ...

Beyond SUM and AVERAGE Now that you have learned about these essential Excel functions, put them into practice. Start applying them to your own spreadsheets and see the difference they make.