What is the AutoFilter feature in Excel 2007? This feature is used to apply a filter arrow next to each column in your Excel database. When this arrow is clicked it will display all the data within that column, but with a checkbox next to it. You can uncheck this box to remove or filter out that specified data to be hidden temporarily form you database. Additional options include hiding blanks or non-blank fields in that column i.e. say for example employees who don't have health insurance will have blank fields and you can hide non-blank fields (those employees who do have insurance) to find all those who don't. Then contact those employees who don't to see if they'd like to participate.

Purchase the training video and you can see this in action for yourself!