HR Data Analysis using Excel

HR Data Analysis using Excel, available at $34.99, has an average rating of 4.15, with 13 lectures, based on 30 reviews, and has 100 subscribers.

You will learn about How to gather HR data from employees How to create database in Excel How to create different data entry forms in Excel How to get preliminary insights of HR data using Pivot Table How to visualize HR with Pivot Charts How to frame hypothesis and test hypothesis How to find association between two HR variables using Chi Square test How to measure impact of HR intervention on Employee Performance This course is ideal for individuals who are Beginner with interest in HR or Individual looking for career in highly rewarding HR Analytics or Individual interested in HR research or Under Graduate or Post Graduate curious to learn HR Data Science It is particularly useful for Beginner with interest in HR or Individual looking for career in highly rewarding HR Analytics or Individual interested in HR research or Under Graduate or Post Graduate curious to learn HR Data Science.

Enroll now: HR Data Analysis using Excel

Summary

Title: HR Data Analysis using Excel

Price: $34.99

Average Rating: 4.15

Number of Lectures: 13

Number of Published Lectures: 13

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

How to gather HR data from employees
How to create database in Excel
How to create different data entry forms in Excel
How to get preliminary insights of HR data using Pivot Table
How to visualize HR with Pivot Charts
How to frame hypothesis and test hypothesis
How to find association between two HR variables using Chi Square test
How to measure impact of HR intervention on Employee Performance

Who Should Attend

Beginner with interest in HR
Individual looking for career in highly rewarding HR Analytics
Individual interested in HR research
Under Graduate or Post Graduate curious to learn HR Data Science

Target Audiences

Beginner with interest in HR
Individual looking for career in highly rewarding HR Analytics
Individual interested in HR research
Under Graduate or Post Graduate curious to learn HR Data Science

Wish to work for companies like Hitachi ABB, Cargill India, Novo Tree Minds, Vertiv (Malaysia), Cummins, ExecBoardinAsia, Accenture, Nielsen Media, Amdocs, GlaxoSmithKline etc. as HR Data Analyst. Then join this course, get great insights of HR data analysis starting from creating HR database to analyzing impact of HR interventions.

Learn how to perform HR data analysis beginning from formulation of objectives to measuring association between skill development and performance appraisal. In this course you will learn how to create database in Excel, create data form, enter data, create tables, draw charts, frame hypothesis, hypothesis testing and report writing. This course will help begin your career in most rewarding HR analytics domain.

Course Curriculum

Chapter 1: Introduction to HR Data Analysis, Data Collection, Data Entry, Coding

Lecture 1: Introduction to HR Data Analysis

Lecture 2: How to create Database in Excel

Lecture 3: How to Create Data Entry Form in Excel

Lecture 4: How to Create Drop Down List Form

Lecture 5: How to Transform Codes to Labels in Excel

Chapter 2: HR Data Tabulation and Visualization with Pivot Table and Charts

Lecture 1: How to create Frequency Table on HR data using Excel

Lecture 2: How to create cross tabulation on HR data using Excel

Lecture 3: How to create pie chart on HR demographic data using Excel

Lecture 4: How to create column chart on bivariate HR data using Excel

Chapter 3: Measure Independence between Categorical variables

Lecture 1: How to test association between two categorical variables in Excel

Lecture 2: How to test Homogeneity between groups using Excel

Chapter 4: Association between two continuous variables

Lecture 1: How to draw XY Scatter plot on continuous HR data using Excel

Lecture 2: Association between two continuous HR variables using Spearman rank correlation

Instructors

Yelamanchili Rama Krishna
Professor, ICFAI Business School (IBS-Hyd), IFHE, University

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 5 votes
4 stars: 13 votes
5 stars: 11 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu