HR & People Analytics Using Excel: HRexcel - HR Analysis
Duration: 4h 40m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.37 GB
Genre: eLearning | Language: English
Duration: 4h 40m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.37 GB
Genre: eLearning | Language: English
Complete Practical course on HR Analytics using Excel. Learn HR Workforce Data Analysis using Microsoft Excel. HR Excel
What you'll learn:
Excel For HR Analytics, Analyze HR Data Using Excel
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
Requirements:
Basic to Intermediate Excel skills
HR professionals with exposure to HR processes
Interest in Human Resources Management, HR Analytics, HR Research
Anyone with interest in Excel and HR Analytics can take this course.
Description:
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
Who this course is for:
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
More Info