Building dynamic interactive human resource dashboard, Excel

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

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.

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

  • Introduction –> 1 lecture • 1min.
  • Dashboard Fundamentals and Employee list – Dummy data –> 1 lecture • 1min.
  • Excel Pivot Tables –> 6 lectures • 25min.
  • Excel Pivot charts –> 3 lectures • 10min.
  • Creating The Dashboard –> 3 lectures • 19min.
  • Course Wrap up –> 1 lecture • 1min.

Building dynamic interactive human resource dashboard, Excel

Requirements

  • Basic Ms Excel knowledge.
  • Passion to self-develop.

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.