Attendance Record in Excel in Tamil 

Don’t Forget to Follow: twitter.com/EndlessKnowled1 facebook.com/enlessknowledge instagram.com/end_less_knowledge

Watched without skip brother. Really well...kindly add leave categories and leave balance details in this sheet 👍💐😊

Your Attendance Record video is awesome. One small thing if you include it will be excellent, likes half day present and Half day Absent paid leaves etc.

All videos of your channel are very clear and well explained.... Most useful videos...Thank you so much

Very detailed explanation.. its useful for me. Nowadaonly not only using P and A. There are many terms comp off, EL, CL, SL. So need to pay employees those who are eligible otherwise lop. If u explain us with considering all these it will be useful.

Thxs anna na youtubela thedi patha. Ipatha ugaluthu vanthuchi thxs anna 👌🌹

Well explained. I love it. I am a beginner. Can you add some more features ( ie) EL SL, CL leaves with balance also Half a day CL & half a day SL which should also reflect in balance.

Very useful 👍 Thank u bro ❤️❤️ daily Working Hours calculate venum bro.. waiting for part 2

Brother Na ipo thaan computer eh use panren enaku romba sandhosam so naan eh ready paniten Indha attendance record ah unga video paathu rombaaaaaa thanks bro. Enaku inno neraya idhula track pannanum brother kathukudukuringala anna.

அருமை, தெளிவான விளக்கம். நன்றி.

Sea is a confluence of Rivers, but this video of the confluence of ideas which are very well explained. Thank you, Sir, expecting more videos. Subscribed.

Anna, The national creators award 2024 ku apply panuga Unagaluku kandipa awards kedaikumALL THE BEST 🤝👍😊

Very much useful video to learn Excel more & more. Thank you so much

first time i saw your video, nice voice & nice explanation its very useful to me thank you

Please provide all videos like this it's actually very useful😊

its an awesome video ... your video making us to learn more in excel

Very good Explanation bro, Thank You For Your Effort/hard work,❣️❣️❣️❣️ In PART-2: some holidays we should work so Can you pls include and overtime option also!💌💌💌

Excellent Explanation Bro, Dates and conditions are changing for each month but, we change our records for each month like candidate names, and more, when I tried to do that the data remains the same for each month, can you explain that.

I like your video, its very useful. I request you to add employee sign in and sign out in it. So as you have mentioned to add them as the Part 2 video, we are all eagerly waiting for that. Thanks for your videos.

Hi bro your video is perfect 😘 neenga sonna Mari Ella perfect ah warudhu but month change aga aga inuput change aga matengudhu inputsku endha formula um podalaye so please short ah oru video potingana helpful ah irukum

Excellent! Explained perfectly

Perfect explanation ❤🎉🎉

Excellent sir, kindly include the Over time details, leave details, weekly off & in different days.

thanks sir 😊 very useful.. clearly explained.

Hello Brother nice information thank you I have doubts for example if I mark March 2022 attendance above when I change the 2023 January attendance are some only why it's not changed could you please explain

Hi brother all your topic very intresting recently start following ur channel everything very us full attendance tracker very intresting if you have idea please post some weekly schedule model thanks....

Bro, you are an eye opener for beginners and people wants to upgrade themselves. I'm proud that I'm your Subscriber 🤗

Super bro. How to make a change of present or absent for overtime attendance of employee with in and out time. Kindly explain this and also make a video for EPF and ESI record sheet same like this.

Great Video Brother. Some companies have work days on alternate Saturdays. What would be the Formula for that?

Super 👍👍... attendance with timings and including 2 months means previous month 26 to present month 25 to calculate, if u can pls do one video.

Good to hear and learn❤️

Bro, really a good video. Just would like to know, in date column having multiple category column like morning and evening. In this type, how we count present in the morning and evening.

tq unga videos all very useful

You explanation was good and easy to understand by your step by step explanation. Your efforts are much appreciated. Had tried this excel the following are the challenges I found. Can you please give solution for this. 1) For one month if we enter (E.g November 2022) and when we change the month to December 2022 the attendance appears the same and even in Weekends and Holidays also the Letters are appearing and no error message are being appeared. 2) If we change for December Month and the November month data is not available. 3) If we clear the entire data is not available. We need the worksheet as below if this worksheet should be usable one to everyone. 1) The entered data should be stored for all the months and when we change the months the entered data should be available. 2) Clear the contents should clear the current sheet and should not erase all the contents. Can you please release an video for addressing this issues. Thanks.

very good bro i watch full video , I learn lot in this video,. and bro if you can do a video about data book management , payable and receivable and customers account management like bank account. for my small business.

Anna intha excel sample copy enaku pin nalla irukku anna nanum innum konjam learn panna help irukku anna ❤️

Very useful information...tkq anna🍫

Hello Sir Very good Explanation kindly include Working Hours calculate, Half day and overtime also Thank U

Very nice explaination bro, double salary, week off ethula add panni oru video poduga bro

Sir When We enter the present and absent in November month, the same data is present in December month. For example November 1st the person is "P" and the same person December "L". Now my query is the November " P" going to December. But in December the person is on leave. Kindly give a solution for this issue. When we change the month data also needs to change. How to change the data's/values??

Thank you Anna very useful my life

Very useful. Thankyou brother

I ❤ Ur voice Bro 🎉🎉🎉🎉

Excellent, Thank you

Excellent sir, kindly include the Over time details, leave details & weekly off in different days.

very useful Thank you very much

You like a genius bro, don't skip the vedio 🔥

Super Learning BRO 👌

