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.
Using slicers to clarify and manipulate fields
Aus dem Kurs: Excel 2016 Essential Training
Using slicers to clarify and manipulate fields
- As you're working with PivotTables, it certainly makes sense at times to see less information, so we've got filters in a variety of locations, and also a relatively new feature, introduced in Excel 2010 called Slicers. We're looking at a worksheet called Slicers in our workbook 14-PivotTables. Within the PivotTable Fields List, you'll see a section called Filters. It's going to be less important in the future because of this new feature called Slicers. Let's talk about how it works. First of all, let's bring in the Product field into the filters area. Now, as you keep your eye on the PivotTable to the left, look what happens above it. It's actually part of the PivotTable, but we haven't used it just yet. It's for Product. Let's click the drop arrow here. Maybe we only want to look at Bamboo Coffee Tables. Click there. Okay, that's all we're seeing. And we're reminded of that. We see that in the heading, and of course PivotTable gets wider at some points, but we're not seeing the…
Ü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
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Creating PivotTables12 Min. 25 Sek.
-
(Gesperrt)
Manipulating PivotTable data11 Min. 27 Sek.
-
(Gesperrt)
Grouping by date and time10 Min. 50 Sek.
-
(Gesperrt)
Grouping by other factors4 Min. 40 Sek.
-
(Gesperrt)
Using slicers to clarify and manipulate fields7 Min. 10 Sek.
-
(Gesperrt)
Using PivotCharts4 Min. 42 Sek.
-
-
-