How to Use Slicer in Google Sheets [Mini Dashboard Template]

how to use Slicer in Google Sheets 3

Hi, in this article we will learn how to use slicer in google sheets.

What is a slicer? A slicer is nothing but a built-in function that can filter data by a condition or value. It’s not a function like the Filter function, instead, it’s something like a button/dropdown list. Slicer works like a button that can be used visually to filter out data and it helps us o break down a large data set to visually get useful insights into the data set.

A slicer is a visual element, it can be moved freely in the sheet, which means that it’s not inside a cell or range it’s an open-end element that looks like a button. We can use it to draw excellent and useful insights into our data visualized by different column names.

Use Cases of Slicer in Google Sheets

We use the filter function to filter the data based on a condition or multiple conditions and it collapses or expands our data based on the condition, but the filter is a pure function, it is not a visual element. Here, the slicer is fully a visual element, there is no formula or condition, or cell address we need while using the slicer. Slicer is like a button we can move it around the sheet and customize it very beautifully using font size, colors, background color, text size, and many other editing features.

A slicer works like a filter, it can filter data by a condition or by values. We need to learn it to draw valuable insights of the data, let’s say you have data of items sales of the month, now you want to see the top selling items, you can easily use a slicer to it, slicer can also be connected with pivot tables and charts to make a dashboard. On the other hand, filters cannot be used like that, they do not give us a visual representation of the filtered data they just collapse the data and show only the filtered data values. We need to learn how to use slicers in google sheets to see how it helps us make useful visual insights of the data based on conditions or values.

See also  How to Make a Bell Curve in Google Sheets [Easy Guide]

How to use Slicer in Google Sheets

Here, we will see everything related to the slicer. We will see various methods and procedures to add and use slicers with our data. For this tutorial, I have a dummy data set that shows the product sales data for the previous months. Let’s see how to go with it and use slicer in google sheets.

How to use Slicer in Google Sheets – Adding a Simple Slicer

Adding a slicer in google sheets, we need some sample data.

Step 1

Sample data

how to use Slicer in Google Sheets 1

Step 2

Select all data
how to use Slicer in Google Sheets 2

Step 3

Go to Data > Add a Slicer

how to use Slicer in Google Sheets 3

Step 4

A visual slicer will be added to your file.

how to use Slicer in Google Sheets 4

 

Note: This slicer will do nothing in this state. So, we need to set up the slicer to make it useful.

See also  How to Add Axis Labels in Google Sheets [Best Guide]

How to use Slicer in Google Sheets – Filter data using Slicer

To set up the slicer we need to double-click on it to open the slicer menu on the right-hand side.

Step 1

Double click on the slicer

how to use Slicer in Google Sheets 5

Step 2

Select a column

how to use Slicer in Google Sheets 6

how to use Slicer in Google Sheets 7

Note: A slicer can take only one column at once.

Step 3

Now you can use this slicer to filter your data visually, click on the “All” dropdown, and select the entities from your selected column to filter out the data.

how to use Slicer in Google Sheets 8

Step 4

Now we can use “Filter by condition”, or “Filter by values”

how to use Slicer in Google Sheets 9

Step 5

Click on “Filter by condition” and select a condition from the drop-down (similar to conditional formatting)

how to use Slicer in Google Sheets 10

how to use Slicer in Google Sheets 11

how to use Slicer in Google Sheets 12

how to use Slicer in Google Sheets 13

Step 6

Define the condition, and click on OK

how to use Slicer in Google Sheets 14

how to use Slicer in Google Sheets 15

Step 7

Click on “Filter by values” and select from the values, it’s more like a manual method.

how to use Slicer in Google Sheets 16

how to use Slicer in Google Sheets 17

Step 8

As you click on Ok, the data will be filtered and collapsed

how to use Slicer in Google Sheets 18

how to use Slicer in Google Sheets 19

This is how you can filter your data using Slicer, and this is how to use slicer in google sheets.

See also  How to Make a Histogram in Google Sheets

How to use Slicer in Google Sheets – Customizing the Slicer

In this section, we will quickly learn how to use the slicer in google sheets and how to customize the slicer, by color, font size, background color, title, etc.

Step 1

Double click on Slicer, Slicer editor will open on the right-hand side

how to use Slicer in Google Sheets 20

Step 2

Go to Customize tab

how to use Slicer in Google Sheets 21

Step 3

Here you can change the title of the slicer and give it a meaningful name.

how to use Slicer in Google Sheets 22

Step 4

You can change the title font family

how to use Slicer in Google Sheets 23

how to use Slicer in Google Sheets 24

Step 5

Next, you can change the font size of the title

how to use Slicer in Google Sheets 25

how to use Slicer in Google Sheets 26

Step 6

Below, you can use “bold” or “italic”, and you can set the text alignment as well

how to use Slicer in Google Sheets 27

Step 7

Next, you can set the title text color

how to use Slicer in Google Sheets 28

