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.

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.

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.

Learn how to create interactive dashboards and dynamic workflows in Excel using modern functions like SUBTOTAL, AGGREGATE, and SWITCH.