Filter

[11 minutes total]

These seven tutorials show how to use the Filter feature in Excel, which allows you to quickly see or create subsets of your original data file. Filtering is one of the most powerful tools in Excel (particularly in conjunction with the Conditional formatting feature) and yet is extremely easy to learn.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

• Filtering data with AutoFilter (1:13)
• Analyzing data with AutoFilter (1:45)
• Using Custom AutoFilter to filter numerical values less or greater than a specified value (1:41)
• Turning filters off (0:34)
• Printing datasets from AutoFilter (1:39)
• Copying just the dataset obtained from AutoFilter (2:23)
• Using the Esc (Escape) key to clear selections and copy another dataset (1:16)

You may need to turn off your browser's pop-up blocker or install the latest Flash plug-in to view these tutorials.