Need big buttons that allow you to filter? Excel slicers are the answer. In this video, Dave shows how to create an Excel table, and he explains how to insert and hook up slicers to that table.
- [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 click anywhere in the data…and then click Insert, Table,…
- Identify the purpose of a filter.
- Recognize situations in which a custom filter would be most effectively utilized.
- Summarize the method Excel uses to read data when an Advanced Filter is applied.
- Recall the approach to take when creating a specific item for a picklist.
- Explain the function of a dynamic array formula.
- Name the keyboard shortcut used to make the filter menus appear in Excel.