4. Grouping, Sorting, and Filtering Pivot Data

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

• Slicers provide a visual way to filter data set. 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.

• Sets will someday make an impressive grouping feature in pivot tables. ...

Get Pivot Table Data Crunching: Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.