Organising Data with Subtotals in Excel

This lesson explores the feature that simplifies dataset summarisation. Subtotals enable you to calculate and display total values for different groups within a dataset. Unlike pivot tables, which may involve a more elaborate setup, Subtotals offer a quick and straightforward way to obtain insights without extensive data restructuring. Subtotals provide a clear breakdown, and the collapsible sections allow you to focus on specific details. You can also revert to the original dataset and restore your data to its initial state. Mastering Excel’s Subtotals will simplify your processes and make data analysis easier.