MS Excel - Advanced Filters
Вставка
- Опубліковано 20 лип 2024
- MS Excel - Advanced Filters
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
To Buy Full Excel Course: bit.ly/38Jyu3p
Use coupon "UA-cam" to get FLAT 10% OFF at Checkout.
Check out latest Video Courses and eBooks : www.tutorialspoint.com/market...
In this video tutorial we will show you many examples that explain:
1. How to setup advanced filter
2. How to use the criteria range in the advanced filter
3. How to use wildcards
4. How to setup your criteria to filter for OR / AND conditions
5. How to filter between two dates or two numbers with advanced filter
For more updates on courses and tips follow us on:
Facebook: / tutorialspointindia
Twitter: / tutorialspoint
LinkedIn: / tutorialspoint
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
This guy's a freaking genius!
Exactly
True
Ijr he teachers it so easily I can understand so easily
Very good guy i must confess
You just taught me what I haven't seen anywhere else. You are just awesome. Great
Thank you so much sir. The advance filter 1-5 sessions were extremely beneficial. Your clear instructions, use of understandable language and examples make the tutorial captivating and useful. Stay blessed! Keep uploading more videos.
You are right, bro; Thank you
The Advance Filter options are explained crisp and clear to the point. Thank you really very informative.
Thank you, when you keep something short and sweet, you make it as brief as possible while still being effective.
Very nicely explained,, I am 52, now learning excel for our NAAc purpose. You are a great help to me. Thnaks...
Best excel teacher. Million thanks. I would love to know if you have programming videos with the same teaching style.
For your teaching style is very well, easy to understand what you try to say, Thanks for the sharing your knowledge, Surely it will use full for who is actually needed about excel like me.
Thank you sir, your videos are very helpful
I just had a question about this video, what's the difference between pivot table and filtering? It seems like they both have the same use..
Sir, i am a new learner to excel and your way to deliver your words is really awesome, very simple, understandable specially belongs to Hindi educational background. Thanks
I didn’t know it’s this easy. Thanks!! You solved my problem.
Same
Your vudeas are always clear, simple, informative and to the point! Luv it!
😀😤😡😠😈👿😩😨😧😦😭
Hello 🌹🍫🌹🍫
GOOD EXPLANATION SIR. I HAVE UNDERSTOOD ALL THE THINGS YOU MENTIONED IN THIS VIDEO AT ONE GO!
My goodness...Thank you for saving my assignment due tomorrow. I hope you get whatever you've randomly wished on the clock whenever it's 22:22 or something. Have a mighty fine day, sir!
Your lessons are clear and easy to understand.Its very effective for me.Thanks for sharing.
Thanks for the amazing video. It cleared out all of my doubts 🙂
Very simple and useful! You have tht knack to make complex things appear simple!
Thank you.. slowly it is getting interesting... for sure... your examples were just apt for me to just get hold of it.
Amazing teacher ever seen of MS EXCEL
Come up with some more features which can be used by a chartered accountant for their work
Thanks and keep uploading
Also new feature of X Lookup have come up
Please make a vedio on that too...
You explained slowly and clearly. Thank you!
Holy cow! Soooooo happy I found this. Very 😎.
What is so great about this is the almost unlimited amount of data gathering jobs these can be applied to. Another great video to send to my computer as a reference. Awesome.
You teach very well sir....which is understood by every one each and every part of your explanation is clear thanku soo much
A big thumbs up for the topic as well as presentation 👌
Your teaching style is nice and easy to understand. Suggestion:- You can add data (excel file) to description, so we can practice as well.
Actually, my problems were solved after shown that.....Thank you so much sir.......
you are really awesome bro, So detailed and clear explanation, God bless you. I am following you.
Very useful. In less time, we are learning more. But facing problem when appying. Because you are operating something but that is not being highlited/appeared to vision(eyes) so that mistakes will be reduced.(Zoom view is required while implementing first 2 conditions)
Thank you
Good tutorial.
I already knew this.. But your way to teach is very new and innovative.
Your sessions are simple and if great use!! Thank you
Excellent video, just improved my pivot and learned about advanced filter
Your pronuciation along with explanation is highly appreciating..
Excellent way of teaching. Keep going. All the best and Thank you so much.
The way of expressing the idea is very nice... Excellent representation skill
Thanks a lot sir. Excellent high quality tutorials. Best wishes sir.
Sir thanks a lot for wonderful training sessions on excel. Would you please explain how do we change put minus on debit in the bank transactions after downloading it into work sheets. Is there any formula to put minus collectively in the entire sheet or we need to do it one by one?
This man just saved my grade. HALLEJUAH! God bless you sir
Thank you for explaining it in a brilliant way
Great explain all lessons Thanks tutorial point well educated teacher❤❤❤
Dear Sir, your tutorial is very useful but I do appreciate if you can provide a link for the same excel sheet for an example etc....
The best in teaching i would say. So easy to understand.
explains very good understandable...one of the best teachers and channels for learning excel
thanks for the video. it is really good. your style of presentation is commendable. when we take the filtered results to another sheet the column width and row height of the source is not maintained in the target sheet. that is a problem.is there any way to solve this also?
Hi sir,
I want some topics in excel as goal seek, ctrl +g (go to), text to column, group and ungroup.
I request you, please upload these videos.
I feel satisfied with ur lectures.
Thank you. 😊
Hello dear. Your videos are very interesting and helpful.
Will you explain how to auto update filtered data using advance filter on other sheet.
ua-cam.com/video/gAR_2R4osms/v-deo.html
Brilliant tutorial. Simple to understand. TQ.
thank you, sir. You explained really well
Just amazing teaching style. God bless you sir.
Thank you so much. This was very clear and easy to understand.
Thank you so much sir. Presentation is very clear and understandable. 👍👍
Thank you this will definitely help me in doing filtering :)
Excellent videos from you.love you bro.thank you.good job.
I must say ur explanation style is awesome
Vey helpful sir, especially because it's in english language. And with this, I'm not only learning the technical part of it, yet the terms which just garnish your knowledge among the colleagues.
ua-cam.com/video/pRUIYzdE-SY/v-deo.html
Thank you soooooooooooooooooooooo much, your video just saved me from a question i was trying solve since 2 days,, your method just saved me...ones again thank you thank you soo much, your methods are great!!!
Thank you, sir. The advance filter option very helpful to me. one-sec thanks to did the video.
It's very good teaching method. Easy to analys. Quickly learn. Thank you
very clear & good explanation thanks lot
Dear Sir,
Good evening,
I am from Bangladesh.
Your teaching method is really very very good and your sound is very clear.
I understood very clearly .
Thank you so much .
👌 it is learning different way of filter option , very usefull while doing work on excel...
Thanks a lot...I really learned from your instructions, simple and precise.. Great Job
thank you for the video. question.. is there a way that any changes in the source data can refresh the outcome
it's good that you explain why thing work and not just how to do them.
really clean explanation
super sir
Thanks lot for creating this video Nice explanation...Superb
Thank you sir. Another Microsoft Excel function learnt today again. Superb teaching!
Useful, easy and clear. Thanks.
Thanka so much. So easy to understood. Batam kepri republic of indonesia
Really you are a good trainer keep doing sir
Thank you for your Video, I have one query can you share syntax if i want to filter only 8th date of month and if 8th date is not present then very next working day.
What a magnificent explanation! 🙏
Thanks a lot. Keep up the good work.
I like your way to explain, thank you
Best explanation like it sir. Thank you
Great video, and great tips, thank you! This same result can be achieved with FILTER and SORT functions as well, right?
Noo
Thankyou sir!! You have made it so simple and quick to grasp....
I'm super Grateful for you Sir really appreciated for your incredible help🙏🏻🙏🏻😇😇🙏🏻 Stay blessed😇
You are very good teacher bcoz u teach very easily......thanx for all
Fabulous explanation! Thank you!
I want to know the process of taking, making and resizing this video...
MaMuan bhai, I'm here also,
Thank you soo much sir...Very helpful
Thanks Dude!
Worth learning..
Sir could you please tell me the benefit of this function?instead of using the advance filters we can do it with simple filters also.so please clarify the difference between them.
Your method of teaching is Excellent Bro
Thanks alot man. You saved my 3 days. ❤️
Very Clear explanation and well organized Video,thanks
Thank you very much for explaining well.
Your explanation, commendable.
Good day,
Awesome video
I used the same method and it worked.
But one problem I faced was that, if I make adjustment on the main source, the filter data doesn't automatically change.
It still stay with the previous data...
Can't it be live?
Nice teaching brother... understood well... thank you...
Thank you sir ... very clearly explain..
Dear Sir. I was very use full my date to day work and make me past and accurate. So credit should goes to you.
thank you sir I am improve knowledge after your lesson excel
the way you are explaing was to good and in clear way
u make this advance filter very simple to us thnx
Hello sir
Your session is very nice
How to apply the filler ( only one criteria) when data is in different column & rows.
Not in one column
Thanks. You made the life easier for others.
Excellent. Very good illustration👏🙏
THANKS BRODER YOUR WAY OF TEACHING IS NICE
Thank you sir.
It's very very useful.
I subscribed your channel