Part 1 - Fully Automated Attendance Tracker with Dashboard in Tamil |Krish's Excel Anywhere.|

#Attendance# #Tracker# #Employee# #Students#
I will show you how to create fully automated attendance tracker in excel file with dashboard. This will be useful for companies, schools, colleges and office for those who use attendance. Well explained in Tamil.
I will use the following point while creating this tracker
Create Drop-Down List
EOMONTH
Text
Conditional Formatting
Match, IF, IFERROR, Value
SUM
COUNTIF
Average
Pivot Table
Charts
Slicers
Dashboards
Thank you for contacting Santhu Analytics.
We are happy to assist with your queries and file. Please book the next available 30-minute slot with Santhu Analytics for further support and receive attendance tracker file.
meetpro.club/S...
Please subscribe and don't forget to put Thumbs Up
Contact - 9481829511
Email ID - [e-mail]

[@pubgkiller9804]

I tried watching your video in playback speed of 1.25x. it seems very good 👌👌👌

[@SanthuAnalytics9510]

I agree 🙂👍

[@alninazz9659]

Way of teaching is good and thank you for sharing your knowledge. It may be very useful for beginners.

[@devarajum0993]

He'll sir , its a very informative session, I was daily taking manual attendance in my office, when i watching this video it's really nice to see. Kindly send me the file sir

[@arockiadeepak]

Very useful and excellent attendance tracker❤❤❤ not only this tracker.. all Excel sheet are awesome bro

[@SanthuAnalytics9510]

Glad to know that. Thank you for your valuable feedback and support 👍

[@perumalammu9579]

Very interesting to watch this video 👌👌👌👌

[@SanthuAnalytics9510]

Thanks 👍

[@azumbasha5201]

Beautiful work. Fantastic ❤

[@giriarcade]

This will be very much helpful for my professional

[@SanthuAnalytics9510]

Thank you for your feedback 👍

[@thakurchoubey5080]

Awesome explanation, i don't know language still understand the concept, very good knowledge

[@SanthuAnalytics9510]

Thank you for your valuable feedback 👍

[@musabaralikan349]

Worth watching

[@SanthuAnalytics9510]

Thank you for your feedback 👍

[@vijayperumal6084]

Ungaludai explanation rommba nalla irukku👌👌👌👌

[@SanthuAnalytics9510]

Thank you 🙂

[@marimuthumari2165]

I need this file to track my students attendance tracker. I am sure this will save my time👌

[@SanthuAnalytics9510]

Got your response. Sent the file too 👍

[@dhanushp3134]

That's so beautiful. I have submitted my contact information. Please send me the file. Thank you for sharing 👍👍

[@SanthuAnalytics9510]

Yep, I have sent the file 👍

[@PRABAKARANP-su3cr]

Thank you for sharing such a useful video sir.. Keep posting

[@SanthuAnalytics9510]

Thank you for your feedback 👍

[@kesavansubramaniam4558]

This video was so helpful to work in govt. Sector please invent the text in our mother tongue தமிழ்

[@SanthuAnalytics9510]

Thanks for your feedback. I'm also happy to add text in Tamil but it will not support for many formulas and functions!!

[@lakshmananp2969]

@@SanthuAnalytics9510 I want thish format excel

[@anitham8960]

This is really beautiful and amazing. Thank you for sharing such a useful video!!

[@SanthuAnalytics9510]

Thank you.

[@pownkumard7719]

Awesome and wonderful video on vacation tracker... I brushed up my knowledge the most.. Thanks a lot! and keep going this way. 🙂

[@SanthuAnalytics9510]

Thank you for your support and feedback

[@ramajayam.e2348]

Thanks Sir, Nature bless you Sir.

[@princymary1]

Keep posting Sir. Thanks for this video.

[@SanthuAnalytics9510]

Sure, thank you for your feedback and support 👍

[@onthemoon381]

Thank you so much for educating us ❤❤❤

[@SanthuAnalytics9510]

Thank you for your feedback and support 👍

[@sanjay_priya]

AWESOME VERY HELPFUL , THANK YOU ANNA

[@SanthuAnalytics9510]

Thank you for your valuable feedback and support 👍

[@BalaKrishnan-mb4jb]

Really very useful information

[@ShivaShiva-ik9sv]

Super explanation 👌👌

[@SanthuAnalytics9510]

Thanks 👍

[@Matching1150]

Hi I saw your vedio on you tube and it was very very useful ..recently I joined in a company and I think this excel will boost my performance ..Can u please send me the file ..I hope you will help me ..

[@SanthuAnalytics9510]

Hello 👋 Thank you for your valuable feedback and support 👍

[@vidyaswaminathan2572]

Hello Sir, Very useful and looks very creativity... If possible wil u share the same with check list option

[@SundaraB]

