Excel for HR Training

Course Details

Modules : 6
Projects : 10
Eligibility : HSC/SSC
Learning Mode : Online / Classroom

Enroll Now

INTRODUCTION

Topics include basic and advanced Microsoft Excel, HR Dashboard & Analytics, Attendance Register using Microsoft Excel VBA, Restaurant Billing System using Microsoft Excel VBA.

CURRICULUM

Read the curriculum and you would know that you would be ready to master MS Excel and HR Analytics after doing this course –

Sr. No.	Course Name	Duration	Course Description
1	Microsoft Excel Basic Training	4	This is the first Excel for HR Training module and it will teach you the basic excel training. We will start with a brief overview. And then you will learn about the interface and how MS Excel works. Then, we will take a case study and then, you will learn how to do data entry, how you can populate the case study into the excel. Next, we will talk about formulas, formatting in excel, updating a calculation, finding percentages, conditional formatting, if function, count if, sum if etc. You will also learn about the pie chart in excel, graphs & chart, sorts, filter function, pivot table, freeze & split, presentation, print, shortcut in excel, and finally common errors. You need to watch 38 videos in total to cover the module.
2	Microsoft Excel – Advanced Training	11	This Excel for HR Training is just an extension of the previous module. Once you have understood the basics of MS Excel, this module will help you go deep. First, we will show you a few practice files that would contain various excel functions. Then, we will talk about data functions, what if analysis, arrays, functions for working with text, pivot table, data filtering, pivot table formatting, using macros in the pivot table, DAX in Power Pivot, names & dynamic range and many such functions and formulas. You need to watch 137 videos to cover the entire module.
3	HR Dashboards & Analytics – Beginners	6	From this Excel for HR Training, you will be able to relate to your subject. First, we will start with a reference file that will offer you a brief about the creation of HR dashboard & analytics. Then, gradually, you will learn about data introduction, index & tab designing, employee front face, the pivot data list, MOM headcount, departmental & location analysis, tenure wise analysis, age-wise analysis, employee demo & quality circles, timesheet late marks analysis, full & final analysis, training analysis, job rating analysis, HR update, and lastly a summary of all that you learn. You need to watch 42 videos in total to cover this module.
4	HR Dashboard & Analytics – Advanced	8	In this Excel for HR Training module, we will also start with a brief overview of the advanced HR dashboard & analytics. Then, we will talk about data introduction, data index, page layout, HC analysis, data & animated macro chart, predictive attrition, Vlookup analysis, BGV analysis, leave analysis & grouping data, Bradford factor, FNF analysis & exit analysis, learning & development analysis, goal seek & payroll analysis, employee profile, HR update & HR update calendar, and finally the conclusion. You need to watch 62 videos in total to cover the entire module.
5	Attendance Register using Microsoft Excel VBA	2	This Excel for HR Training module is dedicated to creating an attendance register. We will start with a brief introduction and then, we will talk about how you can create a project interface, generate student ID in attendance register, and finally will talk about display date and save mark. You need to watch 24 videos in total for the entire module.
6	Restaurant Billing System using Microsoft Excel VBA	3	This is the last module of this Excel for HR Training. We will start with a project introduction session. Then, you will learn about the interface, billing calculator, how you can activate currency, checkbox & text box, and finally, tax & home delivery button. You need to watch 20 videos in total.

TARGET AUDIENCE

Students who are interested to start a career in HR: If you are a graduate or an undergraduate student, and if you want to pursue a career in HR you may want to do this course. This Excel for HR Training will kickstart your career in HR and you would be able to showcase your skills during the interviews.
HR Professionals: If you’re working as an HR, this Excel for HR Training may give you a boost in your career. And you may expect to affect the result of the organization directly.
Entrepreneurs of HR Business: If you run a recruitment firm or have an L&D Consulting firm, you would be able to get tremendous benefit out of this Excel for HR Training.