During this hour, you learned database terminology, how to build a database, search for data in the database, and filter records. Now you should have a basic understanding of how databases can be created in Excel.

In the upcoming hour, you put the database you created to good use by subtotaling numbers, using advanced AutoFiltering techniques, as well as sorting and querying data.

    Part I: Excel Basics