Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Excel Interactive Human Resource Data Dashboard

Posted By: naag
Excel Interactive Human Resource Data Dashboard

Excel Interactive Human Resource Data Dashboard
MP4 | Video: 1280x720 | 63 kbps | 44 KHz | Duration: 1 Hours | 139 MB
Genre: eLearning | Language: English

Learn to create a powerful interactive Human Resource dashboard using Excel Pivot Tables an Pivot Charts

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.

Excel Interactive Human Resource Data Dashboard