It is important to keep an eye on the HR resources of the company. In this article, we will show you how to use various methods to build a human resource dashboard. Furthermore, you can find and download two free ready-to-use templates. The first template provides a quick overview of six organizational departments. These are the following: Accounting, Administration, Customer Support, Finance, Human Resources, IT, Marketing, R&D, and Sales. Our goal is to track and display the most used HR key performance indicators: Total Salary, Total Bonus, Total Overtime, and Total Sick Days. Using the REPT function, we will build a custom people graph instead of using charts.
The second template uses a drop-down list and the linked picture method in Excel. We split the spreadsheet into two sections. The first part contains the drop-down list and the main data set. The second part shows a plan versus actual performance comparison based on the selection. We use multiple line charts to create a dynamic template.