How to create an Attendance Tracker in Excel - Malayalam Tutorial

[@RajShines]

ആവശ്യമില്ലാത്ത മുക്കലും മൂളലും, തിരുത്തലുകളും ഇല്ലാതെ, ആവശ്യമായ കാര്യങ്ങൾ വളരെ സ്പുടമായി, കൃത്യമായി പറഞ്ഞ്‌ തരുന്ന രീതി! 👌 വളെരെ നല്ല ടുട്ടോറിയൽ. 👍💐

[@rajeeshk8139]

നിങ്ങളുടെ ചാനൽ കാണാൻ തുടങ്ങുന്നതിനു മുൻപ് എനിക്ക് excel നോട് വലിയ ഇഷ്ടമൊന്നും ഇല്ലായിരുന്നു .. കാരണം അതിനെ പറ്റി വലിയ അറിവ് ഇല്ലാത്തതു തന്നെ കാരണം.ഇപ്പോൾ ഇതു കാണാൻ തുടങ്ങിയതോടെ excel എന്റെ ഏറ്റവും ഇഷ്ട്ടപെട്ട ഒന്നായി മാറി..practice ചെയ്തു നോക്കാറുണ്ട്..thank you ♥️

[@XLnCADMalayalam]

My pleasure :)

[@sandraaps78]

Link picture ഏത് സെല്ലിൽ ആണ് click ചെയ്യേണ്ടത്

[@SOAOLSRY]

Thanks for wonderful class and created a attendance register. May God Bless you sir. Teacher is Light and You are the brightest one.

[@XLnCADMalayalam]

Thank you for your kind words :)

[@ArunDas-nh5in]

Sir am ITI instructor, This video is a life saver, thankyou for this topic🙏. I have created similar real time attendance register of my students after watching this video. 👍💖

[@vinnens]

Now I am creating one of the same for 2023, after watched this video, very helpfull

[@farooqmanhanath392]

നിങ്ങളുടെ അവതരണം പൊളിയാണ്..... 🌹🌹🌹 ഇരുന്നു പോകും ശെരിക്കും 🥰

[@XLnCADMalayalam]

Thank you ❤️😀

[@preetech627]

Thallillathe karyam mathram paranjutharunna nisaram youtuberil oral..super class. Thank you

[@skgskg9980]

Sir,Thank you.. Nice Class, Super Presentation, Very informative

[@athirappillyresidency6800]

You are doing a great job and describing as simple way . Everybody can understand very easy. Keep it up. Thank you.

[@XLnCADMalayalam]

Thank you 😀

[@thanseerthansi5465]

Perfect presentation...
Perfect classes...

[@XLnCADMalayalam]

Thank you 😀

[@shamee96]

super and simple explanations thanks

[@XLnCADMalayalam]

Glad you liked it😀

[@reghukumar9343]

Super Presentation.

[@heavenofjoy4916]

Swanthamayi cheythu ❤❤❤❤

[@vallavilasreekumar4420]

വളരെ ഉപകാരപ്രദമായ ട്യൂട്ടോരിയൽ

[@XLnCADMalayalam]

Thank you :)

[@cherianjoseph1943]

What a good teacher you are.
I am judging with my very long experience

[@XLnCADMalayalam]

Thank you 😀❤️

[@aonemedia7640]

Good presentation.... വിരസത ഇല്ലാത്ത അവതരണം ...

[@XLnCADMalayalam]

Glad to hear that 😀

[@alexanderjacob77]

Great. This is a new world to me. Thanks

[@bineeshsency4883]

Super, valuable class. Thank you so much.

[@varshaanil1762]

Sooper very informative, useful thank you for your video

[@XLnCADMalayalam]

😀

[@sqdxb]

Very calm and soothing.....'excel'lent class.
..

[@XLnCADMalayalam]

Thank you :)

[@baijupmathew9397]

Very useful tutorial class

