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
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.