• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Outlining, Subtotaling, and ... > Organizing and Auditing Your 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 display, print, and report precisely what you want.

Chapter 18, “Using Excel's Data-Management Features,” describes the Excel options for sorting, filtering, and protecting your data. This chapter continues with data-management features by providing details on outlining and grouping, consolidating, and using data validation and auditing to help prevent, locate, and correct data errors.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint