SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)
14 November 2019 Excel Hacks: Tips & Tricks
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
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 :)
★ My Online Excel Courses ► https://www.xelplus.com/courses/
In this Excel tutorial we cover a few important topics rather quickly:
00:00 How to use Advanced Filter in Excel
00:50 How to Filter For MULTIPLE Conditions Using Advanced Excel Filter
02:05 Approximate Match - How to Use Wildcards in Advanced Filter
02:48 How to Copy the Advanced Filter Results to Another Sheet
04:20 Advanced FILTER TRICK
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
⯆ 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://rumble.com/v2tv4re
For Excel Filter Basics check out this video: https://rumble.com/v2tv4oo
★ 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/
RESOURCES I Recommend: https://www.xelplus.com/resources/
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 #Excel #LeilaGharani
-
1:19:36
Excel For Freelancers
3 years agoLearn How To Create This AMAZING Excel ONE CLICK Dynamic Filter Workbook
97 -
1:00
The Excel Zone
1 year agoBASIC WAY TO FILTER DATA IN EXCEL
56 -
14:45
skyago
1 year agoTen Amazing Excel Tips and Tricks
38 -
1:27
The Excel Zone
1 year agoEXCEL SLICERS - THE SMART WAY TO FILTER DATA
101 -
1:44:58
Excel For Freelancers
3 years ago $0.02 earnedLearn How To Create The Most User-Friendly Filters In Excel You Have Ever Seen [Free Download]
96 -
12:58
Practical Excel Tips
1 year agoFiltering And Sorting Tips in Microsoft Excel
20 -
55:32
Excel For Freelancers
3 years agoLearn These Amazing Excel Advanced Filter Techniques in Minutes [Employee Manager Part 4]
55 -
7:22
Nerdalific
3 years agoUsing Filters in Excel / How to use Filters in Microsoft Excel / Excel Tutorial
1 -
0:57
Dexcelo
1 year agoFilter Function #excel #تعليم #microsoft #اكسل #microsoftexcel #office #data #datascience #exceltips
3 -
53:16
Excel For Freelancers
3 years ago $0.01 earnedThe Ultimate Excel Advanced Filters In VBA [Full Training Course]
32