Filters and Slicers

Once you have your data in a table, you can use these elements in Excel to filter your data for what you want to find. For all of these, it helps if you have converted your raw data to a table.

Filters

Creating a table automatically creates filters for each of your headers. Click on the drop down in the header to select the data you want to filter.

Filtering

Slicers

These are boxes linked to a column that have all the values of the column displayed. Clicking on one or more of these filters for those values. These are excellent if you want to create a dashboard as they are really easy to use and can look great. To create one, click into your table, and then use the Design tab that appears under Table Tools.slicers

 

Leave a Reply

Your email address will not be published. Required fields are marked *