ADVANCED EXCEL TRAINING ( NON VBA)

SIS TRAINING CELL PVT. LTD
SPECIALIZED TRAINING PROVIDER ON HR / ADVANCE EXCEL/ PAYROLL TRAINING
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
OFFICE ADDRESS: E-133, SECTOR-27, NEAR SAB MALL and 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