I will prepare daily attendance and absenteeism dashboard

An Excel Spreadsheet that enables to track attendance for approximately 50 employees of your company.

Able to add employee name to one place and it automatically populates on every month tab in workbook instead of having to add it manually.

• Color coded key for different types of leave such as sick, vacation, no call, personal and other.
• You can have multiple features such as Date wise view, Team wise/Individual view.
• Data entry for vacations taken by employees.
• Additional advantages that you get from the dashboard--
• Absent rate of employees (in any year or latest 3 month period).
• Vacation patterns for individual employees (or teams).
• On which dates most employees are absent?
• Who is taking most (or least) vacation days?