Special Edition Using® Microsoft® Office Excel 2003

Chapter 19. Outlining, Subtotaling, and Auditing Worksheet Data

In this chapter

• Organizing and Auditing Your Data

• Grouping or Outlining Data

• Consolidating Data

• Creating Automatic Subtotals

• Validating and Auditing Data Entry

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 ...