HOT
blank

HR & People Analytics Using Excel: HRexcel -HR Analysis

Business

Rating3.7
Enroll Now

HR & People Analytics Using Excel: HRexcel -HR Analysis, available at $59.99, has an average rating of 3.65, with 45 lectures, based on 30 reviews, and has 125 subscribers.

You will learn about Excel For HR Analytics, Analyze HR Data Using Excel in 2024 Create HR Reports using Excel Pivot Tables – Slicing and Dicing of HR Data Create Responsive and Interactive HR Dashboard From Scratch Key HR Metrics You should know How To Calculate HR Metrics in Excel Statistics In HR Using Excel – Basic statistical techniques (which comes with simple explanations) How To Make HR Reports Using Excel Top Excel Formulas you should know as HR Professional Time Saving Excel HR Excel Keyboard Shortcuts to speed up work flow. Fundamental knowledge and Skills of HR Analytics Basic Principles of HR Analytics How to get preliminary insights of HR data using Pivot Table How to visualize HR Reports with Pivot Charts Using Excel Data analysis Toolpak and HR Data This course is ideal for individuals who are HR employees who want to learn how businesses are using analytics to study their workforces or The course is designed for individuals with HR related experience who want to develop their knowledge, skills and hands on experience for HR Analytics or Beginner level analytics people who wonder how analytics is different in HR or Students who wish to explore whether they would enjoy a career in HR Analytics or Human Resource department It is particularly useful for HR employees who want to learn how businesses are using analytics to study their workforces or The course is designed for individuals with HR related experience who want to develop their knowledge, skills and hands on experience for HR Analytics or Beginner level analytics people who wonder how analytics is different in HR or Students who wish to explore whether they would enjoy a career in HR Analytics or Human Resource department.

Enroll now: HR & People Analytics Using Excel: HRexcel -HR Analysis

Summary

Title: HR & People Analytics Using Excel: HRexcel -HR Analysis

Price: $59.99

Average Rating: 3.65

Number of Lectures: 45

Number of Published Lectures: 45

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 45

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

  • Excel For HR Analytics, Analyze HR Data Using Excel in 2024
  • Create HR Reports using Excel Pivot Tables – Slicing and Dicing of HR Data
  • Create Responsive and Interactive HR Dashboard From Scratch
  • Key HR Metrics You should know
  • How To Calculate HR Metrics in Excel
  • Statistics In HR Using Excel – Basic statistical techniques (which comes with simple explanations)
  • How To Make HR Reports Using Excel
  • Top Excel Formulas you should know as HR Professional
  • Time Saving Excel HR Excel Keyboard Shortcuts to speed up work flow.
  • Fundamental knowledge and Skills of HR Analytics
  • Basic Principles of HR Analytics
  • How to get preliminary insights of HR data using Pivot Table
  • How to visualize HR Reports with Pivot Charts
  • Using Excel Data analysis Toolpak and HR Data

Who Should Attend

  • HR employees who want to learn how businesses are using analytics to study their workforces
  • The course is designed for individuals with HR related experience who want to develop their knowledge, skills and hands on experience for HR Analytics
  • Beginner level analytics people who wonder how analytics is different in HR
  • Students who wish to explore whether they would enjoy a career in HR Analytics
  • Human Resource department

Target Audiences

  • HR employees who want to learn how businesses are using analytics to study their workforces
  • The course is designed for individuals with HR related experience who want to develop their knowledge, skills and hands on experience for HR Analytics
  • Beginner level analytics people who wonder how analytics is different in HR
  • Students who wish to explore whether they would enjoy a career in HR Analytics
  • Human Resource department

Last Updated July 2024
Hi dear,

I welcome you to the complete Practical course on HR analytics using Excel.

This course is specifically tailored to you that have little or no experience in processing and analyzing HR data using Excel. Also, If you want to build a solid foundation in the world of HR Data Analysis or you want to sharpen your skill as a HR Data Analyst, then this is the course you need to get started.

You will see an example on how raw HR data is transitioned to a meaningful HR dashboard with step by step process.

Excel HR Data Analytics Full Course | Essential Skills For Data Analysis In Excel

Among the many things you will learn in this course are:

  • – Excel For HR Analytics

  • – Key HR Metrics You should know

  • – How To Calculate HR Metrics in Excel

  • – Statistics In HR Using Excel

  • – How To Make HR Reports Using Excel

  • – HR Report Using PivotTable in Excel

  • – Interactive HR Dashboards

  • – Top Excel Formulas you should know as HR Professional

  • – Time Saving Excel HR Excel Keyboard Shortcuts to speed up work flow. And Many More…

