- The Business Problem
- Important Note
Online
₹ 649 3,499
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
An Excel dashboard is a one-page document that assists managers and business representatives in monitoring important KPIs or metrics and making decisions in light of them. Data-supported charts, tables, and views can be found in Excel dashboards. Even though reports are frequently referred to as dashboards, not all reports are dashboards. Unlock HR - HR Analytics, People Analytics, and Talent Analytics developed the HR Analytics - Build Dynamic Excel Dashboard from Scratch online certification, which is made available by Udemy.
HR Analytics - Build Dynamic Excel Dashboard from Scratch online course involves 5 hours of digital lessons along with articles and 2 downloadable resources and aims to teach participants how to build an excel dashboard for human resources analytics. HR Analytics - Build Dynamic Excel Dashboard from Scratch online training explains the methodologies involved with topics like data validation, data preparation, data collection, data analysis, and dashboard wireframe as well as covers the techniques for streamlining and analyzing data with Excel pivot tables and linked charts.
The highlights
- Certificate of completion
- Self-paced course
- 5 hours of pre-recorded video content
- 1 article
- 2 downloadable resources
Program offerings
- Online course
- Learning resources
- 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
certificate availability
certificate providing authority
What you will learn
After completing the HR Analytics - Build Dynamic Excel Dashboard from Scratch certification course, candidates will gain an understanding of the principles of human resources and will acquire a solid understanding of the strategies involved with creating excel dashboards using Microsft excel and VBA for HR analytics. In this HR analytics course, candidates will explore the fundamentals associated with data preparation, data validation, data collection, data streaming, data analysis, and presentation as well as will learn about the principles of design. In this HR analytics certification, candidates will learn about concepts involved with KPI dashboards, dashboard wireframes, analytics maturity models, and recruitment metrics as well as will acquire the skills useful for making decisions.
Who it is for
The syllabus
Introduction
Data Collection
Data Collection and Architecture
Dashboard Wireframe
Wireframing
Data Validation
Data Validation
Data Preparation
Variable Creation and Ageing Calculation
Calculation
Pivot Tables
Linked Tables
Inter connected Tables
Charts and Graphs
Building the Charts
Dashboard Layout
Dashboard Designing and Layout
VBA - Visual Basic
Filters using VBA
Slicers
Pivot connections
Macro
Hide and Seek using Macro
Final Touch
Final Touch to DashBoard
Presenting the Dashboard
Dashboard Presentation
(Bonus) Why Dashboard?
Why dashboard and not a report?
(Bonus) Analytics Maturity Model
Analytics Maturity Model
(Bonus) Recruitment Metrics and KPI's
Recruitment Metrics and KPI's
Bonus - Top Excel Formulas you should know
- Count and Frequency
- Largest and Smallest Values
- Averages
- Confidence Intervals
- Percentile, Quartiles and Rank
- Deviation and Variance
- Covariance
- Trend Line Functions