Course details

Join the 1% Excel users who know how to use the most powerful features in Excel.

In this short course learn to create a powerful interactive Excel dashboard for Human Resource data using simple drag and drop technology.

This course is for Excel 2010 and 2013 users and for Human Resource practitioners. In the course you will learn how to construct a dashboard using Pivot Tables and Pivot Charts with no VBA programming.

The course uses an Employee Master file of 49 employees. You will learn to create Key Metrics such as Total Number of Employees, Average Age, Average Length of Service and Average Salary.

In addition you will learn to create a Trend graph displaying the number of employees by hiring date. You will also learn how to analyze age and salary by buckets such as age groupings of 20 to 30, 30 to 40 and salary of 20K to 30K, 30K to 40 etc.

You will learn how to create interactive dashboards using powerful slicer technology. Slicers are an easy to use technology that make it easy for users to ask questions of their data.

Updated on 22 March, 2018
Courses you can instantly connect with... Do an online course on Soft Skills starting now. See all courses