A slicer typically displays the components:
Filtering button that is not selected indicates that the item is not included in the filter.Filtering button that is selected indicates that the item is included in the filter.A Clear Filter button removes the filter by selecting all items in the slicer.Slicer displays the following components:Slicer header indicates the category of the items in the slicer.Border moving and resizing controls allow you to change the size and location of the slicer.Scroll bar enables scrolling when there are more items than are currently visible in the slicer.
How to use Slicers in Excel
If you want to connect a slicer to more than one PivotTable, go to Slicer > Report Connections > check the PivotTables to include, then select OK.
KeyTips to reach Slicer in Excel: Alt + N + SF Slicer can be found under the Insert tab in the Ribbon. A slicer acts as a report filter, so you can hook it up to a PivotTable, PivotChart, or CUBE function to filter them and create an interactive report. In the example illustrated below, there is a slicer in three different Countries. One or more or all countries can be selected. This would reflect a filtered data corresponding to the number of selected Countries.
In contrast, selecting a tile in a slicer in Excel is easy – it takes just one click. To select multiple tiles, use combinations of ctrl+click, shift+click, or click+drag. Using slicers to create your reports will invite interaction, enabling you and your collaborators to spend less time sifting and more time analyzing. Slicers also works with Excel Services and Excel Web App too, so you can work and share on the web as well. Hope this helps.
