Chapter 19. Outlining, Subtotaling, and Auditing Worksheet Data
In this chapter
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 ...