Hour 22. Working with Your Database

This hour explains how to work with your database and perform all kinds of operations on it to display the information you need. You'll be subtotaling your data with statistical functions, using advanced AutoFilter functions, and setting up a criteria range to retrieve data.

When you're through with the exercises in this hour, you'll be quite comfortable with retrieving data in your database. Then you can use your own databases and practice retrieving data in various and sundry ways.

The highlights of this hour include the following:

  • How to work with subtotals

  • How to use advanced AutoFilter functions

  • How to set a criteria range

    Part I: Excel Basics