Microsoft Office Excel 2016: Part 4 (Data Analysis with PivotTables) - Filtering PivotTable data comes in handy when you are analyzing a subset of your data and want to ignore all data that is not relevant to your current analysis. (The FILTERS Area, Slicers, The Insert Slicers Dialog Box, The Slicer Tools Contextual Tab, Timelines, The Timeline Tools Contextual Tab)