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

Share the joy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Roma

Leave a Reply

avatar
  Subscribe  
Notify of