Excel Interactive Human Resource Data Dashboard
4.1 (39 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
280 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Interactive Human Resource Data Dashboard to your Wishlist.

Add to Wishlist

Excel Interactive Human Resource Data Dashboard

Learn to create a powerful interactive Human Resource dashboard using Excel Pivot Tables an Pivot Charts
4.1 (39 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
280 students enrolled
Created by Ian Littlejohn
Last updated 12/2014
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 37 mins on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create a Human Resource dashboard using simple drag and drop technology
  • Learn how to use Pivot Tables and Pivot Charts
  • Create Key Metric calculations
  • Create a powerful age analysis for HR data
  • Create a trend graph displaying number of employees hired by year
  • Learn to create a salary analysis grouping the number of employees and what they earn
  • Learn to use powerful slicer technology to create interactive dashboards
View Curriculum
Requirements
  • Excel 2010 / 2013
Description

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.

Who is the target audience?
  • Excel users
  • Business users
  • Human Resource practitioners
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 10 Lectures Collapse All 10 Lectures 41:01
+
Introduction
3 Lectures 03:19

In this lesson we will review the completed Human Resource dashboard. This will display the completed dashboard.

Preview 03:13

This document displays the steps that we will complete to create the Human Resource dashboard.

Review the Completed HR Dashboard
2 pages

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.

Download the Training Data File
00:06
+
Dashboard Creation
5 Lectures 33:34

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.

Preview 10:14

In this lesson we will create a Trend graph displaying the number of employees that have been employed by year.

Number of Employees Hired by Year Trend Graph
06:55

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.

Age Analysis by Gender
04:09

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.

Salary Analysis
04:59

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.

Adding Slicers to the Dashboard
07:17
+
Conclusion
2 Lectures 00:05

Click on the View Resources button to access and download the completed dashboard.

Download the Completed Dashboard
00:05

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.

Conclusion
2 pages
About the Instructor
Ian Littlejohn
4.5 Average rating
1,124 Reviews
7,827 Students
9 Courses
Excel Business Intelligence and Power BI Trainer

Ian is a trainer that specializes in Microsoft Excel Business Intelligence tools and techniques making it easy for learners to harness the power of Excel PivotTables, PivotCharts, PowerPivot, Power Query, PowerView and Power BI.

Ian has been training learners on these powerful technologies for a number of years making it easy for the business user 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 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.