4. Grouping, Sorting, and Filtering Pivot Data

Some of the excellent new features that Microsoft added to pivot tables filtering in recent versions include the following:

• Slicers provide a visual way to filter data sets. Slicers are far superior to the old Page Filter technology. Yes, they can take up a lot more real estate, but they also vastly improve the multifiltering technology introduced in Excel 2007.

• Timelines are like a visual filter but for dealing with dates. You can filter by day, month, ...

Get Excel 2013 Pivot Table Data Crunching now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.