Employee Holiday & Sickness Planner, Reusable Excel Template

Microsoft Excel Spreadsheet Employee, Staff or Office Holiday & Sickness Planner or Calendar reusable

As an advanced and highly experienced Microsoft Excel user, I have put together this easy to use attendance management template.

This template has been developed and tested in Microsoft Excel 2007 – 2013, to accurately manage your employee’s absences throughout a year. The annual leave year is set a default to run from January to December, however you can easily change this by updating ONE CELL (yes one cell to change the whole workbook!!).

You do not have to be an advanced excel user to use and adjust this template. This workbook has been specifically developed to not contain any macros to help with your organisations security.

There is one cell to completely change all the formulas and dates to another year so you can re-use this template as many times as you like.

100's of these sold already, buy with confidence and check my feedback. You will not be disappointed with your purchase.

To summaries you will be receiving:

*Easy to use and maintain employee absence planner.
*One date to change all sheets and calendars to a year and 12 month period to suite you.
*Monitor up to 30 employees at one time. This can be extended upon request. Please check before purchasing.
*5 pre-defined absence types (Holiday, Half Day Holiday, Sickness, Training, Maternity or Paternity) and the option to add another 5 more.
*NO MACROS.
*Dynamic current month, week and daily employee availability percentages.
*Annual Holiday entitlement remaining.
*Option to enter your own office closure dates.
*Monthly Dashboard to report on employee and team absences.
*Yearly Calendar for the company and at a employee level, this is ideals for 1-1s.
*Sick Absence monitoring - Bradford Factor, Bradford Formula or Bradford Points (as it is usually referred too) is used in human resource management as a means of measuring workers absenteeism.

Please check out my other templates for sale in my shop. I can also help with any queries or development related to formulas and VBA in Microsoft Excel. Please contact me for more information.

You do not have permission to distribute or re-sell the template.