Keep an eye on the HR resources of the company! In today’s excel dashboard guide, you will find two ready to use workbooks. As usual, we will build the dashboards from the ground up.
The first template uses a people graph. You can track the following key metrics: Salary, Bonus, Sick days by branch.
How to show the performance using a new way? The first thing that you should learn an old Excel function. The fact: sparklines will not appear in earlier versions. Making a good dashboard in Excel is a space-saving job. If you are using the REPT function and a little trick, you can fully replace sparklines. Because it is a text function, you can repeat custom fonts in a single cell. Read more, and you will see how it works!
Are you ready to use the linked picture method in Excel? The drop-down list and pivot tables are core functions in Excel. The next dashboard has an easy learning curve. As first, place your data set in the data Worksheet. Insert simple vector graphs into the ‘Data’ Worksheet. Create unique ranges for graphs using the name manager. After that, link the pictures to the ‘Dashboard’ sheet from the ‘Data’ sheet. Finally, use line charts to display the plan and actual values. It is easy!