HDTutorial
EN
How to Use Advanced Filters in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Use Advanced Filters in Excel

784,311 views October 26, 2011 10:45

Watch on YouTube
ChannelDanny Rocks

Description from the creator

In addition to the built-in AutoFilters in Excel, you can create Advanced Filters that allow you to extract unique records or calculate criteria based on external data.

I do not use Advanced Filters as much as I did in the past because Excel 2007 greatly improved the built-in AutoFilters. However, you will pick up at least two good tips from this lesson - including how to extract Unique Records and copy them to a new worksheet.

I invite you to visit my online shopping website - shop.thecompanyrocks.com - to see all of my resources and explore the many products and services that I offer.

Danny Rocks
The Company Rocks

About this tutorial

Danny Rocks published this 10:45 video tutorial on October 26, 2011. It has been watched 784,311 times on YouTube.

Category
Education
Duration
10:45
Published
October 26, 2011
Views
784,311
Likes
1,214

Tags

Share

Further reading

  • Filter by using advanced criteria - Excel support.microsoft.com

    It displays the Advanced Filter dialog box instead of the AutoFilter menu. You type the advanced criteria in a separate criteria range on the worksheet and above the range of cells or table that you want to filter. Micr…

  • Advanced Filter in Excel (Examples) | How to Use Advanced ... educba.com

    Advanced Filter in excel is next level filter option available in the Data menu tab under Sort & filter section which is used to filter the selected data as per the criteria we set for this. For this, first, we need to…

  • Advanced Filter in Excel - Easy Excel Tutorial excel-easy.com

    10. On the Data tab, in the Sort & Filter group, click Advanced, and adjust the Criteria range to range A1:E3 (blue). 11. Click OK. Result. Note: always place a formula in a new column. Do not use a column label or use…

This tutorial in other languages