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

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

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.

Finding the lowest or highest value in an Excel row or column is simple using the MIN () and MAX () functions, respectively. You just drop in the function and specify the range. Highlighting the ...