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:

To find out more about Excel Advanced Filter check out this video:
For Excel Filter Basics check out this video:

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free


EXCEL RESOURCES I Recommend:

Get Office 365:
Microsoft Surface:

GEAR
Camera:
Screen recorder:
Microphone:
Lights:

More resources on my Amazon page:

Let’s connect on social:
Instagram:
Twitter:
LinkedIn:

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

XelplusVis,Leila Gharani,Advanced Excel tricks,Excel online course,Excel tips and tricks,Excel for analysts,Microsoft Excel tutorials,Microsoft Excel,Excel 2016,Excel 2013,Excel 2019,Excel 2010,excel advanced filter copy to another location,excel advanced filter,excel filter copy to another sheet,excel filter trick,excel hacks,excel hacks and tricks,excel advanced filter copy,excel advanced filter multiple criteria,excel advanced filter with wildcards,