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 live online training, plus books, videos, and digital content from nearly 200 publishers.