Excel Interactive Human Resource Data Dashboard

Learn to create a powerful interactive Human Resource dashboard using Excel Pivot Tables an Pivot Charts
4.1 (30 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.
225 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 10
  • Length 41 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course 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.

What are the requirements?

  • Excel 2010 / 2013

What am I going to get from this course?

  • 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

What is the target audience?

  • Excel users
  • Business users
  • Human Resource practitioners

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:13

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

2 pages

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

Article

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.

Section 2: Dashboard Creation
10:14

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.

06:55

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

04:09

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.

04:59

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.

07:17

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.

Section 3: Conclusion
Article

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

2 pages

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ian Littlejohn, 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.

Ready to start learning?
Take This Course