How to utilize slicers in Excel

Transform the data into tabular form.
Mark the checkbox beside each slicer you wish to create.
Arrange the slicers through dragging and dropping them until fully visible.
You have the option to style slicers using the Slicer tab found in the Ribbon toolbar.
The table has now been refined to display only 2018 equipment sales based on our preferences.
Now, the table showcases clothing and equipment sales data from the year 2018.
Click on the red X icon to eliminate the filters applied by the slicer.
Integrate a 2D pie chart reflecting the table’s data.
Considering the abundance of data points included, the chart seems inconclusive.
Post-slicer filtration, the chart becomes much more comprehensible.
Establish a PivotTable derived from the tabular data.
Create a PivotTable using the sidebar feature. (Click on the image to enlarge it.)
Utilize the Category slicer to exclusively exhibit clothing sales in the PivotTable.
Refer to the other PivotTable created. (Click on the image to enlarge it.)
Associate a slicer with the secondary PivotTable.
The linked PivotTable is now singularly focused on the year 2018.
Severing the bond between a PivotTable and a slicer.

About Author

AndyC

Andy Curtis is an award-winning security consultant, researcher and public speaker. He has been working in the computer security industry since the early 1990s, having been employed by state and federal government, leading healthcare and banking providers across three continents. He has given talks about computer security for some of the world’s largest companies, worked with law enforcement agencies on investigations into hacking groups, and is a regular voice on TV and radio explaining IT security threats.

See author's posts