More Excel videos are in the full course here.

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, phone number, home address, expected wage and of course - profession.

By using the “Filter” utility you can quickly bring up from your table and show:
All the job seekers that live in New Jersey.
All the seekers who are female.
All the seekers with the profession defined as: model.
All the Female models who live in New Jersey.
All the Female models who are single and live in New Jersey and are under the age of 28.
...The lawyer with the lowest “expected wage” in New Jersey...