O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

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 9. Creating Dynamic Lists with PivotTables

Creating Dynamic Lists with PivotTables

Chapter 9 at a Glance

In this chapter you will learn to:

✓ Create dynamic data lists with PivotTables.

✓ Edit PivotTables.

✓ Create PivotTables from external data.

An important consideration when you create your Microsoft Excel worksheets is 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 to make.

One limitation of the standard Excel worksheet is ...

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