IP generation, Monthly challan generation &
payment, ESI card update, ESI IP deletion, ESI
contribution statement generation, IP dispensary
addition and change
Maternity benefit claims.
Professional Tax (AP)PT remittance process and
calculations, PT monthly returns, Annual returns
filing Statutory Forms & Checklist
Submission of Monthly / Annual Returns
C) Advanced MS Excel & MS Word
Vlookup & Hlookup
Pivot Table & Chart
Auto & Advanced Filters
Sort & Sub Total
Data Validation
Conditional Formatting
Mail Merge for Letters & Payslips
D) Important HR calculations & formulas
PF challan calculations
ESIC remittance calculations
Bonus formula
Gratuity formula
Salary workings formulas
Absenteeism formula
Attrition formulas
F&F ( Full and Final settlement calculations )
TDS computation formula
PT formula
Human
Resource Management
I. Talent
Acquisition
Manpower Planning (Role play)
Manpower budgeting
Standard Operating Process (SOP explanation)
Manpower requisition form (Practical)
II. Practical
Recruitment
Direct Recruitment
Indirect recruitment
Selection process
III. On
boarding Process
Joining Formalities & Documentation
On Boarding Process Induction and orientation of
organization
Personnel File Management
MIS Reports to prepare recruitment tracker and keep
information to the management with statistics.
