Slicers act as visual filters, allowing you to filter and visualise your data as either in a table or as a chart. You can easily create Slicers in Excel.

  1. First enter your data into Excel and put it into a table with headers.

excel slicers

2. Highlight your data in the table, click the design tab and then click insert Slicer.

excel slicers

3. Select the Slicer that you want to add and click OK.

Excel Slicers

4. The Slicer can then be used to filter your data.

excel slicers

5. If you add a chart you can also use the Slicer to filter the data in that.

excel slicers excel slicers