HR Administration Dashboard (Excel)

Excel template for HR Administration Dashboard

Step by Step user guide - HR Admin Dashboard Excel Template
Overview of Steps 1. Enter Settings (one-time) 2. Enter Starting List of Employees 3. Enter any changes a) New employees, b) changes in existing em...
Tue, 13 Sep, 2022 at 11:15 PM
Limits - HR Admin Dashboard Excel Template
The template is designed to support up to 2000 rows of employee data by default. The number of rows includes number of employees (EMPLOYEES sheet) and numbe...
Tue, 13 Sep, 2022 at 11:14 PM
Compatible Excel versions
For Windows user: The template requires Excel 2019 or later.  It works in Excel 365. It also works in Excel online For MAC user, since this templat...
Wed, 20 Dec, 2023 at 12:50 PM
Salary data is not being used in Dashboard
If you notice that the salary calculations are completely missing in the dashboard (Salary distribution report, salary grade report and pay equity report...
Sun, 25 Sep, 2022 at 5:46 AM
Why are the filters on Dashboard not working on a MAC system?
If you are using any MAC device to use the HR Admin Dashboard, please note that the filters on the dashboard DO NOT work. The dashboard uses Power Pivot, o...
Thu, 28 Sep, 2023 at 12:16 PM