how to use Slicer in Google Sheets 29

Step 8

Finally, you can set the background color of the slicer

how to use Slicer in Google Sheets 30

how to use Slicer in Google Sheets 31

 

This is how you can customize your slicers, there are some more options to see that come with slicers.

Click on the three dots on the right top of the slicer

Here,

Edit Slicer: opens the slicer menu (identical to double clicking on the slicer)

Copy Slicer: copy the slicer into the clipboard

Delete Slicer: deletes the slicer

Set the current filter as default: set the current filter as the default filter

Learn more: will open the help window

See also  How to Zoom Out on Google Sheets [5 Methods]

How to use Slicer in Google Sheets – With Pivot Table

Pivot tables are more useful when working with slicers, we can make and use pivot tables of our original data and can work with Slicers, it helps us more to minimize the data and keep only the useful data in the pivot table. Let’s see how we quickly make a pivot table and work with slicers

Step 1

Select all the data

how to use Slicer in Google Sheets 32

Step 2

Go to Insert > Pivot Table

how to use Slicer in Google Sheets 33

Step 3

Select New sheet (only for keeping things organized and clean)

how to use Slicer in Google Sheets 34

Step 4

Click on create, and a pivot table will be created on a newly created sheet into the same workbook
how to use Slicer in Google Sheets 35

how to use Slicer in Google Sheets 36

Step 5

In the pivot table editor, add a row by clicking on the add button (you can add any row, here I am adding the products)

how to use Slicer in Google Sheets 37

how to use Slicer in Google Sheets 38

Step 6

in the next column, click on add in the Values section to add values in this column (select any column for, I have selected sold Qty)

how to use Slicer in Google Sheets 39

how to use Slicer in Google Sheets 40

Step 7

Now you have a simple summary of your data, you can add a slicer and the data inside the pivot table will be filtered as you specify it using the slicer.

how to use Slicer in Google Sheets 41

This is how you can work with pivot tables and slicers.

See also  How to Convert Formulas to Values in Google Sheets (Complete Guide)

How to use Slicer in Google Sheets – Creating a Mini Dashboard

We can make a dashboard using a pivot table, slicer, and charts. In this section, we will see how to use a slicer in google sheets to create a dashboard. For this, we need to make a chart, and also, we can make more pivot tables (optional)

I am using a pivot table and chart to make a dashboard; I will also create multiple slicers for multiple columns of my data.

Step 1

Create the pivot tables, you can create as much as you need (as we created in the previous section)

how to use Slicer in Google Sheets 42

Step 2

Create a column chart, with the pivot table’s data (or you can add any chart as per your preferences)

how to use Slicer in Google Sheets 43

how to use Slicer in Google Sheets 44

Step 3

Add some slicers (use source data, not the pivot table’s data) and assign a different column to each (use the source data for the slicer)

how to use Slicer in Google Sheets 45

Step 4

Now you can use various filters and you can see the real-time changes in the pivot table and the chart.

how to use Slicer in Google Sheets 46

This is how you can use the combination of slicers, pivot tables, and charts to make an amazing dashboard for your datasets.

See also  How to Apply Conditional Formatting Strikethrough in Google Sheets

Get How to Use Slicer in Google Sheets Free Template

Note: Make a copy and work on the copy, do not ask for editor’s access.

Useful Notes on How to use Slicer in Google Sheets

  • Slicers can have only one column at once
  • Slicers can be resized freely
  • Slicers can be customized
  • Slicers are visual elements that look like a button and work like drop-down filters

Frequently Asked Question

How slicers are different from filters?

There are many differences between slicers and filters to talk about, but the primary difference is the difference between the visual representation and the imperceptible view. This makes slicers more accurate to use when making dashboards like presentations in google sheets. We can filter out data based on conditions or values. Another major difference is slicer is not a function or formula we don’t need to deal with the syntax, whereas the filter is a pure function that follows a syntax. Slicers can be freely moved, resize, customized, and can show data visually very easily. These are the main differences between slicers and filters.

See also  How to Make a Table in Google Sheets (Complete Guide)

Conclusion

Wrapping up how to use Slicer in google sheets, we have learned about the slicer, how it works, and why they are so helpful in the visualization of the data in google sheets. In this tutorial, we have covered several things like pivot tables, slicers, and also charts. We have seen how to use the combination of these three features of google sheets to make excellent dashboards. We have learned how to make a simple slicer, how to set up a slicer by assigning a column, and how the is filtered based on conditions and values in the slicer. We then discussed the customization of the slicer, and have seen several editing options we have in the slicer editor. We also saw how to make pivot tables to work on summarized data with slicers, and then finally we created a dashboard, and using various slicers we made a dashboard with several columns of data using multiple slicers. I hope you find this article helpful and that you have learned many new things. Don’t forget to like share and subscribe to Office Demy for more exciting updates. Thank you so much. Keep learning with Office Demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general