Hello Sir, Whow, what a super video with lot of your examples, no one can't explain this type. Keep it up Sir. while I watch this video i really come to now about the advance filter concept. It's really amazing. Once again I very much thankful for your dedicated videos. Keep it up for your dedicated teaching achievement and one more thing am waiting for your wild card video also. Thanks Sir.
@@Prabasmsoffice Yes of course sir, this is my hunger about excel, I have to learn about excel, so i am very curious to watch your videos, thank you sir.
Bro, your genius. Your explanation was very clear. If I watched any topic of the vedio then related files I download and learned strongly. Thank you dear.
Brother I followed your excel teaching videos all, very interesting and more usefull, thank you, All employees and students should see these videos, You should practise laptop or desktop when watch these videos,
Prabas MSOffice = Unique . Easy to understand and learn. Thanks for your Intiative and support. Advance Happy New year 2020🍾🎉, Hope this new year brings you all that your heart desires!😊
Sir thank you for your videos intha concepts na sap use panniruka but athu ennanu enaku theariyathu ippo niga sonna odanea enaku purinjiduchi than you so much and advance happy year
@@hajajahirhussain6814 No brother. Advanced filter dynamic aa work aagathu. But dynamic aa filter pannurathuku oru vazhi irukku. Soon you will receive a notification on this concept. Stay with us.
hi sir your videos are really cool . your teaching style is also unique. i have a doubt sir. how to put rank for changing numbers. for eg- if number is changing every second rank1 if number is changing every 2 seconds rank2 if number is changing every 3 seconds rank3 if number is changing every 4 seconds rank4 like this
Hi Prabhas How do I get more training on Vlookup Pivote and if conditions Need some training materials for the same Your terms and conditions can be discussed Please reply Thanks Selvam
1. Advance filter use panni filter aana rows ah nan manual ah copy panni innoru location la paste pannum bodhu hided rows also paste aagudhu. How to avoid this?? 2. Advance filter la every time namba criteria ah select panradhuku badhila, Criteria la any changes pannina adhu result la reflect aagadha?? Pls give me any solution for this...
@@Prabasmsoffice Brother i watched the video fully. But adhu enna hint nu find panna mudila. I want to filter a number which has * symbol in the end of the number.
sir நான் பில்டெர்ரில் year காலத்தில் 2008 பில்டெர் செய்தேன் ஆனால் கடைசி வரியில் 2021 வருகிறது.தயவு செய்து கூறவும் excel sheet sent mail---------------Thanks
Easy ah irunchi Anna. thanks 👍
Thanks for watching this video, keep exploring more such tutorials.
Hello Sir, Whow, what a super video with lot of your examples, no one can't explain this type. Keep it up Sir. while I watch this video i really come to now about the advance filter concept. It's really amazing. Once again I very much thankful for your dedicated videos. Keep it up for your dedicated teaching achievement and one more thing am waiting for your wild card video also. Thanks Sir.
Hi Brother,
Thanks for your interest on learning this concept. I will make sure to publish wild card concept soon.
Well I watched it
@@sarahari7901 Welcome sir, come to learn
Thanks for your interest. Happy learning. Request you to watch our rest of the videos too.
@@Prabasmsoffice Yes of course sir, this is my hunger about excel, I have to learn about excel, so i am very curious to watch your videos, thank you sir.
Wonderful. Very easy to find. Sir
Unga all excel video paththu than anaku excel la appadi work pandrathunnu therinjathu romba nandri sir.
Thanks for your real-time comment. Keep learning.
This is the super demo for advansed filter, every one must see, to become expert in excel working in office.
Great bro very clear explanation . my first day watching your video, really will help for all the beginner whom want to use excel. thank you so much
Very useful filter option used sir,
Advanced Congress to silver UA-cam medal ☆☆☆♤ ,quickly gold medal achievement in next year
Thanks for your Golden words. Your support is highly appreciated. We can grow together. Thanks.
Excellent video, very informative and interesting
Bro, your genius. Your explanation was very clear. If I watched any topic of the vedio then related files I download and learned strongly. Thank you dear.
Thanks for your positive comment. Happy learning.
Sir your formulas are very easy to understand and very useful for me to upgrade my excel skill.Thank you for wonderful 👍 job
Brother
I followed your excel teaching videos all, very interesting and more usefull, thank you,
All employees and students should see these videos,
You should practise laptop or desktop when watch these videos,
Thanks brother for your wonderful comment. Happy learning.
Prabas MSOffice = Unique . Easy to understand and learn. Thanks for your Intiative and support. Advance Happy New year 2020🍾🎉, Hope this new year brings you all that your heart desires!😊
Appreciate your comment. Keep supporting.
Wishing you the same.
Excellent teaching. Please do some video for macros
Sure, already recorded some VBA videos, they are in editing process. Please stay with us by enabling the notification icon.
Thanks Prabas MS office for your videos so
We are learning and enhance my skills from Excel videos and thanks Prabas. ☺
Happy learning
Sir thank you for your videos intha concepts na sap use panniruka but athu ennanu enaku theariyathu ippo niga sonna odanea enaku purinjiduchi than you so much and advance happy year
Hi Sathiyaraj, it is a good practice to relate the learned concept with your existing skill.
Keep sharing our videos with your friends.
nice concept sir, i have one doutbt is there possible to find out numerical values??? and we use this concept multiple set of tables?
Yes possible. Try to get answered from this video itself. I have explained that too. Watch it carefully.
If you want to find anything, use Conditional Formatting
@@Prabasmsoffice sure bro
Good video bro.
Vba pathi thodarnthu oru series a edunga bro..
Sure brother, planning to publish more videos on VBA.
@@Prabasmsoffice and intha advance filter concept laye dynamic a result change aagura madhiri edhum vazhi irukkudha bro??
@@hajajahirhussain6814
No brother. Advanced filter dynamic aa work aagathu.
But dynamic aa filter pannurathuku oru vazhi irukku.
Soon you will receive a notification on this concept. Stay with us.
@@Prabasmsoffice kandipa sir.
Super sir , thanks for dedicate d video
Sir wild card pathi video podunga sir ellarum new ah learn pannuvanga
Thank you Raja for watching the entire video. Happy learning
Really Useful sir......👍
Thanks a bunch
Very very useful
Keep learning and supporting.
hi sir
your videos are really cool . your teaching style is also unique.
i have a doubt sir. how to put rank for changing numbers.
for eg- if number is changing every second rank1
if number is changing every 2 seconds rank2
if number is changing every 3 seconds rank3
if number is changing every 4 seconds rank4
like this
The normal RANK function will work. Have you tried?
@@Prabasmsoffice will you please give your mail for explain the issue
Very nice
Thanks for your continuous journey with Prabas MS Office
Very Nice sir
Thanks Raja for posting your appreciation. Happy learning.
ua-cam.com/play/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH.html
Excellent presentation. Where can I find the Excel worksheet for download to practice. Please share the link. 🙏🙏
prabastech.com/downloadable-excel-supporting-files-archived-2/
Check here
Dear Sir, Thanks for the video.... How can extract word from sentence in excel?
Please write your requirement to prabas.msoffice@gmail.com with some more examples. Hope to see your email soon.
Hi Prabhas
How do I get more training on Vlookup Pivote and if conditions
Need some training materials for the same
Your terms and conditions can be discussed
Please reply
Thanks
Selvam
Email to prabas.msoffice@gmail.com
Awesome ❤️
Thank you so much for watching the video. Keep supporting.
While giving criteria as a number ( amount =60000) shall we insert equal sign before the number?
If you use =60000, then you will get output only for 60000. the same way you could use =, , or only the number.
Nice
Prabha is My favorite
Glad that you liked it.
If this is your favourite concept, share it with your favorite people.
Amazing video
Goodmorning. There are more amazing videos available in our channel. Please watch them too. Thanks.
Super sir
Thanks for Excel filter and I want to be interest calculation in Excel sheet
Good buddy, keep upgrading your knowledge. Happy learning
Are you providing any Excel Training...?
Yes I provide Office training for the following packages.
Excel, Word, PPT
Happy learning brother.
Location please...
At URAPPAKKAM, near Tambaram, Chennai.
Ungaluku veru engun kilaigal ullatha....(Trichy)
இல்லை.
Appreciate your interest.
Sir, please help me how multiply timings in excel. Example 2 hr 30 min multiply 65 days
Downloadable practice file is updated in the following link:
www.prabastech.in/free-downloads/
THANK YOU SIR. BUT I WANT INCULDING FORMULA. CAN I DO IT?
Yes sure, you can do it.
1. Advance filter use panni filter aana rows ah nan manual ah copy panni innoru location la paste pannum bodhu hided rows also paste aagudhu. How to avoid this??
2. Advance filter la every time namba criteria ah select panradhuku badhila, Criteria la any changes pannina adhu result la reflect aagadha?? Pls give me any solution for this...
Bro iam waiting for a solution for this comment...
Bro How to filter number which has * in it?
Posible brother, I have given a hint in this video. Watch it again.
@@Prabasmsoffice fulla parthuten. Neenga solra hint enga varudhu nu therila.
@@Prabasmsoffice Brother i watched the video fully. But adhu enna hint nu find panna mudila.
I want to filter a number which has * symbol in the end of the number.
Advanced filters dynamic ah matra mudiyuma?
No Brother, we can't dynamically update Advanced Filter..
But it works: ua-cam.com/video/F8Wthj4tvTM/v-deo.html
easy to learn this vedio please must watch i think you understand
..sir =filter formula eppadi add pandradhu. Ennodadhu 2019 latest dhan. But = filter formula Illa sir
The special Filter formula is now available only for Office O365 users.
You my get it later.
How to do greater or equal to
The same way as explained in this video.
H look up function formula easy method
If you want to know HLOOKUP formula, watch the following playlist:
ua-cam.com/play/PLXqX9fbIzJMabaqSMTD-CLMwfYdoVR7AS.html
How to filter the blank coloumns??
Blank columns?, I will try to address your request in the upcoming videos
sir நான் பில்டெர்ரில் year காலத்தில் 2008 பில்டெர் செய்தேன் ஆனால் கடைசி
வரியில் 2021 வருகிறது.தயவு செய்து கூறவும்
excel sheet sent mail---------------Thanks
Sure, will check and update.
In 25m 10 sec
I learned new wildcard
Thanks for watching the entire video.
Once again, congratulations for winning the 2nd GiveAway.
Filtered Data to be in separate sheet not in same sheets
Who is winner
No one brother.
The above competition is still alive
It is little old only, but if you can get 50 likes now, I can consider you as a winner. 🏆.
I request you to encourage your friends to watch our videos.
Very good sir
Practice file is also available in our usual downloadable location, do utilize it. Happy learning.
Very interesting
Thanks for watching this video.
ua-cam.com/play/PLXqX9fbIzJMbyD30T_0MnBuKrT1P26c7B.html