HR PRACTICAL TRAINING WITH JOB PLACEMENT SUPPORT

SIS TRAINING CELL PVT. LTD
SPECIALIZED TRAINING PROVIDER ON HR / ADVANCE EXCEL/ PAYROLL TRAINING

HR GENERALIST TRAINING CONTENT DETAILS
(TOTAL HRS-50 HRS, FEES RS.9500/-)

STATUTORY COMPLIANCE & COMPENSATION
PF ACT *ESI ACT *BONUS ACT *GRATUITY ACT *CTC DESIGNING *GROSS & NET SALARY *LEAVE POLICY *ATTENDANCE SHEETS
* INCOME TAX CALCULATION * ITR FILE * FORM 16 * TAX PLANNING *DESIGNING SALARY SLIP *RETURN FILE CHALLAN * HALF YEARLY & ANNUAL RETURN FILE *PROFESSIONAL TAX.
LABOUR LAW
*MINIMUM WAGES ACT *PAYMENT OF WAGES ACT *WORKMEN COMPENSATION ACT * MATERNITY BENEFIT ACT *CHILD LABOUR (PROHIBITION & REGULATION) ACT, 1986 *EQUAL REMUNERATION ACT 1976 * INDUSTRIAL DISPUTES ACT *TRADE UNION ACT *FACTORY ACT * PROCESS TO TAKE LICENCE * REGISTRATION & HALF YEARLY RETURN.
HR GENERALIST AREA
*MANPOWER PLANNING *END 2 END RECRUITMENT *JOINING FORMALITIES & RELIEVING PROCEDURE *INDUCTION POLICY *TRAINING & DEVELOPMENT * ER MANAGEMENT *ATTRITION & RETENTION POLICY * EMPLOYEE ENGAGEMENT ACTIVITES * HR JARGON.
CORE HR AUDIT DOMAIN
*ISO 9000/14000 * KAIZEN & 55 *PMS *COMPETENCY MAPPING *TNA *SWOT * POLICY IMPLEMENTATION *GRIEVIANCE HANDLING
LAB SESSION
ADVANCE EXCEL-*VLOOKUP *HLOOKUP * PIVOT TABLE * GOAL SEEK * AUTO & ADVANCED FILTERS *SPLITS AND FREEZE PANES *ATTRITION FORMULA * PF & ESI IN EXCEL SHEET *PROFESSIONAL TAX SLAB * FORMULAS & SHORT HAND KEYS *MIS REPORT
WORK ON PAYROLL SOFTWARE-COMPLETE PAYROLL PROCESSING
JOB PORTAL- *BULK MAILING *JOB POSTING *SHORTLISTING RESUME *HEAD HUNTING
INTERVIEW SESSION- HOW TO HANDLE INTERVIEW QUESTIONS BOTH PERSONAL & PROFESSIONAL
ADVANCE EXCEL TRAINING (TOTAL HRS-20 HRS, FEES RS.5000/-)

• DATA CONNECTING
• HYPERLINK
• V LOOKUP
• H LOOKUP
• TRANSPOSE
• DATA VALIDATION
• GOAL SEEK
• PIVOT TABLE
• PIVOT CHARTS
• ATTRITION FORMULAS
• CONDITION FORMATTING FREEZE PANES
• FILTER MACROS (RECORDER)
• CONNECTION OF ONE SHEET TO OTHER SHEETS
• DASHBOARD
• ARRANGEMENT OF ALL SHEETS MERGING FOR ALL CHARTS
• PREPARATION OF MIS REPORTS
• REMOVAL OF DUPLICATES FORMULAS (AROUND 50)
• PROTECTION OF SHEET ADDITION OF NEW COMMENTS
• EMPLOYEE DATABASE
• ATTENDANCE CALENDAR
• ATTRITION REPORT
• PF DATABASE MANAGEMENT
• TRAINING PLANNER CHART & TRAINING MIS REPORT
• TRAINING CALENDAR

PAYROLL MANAGEMENT TRAINING(TOTAL HRS-24 HRS,FEES RS.6500/-)

*EMPLOYEE INFORMATION *ORGANIZATION TREE *SALARY DETAIL * EMPLOYEE SELF SERVICE * LEAVE SET * DOCUMENT CENTER *PAYROLL CENTRAL *ARREARS *MASS COMPENSATION DETAILS * PAYSLIPS *BANK TRANSFER *CASH PAYMENT TRACKER *HOLD & RELEASE SALARY *INCOMETAX DECALARTION * FLEXIBLE BENEFIT PLAN DECLARATION REPORT * QUERY BUILDER *PAYROLL STATEMENT *EXCEL IMPORTER *PF & ESI FILING
Office Address: E-133, Sector-27, Near Sab Mall, Near Atta Market,
Nearest Metro Station- Sector 18, Noida

Contact Person: Malini Banerjee 9950504877/9999815825 , email id: [email protected]
Jaya Rathor 9910321358/9210956428, email id: [email protected]

Website: www.sistrainingcell.co.in