skip to Main Content

How to Use ‘Advanced Filter’ to Select and View a Specific Set of Data (Excel 2010/2007)

This operation allows you to extract specific data for review. You can create a ‘set’ of specific criteria to use to ‘Filter’ the data. In this example we will pull out specific information from a list of employees. We will create criteria that will display employees that were employed before a specific date, make more than $40,000 and work in one of three departments.  This will work the same in Excel 2010 and Excel 2007.

This post is only available to members.
Back To Top