You can use slicers to filter data that is formatted in a table quickly and easily. To insert a slicer into your Excel spreadsheet, select your table and go to the Insert tab. In the Filters group select Insert Slicer and choose the fields from the list you want a slicer to apply too.
You will now have a slicer in your spreadsheet. To use it, just select the option from the list that you want to view. For example, above I have chosen to see the food orders that Terry Walton dealt with.