#165

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:~
Previous Video: • #164-Fun with VBA: Edu...
Next Video: • #166-Employee Manager ...
***********************************************************
Complete Series Playlist: • Attendance Management ...
***********************************************************
Related Video Links:
***********************************************************
~:Support Our Work Financially:~
Premium Download : sahacomputer.c...
***********************************************************
~:Join us on Social Media :~
🔔Subscribe to Our Channel: bit.ly/2TTblTG
Visit Website: www.sahacompute...
Join Us on Patreon: / scec
Facebook: / scecpkt
Twitter: / manojsaha2016
***********************************************************
~:Hire Me:~
If want me to help you to build Excel-based applications, you can Hire ME!
Contact me: [e-mail]
***********************************************************
~:Sponsored:~
***********************************************************

[@SahaComputer]

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

[@mahadysumon7140]

Love from Bangladesh. Its a nice work....I want to do this by myself. Please upload soon

[@SahaComputer]

I have already started recording the tutorial. I will try my best to upload soon.

[@mohammedimran2666]

Please include the overtime

[@4osterCAD]

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

[@SahaComputer]

Thanks for your nice comment. Tutorial for makeings of this video will come one by one. if you want learn this, you can subscribe our channel.

[@offcialsupervisor758]

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

[@SahaComputer]

Download link is given in the description box.

[@DhruvGoswamiOfficial]

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

[@SahaComputer]

When an employee request for a leave, first enter the data in Pre-booked leave sheet, go to Leave planner sheet to check that number of employee needed per day doesn't effect and also go to Leave Report sheet and check that employee does not cross the leave entitle by the company. and all the marks in Pre-booked leave sheet and Leave Reports sheet are done by formulas.

[@excelmaster9188]

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

[@SahaComputer]

Its my pleasure.

[@SRSBD]

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

[@SahaComputer]

In this file the features are already given.

[@excelmaster9188]

Plz sir make a video on stock management money fully automated

[@SahaComputer]

Watch this stock management related videos & subscribe our channel 0: kzbin.info/www/bejne/Z4u9gKmFadp0n5I 1: kzbin.info/www/bejne/Y3_Jcndog5J0jqs 2: kzbin.info/www/bejne/bmrRfYiHiM-Wg5I 3: kzbin.info/www/bejne/rqHXp2x6irOIi68

[@sathiyarajs9560]

Could you guide how apply WO different days

[@SahaComputer]

Watch this video, your problem will be solved: kzbin.info/www/bejne/rpeViGCJest2nqs

[@karthickm6851]

Payment method paylater option kindly add.. please support immediately

[@SahaComputer]

Sorry, We don't have that option.

[@sharna5541]

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!

[@sharna5541]

so for example in this video when he selected February, a new tab appeared at the bottom... how do I make that happen please?

[@SahaComputer]

I have used the vba code to do so. see this play list, everything is discussed. kzbin.info/aero/PLpsGVOobEOlDX4ug8tA9B1ZT5ZInl6dqz

[@excelmaster9188]

Love it❤️❤️❤️

[@SahaComputer]

Thanks for your nice comment.

[@kuldeepgupta9506]

Hi can this be done in google sheets..

[@SahaComputer]

Not all features

[@mohammedimran2666]

Dear, What about overtime..? Please tel me

[@SahaComputer]

I will make a seperate video on it.

[@waseemahmad6764]

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

[@SahaComputer]

kzbin.info/aero/PLpsGVOobEOlDX4ug8tA9B1ZT5ZInl6dqz Watch this playlist

[@geetasolanki5745]

Plzz uplod in hindi

[@SahaComputer]

Recently we don't have hindi video. We are trying to convert all videos in hindi.