Excel Slicers are easy to use visual controls added to Excel that allows to quickly and easily filter data in an interactive way by selecting values from a list.

You can add and use Slicers to select items to filter a PivotTable in a more visual way. If you have Excel 2010, you can use the new Slicers tool to make your PivotTable even easier to work with.

In Excel 2013, if you want to add Slicer to your charts, select the data range and click on insert > Slicer. Now, select the part of the data you want to use as a filter.

Use Slicers for Better Filtering: Slicers are a great way to filter your data visually. They make it easy to see which filters are applied and allow you to quickly change them.

This is the demonstration file to accompany the article, How to use a custom sort on slicer buttons in Microsoft Excel, by Susan Harkins.