You have seen how an ordinary range can be used as a data list in Excel 2003. You know about AutoFilters, advanced filters, fields, and records. Now it is time to explore a few more Excel features that you can use to get the most out of your Excel database.

In this lesson you will learn how to filter records with wildcard characters, and how to validate data. You will learn about Excel database functions and Excel lookup functions. In the exercise at the end of the lesson, you will practice using an Excel lookup function.