Chapter 10. Creating Dynamic Lists with PivotTables

Chapter at a Glance

Creating Dynamic Lists with PivotTables

In this chapter, you will learn to:

Create dynamic lists with PivotTables.

Filter, show, and hide PivotTable data.

Edit PivotTables.

Format PivotTables.

Create PivotTables from external data.

When you create Microsoft® Office Excel® 2007 worksheets, you must consider how you want the data to appear when you show it to your colleagues. You can change the formatting of your data to emphasize the contents of specific cells, sort and filter your worksheets based on the contents of specific columns, or hide rows containing data that isn’t relevant to the point you’re trying ...

Get Microsoft® Office Excel® 2007 Step by Step 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.