From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add a slicer for a table
From the course: Data-Driven Presentations with Excel and PowerPoint (365/2019)
Add a slicer for a table
- [Instructor] This workbook is named Slicer, and it's called Slicer because I want to show you how to add slicers to a table. Slicers work for both regular tables that we create using the Format as Table command and for pivot tables as well. And they're useful in two different ways when we think about PowerPoint. If I have to quickly filter to be able to create a chart that is specific, for example, in our case to a sales region, and I do this repeatedly, then a slicer saves me some steps, as you'll see after we create one. The other possibility is that I might paste a hyperlink in a presentation to be able to come directly to Excel and answer some questions. And in that case, slicers make it very obvious when you are filtering data and what data does not appear with the filter applied. A quick reminder that how we would filter using the controls here in our table is we would, for example, to show Central US, turn…
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.