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

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

To use the function, you simply enter the function name at the sheet level, as you would any of Excel’s built-in functions. That’s all great, but there’s more.

Normally, you enter a formula and use the fill handle to copy the formula as needed. For example, using the data range shown below, you might enter a SUM() function that sums B3:E3 in cell F3.