Learn how to summarise your data with Excel’s Subtotal tool

Excel offers lots of tools for analysing your data, from the simple formula to the mighty PivotTable. Somewhere between the two sits the “Subtotals” tool.

This nifty option allows you to group your data into sections, then get totals for each section. Excel automatically writes your “Subtotal” functions for you to do the analysis, and it even adds grouping levels so that you can expand and collapse the groups you’re interested in with a single click.

It may not be as dynamic or powerful as the PivotTable, but Subtotals are simple, straightforward and can often give you what you need.

In this video, we show you how to make the most of them…