Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Using Advanced AutoFilter Functions

In Hour 21, you learn about filtering data with Excel's nifty AutoFilter feature. This session takes that discussion one step further and talks about using advanced AutoFilter functions, such as extracting filtered data, and using the Top 10 AutoFilter and Custom AutoFilter options.

After you filter your records to display specific data in your database, you can extract that data by copying it to another worksheet or workbook. It's simple to do—just use the Copy and Paste tools to place the filtered data somewhere else.

As for fancy AutoFilter functions, you have Custom AutoFilter that lets you set up comparison criteria, as well as create AND or OR criteria. For example, you can search for all the employee ...