Use of Slicer in MS Excel

If we are analyzing dataset using pivot tables like this:

Use of slicer1

Let suppose there are many values in column selected as filter (here we want to know detail month wise – it has 12 values), so each time selecting value from drop down is little difficult.
Slicer can be used to simplify this scenario, as it will give a box having all possible values in selected field:

Use of slicer2

It is very easy to bring slicer in front, just follow below steps:

Step1: Keep mouse on pivot table
Step2: Insert -> Slicer
Step3: Select the column name which you want to use as filter (show in slicer)

Use of slicer3

Leave a Reply

Your email address will not be published. Required fields are marked *