HR GENERALIST AND PAYROLL (ADVANCE EXCEL FREE)

• Payroll & Salary Processing
  • Hands on Experience on Payroll Processing
  • Payroll Input Sheet preparation.
  • Leave processing for pay days.
  • New Joiner Salary Revision (Increment & Decrement), Arrears calculation
  • Handling Full & Final Settlement Activities
  • Handling Monthly Reimbursement Process
• Handling Statutory Compliances
  • Monthly Employee wise Provident Fund & ESI Reports
  • PF , ESI, LWF , PT Registration, Return & Online Challan.
• Labour Laws
  • PF
  • ESI
  • Gratuity Act
  • Bonus Act
  • Minimum wages Act
  • Factory Act
  • Payment of wages Act
  • Contract Labour Act
  • Shop & Establishment Act
• ERP Cloud Software like Keka, Kissflow.
• 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.

• Performance Management
  • 360
  • MBO
  • SWOT Analysis
  • Preparing Questionnaire

• HR Policies & Procedures development
  • Dress Code Policy, Communication Policy, Visitor Policy
  • Recruitment Policy, Termination & Resignation Policy
  • Documentation Policy, Probation Period
  • Employment Practice Policy, Business Ethics Policy
  • Leave and Grievance Handling Policy.

• Training & Development
  • Objectives of Training
  • Training need Analysis
  • Evaluation of Training Program
  • Methods of Training
  • Training feedback
• 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

• Employee Separation /Off – Boarding
  • Exit Interview & feedback
  • FnF process
  • Letter preparation
  • Assets Handover
  • NOC

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

• Employee Engagement
  • Co-ordination
  • Motivation process
  • Grievance Handling
  • Employee satisfaction
  • HR Grievances
  • Employee Relations
• Advance Excel
  • V-Lookup , H-Lookup WITH (Array + Match + Choose), FREEZE PANES, Pivot Table/ Pivot Charts
  • Data Validation, Match & Index, Condition Formatting ,Text To Column Wizard, Remove Duplicates
  • Logical Formulas (IF,And,OR, IFError, Nested IF+And+OR), Protecting Sheet
  • Text Formulas (Contatnate ,Upper,Lower,Proper,Trim, Left, Right,Mid, Find, Replace,Substitute,Text)
  • Statistical Formulas (Sumif, Countif, Averageif, Sumifs, Averageifs, Countblank, Counta)  
  • Date & Time Formulas (Datevalue, Timevalue, Today, Now, Edate, Emonth, Networkdays, Workday, Day360)
  • Recording & Assign Macros, Goal Seek &  Hyperlink (Linking Sheets, Website, Objectives)

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