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

Chapter 21. Managing Data with Formulas ... > Combining Excel Features to Manage Y...

Combining Excel Features to Manage Your Data

This chapter provides a number of suggestions for creating worksheets that help you manage your data. Some features may be familiar from other chapters. The point here is to use feature combinations that automate worksheets and save time and effort for the user. Although the chapter begins with some simple solutions, the particular focus of this chapter is on building more complex formulas, using database functions, and adding form controls to help the whole process work more efficiently.

Excel offers a variety of features that stand alone to accomplish specific tasks but when combined can be powerful tools to extract information from your worksheets seamlessly and almost effortlessly. Suppose that one of your job functions is to track week-to-date, month-to-date, and year-to-date costs for your company's hourly employees. With the right worksheet setup and formulas, you don't have to manually calculate this information—the worksheet will do it for you, based on the daily entries. The same principle applies whether you're tracking production quantities, inventory, sales, or any other type of information that requires some kind of consistent calculation.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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