Chapter 19. Outlining, Subtotaling, and Auditing Worksheet Data

Organizing and Auditing Your Data

As mentioned often in other chapters of this book, structuring the data in your workbooks is essential to using them effectively. Structure is particularly crucial if you plan to extract, chart, pivot, or create reports from the data. If the worksheet is put together randomly, without good planning, reorganizing, and reporting, it later can cost a lot of time and frustration. When a worksheet is well structured, on the other hand, you can take full advantage of Excel’s data-management features to ...

Get Special Edition Using® Microsoft® Office Excel 2003 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.