How to Use Slicers in Advanced Excel?

Slicers are one of the best tools to analyze data quickly. Slicers can only be applied to tables and pivot tables. They help filter data quickly on multiple levels. It also shows the current filtering state of given data. 

Where we can find Slicers?

Go to Insert Tab and in the right-most corner, you will find an option name Slicer. 

Exploring Slicers

Given a data set of student Names, Sections, Exams, and Physics marks. Show the filtered data of students name Diksha and Raj of Section A with the help of slicers. 

Steps

Step 1: As Slicers work only for tables and pivot tables. So the current cell should be inside a table only. Go to Insert Tab and click on Slicer. A pop-up name Insert Slicers appear. 

Step 2: Select the fields in which you want to apply to sort. For this data set, we are selecting Name and Section. Click Ok. Now two more pop-up appears one is Name and another one is Section. 

Step 3: The pop-up that appeared has items in each field. We can select multiple items by pressing Ctrl and clicking the items you want to select. Some advance options are: 

1. Clear Filter: It clears all the selected items in the field. Shortcut for Clear Filter is Alt + C.  
2. Multi-Select: It helps select various items in a given field. Shortcut for Multi-Select is Alt + S.

Step 4: Select Diksha and Raj in the Name field. Now, all the rows with the name Diksha and Raj appear. 

Step 5: Selecting A in Section Field. This filters all the students’ names Raj and Diksha of Section A. 

Step 6: Hence, we got all the students of Section A having names Raj and Diksha.

 The Slicers help filter large amounts of data very quickly and help us analyze the insights from that data.