SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

With Excel's Advanced Filter feature you can filter for multiple criteria and copy the filtered results to another sheet. But did you know of the trick shown in the video? I didn't :)

In this Excel tutorial we cover a few important topics rather quickly:
1. How to use Advanced Filter in Excel
2. How to Filter results for multiple conditions using advanced Excel Filter
3. How to Filter results based on an approximate match - i.e. how to use wildcards in advanced filter
4. How to copy the advanced Excel filter results to another sheet
5. AND FINALLY THE ADVANCED FILTER TRICK: 4:20

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-advanced-filter-trick

To find out more about Excel Advanced Filter check out this video: https://youtu.be/VqQACB_69SQ
For Excel Filter Basics check out this video: https://youtu.be/wMlTDXPEjag

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Видео SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!) канала Leila Gharani