Key Features of the Build HR Dashboard using Excel Course
- Lifetime access to the course
- No hidden fees, only pay the price of the course which includes exam fees.
- Recognised qualification upon successful completion of the course
- Study from anywhere, anytime, whenever it is convenient for you.
- Affordable and engaging e-learning study materials
- Study at your own pace from tablet, PC or smartphone
- Online tutor support when you are in need.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.
Requirements
Our Build HR Dashboard using Excel is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Career Path
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
Course Curriculum
| Section 01: Introduction | |||
| Introduction to Creation of HR Dashboard and Analytics | 00:07:00 | ||
| Section 02: Data Introduction | |||
| Final Data | 00:08:00 | ||
| More on Data | 00:08:00 | ||
| Section 03: Index Design And Tab Designing | |||
| Index Design | 00:09:00 | ||
| Tab Designing | 00:09:00 | ||
| Tab Designing Continues | 00:09:00 | ||
| Section 04: Employee Frontface | |||
| Employee Frontface | 00:12:00 | ||
| Employee Frontface Continues | 00:07:00 | ||
| Employee Database View | 00:06:00 | ||
| Section 05: Pivot Data List | |||
| Pivot Data List | 00:11:00 | ||
| Pivot Data List Continues | 00:06:00 | ||
| Change Pivot Table Data Source | 00:10:00 | ||
| Section 06: MOM Headcount | |||
| MOM Headcount | 00:12:00 | ||
| MOM Attrites and MOM Hires | 00:09:00 | ||
| MOM Attrites and MOM Hires Continues | 00:05:00 | ||
| Section 07: Departmental And Location Analysis | |||
| Departmental and Location Analysis | 00:07:00 | ||
| Departmental and Location Joinees Exits Analysis | 00:08:00 | ||
| Attrition Percentage | 00:10:00 | ||
| Section 08: Tenure Wise Analysis | |||
| Tenure wise Analysis | 00:09:00 | ||
| Employee Demographics | 00:09:00 | ||
| Section 09: Age Wise Analysis | |||
| Age wise Analysis | 00:05:00 | ||
| Age wise Analysis Continued | 00:09:00 | ||
| Section 10: Emp Demo And Quality Circles | |||
| Employee Demo | 00:08:00 | ||
| Quality Circles | 00:08:00 | ||
| Leave Analysis | 00:06:00 | ||
| Leave Analysis Continued | 00:08:00 | ||
| Section 11: Time Sheet Late Marks Analysis | |||
| Time Sheet Late Marks Analysis | 00:07:00 | ||
| Evaluate Formula | 00:08:00 | ||
| Section 12: Full And Final Analysis | |||
| Full and Final Analysis | 00:08:00 | ||
| More on Full and Final Analysis | 00:07:00 | ||
| Section 13: Training Analysis | |||
| Training Analysis | 00:11:00 | ||
| Section 14: Employee Compensation Frontface | |||
| Employee Compensation Frontface | 00:09:00 | ||
| Employee Compensation Frontface Continued | 00:04:00 | ||
| Payroll and OMS | 00:12:00 | ||
| More on OMS | 00:03:00 | ||
| Section 15: Job Rating Analysis | |||
| Job Rating Analysis | 00:05:00 | ||
| Department Salary | 00:10:00 | ||
| Working on Bonus | 00:09:00 | ||
| Section 16: HR Update | |||
| HR Update | 00:12:00 | ||
| HR Update Continued | 00:09:00 | ||
| HR Update – Recruitment | 00:07:00 | ||
| Section 17: Conclusion | |||
| Conclusion | 00:06:00 | ||
| Certificate and Transcript | |||
| Order Your Certificates or Transcripts | 00:00:00 | ||
Related Courses
PowerPoint for Business
£24.99
4 STUDENTS ENROLLED
