Chapter 9. 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 ...
Get Microsoft® Office Excel® 2003 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.
