MS Excel - Advanced Filters
Vložit
- čas přidán 17. 07. 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 "CZcams" 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 "CZcams12" 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
Check out latest MS Excel Online Training
courses on : bit.ly/38Jyu3p
Use coupon "CZcams" to get FLAT 10% OFF"
explains very good understandable...one of the best teachers and channels for learning excel
SIR I FOLLOW YOU BUT TELL IF I WANT TO SEARCH WEST SOUTH AT THE SAME TIME
You just taught me what I haven't seen anywhere else. You are just awesome. Great
The Advance Filter options are explained crisp and clear to the point. Thank you really very informative.
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
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...
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
GOOD EXPLANATION SIR. I HAVE UNDERSTOOD ALL THE THINGS YOU MENTIONED IN THIS VIDEO AT ONE GO!
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.
Best excel teacher. Million thanks. I would love to know if you have programming videos with the same teaching style.
I didn’t know it’s this easy. Thanks!! You solved my problem.
Same
Thank you.. slowly it is getting interesting... for sure... your examples were just apt for me to just get hold of it.
Your lessons are clear and easy to understand.Its very effective for me.Thanks for sharing.
Your pronuciation along with explanation is highly appreciating..
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 👌
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..
Thanks for the amazing video. It cleared out all of my doubts 🙂
Actually, my problems were solved after shown that.....Thank you so much sir.......
Your teaching style is nice and easy to understand. Suggestion:- You can add data (excel file) to description, so we can practice as well.
Very simple and useful! You have tht knack to make complex things appear simple!
Your vudeas are always clear, simple, informative and to the point! Luv it!
😀😤😡😠😈👿😩😨😧😦😭
Hello 🌹🍫🌹🍫
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
You explained slowly and clearly. Thank you!
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...
Excellent video, just improved my pivot and learned about advanced filter
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 way of teaching. Keep going. All the best and Thank you so much.
Thank you for explaining it in a brilliant way
Thanks a lot sir. Excellent high quality tutorials. Best wishes sir.
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!!!
The best in teaching i would say. So easy to understand.
The way of expressing the idea is very nice... Excellent representation skill
explains very good understandable...one of the best teachers and channels for learning excel
Thank you sir. Another Microsoft Excel function learnt today again. Superb teaching!
you are really awesome bro, So detailed and clear explanation, God bless you. I am following you.
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!
Just amazing teaching style. God bless you sir.
Thank you so much sir. Presentation is very clear and understandable. 👍👍
really clean explanation
super sir
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 .
This man just saved my grade. HALLEJUAH! God bless you sir
Thank you this will definitely help me in doing filtering :)
It's very good teaching method. Easy to analys. Quickly learn. Thank you
Great explain all lessons Thanks tutorial point well educated teacher❤❤❤
Thanks a lot...I really learned from your instructions, simple and precise.. Great Job
I must say ur explanation style is awesome
Thank you so much. This was very clear and easy to understand.
Brilliant tutorial. Simple to understand. TQ.
Dear Sir. I was very use full my date to day work and make me past and accurate. So credit should goes to you.
very clear & good explanation thanks lot
👌 it is learning different way of filter option , very usefull while doing work on excel...
You are very good teacher bcoz u teach very easily......thanx for all
Thanks lot for creating this video Nice explanation...Superb
Really you are a good trainer keep doing sir
thank you, sir. You explained really well
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. 😊
What a magnificent explanation! 🙏
Thanka so much. So easy to understood. Batam kepri republic of indonesia
Top notch no nonsense teaching!
Thank you, sir. The advance filter option very helpful to me. one-sec thanks to did the video.
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?
Excellent videos from you.love you bro.thank you.good job.
Best explanation like it sir. Thank you
You are best! God bless uh🎉❤
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.
czcams.com/video/pRUIYzdE-SY/video.html
it's good that you explain why thing work and not just how to do them.
Hello dear. Your videos are very interesting and helpful.
Will you explain how to auto update filtered data using advance filter on other sheet.
czcams.com/video/gAR_2R4osms/video.html
Thanks alot man. You saved my 3 days. ❤️
Useful, easy and clear. Thanks.
I'm super Grateful for you Sir really appreciated for your incredible help🙏🏻🙏🏻😇😇🙏🏻 Stay blessed😇
Thank you sir ... very clearly explain..
Nice teaching brother... understood well... thank you...
Thanks a lot. Keep up the good work.
Thanks Dude!
Worth learning..
Thankyou sir!! You have made it so simple and quick to grasp....
Fabulous explanation! Thank you!
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....
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?
Thank you, was really useful
Bro your always my go to. Thanks man
Very Clear explanation and well organized Video,thanks
Your explanation, commendable.
Nice sir..
Easy to learn
Tq so much sir
Great sir, also great demonstration style
Thanks. You made the life easier for others.
I like your way to explain, thank you
very helpful video.. explanation at its best
I want to know the process of taking, making and resizing this video...
MaMuan bhai, I'm here also,
thank you sir I am improve knowledge after your lesson excel
Your method of teaching is Excellent Bro
I liked your way in illustration. smart
Very useful tutorial . Thank you
No words for the way you teach 😊😎
Thank you sir.
It's very very useful.
I subscribed your channel
Great explanation of the function. Thanks sir ❤❤