Attendance Record in Excel in Tamil
HTML-код
- Опубликовано: 6 ноя 2022
- How to create Attendance Record in Excel Step by step Tutorial.
Click the Link below to learn. (Subscribe for more upcoming Tutorials)
Substitute Function in Excel in Tamil
• Substitute Function in...
Excel LAMBDA Function Basics in Tamil
• Excel LAMBDA Function ...
7 Excel Settings you should change
• 7 Excel Settings you s...
#exceltutorialtamil #endlessknowledge
Don’t Forget to Follow:
twitter.com/EndlessKnowled1
facebook.com/enlessknowledge
instagram.com/end_less_knowledge
Hi Bro your video extremely useful. Had a doubt, please help. If I wants to enter in the weekend as well, how the formula needs to modfiy. I tried but didn't worked. Since we used the reverse function for weekend & weekdays.
Sir Unga Email I'd sollunga sir ungalukku oru attachment anuppanum Neriya Peru kitta kettuta doubts But yarum solve pannala please unga mail id kodukka mudiyuma
அண்ணா நான் இளங்கலை வரலாறு படித்த மாணவன் நான் அரசு தொழிற்பயிற்சி ஸநிலையத்தில் கணினி இயக்குபவர் பயிற்சி முடித்தேன் டேட்டா என்டரி வேலை கற்க ஆசை எனக்கு எக்ஸல் கொஞ்சம் புரிகிறது இது கடினமாக உள்ளது அண்ணா என் அறிவுக்கு கணினி அறிவியல் ஏறவில்லையோ என்று தோன்றுகிறது
அண்ணா 5.02 இந்த இடத்தில் நீங்கள் கூறியது போல் f3 கொடுத்து drop down கொடுத்து year monthஐ கொண்டு வரலாம் என்று f3 கொடுத்தால் வரவில்லை அண்ணா????
Hi Bro, can you able to share the excel file?
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.
what you mean by this half day present and half day absent paid leave as in this instant the faculty has resigned and not consindered for any of the cases ....half day .....anna university ? another half sri balaji polytechnic ? paid leave by aarupadai veedu research foundation , or achariya college of engg and technology or .................??? who will provide salary for ...faculty who resigned some 10 years ago ???
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.
All videos of your channel are very clear and well explained.... Most useful videos...Thank you so much
Yes bro...
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.
Very much useful video to learn Excel more & more. Thank you so much
அருமை, தெளிவான விளக்கம். நன்றி.
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.
Sure soon brother... Also learn how to use GEMINI AI ruclips.net/video/xZfLQRYJQgk/видео.html
Very useful 👍 Thank u bro ❤️❤️ daily Working Hours calculate venum bro.. waiting for part 2
first time i saw your video, nice voice & nice explanation its very useful to me thank you
Thxs anna na youtubela thedi patha. Ipatha ugaluthu vanthuchi thxs anna 👌🌹
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
I have the same issue as like you brother.
Yes enakum input change aga solution therinja share panunga
Thank you so much for the detailed video. Even I have the same issue. Input values not changing while changing the month . 😮
I have same problem
I have same problem
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.
Please provide all videos like this it's actually very useful😊
Excellent! Explained perfectly
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!💌💌💌
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.
Perfect explanation ❤🎉🎉
Excellent sir, kindly include the Over time details, leave details, weekly off & in different days.
its an awesome video ... your video making us to learn more in excel
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.
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.
tq unga videos all very useful
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.
Great Video Brother. Some companies have work days on alternate Saturdays. What would be the Formula for that?
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.
Bro, you are an eye opener for beginners and people wants to upgrade themselves. I'm proud that I'm your Subscriber 🤗
Anna, The national creators award 2024 ku apply panuga
Unagaluku kandipa awards kedaikumALL THE BEST 🤝👍😊
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....
Thank you Anna very useful my life
thanks sir 😊 very useful.. clearly explained.
You're most welcome... Keep Learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
Excellent, Thank you
Excellent sir, kindly include the Over time details, leave details & weekly off in different days.
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.
My brother🙂, I hope you are doing well and great. Actually there are no issues in this video because this tutorial is focused on creating basic attendance record. As i mentioned in this video, soon an advanced video will be updated regarding all the queries. I hope you understand, my brother.
very useful Thank you very much
Very useful information...tkq anna🍫
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.
Very nice explaination bro, double salary, week off ethula add panni oru video poduga bro
Hello Sir Very good Explanation kindly include Working Hours calculate, Half day and overtime also Thank U
Anna intha excel sample copy enaku pin nalla irukku anna nanum innum konjam learn panna help irukku anna ❤️
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
Very useful. Thankyou brother
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
Super Learning BRO 👌
Bro Employee data, leave record, salary breakup pandra maathiri oru video podunga
Verry good teaching sir.
Add in auto save records for another sheet after then cleared data
noted 👍
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.
Excellent sir , Guru
In part two I need salary detail and esi & pf details sir
I ❤ Ur voice Bro 🎉🎉🎉🎉
You just made my day! Thank you for the compliment brother...
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 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 🙏🙏🙏❤🧡💛💚💙🤎
Please post next video with EL,CL,SL, halfday present/absent etc
sure... Keep Learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
I can watch more than 5 time, finally I can understand
Hi brother nice 👍, I need some data to add this attendance sheet.
I need add some staff and deletion options with same effort
Much useful video
You like a genius bro, don't skip the vedio 🔥
You are the best brother 😊
Thank you very much, very useful video. Please make one video for instead of “P or A” make it as number of hours
Noted
Really very good explanation sir 💐
Thanks and welcome
Thank you Sir..
ரொம்ப ரொம்ப நன்றி 🙏🙏🙏🙏
Your most welcome... Keep learning more about excel important functions ruclips.net/p/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa
SUPER SIR YOUR ARE EXCELL KING
Vera level brother
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.
Thanks Bro, and im waiting for Warehouse Stock Maintenance Video. Please Bro 🙏🙏🙏💪 God Bless U!!!
Coming soon!
Excellent sir
A for Absent, P for Present, L for Leave or WO for week off then better.
I really like it your all video's
Thanks...
Bro super . one doubt bro clear panathu aprm previous month year change pana data's thirumba Vara mathiri pana mudiuma
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.
Thanks for the idea!
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?
Excellent Explanation
Glad you liked it... Keep Learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
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.
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.
Thanks bro👍👍👍
Excellent explanation...👌
Thanks a lot 😊... Keep Learning more about Excel ruclips.net/p/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh
Very clear explained bro...👌 Tq so much bro....🙏
Welcome 😊
@@EndlessKnowledge bro.. 1st cell la weekday formula use panirukinga....
And same cell la countif formula use panringa..
I just try it.. bt countif formula use pana apro Saturday ku false varuthu.. means weekday formula work agala
Enna panrathu 🙄🙄🙄🙄
@@reshmareshma8148 same problem enakum varuthu
thankyou sir,i need to add names that means new staff,and want to delete some staffs and weekly off for restaurantattendance
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??
period wise how to do the same format we have seven periods in a day and we want to close both weekly and monthly by calculating total no of hours pls do video for that.
Hi bro salary method konjam explain pannunga plz
Insert salary, reductions and paidholiday off day leave and assume without 2nd saturday as a working day
Great!
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.
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
Thank you so much Sir.
your most welcome...
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 🥺
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...
Bro I need Check-in and Check-out timing with per day calculation
Hi Bro please include present % absent % in this attendance as well as Holiday taken % LOP%
Hi bro, how to calculate food costing formula please share video thank u
Very useful. Please add EL, CL, COL, working time, closing time. Permission
As soon as possible...
Thank you sir 🙏 and one daout sir how to missing value find sir please sollunga sir
ho
Good Video, But, one more request for in the same excel. Just need to add daily activities (task). each employees ?
new video is getting ready...
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 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.
Hi nice explain... In my company salary month 21 to 20.. if it possible without error..
I'm working as a design engineer electrical