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

Chapter 17. Setting Up a List or Databas... > Using Excel As a Database Program

Using Excel As a Database Program

Although "number crunching" is Excel's primary purpose, the row-and-column format lends itself to creating and storing databases (called lists in Excel). Generally, a good rule of thumb is that if your list grows to more than 2,000 rows, you should store the information in a data warehouse or relational database. Whether you need to store a product catalog for quick lookups or employee information for use with your accounting software, you can create, edit, sort, analyze, and filter your data with the options on the Data menu.

This chapter begins discussion of data storage and analysis in Excel, with discussions of various methods of data entry and options for viewing, printing, and reporting on the list data. The following chapters explore additional options for sorting, filtering, grouping, consolidating, outlining, and auditing lists and tables; using tools and form controls to analyze data; and PivotTables, an important and useful feature of Excel for use in summarizing and manipulating the structure of your lists.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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