[@XLnCADMalayalam]

Glad to hear that :)

[@ajeeshaju5040]

Excellent class 👏👏

[@XLnCADMalayalam]

Glad to hear that 😀

[@KVIEWS36]

your all videos are very much useful and informative...thank you

[@XLnCADMalayalam]

You are most welcome😀

[@rajukdavis]

As usual, it is an excellent data and explanation. This would solve the attendance problem. If you can incorporate half day Attendance also, it would be beneficial.

[@sreekuttynidin7393]

Thank you sir.Very useful Information

[@XLnCADMalayalam]

My pleasure :)

[@maheshsankaran8880]

Good presentation

[@XLnCADMalayalam]

Thank you :)

[@abdulrahimanthayyil3164]

സൂപ്പർ ക്ലാസ്സ്

[@XLnCADMalayalam]

Thank you :)

[@kmvc75]

Professional and easy to follow 👍👍👍.....

[@XLnCADMalayalam]

😀

[@ajilaaijas5231]

Very simple methods

[@nishanthk255]

Simple and good explanation 👍🏻😍

[@XLnCADMalayalam]

Glad you liked it

[@riyareenu]

Valuable classes well explained❤❤😍

[@XLnCADMalayalam]

Thank you :)

[@ajilaaijas5231]

Best presentation .FOLLOW

[@XLnCADMalayalam]

😀👍

[@mohamedshafeeq7153]

Good teaching

[@XLnCADMalayalam]

Thank you 😀

[@santalks557]

GREAT SIR,THANKS

[@kaizemohammed4737]

Nice presentation 👍🏻

[@XLnCADMalayalam]

😀

[@harriskovoor1340]

അടിപൊളി 👌

[@vaisakht9657]

നോട്ടിഫിക്കേഷൻ വന്ന ഉടനെ കണ്ടുകൊണ്ടിരുന്ന ചാനൽ നിർത്തി ഓടി വന്നു, നിരാശപ്പെടുത്തില്ല എന്നുറപ്പാണ് 😄

[@XLnCADMalayalam]

Glad to hear that 😀 and Thank you for that awesome compliment❤️

[@jijujiji245]

ഞാനും

[@53539]

In

[@muhammedshafeeq9337]

Me the same 😍👍

[@joebjulian4975]

Excellent.

[@XLnCADMalayalam]

Thank you! Cheers!

[@arunnd7401]

Super ❤️

[@XLnCADMalayalam]

Thank you :)

[@savinb7360]

great job

[@XLnCADMalayalam]

Thank you :)

[@premprasanth8994]

Great one!

[@XLnCADMalayalam]

Thank you! Cheers!

[@nisarnm2011]

no words to thank you,

[@XLnCADMalayalam]

Most welcome😀

[@nishiali9841]

Sooooper sir👍👍👍👍thank you sir

[@XLnCADMalayalam]

My pleasure 😀

[@carosswholesale5206]

Simple and informative attendance tracker.

[@sadikpazhankave5286]

Sir, your class is really outstanding. Iam fond of watching your all videos becoz your presentation is very well. I appreciate you lot to you. Expecting a new concept ASAP. (Sadik- Doha - Qatar)

[@XLnCADMalayalam]

Thank you for your kind words :)

[@racheljacob8155]

Was very helpful

[@XLnCADMalayalam]

Glad to hear that 😀

[@pulikodanfromkl-1482]

Amazingly 👏👏👏👏

[@XLnCADMalayalam]

Thanks a lot 😊

[@pmdasan6342]

Thank you

[@XLnCADMalayalam]

My pleasure 😀

[@sbl-solutions]

Thanks, Good Explanation

[@XLnCADMalayalam]

You are welcome :)

[@SaMTechs]

Robotic Sounds , awesome

[@XLnCADMalayalam]

Glad you like it!

[@sajadabbas]

Thank you for your valuable information. expect many more😍😍😍

