Course Overview
- Course Title: HR Analytics using MS Excel for Human Resource Management
- Instructor: Abhishek (MBA - FMS Delhi, B. Tech - IIT Roorkee), Pukhraj (MBA - IIM Ahmedabad, B. Tech - IIT Roorkee)
- Target Audience: Human Resources managers, executives, students interested in HR analytics
- Prerequisites: PC with any version of Excel installed
Curriculum Highlights
- Key Topics Covered:
- Introduction to HR Analytics
- Essential MS Excel formulas for HR metrics
- Visualization and HR Dashboarding
- Data summarization using Pivot tables
- Basics of Machine Learning and Statistics
- Preprocessing Data for ML models
- Linear regression model for predicting metrics
- Key Skills Learned:
- Automate HR metrics calculation
- Create HR Dashboards
- Proficiency in Excel data tools
- Implement predictive ML models
- Use pivot tables for data summarization
- Master essential Excel formulas
- Utilize lookup functions like Vlookup, Hlookup
Course Format
- Duration: 9.5 hours on-demand video
- Format: Self-paced online course
- Resources:
- 5 articles
- 88 downloadable resources
- Access on mobile and TV
- Closed captions
- Certificate of completion