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

Chapter 1. Misusing Excel as a Database ... > CASE STUDY: Overworking Functions

CASE STUDY: Overworking Functions

You've taken on The Sisyphus Corporation as a client to help it solve a data tracking problem. Sisyphus wants to track information about purchase orders (POs) that it has prepared for its vendors. As the vendors send invoices for payment, the Sisyphus staff enters information into an Excel workbook. The information includes data such as PO number, PO date, invoice number, invoice amount, invoice date, and so on.

Over time, Sisyphus acquires a considerable amount of information, some of which appears in Figure 1.1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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