HOW TO MAKE AN ATTRACTIVE ATTENDANCE TRACKER IN MS EXCEL (TAMIL) | Kallanai YT

In This Channel I'm Providing Advanced MS Excel & VBA Macro Tutorials In Tamil Language etc.....
Also I Solved Rubik's Cubes & Praminx Cubes In Tamil (From 2x2, 3x3, 4x4 & 5x5)
HOW TO MAKE AN ATTRACTIVE ATTENDANCE TRACKER IN MS EXCEL (TAMIL) | Kallanai YT

[@ajithkumarsurya8605]

Lots of thanks to you sir and I have one doubt Sunday highlight pandradhuku H1 lock pannanum sonninga epdi lock pannanum sollunga sir please

[@raj28san]

Super Sir. God bless you

[@kavincrisnold8024]

Very helpful

[@krishnamoorthy5953]

Thanks for your valuable support and update sir

[@KallanaiYT]

Thank you

[@ahamedrefaideen8704]

SUPERB .....NICE

[@KallanaiYT]

Thank you

[@ajithkumarmariyadoss3435]

Super sir

[@maiyappenmuthiah2991]

Thanks bro today i learn one type

[@KallanaiYT]

Thank you

[@marans22]

அண்ணா மிகவும் நன்றி இதே போல் ஒவ்வொரு மாதமும் prepaid பண்ணிட்டு ஒரு main Sheet ல் employees name type பண்ணும் அல்லது மாதம் type போது தனித்தனியாக leave details வருவது போல் செய்வது எப்படி... ஒரு tutorial போடுங்கள் நன்றி 🙏🙏

[@venkatesank7785]

Nice explanation good job

[@KallanaiYT]

Thank u

[@rajeshkannank5965]

Thank you

[@KallanaiYT]

You're welcome

[@rajiefidfufugudydyddyshwar1558]

Sir,pls Tel Sunday formula clearly H1 should I put or select h1cells

[@KallanaiYT]

U can do both way (Select or Type) but row number has to be locked and column has to be unlocked "We are not using Sunday function this is normal text function and then applied required format inside the function"

[@sshankar5558]

Hai bro mobile xl sheet yaipadi Painnalam bro soillugaa please

[@anabasirasna5540]

Kindly let me know why we used planned and unplanned % and where should we calculate those percentage in salary sheet

[@rosejubli7571]

Bro...1- march nu select panni copy pantringala athu enakku puriyala...pls explain more...cruiser eapdi vachu click pannanu..deep ah sollunga

[@yovangnanapriyam7068]

Please send the formula for sun locking

[@lovemyindia4992]

Sir half dayku eppadi sir calculate pandrathu

[@isaacjesudoss]

Dear friend good for Attenance Sheet ,but I need Date Required for Row.how to apply text formula

[@KallanaiYT]

U have to apply same function but row has to be unlocked and column has to be locked. That's the difference

[@rajeshsathyarajeshsathya9073]

Bro what is the difference between leave and absent

[@gopisaravananr1748]

Sir what is planed and unplanned?

[@iyappanshekar1913]

Please Say what is the exact formula from yesterday i see this video different diamension i never understand please reply the exact Sunday colour formula.

[@KallanaiYT]

"We are not using Sunday function, this is the normal text function and then applied required format inside the function" Row number has to be locked and column has to be unlocked in that text function.

[@maiyappenmuthiah2991]

What is the shortcut for locking? I tried to lock after text I can't able to do that?

[@iyappanshekar1913]

Ple say

[@KallanaiYT]

U can press F4 from the function key to lock excel cells

[@banuprasad1769]

How to take printout

[@KallanaiYT]

We have separate video in playlist pls look into it

[@k.r.thirumal2035]

Sir,,please tell formula for sunday mention

[@KallanaiYT]

Bro, "We are not using Sunday function this is normal text function and then applied required format inside the function" Row number has to be locked and column has to be unlocked in that text function.

[@madhanbabupb947]

Formula description la poodunga

[@KallanaiYT]

I'll try to give code

[@SENTHILKUMARS-hq9bo]

sir doulcos epade podurathu

[@firebox9929]

Sunday formula work akala sir

[@KallanaiYT]

What is the error ?

[@manickamg4078]

i want to payroll excel video

[@KallanaiYT]

will do it

[@r.vijayaraghavanrvr5755]

In formula =Text(H$1,"DDD")="SUN"'.Can you explain lock symbol.$ this is lock symbol?

[@iyappanshekar1913]

Please Say what is the exact formula from yesterday i see this video different diamension i never understand please reply the exact Sunday colour formula.

[@KallanaiYT]

Yes this is the $ lock symbol. For shortcut F4

[@shouly.1]

@@KallanaiYT But sir i am using lap but when i press f4 button it will open windows tab ..!? 🙄

[@karthickk5447]

Lock epdi pandrathu

[@KallanaiYT]

Select your cell address & Press F4

[@joyjoens8233]

Ithula salary list epadi padurathu

[@SadamHussain-dl6bz]

Joy Joens easy ...but try

[@mugundansivadjody5541]

The Sunday formula is not working

[@KallanaiYT]

"We are not using Sunday function this is normal text function and then applied required format inside the function" Row number has to be locked and column has to be unlocked in that text function.

[@sn..youtube6421]

Pls send a formula