Excel 2010 : Slicer - New Filtering Technology

Today we will look into one of the new feature of Excel 2010 - Slicer.
Slicer is helpful to drill-down and analyze the data. Let us see how it will work.

Open the sales report.


Pivot table gives the in-built filter option and grouping too. Slicer is adding more drill-down options.
Insert the slicer from Insert -> Slicer.





You will get the option to select the column in which the drill-down needs to be done. Select the required field or fields; this will add one slicer per field. I am selecting two fields Product and Customer.





We can do the drill down by using one slicer or using both slicers.