I am a 72 yr old. I am a compliance consultant. Your videos are helping me to work faster with various formulae. I have learnt from your tutorials Pivot,Col Row highlight with color,Vlookup. Now see the video IUnity of IF, Index, Match and VLOOKUP | Advanced Excel Formula in Tamil | Which formula One . I am getting stressed out when I sit continuously. Keep updating.
The most frequent and major problem that I faced while working through these assignments was knowing which formula to use for certain computations.For me, the Excel you tube channel through prabas ms office was the most helpful tool to address and solve these formula issues.The website worked the best because not only did it have the equation, but it also included steps and examples for each equation.If there was information I could not find through any other source, I usually turned to prabas ms office.These channel walked through the steps to help find whatever value I was trying to compute.This was a great help, because the channel walked through the examples right on Excel, so I knew exactly what to do when I went back to my workbook. Many thanks to you......
How can we say it's not liked,excellent and easiest explanation, we can learn a lot from you,this is what most sought after by me for a long time,finally i got it,thank you so much,God bless you
Already my teacher has taught me byt I can't understand but u are teaching simple 🙏🙏great sir and how many formulas important in excel that everything could u teach in one video sir pls this is my request to u
Hi..Prabha.. I was eagerly awaiting to see your video ..!!! Excellent..! I am always love your presentation..!! How good..!!! Thank you.. today 1 more subscriber by my reference..!!😊😊😊
Sir I have a doubt. It is regarding data entry for a exam . I have to enter the register number and the subject code for that register no. Which formula should I use to restrict for that register no the same subject already entered should not be entered
Sir last month sales man report and current month sale man report how to compare. Example last month 15 person, current month 21 person, extra five person add how to find out additional 5 person
super explanations, But I need to calculate Total of 5% tax Amount & 12% Tax Amount from a Table, How to use Vlookup formula? Please explain me Sir, Thank you
Good evening sir, This is Ramesh kannan from Mysore (village), I am working in Bricks company a small company, I have improved in Excel formula, I am understand in card codez but dollar symbol I don't understand sir, more confusing sir,say speeking slowly, and maximum use Tami words sir.
Sir enaku oru doubt. Ipom oru worksheet la two types of data iruku. Ex:college,school 1st column la enaku college and school base panni more datas iruku but enaku school la irukura data matum venum atha epdi vera worksheet la edukurathu please explain pannunga
Thanks for writing your comment. If you need any support from Prabas MS Office, please read the following options: Option 1) If you are my Subscriber, you are expected to calle me on all Saturdays between 10 to 11.45 am. Make sure to install AnyDesk software and call me for assistance. Option 2) Subscriber can also share your requirements through email and wait for the solution as a video. I will make sure to publish a video for you in our TH-cam Channel. Option 3) If you are my client, you can call me anytime and get the necessary support. Email me for more information. prabas.msoffice@gmail.com By Prabas MS Office
Hi Brother. Good Evening. I hope you and all your family members are safe. You videos are understandable.. Thank you for the Videos. I have a doubt. Please explain the below formula =Index( Reference, Row Number, [Column Number],[Area Number]). Where we can use this formula. Please explain this or share the video link, If it is explained in other video...
Thanks for wishing PRABAS MS OFFICE. We are all safe and secure,no hope you too safe. Coming to your doubt: Index is one of the beautiful formula, if we combine Index formula with other formulas, we can get fentastic solutions. Do access the following link to know more: Excel Index Formula in Tamil: th-cam.com/play/PLXqX9fbIzJMa50eD9ZE3FZUaHLMWyg10o.html
Sathyaraj, xlookup is now available only for limited office insider as beta trail. I will make sure to publish a video when it is available. Thanks for your interest.
I am a 72 yr old. I am a compliance consultant. Your videos are helping me to work faster with various formulae. I have learnt from your tutorials Pivot,Col Row highlight with color,Vlookup. Now see the video IUnity of IF, Index, Match and VLOOKUP | Advanced Excel Formula in Tamil | Which formula One . I am getting stressed out when I sit continuously. Keep updating.
Thanks for sharing your takeaways.
As you suggested, we always post such videos. Thanks.
I'm familiar in MS package for more than 12 years, but I can't skip seeing your videos and explanation. Very nice and interesting 👍👍 thank you
Thanks Irfan, keep learning and supporting.
👍
Your Explanation Was Next Level
சிறப்புபாக இருந்தது சார். இதேபோன்று எளிமையாக போடவும். மகிழ்ச்சி.
கட்டாயமாக, நன்றி.
Keep watching and learning.
Downloadable practice file is placed in the usual location.
prabastech.in/free-download
In 15m 36sec
=index(array of salary, match(job type, array of job types, Exact Find))
Great Explanation
Perfect Karthick
Anna unga explanation romba elumiyavum ,arumayaum iruku
Nandei thambi
The most frequent and major problem that I faced while working through these assignments was knowing which formula to use for certain computations.For me, the Excel you tube channel through prabas ms office was the most helpful tool to address and solve these formula issues.The website worked the best because not only did it have the equation, but it also included steps and examples for each equation.If there was information I could not find through any other source, I usually turned to prabas ms office.These channel walked through the steps to help find whatever value I was trying to compute.This was a great help, because the channel walked through the examples right on Excel, so I knew exactly what to do when I went back to my workbook.
Many thanks to you......
I appreciate you for providing such a honest comment. There is a lot to learn and achieve.
Stay tuned with Prabas MS Office.
How can we say it's not liked,excellent and easiest explanation, we can learn a lot from you,this is what most sought after by me for a long time,finally i got it,thank you so much,God bless you
Thank you! Please explain date wise debit and credit totals in two columns and balance in next line like in tally cash book
Very nice and interesting explanation, even beginner to excel can understand easily, thanks for sharing the knowledge
Thanks for your positive comment. Keep learning and supporting. 👍
ஒரு பானைக்கு சோற்றுக்கு ஒரு சோறு பதம் example super
Superb Kannan for stressing the point. Good observation.
Way of teaching... amazing 😍.. I'm just stranger for excel... I understand well❤️
Appreciate your time to put a positive comment.
Request you to watch rest of the videos too.
th-cam.com/play/PLXqX9fbIzJMbyD30T_0MnBuKrT1P26c7B.html
Excellent
Excellent Sir, simple explanation.
Keep learning.
Already my teacher has taught me byt I can't understand but u are teaching simple 🙏🙏great sir and how many formulas important in excel that everything could u teach in one video sir pls this is my request to u
Sure I will try to make a seperate video for your request. கற்க கசடற.
Very Nice
Very nice thanks
Supper first time watching sar very yous full thank you
Thanks for watching. Watch our rest of the videos too. Happy learning
super sir. excellent explanation.
Super super sir fantastic sir
Thanks for video
Super explain
Good learner
Well explained thanks 👍
I am not like 2nd option, i like 3rd and 4th only simply super and thanks for your good teaching
Thank god❤
Super very easy to compare other formula s
Yes Gopi. Try to download the practice file and practice it.
Thanks for following PrabasMsoffice.
Super
Sir vannakkam how use without trim formula . To delete extra space. Kindly guide me sir
Different products different values in 1 column formula. Example hotel rs. 1000, taxi rs.5000, flight rs. 10000 like this
Hi..Prabha.. I was eagerly awaiting to see your video ..!!! Excellent..! I am always love your presentation..!! How good..!!! Thank you.. today 1 more subscriber by my reference..!!😊😊😊
Thanks for your energetic and positive feedback.
Thanks for referring prabas msoffice to your friends. Need your support guys.
@@Prabasmsoffice For your quality of presentation it's our small complement..😊😊😊
Bro Yennakku Ipoo Tea shop la use panra sale report Eppadi use panna Nalla irukkum Athukku farmula solli koodunga BBro
Ur voice is very sweet ☺️
Thanks sister.
Vlookup very use full bro
Thanks for taking time for posting your thoughts. 👍
Thank you very much sir.🙏 I am seeing your videos just now. Too late...😔
Thanks for your new journey
benefit if,index,vlookup,thank you
Sir I have a doubt. It is regarding data entry for a exam . I have to enter the register number and the subject code for that register no. Which formula should I use to restrict for that register no the same subject already entered should not be entered
very nice explanation. continue your work
Share our videos with your friends. Share it in your whatsup groups if possible.
@@Prabasmsoffice kandippa recommend pannuvan
அருமை
Nice explanation
Thanks Mohammed for posting your comment.
Sir last month sales man report and current month sale man report how to compare. Example last month 15 person, current month 21 person, extra five person add how to find out additional 5 person
Easily posible brother. Try to watch our vlookup videos.
Hi prabha, I am your new subscriber , the way of your explaination and voice modulation is good
Happy learning 👍
Point Decimal two digit number mattum Small size ah change panna mudiyuma??
Excel இல் இதை ஒரே ஃபார்முலா மூலமாக செய்ய முடியாது. ஆனால், இரண்டு ஃபார்முலா மூலமாக நம்பர்களை பிரித்து, தனித்தனியாக format செய்யலாம்.
@@Prabasmsoffice நன்றி bro 🙏.. அந்த இரண்டு ஃபார்முலா என்ன என்று ஒரு வீடியோ பண்ணுங்க bro. நன்றி 🙏
கட்டாயமாக.
@@Prabasmsoffice நன்றி 🙏
Sir supera solringa,but claritya excel sheet therila sir
Thanks for your comment, please make sure to view this video in high resolution mode.
Super teaching sir Google sheet functions konjam teech pannuinga sir please please sir
Sure
Good explanation sir, we need shift schedules whole month this type of method how to used sir every Sunday weekly off highlight 3shift working
Thanks for your question. Please elaborate your question with some more examples.. thanks.
prabas.msoffice@gmail.com
@@Prabasmsoffice okay sir
Will give you sir
super explanations, But I need to calculate Total of 5% tax Amount & 12% Tax Amount from a Table, How to use Vlookup formula? Please explain me Sir, Thank you
ungalukku idhu epdi panradhunu therinjadha
Sir... How can we do vlookup if there are multiple cell values in a row for that reference cell in the reference row?
We can use vlookup for multiple references too.
Good evening sir, This is Ramesh kannan from Mysore (village), I am working in Bricks company a small company, I have improved in Excel formula, I am understand in card codez but dollar symbol I don't understand sir, more confusing sir,say speeking slowly, and maximum use Tami words sir.
Amazing
Appreciate your learning interest. Keep upgrading.
Sema idia
Appreciate you for posting your comment again. Thanks.
Sir enaku oru doubt. Ipom oru worksheet la two types of data iruku. Ex:college,school
1st column la enaku college and school base panni more datas iruku but enaku school la irukura data matum venum atha epdi vera worksheet la edukurathu please explain pannunga
You could use lookup or index match Formula
Whether any material or books published by you regarding Microsoft excel please furnish details
Thanks for writing your comment.
If you need any support from Prabas MS Office, please read the following options:
Option 1) If you are my Subscriber, you are expected to calle me on all Saturdays between 10 to 11.45 am.
Make sure to install AnyDesk software and call me for assistance.
Option 2) Subscriber can also share your requirements through email and wait for the solution as a video. I will make sure to publish a video for you in our TH-cam Channel.
Option 3) If you are my client, you can call me anytime and get the necessary support. Email me for more information. prabas.msoffice@gmail.com
By Prabas MS Office
We do not provide any material for reading...
I think VLOOKUP is fastest and easiest way (for me)
That's good. Keep practicing.
Bro na office la work pandren excel la data's la work pandra mathiri formula podugga basic formula ellama extra va
Sure brother.
Bro if condition la 6 posting irukku so formula la last la 6 close bracket kudukkanuma 🙄
Oru close bracket kudutha podhuma
If you Open 6 brackets, you also have to use 6 Close brackets in IF condition.
You are great sir....thank you so much for sharing your knowledge
நன்றி நன்றி. Please consider to subscribe for future updates.
Any example for index having 3 column of values..pls reply
Will make a video on this concept soon.
@@Prabasmsoffice 👍
Filter use panni designed ha filter amount enter panni drag use pannalam formula venam illa
Hi Brother. Good Evening. I hope you and all your family members are safe. You videos are understandable.. Thank you for the Videos.
I have a doubt. Please explain the below formula
=Index( Reference, Row Number, [Column Number],[Area Number]). Where we can use this formula. Please explain this or share the video link, If it is explained in other video...
Thanks for wishing PRABAS MS OFFICE.
We are all safe and secure,no hope you too safe.
Coming to your doubt:
Index is one of the beautiful formula, if we combine Index formula with other formulas, we can get fentastic solutions.
Do access the following link to know more:
Excel Index Formula in Tamil: th-cam.com/play/PLXqX9fbIzJMa50eD9ZE3FZUaHLMWyg10o.html
Bro.. where can i get the practice file
I will try to find and share.
Hiw to split amount in excel sir
It is posible, many ways are there to split your required text from an another text.
1. Left
2. Right
3. Mid
4. FlashFill
5. PowerQuerry
6. More
Try one of these.
Sir please take xlookup formula
Sathyaraj, xlookup is now available only for limited office insider as beta trail. I will make sure to publish a video when it is available. Thanks for your interest.
New formula erundaa sollunga sir
Sure.
Filter n copy paste problem solved
Yes, there are many benefits....
Still ...I feel index match . difficult for me ....sir
But it has more flexibility over the vlookup formula brother. Left lookup is only posible with Index Match..
@@Prabasmsoffice ok sir will try my best and adapt sir
@@Prabasmsoffice will try my best and adapt sir
Naraya pesura mari iruku konjm short paunga
Noted
Very usefull to us
Very usefull sir thanks
Thanks Madurai Somu for posting your comment here. Happy learning.