HR Dashboard

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.

Using this template is very easy, you just need to:

• Input your settings
• Enter/import employee data
• Enter/import movement, sanctions and remuneration data

Video:

Template Requirements and How to Use:

• Works on PC with Windows.
• Does not work on 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.
• 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”.

Customizable template:

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.

Included in the download:

• A template with sample data
• An empty template, ready to receive your data.

Download link:

• Downloads are available from your account once your payment is confirmed.

Warning:

We have put a lot of effort into providing you with a quality work tool at a reasonable price. We kindly ask you to respect the copyright so that we can continue to exist, develop and improve our services. Thank you.

Once purchased, it is prohibited to resell, redistribute, sublicense, assign or transfer this file to anyone in any form. Please read our terms and conditions before purchasing this product.