10 Most Useful Excel Formulas - Malayalam Tutorial
ലോകത്തിൽ ഏറ്റവും കൂടുതൽ ഉപയോഗിക്കപ്പെടുന്ന പത്ത് എക്സൽ ഫോർമുലകൾ വിശദീകരിക്കുന്ന വീഡിയോ.
10 Most Popular Excel Functions explained with examples.
00:00 Intro
00:43 SUM
03:53 IF
09:12 CHOOSE
11:30 DAYS
12:52 VLOOKUP
16:08 DATE
17:40 LOOKUP
20:08 MATCH
22:02 FIND
24:59 INDEX
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/course/microsof...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/course/learn-mi...
Start learning Microsoft Excel in Malayalam
• Microsoft Excel Tutori...
#ExcelMalayalam #LearnExcelInMalayalam #MalayalamExcel
Пікірлер: 150
BGM ചേർക്കാത്തത് നന്ദി മികച്ച നിലവാരത്തോടെ കൂടി വീഡിയോ പോസ്റ്റ് ചെയ്യുന്നു All the best 👍
Super class... Simple and powerful.. No BGm. No lag. Only relevant points
@XLnCADMalayalam
3 жыл бұрын
Thank you :)
Start learning Microsoft Excel in Malayalam kzread.info/dash/bejne/hqqZyKWblZzZY5M.html
Professionally higwy dsgnr aavathe oru teacher aavendathayirunnu.slow learners polum full mark nedum👌.Nale oru intrw und thank u sooo much
@XLnCADMalayalam
4 жыл бұрын
Thank you for that Awesome compliment :)
To the point explanation...thank you.. It was very useful and informative
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that :)
Super class നല്ല അവതരണം, ഒരുപാട് ഉപകാരപ്പെട്ടു, നന്ദി ഉണ്ട് sir
വളരെ ഉപകാരപ്രദം
പക്വമായ അവതരണം ,നല്ല ശബ്ദം👏👏👏
Good information 👍🏻👍🏻👍🏻👍🏻 thanks
👍 very usefull
Great explanation 👌
Valare nalla class anu sir.... Thank you... God bless you
@XLnCADMalayalam
3 жыл бұрын
You are welcome :)
Very useful, thank uh so much,god bless uh...
@XLnCADMalayalam
3 жыл бұрын
Welcome 😊
Informative
Thanks alot.. Really helpful❤️
@XLnCADMalayalam
3 жыл бұрын
Glad it helped!
Super, highly informative
@XLnCADMalayalam
3 жыл бұрын
Glad you think so!
ആദ്യമായിട്ടാണ് ഇവിടെ എത്തിയത്. Very nice explanation 👌. All the best. Go ahead....
@XLnCADMalayalam
3 жыл бұрын
Thank you :)
സൂപ്പർ
Love u sir Thank u
VERY HELPFUL VIDEOS.
@XLnCADMalayalam
4 жыл бұрын
Glad you think so!
It is very beneficial , and your presentation is very exceptional
@XLnCADMalayalam
3 жыл бұрын
Thank you for that awesome compliment :)
Super..nannayi thanne simple ayi paranju thannu....thanku❤
@XLnCADMalayalam
Жыл бұрын
my pleasure :)
Great ❤️❤️❤️❤️
Nice class👍👍 Very useful,Thanks
@XLnCADMalayalam
2 жыл бұрын
My pleasure :)
Well presented... Thank you so much
@XLnCADMalayalam
3 жыл бұрын
Glad it was helpful!
Thank u
Very useful video thank sir
@XLnCADMalayalam
2 жыл бұрын
My pleasure :)
Thankuuuuuuuuuuuuu💓💓💓👌👌👌🥰🥰🥰its so useful
@XLnCADMalayalam
3 жыл бұрын
My pleasure :)
Adipoly 👍👍👍 Thanks sir.
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Thank u Good class
@XLnCADMalayalam
3 жыл бұрын
You're welcome!
Explain well 👌👌
@XLnCADMalayalam
3 жыл бұрын
Thanks and welcome
Nice class... Thanks
@XLnCADMalayalam
2 жыл бұрын
You are welcome
Brilliant....ആ excell ഫയൽ അപ്ലോഡ് ചെയ്യാമോ 😁
Thank u sir
@XLnCADMalayalam
3 жыл бұрын
So nice of you
Valare nannayi mansilakki thanna sir nu thanks
@XLnCADMalayalam
2 жыл бұрын
Glad to hear that. Thank you :)
Brilliant 💯
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
എനിക്കിതു വളരെ ഉപകാരപ്പെട്ടു 😍😍👍👍👍 thanks sir
@XLnCADMalayalam
3 жыл бұрын
Glad to hear that.
@sunilpeter5461
3 жыл бұрын
@@XLnCADMalayalam 😍😍😍👍👍👍👍
Thank you
@XLnCADMalayalam
2 жыл бұрын
My pleasure :)
THANK YOU SIR
@XLnCADMalayalam
3 жыл бұрын
Most welcome
thanks lot
@XLnCADMalayalam
3 жыл бұрын
You are most welcome
KOLLAM THANKSSSSSSSSSSS
Very useful
@XLnCADMalayalam
2 жыл бұрын
Glad you think so!
Thanks
@XLnCADMalayalam
4 жыл бұрын
Welcome
Hai I need to customerise excell for our annual maintenance contract for service to our client with monthly, quarterly basis. How can manage service and payment
Hi I can't perform using formula, after pressing enter key showed formula you typed an error. I am using Excel 10. Please suggest a solution
👍👍
Good.
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
Super class✌
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
👍
oru worksheetil cheitha claculation nte total sum next worksheetil kittan ayetulla steps nthokeya..athinte videos undekil pl sent the link
Super
@XLnCADMalayalam
2 жыл бұрын
Thank you :)
🙏
എങ്ങനെ ആണ് എക്സലിൽ ഒരു സോഫ്റ്റ്വെയർ സ്കൂൾ അക്കൗണ്ട്സ് എൻട്രി ചെയ്യാൻ ഉണ്ടാക്കുന്നത്. പ്രധാനമായും ഫീസ് എൻട്രി ആണ്. പിന്നെ ledger വേണം. അതിനെ കുറിച്ച് ഒരു വീഡിയോ ചെയ്യാമോ? 🤔
Hi, just zoom ur screen while explaining it will be more better'✨
@XLnCADMalayalam
2 жыл бұрын
Thank you for the suggestion😀
Sir, Can I possible to highlight Date column before 2months date(to check expiry)
@XLnCADMalayalam
2 жыл бұрын
this can be done using Conditional formatting. Check my videos on the same.
if functionil pass and fail try chydhu. 1st candidate nte correct vannu baaki elladhum thazhott drag copy cheyyan vendi f4 function press cheyyumbol elladhum delete avaann cheyuunadh.......y sir.. ?
@XLnCADMalayalam
2 жыл бұрын
Please go through my videos on IF function and Relative, Mixed and Absolute references.
no music . no unnessessory talks and lag നല്ല ക്ലാസ്
@XLnCADMalayalam
2 жыл бұрын
😀 Thank you
When we are using LOOKUP function…Is it compulsory to keep the data in alphabetical order.
@XLnCADMalayalam
3 жыл бұрын
Yes. LOOKUP function is designed in such a way that it assumes values in the lookup_vector are arranged in Ascending order.
@shafikp6361
3 жыл бұрын
@@XLnCADMalayalam Thanks 😊
Dataset share cheyyumo practice cheyyan aanu....(pin cheythu vekkumo description il)
@XLnCADMalayalam
Жыл бұрын
60+ Practice files are available with my online course on Excel. Please check the video description for details.
Automatic ayi data change avunnu pinne format cell il poyi change cheyyanam pinnem angene avum any solutions
I have tried VLOOKUP formula for getting the details from another sheet. But it is not working. Could you please help me on this..
@XLnCADMalayalam
3 жыл бұрын
I have done a video on this topic. Please go through the videos section.
Sir please explain the dif between find and search..
@XLnCADMalayalam
3 жыл бұрын
FIND function is case-sensitive and does not allow wildcard characters whereas SEARCH function is not case-sensitive and allows the wildcard characters "?", "*" and "~"
ഒരു account Sheet തയ്യാറാക്കി കഴിഞ്ഞ് അതിലുള ഒരു പോലെ വരുന്ന (5 പെട്രോൾ ബിൽ, TA Grocery] തിന്റെ തുകകൾ എങ്ങനെയാണ് ചെയ്യുന്നത്.
@XLnCADMalayalam
2 жыл бұрын
Please check my video on SUMIFS function.
what is the use of Choose function? did not understand, If this is for a huge data?
Sir... Find function um search function um thammil olla diffrence enthaanu?
@XLnCADMalayalam
3 жыл бұрын
FIND function is case-sensitive and does not allow wildcard characters whereas SEARCH function is not case-sensitive and allows the wildcard characters "?", "*" and "~"
Thanks ഒരു സംശയം ചോദിക്കട്ടെ, ഒരു excel ഷീറ്റ് password Protect ചെയ്ത ശേഷം mail അയക്കുന്നു download ചെയ്യുമ്പോൾ Protected ആണ്, but Password ഇല്ല, ഈ പ്രശ്നം എങ്ങനെ പരിഹരിക്കാം
SIR 0 and less than 0 vanna "0" ennum athil kooduthal vanna " (X-1)*500 " kittan engane cheiyamm???
@XLnCADMalayalam
3 жыл бұрын
=IF(A1
Good presentation 👍 One doubt Oru sheet 1 ninnum sheet 2 pokan shortcut key vallathum undo?
@XLnCADMalayalam
2 жыл бұрын
Press Ctrl + Page Down to select the next worksheet
@shaminashabeer3461
2 жыл бұрын
@@XLnCADMalayalam Thanku😁
Oru Main list of numbers and a supplement list of number atil supliment listil ellathaa main listil ulla numbers kandu pidikkan ulla function onnu parayaammoo
@XLnCADMalayalam
2 жыл бұрын
I think I have done a video on this topic. Please refer the videos section of this channel.
എക്സൽ ഒരു ഷീറ്റിൽ ഫുൾ ടാറ്റ ഉണ്ട്. തൊട്ടടുത്ത ഷീറ്റിൽ രജിസ്റ്റർ നമ്പർ കൊടുത്താൽ ആദ്യത്തെ ടാറ്റ ഷീറ്റിൽ നിന്നും ആ പാർട്ടിക്കലർ റെക്കോർഡ് മാത്രം കിട്ടാൻ എന്ത് ചെയ്യണം
@XLnCADMalayalam
2 жыл бұрын
Please refer my videos on VLOOKUP function.
കോഡ് നമ്പർ കൊടുക്കുമ്പോൾ ഓട്ടോമാറ്റികായി അതിനുള്ള ഡിസ്ക്രിപ്ഷൻ മറ്റൊരു കോളത്തിൽ കാണിക്കാൻ എന്ത് ചെയ്യണം?
@XLnCADMalayalam
2 жыл бұрын
Please go through my videos on VLOOKUP and INDEX+MATCH formulas
സാർ ഒരു പ്രോജെക്ടിന്റെ monthly എക്സ്പെൻസ് റിപ്പോർട്ട് തയാറാക്കുന്നത് എങ്ങനെ എന്നത് ഒന്ന് ചെയ്തു കാണിക്കുമോ....
പണിക്കാരുടെ ദിവസേനയുള്ള ഹാജർ P എന്നും അല്ലെങ്കിൽ A എക്സൽ ഷീറ്റിൽ ഇടുമ്പോൾ അതിന്റെ പ്രെസെന്റും അബ്സെന്റും ഓട്ടോമാറ്റിക്കായി ടോട്ടൽ കോളത്തിൽ വരുമോ??
@XLnCADMalayalam
3 жыл бұрын
Please go through my video on COUNITIF Function.
When I tried the Days formula this is message I received . Could you please help me correct my error? Start date, 1/1/2022 End date, 2/4/2022 Number of days, #NAME?. thanks
@XLnCADMalayalam
2 жыл бұрын
To fix the #NAME error, Please check my video on Formula Errors in Excel.
@santhoshpillai9950
2 жыл бұрын
@@XLnCADMalayalam Thank you.
if we hide the formula the formula we can't work, any solution
@XLnCADMalayalam
2 жыл бұрын
Can you explain this question with an example?
Sir, ഒരു ലിസ്റ്റിലെ സ്പെസിഫിക് കളർ ഉള്ള സെൽ മാത്രം count ചെയ്യാൻ പറ്റുമോ ?
@XLnCADMalayalam
2 жыл бұрын
Yes. It is possible. But there are no direct methods for counting cells based on color. Will do a video on this topic in near future.
@jojimon86
2 жыл бұрын
@@XLnCADMalayalam thanks , will wait for your video.
സർ,കുറെ ജോലിക്കാരുടെ മാസ attendance ഷീറ്റിൽ നിന്നും അബ്സെന്റും പ്രെസെന്റും വേർ തിരിച്ചുണ്ടാക്കാനുള്ള function എന്താണ്??
@XLnCADMalayalam
3 жыл бұрын
IF function can be used for that purpose.
Days function formula drag cheiumbo adhinde day kanikunth wrong an .
Sir, lookup fn il formula add cheythu first place code kitti, 2nd place name change cheyumbol place code varunilla
@XLnCADMalayalam
2 жыл бұрын
I suggest to refer my other videos on VLOOKUP.
@jithinrajan1202
2 жыл бұрын
@@XLnCADMalayalam data Alphabeticalekku convet cheythappol ready aayi
Excel worksheet delete ayal thirich edukkan endangilum opetion undo
@XLnCADMalayalam
3 жыл бұрын
To my best knowledge you cannot undo that action. Better close the file without saving or save the file in some other name. The next time when you open the original file, you will find the deleted worksheet intact.
എക്സല്ലിൽ സാലറി സ്ലിപ്പ് ഉണ്ടാക്കുന്ന വീഡിയൊ ചെയ്യാമൊ
@XLnCADMalayalam
2 жыл бұрын
Thank you for the suggestion👍 Let me work on it.
Exact function paranj tharo
@XLnCADMalayalam
3 жыл бұрын
Sure.
ഒരു സംഖ്യയുടെ more than 1/6 കാണാൻ ഫോർമുല പറയുമോ സാർ
@XLnCADMalayalam
3 жыл бұрын
എക്സലിൽ ശതമാനം കണ്ടെത്താൻ ഫോർമുലകൾ എന്നൊരു വീഡിയോ ഞാൻ ചെയ്തിട്ടുണ്ട്. Please refer to that video.
Nuber അടിച്ചാൽ അതിന്റെ സ്പെല്ലിങ് എങ്ങിനെ ആണ് കിട്ടുക Ex . 100 അടിച്ചാൽ അതിന്റെ One hundred rupees എന്നു എങ്ങിനെ കിട്ടുക
@XLnCADMalayalam
4 жыл бұрын
I have done a video on that topic. Please go through the videos section of this channel for that.
Thanks
@XLnCADMalayalam
3 жыл бұрын
Welcome
👍