SLA Consultants India
is an HR Outsource company and we provide MIS/Backend Operation/Data Analyst/EDP Practical Training for more than 5
years with a Proven Track Record to
train MIS/Backend Operation/Data Analyst /Fresher manpower at all level. SLA Consultants
always invites Graduates , MIS Executives , Pursuing Masters or Professional
for Practical Training Classes with Real Time Exposure.
Course Duration: 30-40 HRS With Highly Skilled 2 Corporate Trainer For
2 Modules
SLA Consultants MIS Training Delivery Method:
A) Web / Desktop Base
B) Instructor-Led Classroom Sessions,
C) Presentations/Demonstration/Practical of concepts.
D) Handouts/Assignments/Real-time Exposure to work on
Clients
Please visit to our website to get more details : http://slaconsultantsindia.com/MIS-Practical-Training-Course.aspx
NOTE: Classes Are Also Available On Module
Basis
Module
1
What
is Excel?
Microsoft Excel is a
general-purpose electronic spreadsheet2 used to organize, calculate, and
analyze data. The task you can complete with Excel ranges from preparing a
simple family budget, preparing a purchase order, create an elaborate
graph/chart, or managing a complex accounting ledger for a medium size business
BASIC & ADVANCE EXCEL
Objective:
Provide Basic/Advanced Understanding of Excel, make
user familiar to create formula and give platform to make good analysis and
introduce Powerful tools of advance excel so that user can make advance
analysis with the help of those tools.
ð Introduction
to Excel, Basic Understanding Menu and Toolbar, Introduction to different
category of functions like Basics, Mathematical and Statistical, Date and Time,
Logical, Lookup and References, Text and Information.
o
SUM,COUNT,
COUNTA, COUNTBLANK, AVERAGE, MAX, LARGE MIN, ABS, SUMIF, COUNTIF, SUMIFS,
COUNTIFS, LOWER, UPPER, PROPER, TRIM, LEN, LEFT, RIGHT, MID, CONCATENATE,
SUBTOTAL,AND, OR, DAY, YEAR, EOMONTH, EDATE, NETWORKDAYS, TODAY, WEEKDAY,
WEEKNUMBER, WORKDAY, FIND,SEARCH, VLOOKUP, HLOOKUP, MATCH, IFERROR, IFNA, IF,
INDEX, OFFSET
ð Filters
(Basic, Advanced , Conditional), Sort ( Ascending, Descending, Cell/ Font
Colour), Single and Multiple
Charts/Graphs, Conditional Formatting, Data validation, Group & ungroup,
Data split.
ð Pivot
Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks.
Worksheet formatting and Print Display
DASHBOARD & VBA
Objective:
Dashboard reports allow user to get high-level
overview of the business and help them make quick decisions. Dashboards are
often called as management information system (MIS), which
provides information that organizations require to manage themselves
efficiently and effectively.
ð To
define KPIs (Key performance Indicator), Customer Service Dashboards or Project
Management Dashboard (Gantt Chart)
ð Dashboard
reports based on Tables and number or Charts/Graphs or Both.
VBA (Visual Basic Programming) is
generally known as VBA Macros which comprises of UDFs (User Defined Functions)
and generally used to simplify repetitive task
ð Macro
Recording, Create user defined function, User Form Concepts, Report Automation,
Outlook Connectivity, Command Buttons, Worksheets/Workbooks Functions.
Module 2> MS- Access
Introduction to MS- Access, Create Query, Tables
and relationships, Basic Queries Using SQL
Module 3>Payroll Processing
a) Pay
structure
b) Leave management (CL, EL, SL, and ML)
c) Basic, HRA,
DA, Conveyance, Medical allowance,
Lunch allowance etc
d) PF, ESIC, Bonus, Gratuity, Overtime, Calculations, Deductions. etc
e) Calculation of Gross , Net salary & CTC
f) Preparation of Break- up salary, Designing
CTC and salary break up and discussion on Compensation and benefits.
2.1 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 different Sections
2.2 Payroll Reporting
a) PF report in Excel sheet
b) ESI report in Excel sheet
c) Professional report Tax
Please find the course and fee
details.
Classes & Course can be designed/customize as per request
Fee According to Module-
Module1 & 2 -- Course Duration is 40 Hrs RS 11,500/ and after discount RS 10 ,500/-
(1st Inst. RS 6,500 & 2nd Inst. RS 4,000(on or before 4th Classes)
Module 1 2,&3 -- Course Duration is 50 Hrs Rs 14,500- after discount RS 13 ,500/-
(1st Inst. RS 6,500 & 2nd Inst. RS 6,000(on or before 4th Classes)
Note: Resume Building @ RS 800
Only
Thanks & Regards
Arbind Gaba
9999491895 |
training@slaconsultantsindia.com
SLA Consultants India