Thanks Bro, and im waiting for Warehouse Stock Maintenance Video. Please Bro 🙏🙏🙏💪 God Bless U!!!

Excellent sir , Guru

Verry good teaching sir. Add in auto save records for another sheet after then cleared data

SUPER SIR YOUR ARE EXCELL KING

Bro super . one doubt bro clear panathu aprm previous month year change pana data's thirumba Vara mathiri pana mudiuma

Hi bro I watched it completely and it's very useful I want to create the below details in the sheet DO - OFF UA - UNAUTHORISED ABSENT SL - SICK LEAVE CO - CANCELLED OFF PH - PUBLIC HOLIDAY TR - TRANSFER Note according to your sheet weekends off but I work in the Gulf so the day off is not fixed in this case how we can create the sheet please upload a video with above detail thank you so much 🙏🙏🙏❤🧡💛💚💙🤎

I can watch more than 5 time, finally I can understand

Vera level brother

Brother, Very great. If the employee has taken half a day leave or absent. How can we calculate his attendance with .5 day in present and .5 day leave or absent.

Bro intha attandance kuda salary calculation [payment salary] iruntha avnga salary and advance payment ellan poga balance salary evalavu nu calculat panna easy aa irukkum.

Hi Bro, Your way of teaching is excellent. I need help from you Oru company la 6 team irukku antha 6 team kum number of work koduthu target set pandrom. Avanga oru oru work ah complete panna avangaloga progress update aaganum. Athu epdi pannalam.

ரொம்ப ரொம்ப நன்றி 🙏🙏🙏🙏

Holiday list la iruka dates attendance record sheet la antha dates "Public holiday" or for example "new year holiday" "Pongal holiday" nu default ah varanum... Also Saturday and Sunday default ah "Week off" nu varanum... Aslo public and week off holiday la work panra employees ku "Douple pay" "comp off" mathiri attendance Mark panra situation varum. So holiday dates la type panuna error varatha mathiri formula poduga bro

In part two I need salary detail and esi & pf details sir

Hi, i want to keep the employees attendance details like duty intime outtime, lunch in, lunch out...i dnt want to clear the records, once i want to see the records of previous month or years what should i do?

Thanks for your video. If we updated the leave details for Jan month, if we go to next month Feb, Jan leave details only available. could you please tell me if we selected Feb month, we need only Feb leave details only available.

Much useful video

Really very good explanation sir 💐

Hi brother nice 👍, I need some data to add this attendance sheet. I need add some staff and deletion options with same effort

Please post next video with EL,CL,SL, halfday present/absent etc

Hi it is really nice, but how to calculate working hours for each day by entering in and out time automatically when my system turns on, is there a way to create in the excel?

I really like it your all video's

Hi Sir, Thanks for this useful video. I have followed all your steps and created the sheet, but one small problem. When I update present in 1st November and change month to dec, it shows as present in 1st dec. I dint update anything in dec. could help me to resolve this.

Excellent sir

Excellent Explanation

Excellent explanation...👌

Thanks for the video..and have an a douut...when i change the month my previous data ramins the same. Iam unable to save the data monthly wise. please advise.

Thank you very much, very useful video. Please make one video for instead of “P or A” make it as number of hours

Thank you Sir..

Great!

Thanks bro👍👍👍

I am trying one type excel sheet but not resolved because the sheet it's contain in colum in brand name row in multiple branch pack wise sales report format excel sheet it's in date wise it's possible thier or not possible bro I need your opinion

Everything is good .with your reference I created my own sheet ..but only thing is ...data remains the same for every month while changing ....every month I need to clear and than need to enter attandance...do u have any idea to save everything in every month with outclear the worksheet for next next month's ....must reply please 🥺

I have one idea for Part-2 Some saturdays are consider as a working days then how to customise these option. Thank you for your effort.

Bro Employee data, leave record, salary breakup pandra maathiri oru video podunga

Very clear explained bro...👌 Tq so much bro....🙏

thankyou sir,i need to add names that means new staff,and want to delete some staffs and weekly off for restaurantattendance

Very useful. Please add EL, CL, COL, working time, closing time. Permission

Sir if i want my employee to attend office on sundays and holiday days also means how that will be accounted if your excel restricts on weekdays and holidays.

I need to keep record 150 students in training period. If i save all details in this single work book, will i get final report of classes attended?

bro i have doubt instead of absent i need to enter hours and if i change january to febeuary that janaury details hour not come then also i would record hours from january to untill decebmer , if any solution please let me know thanks

Hi bro if I change the month previous month data also reflect in the new month also and half day leave how can we include

Hello Thanks for the wonderful video.... I have a doubt pls help me to resolve When I enter the present and absent in Jan month, the same data is present in all months. For example If I enter Jan 2nd Present the same data apply rest of the months. Kindly help me me to resolve this issue. Thanks Saravanan

Sir, we are putting site names instead of "P". How do we calculate that? Our employees, market labours, and weekly wages all in one.. How to record attendance for the same. Please assist...

Super sir,more informative

Bro when I change month , will all the data (present,absent) will change .........if it is changing that will be helpful

Thanks for this video and please how do update month wise P And A when change the month automatically changed as per the employee name or ID.For i.e.Employee A mentioned in the cell P on 01st date when change the month automatically update.

Thank you so much Sir.

Hi I hve doubt in this template can we check previous month data or old data

Sir ethu like January la enna attendance iruikko same Absent present than February or any another month poonurumm vaaruthu aathu enna sir pannanum please explain me.

good evening sir

A for Absent, P for Present, L for Leave or WO for week off then better.