Analyzing Data by Using PivotTables in Excel 2016: Filter PivotTable Data
Interactive

Analyzing Data by Using PivotTables in Excel 2016: Filter PivotTable Data

BizLibrary
Updated Feb 05, 2019
Book a demoTry it for free
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)
Related learning
Using PivotTables and PivotCharts in Excel 2016: Filter Data by Using Slicers and TimelinesInteractive ⋅ 4 mins
Preparing Data and Creating Pivot Tables in Excel 2016: Create a PivotTable From a Local Data SourceInteractive ⋅ 6 mins
Excel Office 365: Sorting & Filtering DataInteractive ⋅ 38 mins
Working With Lists in Excel 2016: Filter DataInteractive ⋅ 2 mins

Explore more technology skills

IT Software
IT Software
Web Design and Development
Web Design and Development
Data & Analytics
Data & Analytics
Design and Animation
Design and Animation
Gaming and Games Development
Gaming and Games Development
Devops, Networking and Security
Devops, Networking and Security
Programming and Web Development
Programming and Web Development
Computer Science and Engineering
Computer Science and Engineering
;