Advanced Excel - Slicers
Slicers were introduced in Excel 2010 to filter the data of pivot table. In Excel 2013, you can create Slicers to filter your table data also.
A Slicer is useful because it clearly indicates what data is shown in your table after you filter your data.
Step 1 − Click in the Table. TABLE TOOLS tab appears on the ribbon.
Step 2 − Click on DESIGN. The options for DESIGN appear on the ribbon.
Step 3 − Click on Insert Slicer. A Insert Slicers dialog box appears.
Step 4 − Check the boxes for which you want the slicers. Click on Genre.
Step 5 − Click OK.
The slicer appears. Slicer tools appear on the ribbon. Clicking the OPTIONS button, provides various Slicer Options.
Step 6 − In the slicer, click the items you want to display in your table. To choose more than one item, hold down CTRL, and then pick the items you want to show.