Chapter 12. Pivot Table Data Crunching for Excel 2007

In this chapter

Grouping Daily Dates to Months and Years 238

Sorting and Filtering 239

Exploring Even More Filtering Options 246

Adding New Items Along a Dimension 255

Showing Percentages Instead of Values 258

Exploring Interesting Uses for Pivot Tables 263

Finding More Information on Pivot Tables 269

Pivot tables in Excel 2007 offer far more options than what have been discussed in the previous two chapters. This chapter will show you how to expand the possibilities of analyses available with pivot tables. This is a great sampling of the most common analyses you might want to perform. If you want to see every possible feature in a pivot table, check out the Pivot Table Data Crunching book ...

Get Special Edition Using Microsoft® Office Excel® 2007 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.