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

Changing Horses

This chapter has taken a brief look at overworking functions, ineffective data orientation, codes versus labels, and flat file workarounds that try to manage relational structures. There are more problems that you've probably run into already—for example, managing multiple simultaneous users and working with data outlines instead of pivot tables. Subsequent chapters in this book deal with these issues in greater detail.

If this chapter leaves you with the sense that Excel is the wrong application for data management, it has misled you. Worksheet functions, transposed lists, code lookups, and other features are sensible, valuable tools for data management. Nevertheless, they can go wrong and often do. That happens usually, if not always, when you find yourself working with more data than your original setup anticipated.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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