Employee Turnover Excel Template

This Employee Turnover Excel Template 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 of Employee Turnover Excel Template, 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.

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 customizations you need to get you exactly what you want in your Appointment Scheduler.