There will be short quiz and related real world example of How HR is able to tackle business problems and provide solutions using Analytics.

The idea is that we use Microsoft Excel and the Power of Excel to quickly solve HR business problems.

One thing I want to tell you is to relax your mind because HR analytics is FUN!

Yes, and with this course, you will find it even more fun because we break it down to a level you will understand. We have made complex concepts look so easy.

So buckle up because it’s going to be a sweet ride.

HR analytics using Excel.

HR Data Analytics With Excel Full Course | Data Analytics Full Course | Data Analytics | Excel Dashboard Course | Interactive Excel HR Dashboard

Updated JANUARY 2024

Course Curriculum

Chapter 1: Introduction

Lecture 1: What to Expect – HR Analytics using MS Excel

Lecture 2: Structure of the Course – Get the best out of this Course

Lecture 3: Welcome to the course – HR Analytics using MS Excel (Excel Analytics)

Lecture 4: Analytics Vs HR Analytics

Lecture 5: What Is HR Analytics – HR Analytics Defined

Lecture 6: Why HR Analytics

Chapter 2: OVERVIEW OF HR ANALYTICS FOR BEGINNERS

Lecture 1: Overview Of HR Analytics

Lecture 2: Concept and Types Of HR Data

Lecture 3: Sources Of HR Data

Lecture 4: HR Analytics Maturity Stages

Lecture 5: Recap – What We Have Learnt

Chapter 3: EXCEL FOR HR ANALYTICS

Lecture 1: Excel For HR Analytics – Calculated Measures and Base Measures

Lecture 2: Practical Excel – Statistics In HR – First Approach

Lecture 3: Practical Excel – Statistics In HR: Second Approach

Lecture 4: Task For You – Statistics in HR

Chapter 4: HR DATA ANALYSIS USING EXCEL

Lecture 1: HR Data Analysis Using Excel – Intro

Lecture 2: Practical Excel – Inspect, Analyze And Clean Up HR Data

Lecture 3: Practical Excel – Create useful calculated measures & attributes from HR Data

Chapter 5: ANALYSIS TOOLPAK – STATISTICS IN HR USING EXCEL

Lecture 1: Statistics In HR Using Excel – Excel Analysis ToolPak

Lecture 2: Activate the Excel Analysis Toolpak

Lecture 3: Practical Excel – HR Analysis Toolpak

Lecture 4: Task For You – HR Analysis Toolpak

Chapter 6: KEY HR METRICS AND EXCEL

Lecture 1: Understanding HR Metrics

Lecture 2: Key HR Metrics You Must Track As HR

Lecture 3: Summary – Key Recruitment Metrics To Track

Lecture 4: More Key Metrics HR Should Track

Lecture 5: HR Metrics – What we have learnt, what to expect

Lecture 6: Practical Excel – Work through Key HR Metrics to Track

Lecture 7: Free Download – Thirty HR Metrics Templates

Chapter 7: HOW TO CALCULATE HR METRICS IN EXCEL

Lecture 1: How to Calculate HR Metrics In Excel

Lecture 2: Practical Excel – Calculate Employee Turnover Rate, Retention Rate Using Excel

Lecture 3: Practical Excel – Calculate Employee Workforce Age Distribution Using Excel

Lecture 4: Task For You – HR Metrics

Chapter 8: HR REPORTS, CHARTS IN EXCEL

Lecture 1: HR Reports Using Excel – What Is HR Reports

Lecture 2: Excel Charts For HR Reports

Lecture 3: HR Reports And Charts In Excel – Bar Chart, Column Chart, Line Chart, Pie Chart

Chapter 9: PIVOT TABLES, PIVOT CHARTS AND HR REPORTS

Lecture 1: HR Reports Using Pivot Table

Lecture 2: Practical Excel – Summarize Data Using Pivot Table

Lecture 3: Practical Excel – Pivot Charts With Examples

Lecture 4: Practical Excel – Slicing And Dicing Of HR Data

Chapter 10: CREATE INTERACTIVE DASHBOARDS FROM SCRATCH

Lecture 1: Getting Started – HR Dashboards

Lecture 2: Create Interactive HR Dashboard From Scratch

Lecture 3: Recap – Pivot Table And HR Dashboard

Chapter 11: TOP HR EXCEL SKILLS FOR PROESSIONALS – BEGINNER TO PRO

Lecture 1: Must-Have Excel Skills for HR Professionals

Chapter 12: TIME SAVING HR KEYBOARD SHORTCUTS

Lecture 1: Excel Keyboard Shortcuts To Sky rocket your Productivity | For HR Professionals

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 1 votes
  • 3 stars: 7 votes
  • 4 stars: 9 votes
  • 5 stars: 12 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!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024