Building dynamic interactive human resource dashboard, Excel

Name: Building dynamic interactive human resource dashboard, Excel
Rating: 4.1 (135 reviews)

Using raw HR data, learn how to create HR statistics from your employee list and display on a dynamic dashboard

Created byGloria Tibakunirwa

Last updated 8/2020

English

What you'll learn

Analyse raw data using pivot tables, pivot charts and slicers to support decision making
Build interactive dashboards that are not static
Prepare reports that inform decision making and impact the bottom line

Course content

6 sections • 15 lectures • 55m total length

Introduction1:08
A brief introduction to the course.

Employee Data1:40
In this lecture you will learn how to maintain HR data in an excel spreedsheet. You will also learn how to create a formatted table.
Single Statistics5:24
In this lecture, you will learn how to create pivot tables with single statistics like headcount, gross salary, average salary etc.
Demographics2:34
In this lecture you will learn how to create pivot tables that show demographics/employee headcount in different employee records like gender, job grades, department, job category, duty station, salary and many more
Multi-dimentional statistics7:53
In this lecture you will learn how to create multi dimentional statistics forexample may analyse the relationship between many dimentions in one table like gender, headcount, department and salary to understand how these are related and where the gaps may be for action.
Grouping/Ranges3:48
In this lecture you will learn how to group data related to age, years of service and salary for better representation and analysis.
Formating Pivot Tables3:47
In this lecture you will learn how to format a pivot table and make it presentable in your reports to users.

Creating the dashboard8:53
In this lecture, you will learn how to create a dashboard uusing charts created earlier.
Inserting Slicers2:31
In this lecture you will learn how to insert slicers into your dashboard to eable you analyse your data further within the dashboard.
Making the dashboard dynamic7:26
In this lesson you will be able to to make your dashboard dynamic so that the slicers can be operational.

Requirements

Basic Ms Excel knowledge
Passion to self-develop

Description

This course is a step by step process of developing a dynamic, interactive HR Dashboard. The uniqueness of this course is that the dashboard you will learn to build is not static BUT dynamic and interactive and on that one dashboard, you can slice and dice your data further to reveal more insights into your raw data. Students will learn how to use inbuilt excel analytical tools like pivot tables, pivot charts and slicers.

Who this course is for:

Human resource professionals
Anyone interested in learning how to create interactive dashboards in Ms Excel

Building dynamic interactive human resource dashboard, Excel

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Dashboard Fundamentals and Employee list - Dummy data1 lecture • 1min

Excel Pivot Tables6 lectures • 25min

Excel Pivot charts3 lectures • 10min

Creating The Dashboard3 lectures • 19min

Course Wrap up1 lecture • 1min

Requirements

Description

Who this course is for: