Organising Data with Subtotals in Excel

Organising Data with Subtotals in Excel

Video • 6 minutes

Learning Objectives

  1. Calculate and display total values for different dataset groups and enhance data summarisation with Subtotal in Excel.

    Lesson Description

    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.