O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required