HR Analytics using MS Excel (Excel Analytics)
5.0 /5- Offered byUDEMY
HR Analytics using MS Excel (Excel Analytics) at UDEMY Overview
Duration | 6 hours |
Total fee | ₹389 |
Mode of learning | Online |
Credential | Certificate |
HR Analytics using MS Excel (Excel Analytics) at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 2 articles and 1 downloadable resources
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
HR Analytics using MS Excel (Excel Analytics) at UDEMY Course details
- For Human Resource students
- For HR Proffesionals
- MS Excel
- Data analysis toolpak
- t test
- anova
- z test
- correlation
- covariance
- histogram
- LR
- moving average
- exponential smoothing
- The present course centers around learning wide applications of Data Analysis ToolPak and applying the same to solve real business problems
- An add-in is simply a hidden workbook that adds additional functions and features to Microsoft Excel
- Real life business problems are used as case studies to understand different tools that come with Data Analysis Toolpak
- Different types of descriptive statistics tools are used to quantitatively describe or summarize the features of collected information
- Inferential statistics tools are used to make inferences about the population with the use of random samples taken from the data
- Predictive statistics tools are used to make predictions about unknown future events
HR Analytics using MS Excel (Excel Analytics) at UDEMY Curriculum
Introduction
Introduction
Data Analysis Toolpak
Data Analysis Toolpak
Descriptive Statistics
Business problem #1 solved using rank and percentile
Business Problem #2 solved using descriptive statistics
Business problem #2 solved using histogram
Inferential Statistics
Inferential stats and hypothesis testing
Business problem #3 solved using correlation and covariance
Business problem #4 solved using paired t-test
Business problem #5 solved using t test unequal variance
Business problem #6 solved using ANOVA single factor
Business problem #7 solved using ANOVA two factor with replication
Business problem #8 solved using ANOVA two factor without replication
Business problem #9 solved using z test
Predictive Statistics
Predictive Statistics
Introduction to Linear Regression
Business problem #10
Business problem #10 solved using LR
Business Problem#11 and introduction to moving average and exponential smoothing
Solving business problem #11 using moving average
Solving business problem #11 using exponential smoothing
Conclusion
Conclusion
HR Analytics using MS Excel (Excel Analytics) at UDEMY Entry Requirements
- Prerequisite: Software Requirement : MS Excel
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?