Home

How to Use the Advanced Filter tool to extract data in Excel

May 6, 2010 09:41 PM

Excel spreadsheet displaying car sales data, including customer city, sales figures, and criteria evaluations.

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

1. Extract data with 1 criteria

2. See how criteria and extract areas get named

3. Extract data with 2 or more AND criteria

4. Extract data with 2 or more OR criteria

5. Extract Unique Records

6. Extract data to different worksheet

7. Extract data to different workbook

8. Add column with True/False formula

9. Extract data with formula criteria

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.