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

Part IV: Going Beyond the Basics > Managing a Database with Excel

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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