Top 10 most important Excel Functions in Excel in Tamil
Вставка
- Опубліковано 17 лип 2024
- 10 Most used Functions in Excel step by step Tutorial.
Practice File: docs.google.com/spreadsheets/...
Click the Link below to learn. (Subscribe for more upcoming Tutorials)
Important Excel Function in Tamil
• Important Excel Functi...
Timestamps:
0:00 Intro
0:35 IF Function in Tamil
2:25 Sumifs Function in Tamil
6:10 Countifs Function in Tamil
8:31 Vlookup with Iferror in Tamil
12:40 Sumproduct Function in Tamil
13:53 Concatenate and Textjoin Function in Tamil
17:01 Unique Function in Tamil
19:01 Filter Function in Tamil
20:25 Sort Function in Tamil
21:43 Wrap Up
#exceltutorialtamil #endlessknowledge
Don’t Forget to Follow:
twitter.com/EndlessKnowled1
facebook.com/enlessknowledge
instagram.com/end_less_knowledge
Excellent explanation sir.... Multiple condition ku difference ah details ah convey panringa... Thank you so much sir....
You are really amazing ... I am using most of the functions in my work and got more appreciations because of you. Thank you so much for these clear information anna❤
Hii sister neenga enna wrk panringa
Wow sema bro great explanation 👏👏👏 thank you so much 🎉keep going 😊
Thank you very much sir
Excellent explanations
very useful to us
Very useful Worthy video❤🥰
Glad you think so!... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Dear sir very excellent explaintion, we use vlookup function fix the data set table dooler simple find the exact value
Thank you very much, very much useful I learnt a lot
Vstack new excel formula explain panni video podunga bro🙏🙏🙏
excellent sir. still a lot to learn
Anna .
Thank you very Much Indeed...
For your Great Helps to All
I am learning much from your YT videos
You're most welcome my brother...
Nice.. Trying to understand this bro
Nice and very clear Bro..tks
Very good useful information 👍
excellent way of teaching
நன்றிகள் பல!🙏🙏🙏🙏
Good Vedio Sir. Good Teaching skill 👍
Praying for your Great success Annaa
Thank you Again..
Thank you so much 🙂 brother...
Thanks bro for your wonderful teaching I had some thing from this video Now I able to manage the very better way Big fan for your teaching😊😍🤩🥰😇
Glad it was useful to you brother... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
@@EndlessKnowledge Thank you Bro
Thanks for your help.
Thanks bro please put a video for it because
It is useful for me again Thanks bro
Thanks for your effort
Super bro my doubts lot off clear in this video👍👌👌👌
Glad to hear that brother... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Super explain 🔥💯👍
Thank you very much SIR.
Anna niga super aa explain pannuringa
its useful for us sir
Excel now all clear Anna.. Thank you so much your precious time annaw ♥️
Welcome 😊 my brother 😊
@@EndlessKnowledge iam not brother I'm your sister Anna ❤️
Thank you so much brother for the clear explanation...
Your most welcome brother... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
@@EndlessKnowledge Sure brother 🙌🏻
Great Help... Thank you...
Your most welcome... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Some function does not come in my excel sheet (text join,unique) this kind of function does not display what can I do
Super BRO 👌
very useful
சார் வணக்கம் தங்களுடன் தொடர்பு கொள்ள வேண்டும். டிரான்ஸ்போர்ட் எக்செல் சாப்ட்வேர் செய்யவேண்டும் தாங்கள் சொல்வது தெளிவாக புரிகிறது நன்றி நண்பரே
Sir shall I do for u
@@sathishkumarmurugan7680can I get your contact information?
Hi. How can I change the cell display content based on another cell value?
Example: 1 cell will have value (0 to 100) which is based on formula and will change. I want another cell to display low, minor and major based on the other cell value. Cell value >15 - “Low”, 15-60 - “Minor” and 60-100 - “Major”. If the cell value is 45 then the other cell needs to display as minor.
Super Learning JI 👌
So nice of you brother...
Thank you so much sir...please teach us about DTP in details pls
Thanks bro
You are a genius sir.
you are! my friend... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Thanks for your videos🙂
Glad you like them!... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Thanks sir
Paaahhh clear explanation 🎉🎉🎉🎉🎉🎉 super 🎉🎉🎉
Glad you liked it... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
@@EndlessKnowledge ok nga😎
Super Anna thank you so much
your most welcome... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Very very useful
Glad it was useful to you... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
Hi sir, how to check whether all columns and rows are matching with sheet 1 and 2
Bro... will you conduct online classes?
Thank you sir 💐Text join, unique, filter,intha option Naa practice pantra Excel la illa sir, may you told me,what reason sir,
HI SIR,
=VLOOKUP(G2,B2:E84,4,FALSE) BUT THE RESULT I GOT IS WHICH IS THE VALUE OF THE FIRST LINE NOT A TOTAL
Thanks anna puriyara madhiri solli kuduthinga
Anna indha 10nukum shortcut solli kudunga pls
sure ma... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Hi, Could you please explain how to segregate card and cash payments?
Mr. @EndlessKnowledge Could You Please Pivot Table *External Connection Based Video Update do useful*.. Thank You🙂
How to ms word insert to Disign view to water mark?. Thanks to you.
Thankyou sir
your most welcome... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Super sir Tq
Welcome... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html
hi, stock market related ah videos podunga bro.
excel with stock market.
Sure 👍...
image file location (image file path) in V column (ex : J:\00.EXCEL\Member List\MemberPhotos\2997.jpg) has , What is the formula to get those images show in W column using this?
Share about chatgpt and AI tool bro
Sir, we need numbers vs image for example 80% to 100% =one image or chart
Sir count ifs and sumifs different solunga sir.
Same ha iruku
Sir ,
Filter formula not coming in my excel pls reply
As usual, you are the best teacher as well as an expert in Excel, very useful for all your videos 👌👌👍👍👍👍✌✌✌✌
Many many thanks... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
👌
👍👍👌👌
need formula for days overdues calculation in ms excel.
RS epdi bro one column box eliya varuthu .. sum ku work aguthu
Enna formula bro ethuku
HI bro which editing software did you use for edit a video please put a video how to edit?
Sure I will brother... i use filmora 13 ua-cam.com/video/TTLlq0XcJNA/v-deo.html
Brother add pannurathuku select pannithaan alt+= pannuna varamatikithu
Text join work aagala anna...
Appadi oru function ae illatha Mathiri kaatuthu
Hi bro
How to calculate lateness by vlookup
Ex: 8am to 8 pm (12hrs shift)
If 8.30 am in time 8pm out time 11.5hrs how to calculate lateness by using vlookup
👍👍👍
👍🙏🙂... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
If two or more cells value is added the total is = 0 i need to get qro in total if > 0 need to show the exact total
✨....Bro unga voice 🤔 Mr.Tamilan channel mari Iruku light ah🤔
Bro sort & filter ku any short cut key solluga bro 😁
Brother you can use Alt + Shift + S to sort and Ctrl + shift + L to Filter
How do we find out, one item next sheet where is on all rolls?
Bro tally prime tutorial potuga
Ok I will try bro...
Bruh video order ra post panna pakuravanga Kulu easy ya irukum
Bro images lanthu epadie data's copy pandrathu
Assignment writing epidi panurathu nu soli thaga bro
17:01 sir. unique function old version ilana epdi unique values edukurathu sir soli kuduga.
you can use remove duplicates from Data tab under Data tools group...
Anna., Orutharoda Age Vachu Entha Year la Piranthu Irukkanga nu Kandu Pidikka Formula Ethum Irukka ?
try this brother... ua-cam.com/video/1tYkzg5Kxb4/v-deo.html
Hi Bro, sheet 1la Material type, Material Code, Material name etc.........
enaku sheet2 la Material code codutha automatic ka Material type and material name display akanum.
ethuku ena function ues pannamu ple..........................................................
Enakkum same powder part number powder name , powder color code and powder supplier nanum powder part num kudutha automatic ha powder name ,color code , supplier list varanum
NOT EXPLAINED H COLUMN IN SUMFS AND COUNT HOW DO YOU PUT >=400??
sumifs,maxifs,unique..... in excel 2016 available ilaya bro
Unique Function... Need office 365 subs...
Bro pivot table try panu lam
bro
Yes brother... ua-cam.com/video/S68AyYZeZrQ/v-deo.html
Filter,sort functionlam invalid nu varuthu🥺
Anna tally solli thanga plsssss
Text join,Unique function lam Ms2013 la kaedaiyatha anna
need office 365 ma... ua-cam.com/video/_6KyULrQS-k/v-deo.html
sumif total sales value 0varudhu sir pls reply
i am waitting your answer
Hi Bro I am working in Saudi Arabia I don't how use the excel tell me basic steps
go through this playlist about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html
Amount la Rs. Kudutha answer vara matuku anna🥺
Sir msexcel 2007 la unique function panna mudiyala sir
yes, you need office 365 subscription...
@@EndlessKnowledge ok sir
Unga excel kedaikum ma
Hi sir i have a one doubts. How to find state wise zone
Example : TN & TELUNGANA, KARNATAKA & KERALA This is south Zone
Example : MAHARASHTRA & GUZARATH This is East Zone. Which formula to use for this in excel.
V lookup
Bro video clear ila
Increase the quality while watching the video brother...
Excellent
Learn how to create a Excel Dashboard with this step by step tutorial ua-cam.com/video/YkLNJTNPgwA/v-deo.html
Thanks anna unga video onnukuda vidama pardhudven aanalum yenakku neraiya doubts erukku.. adha yepdilam solve panradhu theriyala.. ungaloda contact number kedatcha nalla erukkum anna
Super BRO 👌
Thanks bro
Welcome brother...