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.

Functions in all categories share a common set of data types such as number, text, date and Boolean. Each function accepts one or more parameters of a given type and returns a value of a given type.

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

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.