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 perform a mathematical calculation on a range of cells in Excel. The most common Functions are SUM, AVERAGE, COUNT, MIN, and MAX.

Excel Spreadsheets: Navigation, shortcut keys, data sort and filter, formulas and functions We start with the basics for navigating, entering, and calculating data.

The SORT function is case-sensitive and treats numbers stored as text differently from actual numbers. Ensure your data types are consistent for accurate sorting.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.