Employee Absences Free Excel Template.
In this version, the template structure has been reorganized to quickly identify the configuration section, which includes Employees, Types of Absences, Departments, and Job positions.
The Department and the Job Position can be assigned in the list of employees, which will be useful for preparing the control report.
The template allows to be reused annually by changing the date of the first day of the year, this allows the months of the year to be automatically updated.
The data record has been restructured allowing the selection of the employee, the type of absence, the starting date and the ending date that the absence lasts. This allows the automatic calculation of days of absence and also shows the department and the related job.
Once the data is completed, we can control the information though a dynamic report.
In the report we can not only control all the registered data, we can also filter by months, type of absence, department, position and employee.
The report is open so you can adapt it according to your needs.
As I have mentioned, it is a template that can be reused annually, so to facilitate the data cleaning work, a button has been included that performs the process of deleting monthly data automatically using a password to avoid pressing it by mistake.
Free Excel Template Images for Employee Absence Control
More information about Controlling Tools
- Travel Expenses Control M1 Free Excel Template
- Multiproducts Breakeven Simulator Free Excel Template
- Planning and Control Projects Costs and Profitability Excel FREE Template M15
- Marketing Plan Free Excel Template
- Direct Costing Free Excel Template
- Balanced Scorecard M1 Excel Template
- Employees Best Practices Improvements Requests M2 Free Excel Template
- Personal Finance Free Excel Template
- Employee Management Free Excel Download
- Hotels Excel Cost Calculation
- Actual Vs Budget Excel Templates
- Decisions Sale Price Lists Calculation Free Excel Template
- Balanced Scorecard Excel Template Key Indicators (KPIs) Control
- Home Budget M2 Excel Template
- Financial Plan M3 Free Excel Template
- Business Plan Budget 5 Years M1 Free Excel Template
- Warehouse Inventory Control Free Excel spreadsheet
- Stocks Planning Procurement Simulator Free Excel Download
- Timesheet Control and Report Free Excel Template
- Suppliers Prices Comparative Analysis Free Excel Download
- Training Management Free Excel Spreadsheet
- Budget Control for Events M1 Excel Template
ERP ODOO Functional Consultant and Controller (Management Control & Controlling)