Employee Turnover Excel Report and Dashboard

Description
This spreadsheet is designed to calculate the company's turnover rate through the Turnover Report and Dashboard. It is divided into four sections: "Settings," "Employee Database," "Turnover Report," and "Dashboard.

Settings
Begin by keeping the lists for "Departments," "Job Titles," "Termination Reasons," "Education Level," and "Ethnicity" filled out.

Employee Database
In this section, you will register all admitted employees by entering their details, such as Employee ID, Name, Gender, Job Title, Department, Education Level, Ethnicity, Date of Admission, and Date of Termination.

When an employee is terminated, fill in the "Date of Termination" in the same row as their name (no need to add a new row).

Important: Only fill in the blank cells. Gray cells contain formulas.

Turnover Report
In this report, you can view the turnover percentage by month by selecting a year in the filter. You can also choose a department and job title to refine the view.

Dashboard
Select a year to view metrics such as Admissions, Terminations, Active Employees, and the Monthly Turnover Rate.

At the moment, the template is designed to handle data within a 10-year cycle for best performance. If you would like to proceed with customization, we can also help extend the supported range.

Please note that this is a template worksheet. If it does not meet your needs 100%, and you are unable to customize it yourself, let me know and we will provide a quote to develop the customisations you need to get you exactly what you want in your Appointment Scheduler.