Slicers in Google Sheets - The Ultimate Guide 
If you have ever used filters for your Google Sheets workbooks before, slicers are an additional feature that will definitely upgrade your workflow. If you haven’t used either of these tools before, this guide will teach you how to use them in the easiest way possible.
Before we get to how to use it, let us take a look at what it is.
What is a Slicer in Google Sheets?
A slicer is an interactive toolbar that allows you to sort through your spreadsheet based on specific values and data. You can use them to change visible information in your spreadsheet through the use of an easily accessible widget.
We will give an example on the use of these but let’s try to differentiate slicers versus filters before we get started.
Google Sheets Slicer vs Filter: What's the Difference?
Both a Slicer and a Filter will perform the same functions and allow you to sift or refine through your data given specified values or conditions. However, you will have to reactivate and deactivate your filters every time you change your conditions.
Shifting between views might also get a little tedious and be less intuitive when there are multiple people using your sheets or when there are several columns you want to categorize through. Slicers can be helpful in these types of cases.