JHA HR GENERALIST
MODULE
Bridge the Educational Gap
Duration:: 4
Hours
Days Batch::Sunaday FEES::
Rs. 12,000/- Total Classes: 12
Note: Flexible Payment in small installment
WITH THIS FEE
ADVANCE EXCEL FORMULAS ABSOLUTELY FREE
**WE PROVIDE
QAULITY BASED HR TRAINING AND GUARANTEED 100% HR JOB PLACEMENT**
HR
ADMINISTRATION PRACTICALMODULE:-
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,PAYROLL PROCESSING
– SALARY PROCESSING, ATTENDANCE AND LEAVE, PAYROLL SOFTWARE AND EXCEL PRACTICE,Functions
viz. TEXT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP, ROUND, ROUNDUP, IF, SUM,
PERCENTAGE etc.
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 LABOUR (REGULATION & ABOLITION) ACT, 1970, THE INDUSTRIAL DISPUTES
ACT, 1947, SEXUAL HARASSMENT OF WOMEN AT WORKPLACE ACT, 2013
HR INTERVIEW GUIDANCE PROGRAMME
ADVANCE EXCEL TRAINING
Duration::
4 Hours Days Batch::Sunaday
FEES::
Rs. 3,000/ Total Classes: 4
Lookup & Information
Functions
• Vertical Lookup (Vlookup)
• Horizontal Lookup (Hlookup)
• Match and Index
• IsText, IsNumber, IsDate , IsNull , IsErr, IsError, IsNa
Advanced List Management
• Advanced Filters
• Using List Features
• Dynamic Lists
Pivot Tables
• Using the Pivot Table Wizard
• Changing the pivot table layout
• Formatting
• Grouping items
• Inserting calculated fields
• Pivot Table Options
• Display and hide data in fields
• Lay out reports directly on worksheet
• Pivot Chart
What If Analysis
• Scenarios
• Goal Seek
• Solver
Protecting & Sharing Files
• Sharing a file
• Tracking changes
• Accepting or rejecting changes
• Applying Data validation rules
• Inserting comments
Mail merge, Macros Etc​​​​
Venue:H.no-1128/31,
Gali No-4B,
Laxman Vihar,
Phase-1
Gurgaon-122001
Haryana