Chapter 11. Managing a Database with Excel

In this chapter

• Understanding database terminology and concepts.

• Setting up a simple database in Excel.

• Using a fill-in-the-blanks form to enter records into your database.

• Finding and sorting database records.

• Summarizing and comparing data in your database using pivot tables.

Although Excel specializes in number- crunching and charting, it can serve as a competent database manager, as well, enabling you to store contact information, product details, employee lists, and any other records you might need to track. Excel provides tools for sorting the records in your database, filtering out a select group of records, and even locating specific entries. This chapter shows you how to set up a database in Excel and use many of its database management tools.