#165-Fully Automated Attendance Sheet In Excel (2021) | Complete Attendance Management System

In this video, you can see a complete attendance management system in Excel.
1. Attendance Dashboard: In this dashboard will get snapshot of attendance status. How many male or female employee you have. List of top 10 employee who are present, absent, on leave during the current month and the current year.
2. Attendance Sheet: In this attendance sheet, You can select the month and do attendance and can also see previous month attendance. You can do attendance one by one or you can do bulk attendance with the form with a single click. Holidays and week off days will be highlighted automatically.
3. Employee Data: In this sheet, you can enter information about employee like department, designation, gender, date of joining, date of resign, contact number, Salary etc.
4. Employee Pre Booked Leave: In this sheet, you can enter the information related to leave taken by the employees. which employee want to take leave from which date which date. and according to that you can plan your employee leave dates.
5. Employee Leave Planner: In this sheet, You can get the report of the Employee Pre-Booked Leave sheet. Here you can see the graphical numerical representation of future leave to be taken by employees. You can also set set the minimum staff required by the company and plan the leave of the employee according to that.
6. Employee Leave Report: You will get the actual Leave Report that are taken by employees. You can set the Previous leave balance, Entitle your current leave amount. Then automatically total leave leave for the employee will generate, Total leaven taken by by the employees will also so here and finally you will get the leave balance of the employee.
7. Weekly Attendance Report: In this sheet, you can get the the attendance report of the employee for a single week only.
8. Daily Employee Attendance Report: In this sheet, You will get the report on daily basis. You just enter the date and select report type i.e Present, Absent and Leave.
9. Advance Salary Payment: In this sheet, You can enter the the detail of advance payment made to the employees and amount to be adjusted in the Payroll sheet.
10. Payroll sheet: In this, every thing is made automated, you don't need to worry about calculation. You just enter the Employee ID and his salary will be calculated.
11. Salary Slip: In this sheet, You will get the salary slip of the employee. It is also auto generated salary slip, You just need to enter the employee Id and you Pay Slip will be ready.
***********************************************************

~:Related Video Links:~
***********************************************************

***********************************************************

Related Video Links:
***********************************************************

~:Support Our Work Financially:~
***********************************************************

~:Join us on Social Media :~
***********************************************************

~:Hire Me:~
If want me to help you to build Excel-based applications, you can Hire ME!
***********************************************************

~:Sponsored:~

***********************************************************

[SahaComputer]

Hi Viewr's, if you have any suggestions please comment us. Please hit the like button. Thanks for watching.

[osterCAD]

So simple and easy to understand... Grateful to be part of this video watchers.

[offcialsupervisor]

Thanks very usefull and nice teaching sir i have need practice file.

[DhruvGoswamiOfficial]

Please tell how to pre booked leave mark in leave planner automatically. Please sir 🙏

[sharna]

Hi, I'm really confused... I've watched #101 #165 #133 but none of them explain how to make the extra sheets come up with different months so I can populate new data. Right now when I change months the data from the previous month is remaining. I don't want to clear January for February, I just want January to have a sheet and February and so on and so on... can you make a video showing this please? Much appreciated everything else has been really easy to follow. Thank you!

[sathiyarajs]

Could you guide how apply WO different days

[excelmaster]

Thank you @saha computer education center for making this video ❤️❤️❤️❤️❤️❤️❤️

[SRSBD]

Please make a attandance sheet for 3shift with individual day off

[kuldeepgupta]

Hi can this be done in google sheets..

[karthickm]

Payment method paylater option kindly add.. please support immediately

[excelmaster]

Plz sir make a video on stock management money fully automated

[mohammedimran]

Dear,
What about overtime..?
Please tel me

[waseemahmad]

Why don't you make tutorials for this we can't 2000 for this If create this tutorials will help us a lot