HR Dashboard

Description
This ready-to-use Excel file allows you to track total and average headcount, hires and departures, promotions and transfers, disciplinary sanctions, ratio of men and women in workplace, payroll metrics, and HR KPIs changes over 3 years.
This Human Resource management tool will help you implement and improve the Human Resources policies in your company.


It allows HR team members to monitor HR analytics over 3 years:


Headcount Metrics
Total and average headcount, full-time/part-time employees, employees by working time, by occupation classification and occupation, by age group and tenure, the average employee tenure and average employee age, employee by division and department, expat workers vs locals, employees with disabilities, gender diversity and headcount metrics changes over 3 years.


Employee Movements Metrics
Hires, departures and employee turnover rate, transfers, promotions and other employee career changes, disciplinary sanctions, man to women ratio and the employee movement changes over 3 years.


Payroll Metrics
Payroll, employer payroll taxes and net pay KPIs, total remuneration, average remuneration and average cost of an employee, highest and lowest pay, payroll break down by department and division, contract type and working time, occupation classification and occupation, age group and tenure, pay Gap between men and women, local and expat workers, employees with and without disabilities, and payroll trends over the past 3 years.


An easy-to-use HR dashboard template perfect for HR managers and executive who wish to keep track of workforce KPIs, identify trends, and keep themselves aligned with the company’s objectives.


Template Requirements:
• Works on PC with Windows.
• Does not work on a MAC.
• Requires Microsoft Excel 2016 or higher with Power Pivot add-in. 👉 Watch this video to find out if your Excel version includes the Power Pivot add-in https://youtu.be/-3U0Om5d_JU
• Memory (RAM) 4 GB or more recommended.
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on the Excel sheet “User Guide”.


Template Customization:
Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.