Войти
  • 168513Просмотров
  • 2 года назадОпубликованоNETVN82

How to easily create Leave tracking in Excel

Leave Tracker is a regular task to keep track of employee leave days. With just one Excel file you can track employee leave by day, by month and use this file for different years. Sample file 00:02 Intro 00:30 Set up years to track vacation days 00:52 Set the days of the month 01:20 Set the days of the week 02:03 Absence types drop down list 02:34 Each type of absence has different colors. 04:08 Total number of vacation days in a month for an employee 04:52 Total sick leave days per month for an employee 05:36 Total number of maternity leave days per month for an employee 05:51 Total number of unpaid leave days per month for an employee 06:18 Total number of days absent in a month by an employee 06:26 Applicable to all employees for one month 07:09 Applies to all months of the year 09:45 Summary of leave days of each employee in a year Help me 777000 subscribes #netvn #excel#excelleavetracking