Excel Tip - Table Slicers

Slicers are visible buttons that you can use to filter data in Tables. They can be printed and formatted and indicate the current filtering state of your data, which has a large advantage over using the filter tool next to the column heading…

 

 To watch without sound, turn captions on by clicking 'CC' then selecting 'English'.