iNEWPM

Course Details

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

 

 

Are you providing Training Classes
IT Courses / Govt Exam Preparation
Higher Studies / Studies Abroad
NEWFreeCompanies HiringUpdates//nuPM