We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Excel tutorial on how to use Slicers in Excel.
What are Slicers?
Slicers are buttons used to filter data in spreadsheets. They can be used to filter pivot tables or Excel Tables. Especially when looking at large amounts of data, using Slicers is a faster way of filtering through that data.
They can also be styled, making them a great option for tasks like creating an interactive dashboard.
In this tutorial, we’ll go over how to create slicers to filter a pivot table and its pivot chart.
We’ll then go over how to filter with Slicers and, finally, how to format – resize and reshape – the slicers and change their settings.