ADVANCE EXCEL WITH MIS
|CLASSES||Monday to Friday (2 hours daily).|
|STUDY MATERIAL||The Study Material will be provided by Institute.
|OBJECTIVE||MIS - Management Information System experts are required for every sector of the economy as well for every industry, there are various reports and informations that Management of an organisation looks for, managers are required to prepare those rpeports using various functions and formulas available in MS excel spreadsheets however many times managers do feel lack of knowledge and understanding how to use advanced excel commands.Most of the topics mentioned are covered under advanced excel course has however excel has huge potential and the learning process is limitless and it takes years of practice to have full fledge mastering on the subject. SIMT advanced excel institute in delhi fulfill this gap by offering quality training.
» Full time Internet facility
» Hi tech classrooms with Video Projectors
» Fully equipped labs with latest computers & multi-media, laser printers etc.
» Power backup
» Extra Practice on Saturday/Sunday
USEFUL RIBBON COMMANDS:» Pivot Table, Dynamic Chart,
» Advanced Conditional Formatting.
» What if Analysis (Data table, Goal Seek, Scenario Manger).
» Creating User Form Function using Macro.
» Data Validation
» Advance Filter & Sorting
» Group & Ungroup,
PROFESSIONAL REPORT CREATION» Employee schedule & time report using advance restrictions.
» Weekly Payroll.
» Employees Attendance Performance report.
» Sales & Stock reports.
» Shrinkage report sample of sales dashboard.
PAYROLL PROCESSINGMODULE-1-STATUTORY & LEGAL COMPLIANCE 1. ESI ACT- 1948 & PF ACT-1952
(A) ESI ACT
(C) Contribution from both employee & employer
(D) Filling (monthly & half yearly)
(F) Filling the form
2. GRATUITY ACT-1972 & BONUS ACT-1965
(A) Coverage & eligibility
(C) Tax exemptions limits
MODULE-2-COMPENSATION AND BENEFITS
1. PAYROLL PROCESSING (A) The pay structure
(B) Leave management(CL,EL,SL,ML)
(C) HRA, DA, conveyance, medical allowance, lunch allowance etc.
(D) ESL, PF calculations
(E) Calculation of gross, net salary & CTC
(F) Preparation of breakup salary, designing CTC and salary breakup and discussion on compensation and benefits.
2. TAX PLANNING FOR SALARIED EMP (A) PT- slab process
(B) TDS- (salaried people)
(C) Slab process of TDS
(D) Calculation of TDS for men, women, senior citizens.
(E) Education cess
(F) Routine tax planning
(G) Tax exemptions under deferent sections.
(A) PF report in excel sheet
(B) ESI report in excel sheet
(C) Profession tax report