O'Reilly logo

First Look 2007 Microsoft® Office System by Katherine Murray

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

PivotTables Views—More Support, Better Insight

If part of your work involves making sense of large amounts of data and displaying it in a format that is both flexible and understandable for others, you will be relieved that Office Excel 2007 makes PivotTables easier to understand and use. Sometimes the simple things make a great difference—such as adding an Undo function for most operations, using the familiar plus and minus indicators for drilling down, and allowing sorting and filtering of data.

More PivotTable Support

Begin the process of creating a PivotTable by selecting the range of data you want to use in your report; then click PivotTable on the Insert command tab. The Create PivotTable dialog box will ask you to confirm the range you ...

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