Course Contents

A comprehensive 6-module Certificate Training on Human Resource Management.

Module - 01 # Statutory Compliance
- The Employee’s Provident Funds and Miscellaneous Provisions Act 1952
- The Employee’s State Insurance Act, 1948
- The Payment of Bonus Act, 1965
- The Payment of Gratuity Act, 1972
- PT
- LWF
- Attendance and Leave
Module - 02 # Labour Law
- The Factories Act, 1948
- The Shops and Commercial Establishment Act, 1962
- The Minimum Wages Act, 1948
- The Payment Of Wages Act, 1936
- Employee’s Compensation Act, 1923
- The Maternity Benefit Act, 1961
- The Contract Labor (Regulation & Abolition) Act, 1970
- The Industrial Disputes Act, 1947
- Comparison of New Codes
Module – 03 # Payroll and Salary
- Understanding the Concept of CTC, Gross, Net Pay etc., Organization CTC Structure
- Concept and Calculation of Leave & Attendance Management
- Designing Salary Breakup {CTC to Gross, Gross to CTC, Net Pay to Gross}
- Concept and Calculation of Income Tax and TDS, TDS Reports, Investment Decl. Form
- Payroll Input Sheet & Payroll Register
- Payroll Software and Excel Practice, Understanding Salary Processing
- Salary Slip
- Full & Final Calculation
- MIS Report & other Reports
Module - 04 # HR CORE
- Talent Acquisition & Recruitment
- Joining Formalities
- Exit Formalities
- Attrition and Retention
- Employee Engagement
- Employee Relations
- Performance Management System
- Training & Development
- HR Policies Formulation
Module - 05 # Sexual Harassment of Women At Workplace Act, 2013
- Definitions
- Committees (Internal Complaints Committee & Local Complaint Committee)
- Complaint Mechanism & Powers Of Committees
- Inquiry Report, Conciliation, False Complaint
- Determination Of Compensation,
- Duties Of Employer/HR & Penalties
- Do’s & Don’ts For Men At Workplace & Checklist
- Tips To Women Employees At Workplace
- Sexual Harassment Policy
Module - 06 # HR Interview Guidance Program
- Resume Update As per HR Profile, Thorough discussion on complete bio-data including candidate’s past experiences,
- HR Workplace Issues & Resolutions (With Solutions).
- Interview Related Common Question and Ans & Interview Tips & Techniques
- HR Mock Interviews
Bonus Module - # Advance Excel
- Introduction, Basic Understanding
- Count, Count blank, Average, Max, Large Min, Abs
- Lower, Upper, Proper, Trim, Len,Concatenate, Left, Right, Mid
- Find, Search,Substitute, Subtotal
- Protecting Sheet, Remove Duplicates, Hyperlink (Linking Sheets, Website, Objectives)
- Data split,Data Validation,Text Function (Data Separation),
- If Logical Condition, Dated if, , Sumif, Sumifs, Countif, Countifs, Averageif, Averageifs, And, Or
- Day, Year, EOmonth, Edate, Net Workdays, Today, Weekday, Week number, Workday, Day and Time Calculation
- V-lookup, H-lookup,Numeric Calculation, Match Index, Choose, Array
- What If Analysis, Offset Function, User form Function in Excel, Advance Filter
- Dynamic Pivot, Dynamic Chart, Conditional Formatting,
- Goal Seek, Recording & Assign Macros

N/A

Instructor Profile

Mohammad Kashif

HR Generalist, Payroll Management, Labour Laws & Statutory Compliance, Talent Acquisition & Recruitment, Training & Development, Performance Management