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

Chapter 9. Creating Knowledge Using Numbers > Putting Your Data in Order

Putting Your Data in Order

Often, the first step in analyzing a mass of data is to see it in some type of order. Sometimes that might be as simple as sorting the data on some criteria. For others, you have to create subsets of the information that allow you to focus your analysis on the data of interest. Excel provides three tools that help you summarize your database information, whether that database is maintained in Excel or whether you link to or import an external database:

  • Sort. Reorder your database by one or more fields, so you can see similar data together.

  • Filter. Create a subset of your data for examination or further analysis.

  • Subtotal. Show similar data grouped together, so you can see summary counts of categories of information.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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