In the previous post, we saw ‘How to Total the Data in an Excel Table?’, now we will learn about how to use slicers to filter data in the Excel table?
Where to Find The Slicers Option?
This option will be activated after you click on it anywhere in the table- to find this option click on the ‘Design’ tab [the design tab will be visible only when you click on the table] after that under the Tools group click on the option ‘Insert Slicer’.
Note: Click on the image

OR
Click anywhere on the table and click on the ‘Insert’ tab under the filters group click on the ‘Slicer’ option
Note: Click on the image

Slicer is like a button with the help of that you can filter data.
Create a slicer to filter data
Using the same example, let’s create a slicer filter
1.Click anywhere in the table
2. The design tab will be activated, click on the design tab under the tools group click on the Insert Slicer or click on the Insert tab under the filters group click on the ‘Slicer’ option.
In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK.
Note: Click on the image

Notes:
- If you want to select more than one item, hold Ctrl, and then select the items that you want to show.
- To clear a slicer’s filters, select Clear Filter in the slicer.
Insert Slicer Using Shortcut Key
To insert slicer using shortcut key click anywhere in the table and press ‘ALT + N + SF’ [Shortcut key may be different just follow the key after pressing ‘ALT’ key].
Note: Click on the image

Also read other articles @ EduTaxTuber
If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.
The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function
How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status
In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More
For Latest Updates & Learning Join Our YouTube Channel: Join Now