O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required