Advanced Filter Excel (And, Or, Between Conditions for Criteria Range)
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Dive deep into the world of Excel's Advanced Filter options in this comprehensive tutorial. Learn how to gain full control over your data filtering with practical and detailed instructions, exploring everything from basic filtering to complex criteria settings.
⬇️ Download the workbook here 👉 pages.xelplus....
✨ Key Highlights:
▪️ Setting Up Advanced Filter: Step-by-step guide on how to use Excel's Advanced Filter feature for precise data analysis.
▪️ Using Criteria Range: Discover how to filter data using specific criteria in separate cells.
▪️ And/Or Conditions and Wildcards: Learn to apply complex filtering logic, including the use of wildcards and combining And/Or conditions.
▪️ Extracting Unique Records: Find out how to extract unique data entries for streamlined reporting.
▪️ Practical Examples: See real-life scenarios showcasing the power and versatility of Advanced Filter in Excel.
★★ Links to related videos: ★★
Excel Filter Trick: • SURPRISING Advanced Fi...
Excel Filter Basics: • Excel Filter Basics (f...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/filter-advanced-file
Thanks, Leila! I’m a long-time Excel user who writes VBA and is now climbing the Power Query (M), Power Pivot (DAX), & Power BI learning curves. But, I never learned or used Advanced Filters. So easy ... with your expert explanation, that is! 👍
Wow Jim, that's quite a climb. I'm glad I could help support it a little bit :)
I'm studying for a big history exam and have an Excel with all the centuries, dynasties and people in it 😅 I've been painstakingly filtering for each unique word when I study by using the search function! Thanks to you, I now know how to quickly filter and find the most important information.
I thought I already knew a lot about Excel... but after watching your videos, I feel I have only scratched the surface! Learning from you is giving me renewed energy!
THANK YOU LEILA!!!
edwin enriquez
Same situation here. Ms Leila is very creative and talented. I appreciate her a lot.
You explain it better than Microsoft's own "experts". Thank you.
I very rarely comment on youtube but I have to say that Leila is my absolute favorite reference when it comes to Microsoft suite. It's like you read my mind and always have the perfect answer to my exact question. I can't count the amount of time I shared your videos or articles to help a coworker on some of their questions, and you instantly become their favorite too. Thank you for spreading the knowledge with your extremely high quality content, you really are making an impact.
Wow, thank you very much Véronique for the kind feedback. I really appreciate it!
Working on a tough project, this video saved me days of work. Leila is the freaking GOAT don't @ me
Advanced filter and unique records only is maybe the best Excel tip I ever received. I already spend ours on google to figure out how to this. Thanks a lot!
Glad it was helpful!
I've been an Excel user from the beginning, but this video was so helpful and Leila's voice is so soothing to listen to.
I'm glad you like it John.
Your movies always teach me not only basic technique, but also advanced one. Thanks!
You're very welcome. I'm glad you like the tutorials.
Till for today I starting watching your videos and found something unique. Most of the videos on youtube tell us all the things which we have already know. But in your videos, I learn something extra about excel. Thumbs up and Goodluck for your hard work.
I'm glad to hear that :) Thanks for the thumbs up!
Dudes have not realized yet, how POWERFUL this function is and how MAGNIFICENT your teaching 💪🧚♀️💯
Thanks for the kind feedback Said :)
your explanation is very splendid and varsatile
Lot and Lots of thanks to my Excel teacher, who is posting Excel videos, which is very simple to understand. Very Lucid. I am praying the almighty to bestow her good health, as she is doing a great job indeed, for the Excel lovers/users/addicts. Waiting eagerly very much for the VBA Series with your authentic style.
Thank you very much Gopala for the very kind words and for your support. I'm working on the VBA course, and I should be ready to start posting some VBA videos here in two weeks time....
Thank You. Very good explanation. Helpful
10,000 thanks for this video. Happy happy joy joy!
Thank you too Thomas!
I learned these advanced formulas which made my daily tasks in excel much easier.Thank you Liela
Happy to hear that!
Hi leila,.. I am watching your all Excel video very interesting and advanced level
Really i can't get bored while iam watching your videos. Nowadays business is low due to covid 19. I have decided to watch everyday 2 videos for you starting from excel introduction. The reason is there is always alot of information where wr can miss them. You are a great teacher dear i wish you the best because you always astonish us with your nice videos.
Only your videos help me in funding solutions to my day to day excel related problems.. Thank you so much. My first ever response on any videos on you tube
I watched a few videos on this subject and yours was the only one that made any sense! This will save me so much time. Thanks so much!
Finding of unique records does save lot of time...you have various solutions with advanced usage for one requirement, simply superb
It's good to have some of these solutions in the toolbox. Glad you find the tutorials useful.
I love the way, you have been teaching us effective methods. Thank you a million times.
My pleasure. Glad you like the video.
I like this channel.........everything you teach that actually in simply way or understandable ❤️😊🤟🏻
Happy to hear that!
Learnt something new today after using Advanced Filters for many years. Thank you.
I'm glad to hear that :)
Thank you so much Leila. Very useful.
The way you teach is very effective, thank you very much.
Thanks for the ultimate solution. You are brilliant..
Thank you sooo much for this easy to understand explanation of advanced filter. Looking back now it is absurd how much trouble I was having; your instruction got me set straight.
I find you the best in explaining excel facts...
Miss Leila, I watch your videos frequently as a refresher course
Thank you! I'm glad to hear that Imran :)
I rarely post comment, but felt I have to; spent > 10 min on microsoft support page and still couldn't figure it out, over here, < 1 min everything is clear! thank you!!
Happy it was helpful, Kevin!
Excellent! Thank you Leila, its easy and clear. I wished to know it before but Im happy that now I know it.
Leila you are super refined in your explanations :D
Thank you! 😃
I normally use the remove duplicates for unique values .. thanks to you... now i can use advance filter to get the unique records ... thanks again
Thanks for easy example.
Thanks for sharing im learn something every videos u make. Very ingotmative direct to the point to the topic. Thans. Keep itt up.
Thank you so much Leila. All your excel tutorials are very helpful and understandable. I love it. I love your channel.
Mam, Always wants to say you
thanks you so much for sharing all these excel videos.
You are the greatest teacher.
Thanks a lot!
@@LeilaGharani 🤗🙏❤️
Nice, It is really useful for our daily reports
Great refresher, I still tend to enter criteria as a string ; = "=whatever" and have found that it can still help when dealing with wildcards.
You are one of the best excel teacher!
You are one of kind the greatest woman in the world thank you so much Ms. Leila.
Thank you so much Ismail for the very very kind comment. I really appreciate your support of this channel.
So helpful! thank you :) - from Missouri, USA
You are going with very step by step so that very helpful for us and easy for learning also
thanku for macking excel soo easy......thanku soo much
Thank you so much! I finally understand how the advanced filter works! I have to learn and understand it since I have exam tomorrow! Thank you!
Great! and good luck!
@@LeilaGharani Thank you so much!!!
Amazing... teaching excel in the simplest and the best way possible... :)
Thanks a lot!
advance filter ! well explained ,thank you !!.
Really nice i watch 100 of videos on Advance filter but no one told me that typing in below is or condition and typing another column is and condition which has solved my problem Many thanks dear
Happy to help :)
literally the best explanation on youtube
Appreciate that, James!
Advanced Filter is a great feature that few know about or use. Thanks Leila for the reminder!
Very true! It took me a while to find out about it too :)
Many many thanks Leila! Please increase the frequency of uploading videos as we are waiting. Thank you so much once again!
Thank you Zahid for your comment! I would love to be able to get more weekly videos out here. For now once a week works - in the future I might be able to do more :)
Your videos are very clear, and specific, I'd wish Microsoft could explain it this way not the convoluted way they always use.
I feel like a 8 year old when I watch your videos, because of the clean and nature simple way you have to explain, ideas are simple, minds are complicated, sometimes if one can't explain it in a way an 8 year old understand it , is because it is still not fully understood at all.
Microsoft should learn something here.,( same as the videos from Mr Randy Austin) , Love it , Kudos Leila , and greetings from New York!!.
Thank you very much for the kind feedback Edward! I'm happy the videos come across like that.
Thanks for the Advanced Fun, after the summit : )
Thanks Mike. It was great to meet you at the summit!
Your videos are the best. I have been writing VBA code over twenty years. I can record a marco while I use your instructions for a specific excel task, then modify the recorded macro. Thanks
i learned too much from this video ma'am you are a best teacher
Thank you, I have had questions about filters and you have answered them .
Your last tip was a mind blowing one
Very useful tricks for MIS , Thank You Leila!
You're very welcome Sanjay.
Thank you for taking the time to film this!
You are so welcome!
Very useful tool explained in great way...thanks @Laila
This is really cool! Never knew Excel had a dynamic filter like this. Thanks!
Glad you liked it!
I often use advanced filter instead of vlookup when I want the original table. I learned some new ways to use it from this video.
Glad you were able to pick up something new Jonathan.
Love your videos....you have gotten me out of a jam so many times. Thanks for the content....keep it coming!
Will do 😊
As always.. thank you very much.. 👍👍👍🌹🌹
You are excellent at explaining this material! Thank you!
Glad it was helpful!
thank you for your videos ....... advanced exel filter.....
I already watched advanced filter but nobody taught what is and and or or how to interpret them.. thanks
Great video. Good pace of teaching as well. I discovered that the basic key is that the criteria given in same row mean AND condition. OR condition cannot be inserted in the same row. Thanks a lot Leila for clearing this.
Very useful as usual!
Wonderful lecture in advance filter! Thanks Leila!
You're welcome K.Clark :)
My collegues will like this lecture too. Thx. Leila from HUN
Thank you very much, dear teacher.
You are welcome!
Thank You for this video.
Content were the one I sought. Amazing
Good Clear Helpful Videos!
Thanks you for the video!
Dear Leila!
It was very interesting. I enjoyed . From teaching your video.
THANK YOU LEILA!!!
My pleasure! Glad you like the video.
❤very good video. It's just what I needed to know.
I am searching for unique records for years but Miss Leila you solved my problems in just one video 7 minutes only
I'm SO happy to hear that! These things can be really frustrating! Thanks for the feedback.
Very helpful ma'am 😊
Very Nice Explanation Mam ... Thànk you Very Much for this Amazing Video
Too Good Explained Mam
Great video. Thanks!!
great technique gonna use it
Very informative, thank you very much. I have learnt a new thing in filters today
You are awesome Leila. Thanks a million
مثل همیشه عالی بود. دستت درد نکنه.
A very well-presented and well-explained video... Thank you
This's very helpful!! I like the way you explain, now thinking of using this with VBA that creating a report in 5 mins without spending time to go through all the tabs...
I'm very glad to hear that. Sounds like a good plan.
Absolutely amazing
This really helped. Thanks! New Subscriber.
Excellent, Very useful for big data
Leila, you are unique.
I'm glad to hear that :)
Thank you so much Leila :)
Thank you Leila.
Hey Leila,
Hope you are doing well, first of all thank you for your each vedio wherein you are elaborating nice way and it is powerful ! I am fan of you !
I like the way you are covering all most essential areas , keep it up and keep sharing !
Thanks a lot !
Thank you Dashrath for your kind words and your support!
Well explained.
thank you! awesome video