Part 1 - Fully Automated Attendance Tracker with Dashboard in Tamil |Krish's Excel Anywhere.|
Вставка
- Опубліковано 12 вер 2024
- #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 - Krishsexcelanywhere2021@gmail.com
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
Beautiful work. Fantastic ❤
Very useful and excellent attendance tracker❤❤❤ not only this tracker.. all Excel sheet are awesome bro
Glad to know that. Thank you for your valuable feedback and support 👍
Way of teaching is good and thank you for sharing your knowledge. It may be very useful for beginners.
I tried watching your video in playback speed of 1.25x. it seems very good 👌👌👌
I agree 🙂👍
That's so beautiful. I have submitted my contact information. Please send me the file. Thank you for sharing 👍👍
Yep, I have sent the file 👍
Thanks Sir, Nature bless you Sir.
Awesome and wonderful video on vacation tracker... I brushed up my knowledge the most.. Thanks a lot! and keep going this way. 🙂
Thank you for your support and feedback
Thank you for sharing such a useful video sir.. Keep posting
Thank you for your feedback 👍
Awesome explanation, i don't know language still understand the concept, very good knowledge
Thank you for your valuable feedback 👍
Ungaludai explanation rommba nalla irukku👌👌👌👌
Thank you 🙂
Very interesting to watch this video 👌👌👌👌
Thanks 👍
This is really beautiful and amazing. Thank you for sharing such a useful video!!
Thank you.
This will be very much helpful for my professional
Thank you for your feedback 👍
Worth watching
Thank you for your feedback 👍
This video was so helpful to work in govt. Sector please invent the text in our mother tongue தமிழ்
Thanks for your feedback. I'm also happy to add text in Tamil but it will not support for many formulas and functions!!
@@SanthuAnalytics9510 I want thish format excel
Keep posting Sir. Thanks for this video.
Sure, thank you for your feedback and support 👍
I need this file to track my students attendance tracker. I am sure this will save my time👌
Got your response. Sent the file too 👍
AWESOME VERY HELPFUL , THANK YOU ANNA
Thank you for your valuable feedback and support 👍
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 ..
Hello 👋 Thank you for your valuable feedback and support 👍
Really very useful information
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
Hello, thank you for your valuable feedback and support! Please send an email to krishsexcelanywhere2020@gmail.com. However, it's chargeable.
Thank you so much for educating us ❤❤❤
Thank you for your feedback and support 👍
Hello Sir, Very useful and looks very creativity... If possible wil u share the same with check list option
Super explanation 👌👌
Thanks 👍
Thank u sir please make more videos related to Management sector
Sure, Thank you for your valuable feedback and support 👍
Sir, wonderful explanation. Pls share this file
Thank you for your support. Please confirm your email id to krishsexcelanywhere2020@gmail.com
That's so beautiful. I have submitted my contact information. Please send me the file. Thank you for sharing sir.
Check your email and confirm
Tq for this video bro👍
Thanks 👍
Nice explanation in tamil
I need it
Thank you for your support 👍 Please confirm your email ID?
Great help with the file
Thanks 👍
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...
Hi, sure 😊 Thank you for your feedback. Please send me your email id to Krishsexcelanywhere2020@gmail.com
How to select the date 21st to 20th period of the monthly cycle, how to create the macro button.
I have already posted a video on how to create the macro for this
bro, can you guide me on how to change the year at the start and end of a date?
Hello bro 👋 It should be charged the moment you change the year
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.
Hi, I have sent a file to everyone who has requested. Please send me your email id if you haven't received it
@kchengalvarayan2158 ,if you know macro formula plz share
Date time and program video playlist layout make pannum video upload sulluga
Epadi Excel
Hello bro, if the month is changed the Present and Absent are repeating.... Can you help me to solve this
Hello, I would like to see the data. Can you please email me Krishsexcelanywhere2020@gmail.com
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
Thank u for your support and feedback. Please confirm your email id I will send you the file - krishsexcelanywhere2020@gmail.com
@@SanthuAnalytics9510very informative, kindly help me with how to use macros
While using if function i am not able to get "1" as the answer still it shows NA. Any idea?
Hello, I need to check the formula that you have used!
Ji This is wonderful and Awesome. Could you please send me template, since I am a bigenner
Thank you 🙂 Sure, please confirm your email ID here - krishsexcelanywhere2020@gmail.com
hi bro different type of years i will changed but start date & end date not repostponed please help me bro
Hello Sir, Thank you for your support 👍 Will connect on WhatsApp 9481829511
Hi, it was very informative. Can you share the file with me please. I was unable to complete the full file due to macros.
Hi, please confirm your email ID. Please send it to my email id
Thank you for your feedback
@@SanthuAnalytics9510hi bro I need this file plz send me
Ugadi iruku but tamil new year kanam, then how to keep it updated for next year bruh edhum mey solla la
awesome and very informative video, can you share the file with me please?
Hello, please confirm your email id to 9481829511
Hai , share this file, clear my doubt, while changing year year will not changed, where I need to change formula,plz reply..
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 krishsexcelanywhere2020@gmail.com
@@SanthuAnalytics9510 ok
@@SanthuAnalytics9510 still not received your file, very poor response Why
i have already submitted the form
Please Kindly send me the excel file
thanks
I hope your email ID ends with 244? If yes, I have sent you the the link. Please check and confirm
@@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
While changing year Date will not update,why?
I would be able to tell you what only when I see the file
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
Hi bro, we have to edit the conditional formatting and add a formula
I require this file submitted the form... Pls response as soon as possible.
Sure, I will check and send
I’m very interested your first part please can I you help me I am from Canada
Hi, sure - you can send your queries to krishsexcelanywhere2020@gmail.com
Hi sir pls send this excel workbook
Hello sir, I have shared the file. Thank you 👍
Can i have this excel?
Sure, please confirm your email id
Sir please send me the excel file the session was very useful
Sure, have you filled the form? If not, please confirm your email ID
Could you please share this file.
I need in format send me files
Ithu venuna nenga amount kepingala
No🙂send me your email id. I will send it to you
Sir please send me this file it will be helpful for my office management
Sure, I will send you. Please send your email ID to krishsexcelanywhere2020@gmail.com
@@SanthuAnalytics9510 sir I have sent you mail 🥰
Over time epadi add pandrathu bro
Additional drop-down add pannala
@@SanthuAnalytics9510 enaku orthar name ku kela venum ot hours la bro please konjam epadinu poduga
Bro, Please share the macro script with us bro
Sure, we will send you by this weekend
Need the sheet
Please confirm your email ID
Bro ithu Send pannu ge Bro
Please confirm your email ID to 9481829511
Sir I have register my phone number can you send this file please sir..?
I think this video copy cat from smart office excel videos
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.
This is my own macro, dashboard with protected with password
@@SanthuAnalytics9510 for your information ua-cam.com/video/q7xByf6I-_M/v-deo.html
Some times Reverse Ennginrring also work
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.
Pls send me file sir
Hello, please confirm your email id
Please share the file ji
Hi Ji, I have sent today. please check your email and confirm. Thank you for your support 👍
I need one doubt in Excel please clear the doubt sir and I'll ping you what's app sir
Hello, sure 👍
please share this file i have already submitted my contact details
Hi, sure, I will send you by tomorrow
I don't have WhatsApp can you please send it through email
Send me your email ID to 9481829511
Hi bro excellent work need this file can you sent it to my email address
Sure, please confirm your email ID to krishsexcelanywhere2020@gmail.com
Really very useful information
Thanks 👍
i have already submitted the form
Please Kindly send me the excel file
thanks
Thank you for your support! You should have received an email today! Please check and confirm