Filters in Excel

Hi Diana

Thank you for your question.

Filters are used when you are using Excel to store data in a series of columns, with a heading above each column, e.g. sort of like an address book where you would have First name, Last name, Street address, City, Postcode.

The filter allows you to get Excel to display only those items in your list that match certain criteria, e.g. with the address book example, you only want to see a list of people that live in London.

We do cover filtering and other list management tools in the Excel Intermediate course.

Kind regards
Amanda