Filtering Data with Slicers - Exercise

Contact Us or call 1-877-932-8228
Filtering Data with Slicers - Exercise

Filtering Data with Slicers

Duration: 05 to 10 minutes.

In this exercise, you will use slicers to filter data in Excel 2013.

  1. Open Filtering with Slicers.xlsx from your Excel2013.3/Exercises folder.
  2. Create slicers for the data for the months of January, February, and March.


  1. Click in the table. Table
  2. From the TABLE TOOLS DESIGN tab, from the Tools group, select Insert Slicer. Insert Slicer Command
  3. In the Insert Slicers dialog box, check the Jan, Feb, and Mar check boxes and click OK. Insert Slicers Dialog Box
  4. View the slicers in your worksheet. View Slicers