Microsoft Excel 2021365 - Beginner to Advanced - Creating Subtotals in a List

The video tutorial explains how to add subtotals to a dataset in Excel using two methods: the Subtotal button on the Data ribbon and Excel formulas. It covers the process of setting up subtotals for different regions, viewing and modifying subtotal settings, and using the Subtotal function in Excel formulas. The tutorial highlights the flexibility and efficiency of the Subtotal button compared to manual formula entry.

What happens when you click the number buttons next to the subtotal in Excel?

What is the process to clear all subtotals in Excel?

Explain the difference between using the Subtotal button and an Excel formula for subtotals.