Advanced Filter in Excel - Explained with Easy Examples

Excel Advanced Filter is one of the most underrated and under-utilized features that I have come across.

If you work with Excel, I am sure you have used (or at least heard about the regular Excel filter). It quickly filters a data set based on selection, specified text, number or other such criteria.

In this video, I will show you some cool stuff you can do using the Excel advanced filter.

This video on Excel Advanced Filter covers how to:
To extract a list of unique items
To filter records using multiple AND criteria - such as sales rep name and geography.
To filter records using multiple OR criteria - such as sales rep is Joe OR John
To filter records using wildcard characters - filter records with sales rep name beginning with J
To use numerical conditions - filter records with sales more than 20000

You can read more about Excel Advanced Filter here: https://trumpexcel.com/excel-advanced...

Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial