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.
In this lesson we will review the completed Human Resource dashboard. This will display the completed dashboard.
This document displays the steps that we will complete to create the Human Resource dashboard.
Download the Training Data File
Please click on the View Resources button to download the Employee Master file that we will be using for the training. Please use the training data file to follow the step by step instructions.
This lecture focuses on creating the key metrics for the dashboard. The lesson will calculate the total number of employees, average age of employees, average length of service, average salary and breakdown of gender.
In this lesson we will create a Trend graph displaying the number of employees that have been employed by year.
In this lesson we will create an analysis that will display the number of employees by age groupings and gender. The groupings will show the number of employees by ages such as 20 to 30, 30 to 40 and so on.
In this lesson we will analyze the number of employees according to salary groupings. For example how many employees earn a salary between 20K and 30K, 30K to 40K and so on.
In this lesson we will add slicers to the dashboard. The slicers will allow us to filter the dashboard by department, gender and marital status.
Click on the View Resources button to access and download the completed dashboard.
Thank you for completing the Interactive Dashboard course. We look forward to having you on other Excel Business Intelligence courses as you develop your skills, capabilities and techniques.
Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and Google Data Studio. Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of Excel PivotTables, PowerPivot, Power Query, Power BI and Google Data Studio.
Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data.
Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools.
Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents.