MS Excel Inserting subtotals in Table

Smoke Studios

In this lesson, we will learn how to insert subtotals in Excel tables to summarize data quickly. You will understand how to group data by categories, apply the Subtotal feature, and automatically calculate sums, averages, counts, and more. This lesson will help you manage large datasets more effectively and generate clear summaries without manual calculations.

Transcript

00:00To add subtotal to this table, you can simply go ahead and select it, then go to data and then click

00:06on subtotal. Go ahead and choose the unit for which you want subtotal. In my case, I'm selecting

00:12total sales and I'm pressing OK. Now, you can see the subtotals right here just like this

00:18for east, west, south and you see the grand total as well. You can go ahead and click on the minus

00:25button right here just like this to go ahead and hide these out as well and just see the totals

00:30right here without the data as well.

Category

Transcript

Comments

Recommended