From the course: Excel: Filtering Data for Beginners
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Use slicers to filter - Microsoft Excel Tutorial
From the course: Excel: Filtering Data for Beginners
Use slicers to filter
- [Instructor] Here's a tip for filtering that you might really like, and that's slicers. In fact, I have some slicers up right here in this workbook already. So these panels of buttons here, these are those slicers. And they're essentially big buttons for filtering. So for example, if I wanted to see only the sales on January 20th, I click that button, and the data would filter just showing you January 20th sales. You can clear the filters by clicking this clear button, and then it works continuously. So I could go ahead and click Jan, and I could also click Company H, and then I could see, okay, what are chocolate biscuits sales for company H look like? And there you go, we got 'em right there, because our slicers filtered this data. So how do you make these slicers? Well first of all, you got to make an Excel table, and I'll show you how to do that. We're going to head on over to this data sheet, and we're going to turn this regular old data into an Excel table. So I'm going to…
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.