RECOMMENDED: Click here to fix Windows errors and optimize system performance
Microsoft Excel 2010 Slicers are easy-to-use visual controls that allow you to quickly and easily filter data interactively by selecting values from a list. The slicer function provides the user with a rich visualization of the pivot table, on which dynamic segmentation and filtering can be applied to display the required data. The search filter considerably reduces the time required to search for a record in the large record.
KeyTips to get a sharp edge in Excel 2010 : Alt + N + SF
Slicer is under the tab Insert in ribbon. A slicer functions as a report filter, so you can connect it to a PivotTable, PivotChart or CUBE function to filter it and create an interactive report.
In the example below, there is a slicer in three different countries. One or more or all countries can be selected. This would reflect a filtered amount of data based on the number of countries selected.
On the other hand, selecting a tile in a slicer in Excel 2010 is easy – just one click. To select multiple tiles, use the Ctrl+Click, Shift+Click, or Click+Drag combinations.
Use slicers to create your reports invites interaction and allows you and your staff to spend less time watching and more time analyzing. Slicers also works with Excel Services 2010 and Excel Web App, allowing you to work and share on the Web.