Aus dem Kurs: Excel 2016 Essential Training
So erhalten Sie Zugriff auf diesen Kurs
Werden Sie noch heute Mitglied und erhalten Sie Zugriff auf mehr als 23.100 Kurse von Branchenfachleuten.
Inserting subtotals in a sorted list
Aus dem Kurs: Excel 2016 Essential Training
Inserting subtotals in a sorted list
- We're looking at a worksheet called Subtotals in the workbook 12 - Data Management Features. As we scroll up and down here we can quickly see this list is sorted by Department. And you might not notice it's also sorted within that by Status. We might want to insert subtitles every time there's a change in the department. We've got lots of different departments represented in this list. Doing this manually would take quite a while. And since we've also got it sorted within that by Status we might even want to have a multi-layered set of subtitles here. We can do this efficiently with a feature called Subtotal. It's on the Data tab on the far right. You must sort the data ahead of time if you expect coherent results. So let's say this example here it's been done. Active cell can be anywhere within the data, we go to the Subtotal button, Data tab in the outline group. Every time there's a change in what department. Now often this might be Employee Name because it's the first column. If…
Üben mit Projektdateien
Laden Sie die Dateien herunter, die von den Trainer:innen verwendet werden. So können Sie mitlesen und durch Ansehen, Zuhören und Üben lernen.
Inhalt
-
-
-
-
-
-
-
-
-
-
-
-
-
-
(Gesperrt)
Sorting data9 Min. 44 Sek.
-
(Gesperrt)
Inserting subtotals in a sorted list8 Min. 39 Sek.
-
(Gesperrt)
Using filters6 Min. 43 Sek.
-
(Gesperrt)
Splitting data into multiple columns8 Min. 26 Sek.
-
(Gesperrt)
Splitting and combining columnar data with Flash Fill6 Min. 40 Sek.
-
(Gesperrt)
Removing duplicate records2 Min. 23 Sek.
-
(Gesperrt)
Using validation tools10 Min. 45 Sek.
-
(Gesperrt)
-
-
-
-