From the course: Excel 2013 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Inserting subtotals in a sorted list - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Inserting subtotals in a sorted list
In this worksheet called Subtotals, we've got a list of data here; it's sorted by Department and Status. And what we'd like to do here is insert subtotals every time there's a change in the Department. In fact we might even want to do that within each Department, do it by Status. So we've got a lot of Account Management people here and whenever there is a breakpoint, in other words whenever we see a change here, we'd like to insert a new row that tabulates the data from above. Now not all of our columns have data that we could tabulate. However, it might make sense to show totals for Salary, well not total for Job Rating, maybe an average. And so we can create subtotals, insert them automatically not by painstakingly doing it manually, by using a feature available on the DATA tab. In order for this feature to work sensibly, the data must be in some kind of coherent order. For example; if we want totals by Building, we're going to get totals all over the place right now because…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.