Excel Advanced Filter - Complete Tutorial in Tamil | 16+ Excel Tips & Tricks of Advanced Filter
HTML-код
- Опубликовано: 2 авг 2024
- Like the normal filter, Advanced Filter is also one of the major featured option in excel. Watching the entire video can give you a lot of ideas to work better in an Excel Database.
#Filter #AdvancedFilter #ExcelTips #PrabasMSOffice
#RemoveDuplicate
The followings are the topics covered in this video:
1) What is Advanced Filter in Excel
2) Get unique records using Advanced Filter in Excel
3) OR concept using Advanced Filter in Excel
4) AND concept using Advanced Filter in Excel
5) OR & AND concept using Advanced Filter in Excel
6) Filter using Wild Card concept in Advanced Filter
7) Giveaway announcement
Free downloadable practice files:
prabastech.com/free-downloads/
All Videos of Prabas MSOffice in Tamil - தமிழ்
• Unity of SumProduct, S...
VLOOKUP Excel Formula in Tamil - தமிழ்
• Learn VLOOKUP Excel Fu...
Excel Shortcuts in Tamil - தமிழ்
• The top Powerful and B...
Latest and Recent Features in Microsoft Office in Tamil - தமிழ்
• 3D Models with Morph T...
Functions / Formulas in Tamil - தமிழ்
• Unity of SumProduct, S...
Microsoft Excel Training in Tamil - தமிழ்
• Learn VLOOKUP Excel Fu...
SumProduct Excel Formula in Tamil - தமிழ்
• Unity of SumProduct, S...
Macro vba in Tamil - தமிழ்
• 1st GiveAway Appreciat...
Giveaway / gift to Subscribers in Tamil - தமிழ்
• 1st GiveAway Appreciat...
Power Query in Excel - Learn Power Query in Tamil - தமிழ்
• 1st GiveAway Appreciat...
Excel Tips in Tamil - தமிழ்
• Learn the top Excel Se...
How to Print Excel Sheets in Tamil - தமிழ்
• The top 5 Excel tips y...
Must Learn Excel Logical Function - Latest Videos - in Tamil - தமிழ்
• Learn Logical Function...
Microsoft Word Training in Tamil - தமிழ்
• How to Create a Table ...
Excel Waterfall Chart in one Minute in Tamil - தமிழ்
• How to Create Waterfal...
Microsoft PowerPoint Training in Tamil - தமிழ்
• 3D Models with Morph T...
How to Create 3D Objects in PowerPoint in Tamil - தமிழ்
• How to Create 3D Objec...
Microsoft Office Tutorial in Tamil - தமிழ்
• Microsoft Office 2016 ...
Excel Chart in Tamil - தமிழ்
• Chart in Microsoft Off...
General Keyword:
Microsoft office tamil
Prabas MS Office
Prabasmsoffice
Prabas Tech
PrabasTech.in
Prabastech
Prabas excel videos
Prabas excel website
Prabas msoffice free download
Latest Microsoft Office Training in Excel
Advanced Microsoft Office Training Center in Tamil at Chennai
Free Microsoft Office Training in Chennai
Live Microsoft PowerPoint Training
Live Microsoft Excel Training
Live Microsoft Word Training
Microsoft Office Online Free Training in Tamil
Free Computer Training in Tamil
Learn Office 365 in Tamil
Excel:
Excel VBA in Tamil
Excel Formulas in Tamil & English
Advanced Excel Training in Chennai
Advanced Excel Training in Tamil & English
Excel Tamil
Excel Coaching in Tamil
Free Online Excel Training
Excel Text Formula in Tamil
Excel Advanced Formulas in Tamil
Excel for Beginner in Tamil
Excel Advanced Training in Tamil
Excel Array Function in Tamil
Excel Pivot Table in Tamil
Excel Basics in Tamil
Excel Tips and Tricks in Tamil
Excel Top Secret
Excel Step by Step Guide in Tamil
Latest Excel Ideas
Free Excel Practice Files
Excel Support for Business Problems
PowerPoint:
Advanced PowerPoint Training in Chennai
PowerPoint Tamil
PowerPoint Coaching in Tamil
Free Online PowerPoint Training
Microsoft PowerPoint Online Free Training in Tamil
Word:
Advanced MS Word Training in Chennai
MS Word Tamil
MS Word Coaching in Tamil
Free Online MS Word Training
Microsoft Word Online Free Training in Tamil
Tags:
#ExcelTamil
#ExcelTipsTricks
#ExcelOnline
#ExcelTraining
#Word
#PowerPoint
#PrabasMSOffice
#Prabastech.in
#Office365
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.
Very useful filter option used sir,
Advanced Congress to silver RUclips medal ☆☆☆♤ ,quickly gold medal achievement in next year
Thanks for your Golden words. Your support is highly appreciated. We can grow together. Thanks.
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.
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.
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
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.
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.
Excellent video, very informative and interesting
Very nice
Thanks for your continuous journey with Prabas MS Office
Thanks Prabas MS office for your videos so
We are learning and enhance my skills from Excel videos and thanks Prabas. ☺
Happy learning
Very very useful
Keep learning and supporting.
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
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.
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
Very good sir
Practice file is also available in our usual downloadable location, do utilize it. Happy learning.
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...
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.
Super sir
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
Awesome ❤️
Thank you so much for watching the video. Keep supporting.
Very Nice sir
Thanks Raja for posting your appreciation. Happy learning.
ruclips.net/p/PLXqX9fbIzJMboP2SYGh-sGft3Vi6H8RGH
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
Amazing video
Goodmorning. There are more amazing videos available in our channel. Please watch them too. Thanks.
Prabha is My favorite
Glad that you liked it.
If this is your favourite concept, share it with your favorite people.
Very interesting
Thanks for watching this video.
ruclips.net/p/PLXqX9fbIzJMbyD30T_0MnBuKrT1P26c7B
THANK YOU SIR. BUT I WANT INCULDING FORMULA. CAN I DO IT?
Yes sure, you can do it.
Sir, please help me how multiply timings in excel. Example 2 hr 30 min multiply 65 days
In 25m 10 sec
I learned new wildcard
Thanks for watching the entire video.
Once again, congratulations for winning the 2nd GiveAway.
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
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
Thanks for Excel filter and I want to be interest calculation in Excel sheet
Good buddy, keep upgrading your knowledge. Happy learning
easy to learn this vedio please must watch i think you understand
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.
H look up function formula easy method
If you want to know HLOOKUP formula, watch the following playlist:
ruclips.net/p/PLXqX9fbIzJMabaqSMTD-CLMwfYdoVR7AS
Advanced filters dynamic ah matra mudiyuma?
No Brother, we can't dynamically update Advanced Filter..
But it works: ruclips.net/video/F8Wthj4tvTM/видео.html
..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.
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.
How to do greater or equal to
The same way as explained in this video.
Filtered Data to be in separate sheet not in same sheets
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.
Downloadable practice file is updated in the following link:
www.prabastech.in/free-downloads/
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.