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

Chapter 1. Misusing Excel as a Database ... > Putting Data Management into Context

Putting Data Management into Context

Excel is a superb application. Its user interface is comfortable and effective—at least, you can make it match your own sense of comfort and effectiveness. The worksheet layout is flexible. You can make the rows and columns stand for whatever you want: records and variables, weeks and days, accounts and debits or credits, and so on.

Excel offers a huge selection of functions: prefabricated formulas that have already done the heavy lifting for you. Its charts help you visualize what's going on with your data. Its pivot tables make it a snap to synthesize and analyze large collections of records. You can even control its appearance so that other users can't tell that what they're looking at is an Excel worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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