Filter Pivot Table with Slicer in Google Sheets

Pivot Tables are the most powerful tools that you can use in your Google Sheets. A slicer is the feature that can filter out Pivot Tables easily. Very useful when you need to keep all your data together but you want to present parts of it (slices) In a previous example you can see how to create a simple Pivot Table in Google Sheets. We used an Education case study where the teacher Amanda wanted to have a summary of their students grades ready for the Teacher-Parent conference. Amanda keeps track of the grades in a simple Google Sheet...read more

How to use a slicer in Excel

Slicers in Excel are filters that help slice the data in a modern and dynamic way. Before slicers, filters were the only way to "slice" a pivot table data. The slicers were a step forward to a dashboard and a first step to Power BI. If you are a Google Sheets user, you can use slicers there too. See here how to use slicers in Google Sheets. How to filter a pivot table without slicers Before slicers, filters were the only way to filter the data. The problem with using filters is that the filters are independent. The data...read more