From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Inserting automatic subtotals

Inserting automatic subtotals - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Inserting automatic subtotals

Earlier in this course, we talked about several methods of adding numbers. And we also talked about different ways of sorting and filtering. In this movie, we'll put these concepts together to let Excel create subtotals for us automatically. If you take a look at this worksheet, we have some pretty typical information. Last Name, First Name, Department and so on. Well, let's just do some basic sorting first. Click somewhere in the Last Name field. And on the Home tab, let's go over here to Sort & Filter, and we can sort A to Z. Maybe let's go to State. Click Sort & Filter and we can sort Z to A. Well, what we want to do is we want to give some information to department heads. And you see we have all these different departments. We want the department heads to know, for example, what's the total number of hours that their people incurred, and maybe we want to tell them what's the average rate. So first thing, you want to do is go into the Department field and let's Sort & Filter A to…

Contents