Functions of Different Categories in Excel. To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math ...

SMALL and LARGE Excel Functions We all know about MAX and MIN functions. They give you the maximum and minimum values of the selected data respectively.

Functions, some of the most useful tools in Excel, let you perform a variety of tasks automatically within a spreadsheet. They return different results depending on certain circumstances, such as ...

As I showed in my first Excel functions article, the serious meat in any spreadsheet is the formulas and functions that perform the calculations. Excel offers functions that you can use to make the ...

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Excel functions are the building blocks; formulas are how you bring them to life. Here's the breakdown.