- What is HR Analytics?
- HR Analytics and Business Decisions
- Analytics Driven Talent Strategy
- Analytics Maturity Stages
- Concept of HR Data
Online
₹ 999
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
HR Analytics Using Excel For Beginners certification course was developed by Segun Akiode - Strategic HR Professional and delivered by Udemy for participants looking for a detailed training program that can assist them in learning the basic concepts and methodologies associated with HR analysis so that they can implement appropriate decisions about how to enhance these procedures and pursue careers in human resource management.
HR Analytics Using Excel For Beginners online course by Udemy is a short-term training program that consists of 1.5 hours of digital lectures along with articles and 16 downloadable resources designed to teach participants about basic analytics techniques and assist them in uncovering data-driven observations that will assist in HR decision-making and reporting. HR Analytics Using Excel For Beginners online classes explain the functionalities of Microsoft Excel and Excel Pivot Tables for creating reports, as well as the stages and concepts involved with data collection, data processing, data analysis, and descriptive statistics.
The highlights
- Certificate of completion
- Self-paced course
- 1.5 hours of pre-recorded video content
- 1 article
- 16 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 Using Excel For Beginners online certification, participants will acquire an in-depth understanding of the fundamentals of human resources for activities associated with HR analytics using Microsoft Excel. In this HR analytics course, participants will explore the fundamentals of data collection, data processing, and data analysis of HR data. In this HR analytics certification, participants will learn about descriptive statistics in human resources as well as will acquire the skills to create HR metrics and HR reports.
Who it is for
The syllabus
HR Analytics For Decision Making
HR Data Analysis Using Excel
- HR Data Analysis and Excel
- Inspecting HR Data for Analysis in Excel
- Formatting HR Data in Excel
- Base Measure and Calculate Measure
- Grouping HR Data Using Excel Table
How To Make HR Reports Using Excel
- Importance of HR Reports
- Excel Charts for HR Reports
- HR Reports Using Excel Column Chart
- HR Reports Using Excel Bar Chart
- HR Reports Using Excel Pie and Doughnut Chart
- HR Reports Using Excel Line and Scatter Chart
- Transferring Excel Charts To PowerPoint
How To Calculate HR Metrics in Excel
- What Are HR Metrics?
- Common HR Metrics
- Employee Turnover Rate in Excel
- Workforce Average Age in Excel
Statistics in Human Resources
- Statistics and Human Resources
- Measures of Central Tendency
- Measures of Dispersion
- The Excel Analysis Toolpak
- Descriptive Statistics Using The Excel Analysis Toolpak
How To Make HR Reports Using Excel PivotTable
- HR Reports and Excel PivotTable
- What is PivotTable in Excel?
- HR Reports Using PivotTable - Question
- HR Report: Workforce Age Distribution
- HR Report: Workforce Gender Distribution
- HR Report: Workforce Length of Service Distribution
Bonus Lecture
- How To Create An HR Dashboard Using Excel
- "HR Analytics: How To Create An HR Dashboard Using Excel"
Instructors
Mr Segun Akiode
Teacher
Freelancer