image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
1
1.1-Introduction
2-Dashboard Fundamentals and Employee list - Dummy data
1
2.1-Dashboard Fundamentals
3-Excel Pivot Tables
6
3.1-Employee Data
3.2-Single Statistics
3.3-Demographics
3.4-Multi-dimentional statistics
3.5-Grouping/Ranges
3.6-Formating Pivot Tables
4-Excel Pivot charts
3
4.1-Creating Pivot Charts
4.2-Formating Pivot Charts
4.3-Creating Spartklines
5-Creating The Dashboard
3
5.1-Creating the dashboard
5.2-Inserting Slicers
5.3-Making the dashboard dynamic
6-Course Wrap up
1
6.1-Congratulations for completing the course