Chapter 17. Setting Up a List or Database in Excel
In this chapter
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 general rule is that if your list grows to more than 2,000 rows, you should consider storing the information in a data warehouse or relational database such as Microsoft Access. Whether you need to store a product catalog for quick lookups or employee information for use with your accounting software, you can ...