Leave Planner/Management Excel Template Enhanced

 

The Leave Planner/Management Excel template, available from the Business Tools Store, has been upgraded to allow the user to specify the Leave Year to start in any calendar month. Previously the system used a January to December Leave Year.

Now as part of the set-up the user specifies the Year and the Start Month and all monthly worksheets and reports are automatically updated to reflect the changes.

The system has also been adjusted to take account of 29 days of February in leap years.

These new features complement the extensive range of existing features that include:

  • Comprehensive leave scheduled produced for each month
  • Up to 10 different leave/absence types can be defined (e.g. annual vacation, study leave, sick leave, etc.)
  • All leave types color-coded facilitating view “at a glance” of the schedules
  • Accrual of annual leave entitlement on a monthly basis is calculated
  • Leave taken in excess of entitlement is highlighted
  • Monthly and annual summaries are produced
  • All leave schedules and summaries can be filtered by department
  • All schedules and summaries formatted for printing
  • Fully customizable Excel template
  • Uses only standard Excel features, no macros
  • Suitable for Excel 2007 & later versions
  • Comprehensive User Guide
  • No Quibble Money Back Guarantee

The enhanced Leave Planner/Management Excel template can now be downloaded.

19th Feb 2013

Recent Posts