[@XLnCADMalayalam]

My pleasure :)

[@mythmith7188]

Thank you so much Sir 🙏🙏

[@XLnCADMalayalam]

Most welcome

[@thankarajanmv]

Very good informative 👍

[@XLnCADMalayalam]

Glad you think so!

[@Anilkumar-fe2hx]

Well explained.. thanks 💐

[@XLnCADMalayalam]

My pleasure😀

[@dotpow9194]

Good one👍🏻

[@XLnCADMalayalam]

Thank you :)

[@cvshabeeri]

Wonderful

[@XLnCADMalayalam]

Thank you! Cheers!

[@v.k.krishnakumar8433]

Great effort 👌

[@XLnCADMalayalam]

Thank you for your kind words :)

[@vishnup8977]

Sir - Thanks soo much -

[@XLnCADMalayalam]

Most welcome

[@sahirkkk3066]

Very useful

[@asharafathikkaparambil9734]

Super , sir

[@XLnCADMalayalam]

Thank you 😀

[@TheTruth-rd6lh]

വളരെ പ്രയോജനം ചെയ്യുന്ന വീഡിയോ ആയിരുന്നു,ഇതിൽ working time ,over time , payment കൂടി add ചെയ്യുന്നത് കൂടി പറഞ്ഞു തരുമോ.

[@vineeshvandanam2015]

വളരെ സന്തോഷം ഒരുപാട് കാത്തിരുന്ന ക്ലാസ്സ്‌,ഇതുപോലെ ഒരു പ്രൊജക്റ്റ്‌ ഇൻകം എക്സ്പെൻസ് കണ്ടു പിടിക്കുന്ന ക്ലാസ്സ്‌ കൂടി കാണിക്കണം എന്ന് അപേക്ഷിക്കുന്നു...

[@XLnCADMalayalam]

Sure and Thank you for the suggestion.

[@ajithnamboodiri9155]

Nice👌

[@XLnCADMalayalam]

Thank you 😊

[@zachariyamohammedmohammedz9158]

Super

[@XLnCADMalayalam]

Thank you :)

[@shafeeqcbv]

വളരെ ഉപകാരപ്രദമായ വീഡിയോസ് ആണ്, thanks, excel dash board, ഉണ്ടാക്കുന്ന ഒരു വീഡിയോ ചെയ്യാ പറ്റോ?

[@XLnCADMalayalam]

Sure and Thank you for the suggestion.

[@nidhinchandran929]

Oru budget tracker chyyumo

[@shafeelack3478]

Sir Working hour base ill attendance chaynuath present ,absent,etc .athu chayunathintee video cheyumoo

[@nafilkk9326]

Sir padman software kurich onn parayummo sir ariyumo aru job kittiyittutt ath konda

[@XLnCADMalayalam]

Sorry. I haven't heard about that software before.

[@nafilkk9326]

@@XLnCADMalayalam ok sir

[@antonydcruz2129]

👍👍👍❤

[@XLnCADMalayalam]

😀👍

[@anirudhanka3957]

Thanks 👍 your class is very much informative. Excellent teachings of excel!!

[@XLnCADMalayalam]

My pleasure. And thank you for your kind words :)

[@asd786786]

Nice

[@XLnCADMalayalam]

Thank you 😀

[@jabirmp1034]

👌👌

[@reenalukose4170]

In some places can't clear properly, especially formula applying areas, can you show by writing that

[@XLnCADMalayalam]

I think the formulas should be clearly visible on a Laptop/Desktop computer.

[@vishnu0480]

Hotel manu&daily collection, monthly collection video plzz..

[@Noufalmrc]

👍👍👍

[@anusharath90s]

Thangz

[@XLnCADMalayalam]

😀👍

[@shakkeertharon9342]

Thanks a lot . How to calculate half day attendance

[@XLnCADMalayalam]

You will have to double the columns, use 0.5 to each half.

