Shop staff filtered

Using the file spreadsheet shopstafffilter.xls to filter the staff as required.

1. In the Address list worksheet, using the Advanced filter feature, filter the names and details of people
   1. living in Essex
   2. have the surname Smith
   3. have the postal code of LD 1 8GK
2. In the Staff members worksheet, using the Advanced filter feature, create a number of filters. Position them in different parts of the worksheet.
3. Make sure you know how to use the advanced filter. Which part of Access is similar to this feature in Excel?  Why would you use it and not use Access?

This work may be freely copied for non-commercial use only. Copyright © Pam Miller.