Since we are startup company we need to create a setup for HR dept so it's look like a professional way to follow the attendence with the database. So please iam requesting you to share this file to show my performance to our management

[@SanthuAnalytics9510]

Hello, thank you for your valuable feedback and support! Please send an email to [e-mail]. However, it's chargeable.

[@manim9204]

Great help with the file

[@SanthuAnalytics9510]

Thanks 👍

[@sssup-lg4sh]

Sir, wonderful explanation. Pls share this file

[@SanthuAnalytics9510]

Thank you for your support. Please confirm your email id to [e-mail]

[@sarang1550]

Tq for this video bro👍

[@SanthuAnalytics9510]

Thanks 👍

[@ashwinmurugavel9015]

Thank u sir please make more videos related to Management sector

[@SanthuAnalytics9510]

Sure, Thank you for your valuable feedback and support 👍

[@shankarmohana2826]

Nice explanation in tamil I need it

[@SanthuAnalytics9510]

Thank you for your support 👍 Please confirm your email ID?

[@kchengalvarayan2158]

That's so beautiful. I have submitted my contact information. Please send me the file. Thank you for sharing sir.

[@SanthuAnalytics9510]

Check your email and confirm

[@priyageetha2165]

Hai anna, I saw your video on youtube and it was very informative. I just joined a company and I think this excel file will boost my performance. Can you kindly send me the file anna? Hoping for a positive reply from you as soon as possible...

[@SanthuAnalytics9510]

Hi, sure 😊 Thank you for your feedback. Please send me your email id to [e-mail]

[@jebastinp6131]

How to select the date 21st to 20th period of the monthly cycle, how to create the macro button.

[@SanthuAnalytics9510]

I have already posted a video on how to create the macro for this

[@venkateshkadimpati9473]

Ji This is wonderful and Awesome. Could you please send me template, since I am a bigenner

[@SanthuAnalytics9510]

Thank you 🙂 Sure, please confirm your email ID here - [e-mail]

[@josephfernando410]

bro, can you guide me on how to change the year at the start and end of a date?

[@SanthuAnalytics9510]

Hello bro 👋 It should be charged the moment you change the year

[@rainbowmusic9843]

Date time and program video playlist layout make pannum video upload sulluga Epadi Excel

[@kchengalvarayan2158]

hi sir, could you please show up the macro process to save the data on the summary sheet. Pl. send mailed & also pinged in the Whatsapp.

[@SanthuAnalytics9510]

Hi, I have sent a file to everyone who has requested. Please send me your email id if you haven't received it

[@madhunmadhu6608]

@kchengalvarayan2158 ,if you know macro formula plz share

[@RVMKNSK]

Hi! Thanks for sharing useful video Info! Could u send me the Macro process to save the datas & can we use Clear option for clear datas if past month datas repeated to current month

[@SanthuAnalytics9510]

Thank u for your support and feedback. Please confirm your email id I will send you the file - [e-mail]

[@supriyat6357]

​@@SanthuAnalytics9510very informative, kindly help me with how to use macros

[@kenomerced4480]

awesome and very informative video, can you share the file with me please?

[@SanthuAnalytics9510]

Hello, please confirm your email id to 9481829511

[@sharatkumar6794]

Hello bro, if the month is changed the Present and Absent are repeating.... Can you help me to solve this

[@SanthuAnalytics9510]

Hello, I would like to see the data. Can you please email me [e-mail]

[@mastkalandarmast]

Hi, it was very informative. Can you share the file with me please. I was unable to complete the full file due to macros.

[@SanthuAnalytics9510]

Hi, please confirm your email ID. Please send it to my email id

[@SanthuAnalytics9510]

Thank you for your feedback

[@jayanthitedy319]

@@SanthuAnalytics9510hi bro I need this file plz send me

[@keerthanar4046]

While using if function i am not able to get "1" as the answer still it shows NA. Any idea?

[@SanthuAnalytics9510]

Hello, I need to check the formula that you have used!

[@animatedmovies7118]

i have already submitted the form Please Kindly send me the excel file thanks

[@SanthuAnalytics9510]

I hope your email ID ends with 244? If yes, I have sent you the the link. Please check and confirm

[@animatedmovies7118]

@@SanthuAnalytics9510 when month and year is changed the start date and end date should change too when i change computer clock time then it works kindly tell me how to change from excel formula itself thanks

[@saravanaspeed3054]

hi bro different type of years i will changed but start date & end date not repostponed please help me bro

[@SanthuAnalytics9510]

Hello Sir, Thank you for your support 👍 Will connect on WhatsApp [phone]

[@patrickjoseph9753]

I’m very interested your first part please can I you help me I am from Canada

[@SanthuAnalytics9510]

Hi, sure - you can send your queries to [e-mail]

[@sukumarsenthil4108]

Bro Saturday Sunday antha month ku ok bro atha apdiye next month ku change pannumbothu data colapse aguthu bro ellam montth odo sat sun um lock agura marii enna pannanum

