S3_Spreadsheets_Filtering

Definition (Class Summary)
Filtering is an option that temporarily takes data out of view, in order to analyze and view it. Filtering is done by setting conditions so that only certain data is displayed.

Filtering Numeric Data
 * whether or not the data equals a certain number
 * whether or not the data is greater than, less than a specific number
 * the data is above or below the average value of the data as a whole

Filtering Text Data
 * whether or not the data matches a certain word
 * whether the data is a word containing one or more letters
 * whether the data is a word that begins or ends with a specific letter of the alphabet



Class Exercises
Auto-Fill Video Tutorial http://www.teach-ict.net/software/excel_2007/sorting_filtering/autofilter.htm

Auto filter 2 Video Tutorial

http://www.teach-ict.net/software/excel_2007/sorting_filtering/autofilter_showing_filtered_rows.htm

Auto filter customization Video Tutorial http://www.teach-ict.net/software/excel_2007/sorting_filtering/autofilter_customising.htm

