How are pivot tables used to filter data in excel?

• Using a slicer, filter data in a PivotTable.
• Go to Pivot Table Analyze > Filter > Insert Slicer Slicer after selecting any cell in the PivotTable.
• Choose the fields for which slicers should be created. Then press OK.
• For each option you make, Excel will place one slicer on the worksheet; however, you must arrange and size them as you see fit.
• Select the things you want to show in the PivotTable using the slicer buttons.
• Manually filter the data
• Select the arrow next to the column heading. The column you want to filter is indicated by a drop-down arrow.
• Uncheck (Select All) the boxes you want to see, then check the ones you want to see. Then press OK.

Read More: What is the benefit of using formulas in excel sheets?