Nowadays, fewer and fewer people are intimidated by numerical crossroads in a worksheet and obtain more abilities to overcome the complex analysis of a data set in Excel.
However, did you know there’s a tool called Slicer that allows you to filter the information apart from filters? If you don’t, relax because this article will answer the following questions related to this aid:
After reading this article, you will have all the knowledge you need to analyze data and a massive data set effortlessly. Let’s begin!
A Slicer is a higher way to filter a Pivot Table, and despite the Report Filter, which is pretty similar, the Slicer can give you three primary advantages (but there are more)
You can drill down into specific sections of a report with a Slicer, and with just one click, you will be able to summarize several reports to display only those values and variables you need!
You can access and add a Slicer by following the steps below:
Notice that you have new Slicers next to or near the original Pivot Table as individual tables for each category you selected.
Note: if they appear disorganized, you can place them with your cursor wherever you need.
Before using the Slicer, you should understand its parts and what they are for to use them to your favor:
Then you will see all the elements you have in each category. You will find a scroll bar at the right if there're so many. And obviously, if you want to resize the box, you only have to click on the corners or borders and drag as much as you want.
Alright! Using the Slicer is very intuitive: all category items will be highlighted in blue by default. So when you click and unmark an element from the Slicer, you are starting to use this tool, and those words in white won’t appear in the pivot table.
Just like that, you can use a Slicer! Of course, if you need to pick multiple items, you can use the Multi-select button or hold the Ctrl key while clicking on the elements you want.
Lastly, if you need to delete a Slicer, you must hover over the Slicer box about the borders or corners until seeing a four-directional arrow. Then, click on it and press the “Delete” key on your keyboard.
Maybe this is the most useful function that the Slicer has, and it’ll help you to be more accurate in your data analysis. However, to start using this fantastic aid, you must first connect the Slicer to all the Pivot Tables by following the steps below:
Tip: If the source of the first pivot table is called “Table 1,” all the following pivot tables must use the same table name.
And there you have it! Every time you click an element in the Slicer, you filter all pivot tables connected to your selection.
Now that you know how worthwhile a Slicer can be, you may have some questions about the topic you want to solve, or you simply want to know how to give it a refined look. Or maybe you’re looking for other tips to master Excel. Anyway, you can improve your abilities with our Excel course here in skillademia. Check it out!