Our course designed as per the need of both fresher and working student.
There are two categories of hr courses.
1. Recruitment process and talent acquisition. (advance excel free)
Advance excel
2. Hr generalist and payroll (advance excel free)
Advance excel
Note: - advance excel is free with both of courses.

Module - 01

1 The Employee’s Provident Funds and Miscellaneous Provisions Act 1952
2 The Employee’s State Insurance Act, 1948
3 The Payment of Bonus Act, 1965
4 The Payment of Gratuity Act, 1972
5 Professional Tax
6 Labour Welfare Fund
7 Attendance and Leave

Module - 02

1 The Factories Act, 1948
2 The Shops and Commercial Establishment Act, 1962
3 The Minimum Wages Act, 1948
4 The Payment Of Wages Act, 1936
5 Employee’s Compensation Act, 1923
6 The Maternity Benefit Act, 1961
7 The Contract Labor (Regulation & Abolition) Act, 1970
8 The Industrial Disputes Act, 1947
9 Comparatively Analysis of New Labor Code (Code of Wages, Industrial Relations Code, Code on Social Security, Occupational Safety, Health & Working Condition Code )

Module - 03

1 Understanding the Concept of CTC, Gross, Net Pay etc.
2 Payroll Software and Excel Practice, Understanding Salary Processing
3 Payroll Input Sheet & Payroll Register
4 Full & Final Calculation
5 MIS Report
6 Designing Salary Breakup & Salary Slip { 'CTC to Gross, Gross to CTC, Net Pay to Gross}
7 Concept and Calculation of Leave & Attendance Management
8 Concept and Calculation of Income Tax and TDS
9 TDS Calculation

Module - 04

1 Recruitment
2 Joining Formalities
3 Exit Formalities
4 Attrition and Retention
5 Employee Engagement
6 Employee Relations
7 Performance Management System
8 Training & Development
9 HR Policies Formulation

Module - 05 # Sexual Harassment of Women At Workplace Act, 2013

1 * Definitions
2 * Committees (Internal Complaints Committee & Local Complaint Committee)
3 * Complaint Mechanism & Powers Of Committees
4 * Inquiry Report, Conciliation, False Complaint
5 * Determination Of Compensation,
6 * Duties Of Employer/HR & Penalties
7 * Do’s & Don’ts For Men At Workplace & Checklist
8 * Tips To Women Employees At Workplace
9 * Sexual Harassment Policy

Module - 06 # HR Interview Guidance Program

1 * Resume Update As per HR Profile, Thorough discussion on complete bio-data including candidate’s past experiences,
2 * HR Workplace Issues & Resolutions (With Solutions).
3 * Interview Related Common Question and Ans & Interview Tips & Techniques
4 * HR Mock Interviews

Bonus Module - # Advance Excel

1 * Introduction, Basic Understanding
2 * Count, Count blank, Average, Max, Large Min, Abs
3 * Lower, Upper, Proper, Trim, Len,Concatenate, Left, Right, Mid
4 * If Logical Condition, Dated if, , Sumif, Sumifs, Countif, Countifs, Averageif, Averageifs, And, Or
5 * Find, Search,Substitute, Subtotal
6 * Protecting Sheet, Remove Duplicates, Hyperlink (Linking Sheets, Website, Objectives)
7 * What If Analysis, Offset Function, User form Function in Excel, Advance Filter
8 * Day, Year, EOmonth, Edate, Net Workdays, Today, Weekday, Week number, Workday, Day and Time Calculation
9 * V-lookup, H-lookup,Numeric Calculation, Match Index, Choose, Arrey
10 * Data split,Data Validation,Text Function (Data Separation),
11 * Dynamic Pivot, Dynamic Chart, Conditional Formatting,
12 * Goal Seek, Recording & Assign Macros

Benefit of the course 

After completion of this course you will get technical support during the job.

Query Portal

ISO Certified Certificate

Practical Training