[@SanthuAnalytics9510]

Hi bro, we have to edit the conditional formatting and add a formula

[@madhunmadhu6608]

While changing year Date will not update,why?

[@SanthuAnalytics9510]

I would be able to tell you what only when I see the file

[@vetrivelveeravel]

Ugadi iruku but tamil new year kanam, then how to keep it updated for next year bruh edhum mey solla la

[@madhunmadhu6608]

Hai , share this file, clear my doubt, while changing year year will not changed, where I need to change formula,plz reply..

[@SanthuAnalytics9510]

Hello 👋 It's been a while since shared this file for free of cost. Sorry about that. There are many reasons behind. If you still want to receive the file please email to [e-mail]

[@madhunmadhu6608]

@@SanthuAnalytics9510 ok

[@madhunmadhu6608]

@@SanthuAnalytics9510 still not received your file, very poor response Why

[@pownkumard7719]

I require this file submitted the form... Pls response as soon as possible.

[@SanthuAnalytics9510]

Sure, I will check and send

[@pvsasirekha1]

Sir please send me the excel file the session was very useful

[@SanthuAnalytics9510]

Sure, have you filled the form? If not, please confirm your email ID

[@mkanniappan9804]

Hi sir pls send this excel workbook

[@SanthuAnalytics9510]

Hello sir, I have shared the file. Thank you 👍

[@tamilchannelahchannelah7910]

Need the sheet

[@SanthuAnalytics9510]

Please confirm your email ID

[@sigamanikannadasan4389]

Can i have this excel?

[@SanthuAnalytics9510]

Sure, please confirm your email id

[@Maheshkumar-fi4jn]

Sir please send me this file it will be helpful for my office management

[@SanthuAnalytics9510]

Sure, I will send you. Please send your email ID to [e-mail]

[@Maheshkumar-fi4jn]

@@SanthuAnalytics9510 sir I have sent you mail 🥰

[@ajithm4430]

Over time epadi add pandrathu bro

[@SanthuAnalytics9510]

Additional drop-down add pannala

[@ajithm4430]

@@SanthuAnalytics9510 enaku orthar name ku kela venum ot hours la bro please konjam epadinu poduga

[@jeeva3164]

I need in format send me files

[@Louiserobertson-s8x]

Could you please share this file.

[@yukeshyuvaraj2326]

Bro, Please share the macro script with us bro

[@SanthuAnalytics9510]

Sure, we will send you by this weekend

[@karthigaiselvannadar5724]

I think this video copy cat from smart office excel videos

[@SanthuAnalytics9510]

Hi friend, What??? You meant we copied the video from different one? This is my own preparation for my office and thought of useful for everyone.

[@SanthuAnalytics9510]

This is my own macro, dashboard with protected with password

[@karthigaiselvannadar5724]

@@SanthuAnalytics9510 for your information kzbin.info/www/bejne/p2jbc6yca65gla8

[@karthigaiselvannadar5724]

Some times Reverse Ennginrring also work

[@SanthuAnalytics9510]

I can see multiple videos like this. I don't see any pivot table, Chart, dashboard and macro in this video. Lots of things are covered from my video.

[@shinyshilciya2024]

Ithu venuna nenga amount kepingala

[@SanthuAnalytics9510]

No🙂send me your email id. I will send it to you

[@Affu06]

Bro ithu Send pannu ge Bro

[@SanthuAnalytics9510]

Please confirm your email ID to 9481829511

[@tspgaming4265]

Sir I have register my phone number can you send this file please sir..?

[@baludurai2150]

Please share the file ji

[@SanthuAnalytics9510]

Hi Ji, I have sent today. please check your email and confirm. Thank you for your support 👍

[@santhoshkumar2662]

Pls send me file sir

[@SanthuAnalytics9510]

Hello, please confirm your email id

[@அஷோக்கார்த்திகேயன்]

I need one doubt in Excel please clear the doubt sir and I'll ping you what's app sir

[@SanthuAnalytics9510]

Hello, sure 👍

[@samsundar5531]

please share this file i have already submitted my contact details

[@SanthuAnalytics9510]

Hi, sure, I will send you by tomorrow

[@SND-ug5zx]

I don't have WhatsApp can you please send it through email

[@SanthuAnalytics9510]

Send me your email ID to 9481829511

[@PrithviDify]

Hi bro excellent work need this file can you sent it to my email address

[@SanthuAnalytics9510]

Sure, please confirm your email ID to [e-mail]

[@moorthikumar5806]

Really very useful information

[@SanthuAnalytics9510]

Thanks 👍

[@kchengalvarayan2158]

i have already submitted the form Please Kindly send me the excel file thanks

[@SanthuAnalytics9510]

Thank you for your support! You should have received an email today! Please check and confirm