akshatratanpal
akshatratanpal 04 Dec 2021
1

Up next

Excel DGET Function Solves 2 of Your VLOOKUP Problems
04 Dec 2021
Excel DGET Function Solves 2 of Your VLOOKUP Problems
akshatratanpal · 12 Views

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

13 Views

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-tric

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/

GEAR I use: https://www.xelplus.com/resources/#gear

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

Show more
0 Comments sort Sort By

Up next

Excel DGET Function Solves 2 of Your VLOOKUP Problems
04 Dec 2021
Excel DGET Function Solves 2 of Your VLOOKUP Problems
akshatratanpal · 12 Views