Modules for Online HR Course

               1.Statutory Compliance 

               2.HR Labour Laws 

              3.Payroll Processing

              4.Day to Day activates of HR

             5.Posh & Sexual Harassment of Women At Workplace

            6.Advance Excel 

• Other Free Tools & Technique with this Course

• HR Interview Guidance

• HR Tools – Word Format File like various kind of letters, PPT, Excel sheets & Reports, Forms, Policies template etc.

Module 1: Statutory Compliance Topics

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.The Code on Wages 2019

8.The Code on Social Security 2020 

9.Attendance and Leave 

Module 2: HR Labour Laws Topics

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.Industrial Relations Code 2020

10. Occupational Safety, Health & Working Condition Code 2020 

Module 3: Payroll Processing

• 1.Understanding the Concept of Compensation Management, Payroll, CTC, Gross, Net Pay etc. 

  2.Designing Salary Breakup through CTC , Gross, Net Pay  

  3.Concept and Calculation of Leave & Attendance Management 

  4.Concept and Calculation of Income Tax and TDS 

  5.Payroll Input Sheet & Payroll Register 

  6.Full & Final Calculation 

  7.MIS Report

  8.Payroll Software and Excel Practice,

  9.Understanding Salary Processing

  10.Pay slips

  11.Project Work

• Handling Statutory Compliances
  • Monthly Employee wise Provident Fund & ESI Reports
  • PF , ESI, LWF , PT Registration, Return & Online Challan.
• ERP Cloud Software like RezerPay, Peopel HR.
• Leave & Attendance Management
  • Attendance calculation (LWP & Reversal of LWP)
  • Leave Policy
  • Attendance Processing with software and manually
• HRIS & Database Management
  • Maintain Employees Personal Information like PAN No, PF Account No, ESIC Number, DOB, DOJ,DOR
• Leave & Attendance Management
  • Attendance processing through manually and with software.
  • Leave policy.
  • Leave Management through manually and with Biometric System.

Module 4: Day to Day activates of HR

1.Joining Formalities (Various Forms, BGV, Induction & Orientation etc. )On – Boarding

• • Letter Preparation
  • Bank Account Opening
  • Induction & Orientation
  • Documentation & form filling.
  • New Joiner User Name, Password, Credentials & Login Procedure to access web portal facility

 2.Exit Formalities (Various Forms,  Feedback Form, Exit Interview etc.)

Employee Separation /Off – Boarding

• • Exit Interview & feedback
  • FnF process
  • Letter preparation
  • Assets Handover
  • NOC

 3.Attrition and Retention

• Attrition and Retention
  • Concept of Attrition
  • Calculation of Attrition Rate
  • Concept of Retention Strategy
  • How to hold employees in the company 

4.Documentation (At the time of Joining, exit and between job.)

5.Email ID Create, Delete & Backup

6.Create Software login Ids

7.Data Management (HRIS)

8.Employee Engagement

Employee Engagement

• Co-ordination
• Motivation process
• Grievance Handling
• Employee satisfaction
• HR Grievances
• Employee Relations 
• Compensation & Benefits Administration

Module 5: Sexual Harassment of Women At Workplace Act, 2013

1.Introduction, Background & Definitions  

2.Applicability

3.Committees (Internal Complaints Committee & Local Complaint Committee)

4.Complaint Mechanism, Process & Powers Of Committees 

5.Inquiry Report, Conciliation, False Complaint

6.Determination Of Compensation 

7.Do’s & Don’ts For Men At Workplace & Checklist 

8.Timelines as per the Act

9.Tips To Women Employees at Workplace 

10.Sexual Harassment Policy & Various Form

11.Rights of the complainant & Respondent

12.Penalties & Corrective Action against Employer and Respondent

Module 6: 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 Find, Search, Substitute, Subtotal 

  5.Protecting Sheet, Remove Duplicates, Hyperlink (Linking Sheets, Website, Objectives) 

  6.What If Analysis, Offset Function, User form Function in Excel, Advance Filter

  7.Day, Year, EO-month, E-date, Net Workdays, Today, Weekday, Week number, Workday, Day and Time Calculation 

  8.V-lookup, H-lookup, Numeric Calculation, Match Index, Choose, Arrey 

  9.Data split, Data Validation, Text Function (Data Separation),

  10.Dynamic Pivot, Dynamic Chart, Conditional Formatting, 

  11.Goal Seek, Recording & Assign Macros 

• Free Study Material

Who should join this course

Any Graduate/Any PG
Fresher
Any Experienced person who wants to make a career in HR Generalist Profile.
Any HR Professional wants to upgrade his/her skill in HR.

What you need

Laptop
Good Internet Speed
Online Meeting Software like - Zoom