Working with the "Filter" utility in Excel
When should you use the “Filter” utility?
Whenever you have a big table, from which you want to show only certain rows that fulfill some criteria.
For example, in an employment agency you have a big table of job seeker’s personal details.
The details could be: First and last name, age, gender, marital status, academic degree, phone number, home address, expected wage and of course - profession.
By using the “Filter” utility you can quickly bring up from your table of data and show:
All the job seekers who live in New Jersey.
All the seekers with the profession defined as: teacher.
All the teachers who live in New Jersey.
All the teachers who live in New Jersey and have a bachelor's degree.
And of course many more such combinations...