[@powerdevelopment9792]

Now I am ur student.....even in Office hours
-Vishnu

[@XLnCADMalayalam]

Glad to hear that :)

[@NihalUsman]

❤️❤️❤️❤️

[@XLnCADMalayalam]

😀🙏

[@rejithomas3323]

which version of MS excel applicable this formula?

[@XLnCADMalayalam]

All versions of Excel since Excel 2007

[@viola6004]

Onedrivil ഒരുഫയൽ അപ്‌ലോഡ് ചെയ്യുന്നത് പറയാമോ.

[@gccnowshad4483]

വ്യത്യസ്തങ്ങളായ കോളങ്ങളിൽ നിന്നും ഒറ്റ കോളത്തിലേയ്ക്ക് കൊണ്ട് വരുന്നതിനുള്ള എന്തെങ്കിലും വഴി ഉണ്ടോ, ഉണ്ടെങ്കിൽ ആ വിഡിയോ ലിങ്ക് ഷെയർ ചെയ്യുമോ

[@XLnCADMalayalam]

Please check my videos on COCATENATE, CONCAT Functions and Flash Fill in Excel.

[@preetech627]

Ee formate mobile phonil work cheyyo

[@anoopkj8087]

Excel 2007 il final sheet work cheyyikkan kazhiyumo?

[@soumyadelson3735]

Sir half day marking kudi parayanne plz

[@XLnCADMalayalam]

In this template we have used 31 columns for 31 days. If you want to make it 2 sessions each day, use 62 columns.

[@rajeevar2435]

ശെരിക്കും ഉപകാരപെട്ടു
...താങ്ക്സ്

[@pradeepliaks6703]

Sr ur classes are simple nd powerful..
One dbt. One employee on 15 days leave..can i get an output in this format... Emp lev fm lev to total days total present ..can i get tis lev data in date format..??

[@anasjalal0542901700]

👍👌

[@RejoJacobone]

How to get chart in different sheet in one sheet using drop down list.picture ?

[@XLnCADMalayalam]

Check my video on Camera Tool in Excel.

[@RejoJacobone]

@@XLnCADMalayalam thanks

[@simibijoy9025]

Sir can you provide customized training

[@XLnCADMalayalam]

Of course, yes. I conduct live workshops. But there should be at least 20 attendees.

[@athulkrishnanr8382]

Sir Format cells il custom koduthittu MMMM YYY ennu kodukkumbo date digite thanna varunna athu engane matthum ?

[@XLnCADMalayalam]

Check whether you have proper dates in those cells. Date formatting can't be applied to text data.
Check the online articles on Date and Time in Excel. You will be able to solve the issue your own. And if you have enrolled in my Excel course, refer to the part on Date and Time in Excel.

[@binnythomas1741]

Many Thanks
Can you please explain about the Macro based excel

[@jaslanizar3297]

How can we get the 2 half-day leave as a full day leave in this leave tracker? Pls respond.

[@RakhilRavi007]

Sir I loved it but I need some more video on it if we want to add more name inbetween month automatically add modified in final sheet & & we can calculate there salary also after subtract there advance amt if possible sir...

[@life-long513]

Sir, ethra quality class padicha center il ninnupolum kittiyitilla....it's so interesting to hear your class. 😊

[@XLnCADMalayalam]

Glad to hear that. Thank you :)

[@SreekumarGanesan]

Kidilosky

[@ANIcare]

when I am creating date , the 2nd column onwards showing " #Value". (4:50 mints showing #Value) please help

[@ramlalsurendranvenjaramood8572]

👌🏽👌🏽

[@mmschool427]

Sir,
I want to create a attendence sheet in school for students in Googel sheet. Can you provide a session on it. Class teachers should be able to access it

[@jinx1503]

❤️❤️❤️

[@XLnCADMalayalam]

😀🙏

[@haseenasayyidabad9516]

👍