Level 3- Payroll & Management Information System (MIS)

  • Payroll – Calculation of Salaries Including EPF | ESI & TDS Factor on Updated Range
  • Employees’ Provident Fund (EPF) & Public Provident Fund (PPF) – Basic Concept of EPF & PPF | Calculation & Deposit of EPF
  • Employees’ State Insurance (ESI) – Basic Concept of ESI calculation & Deposit of ESI & Making Monthly Challan
  • SAP-ERP – Introduction to SAP-ERP | Accounts Payable & Accounts Receivable Transaction
  • Google Drive – On Line Maintaining Documentation
  • MS Excel – Basics with Practical Knowledge | Advance Level Excel

MS Excel for Accountant & MIS

  • Flash Feature
  • Mathematical Feature – (Count Sum|Min|Max|Average|Mean|Median|Sumif|Countif|Averageif) | Calculation Of Loans Through Excel | Rounding Decimal Places
  • If Functionality – Uses Of If Functionality | AND Operator| OR Operator | Display Cell Formulas In Another Cell
  • Lookup Features – V-lookup | H-lookup & How to Manage Lookup Tables
  • Sprklines – Sparkline Creation | Alteration | Deletion of Sparkline
  • Outlining
  • Scenarios – Setting Up | Altering | Merging & Producing a Summary of Scenarios
  • Custom Views
  • Text Manipulation
  • Arrays – Creation of Array Formulas with If Functionality
  • Auditing & Trouble Shooting Formula – Tracer Arrow | Auditing Tools
  • Pivot Table | Chart
  • Goal Seek & Solver
  • Macros
  • Designing Aged Reports & Data Bucketing Concepts
  • Reducing Speculation & What –If- Analysis | Quick Analysis Tools
  • Calculation Of Time Value of Money | Depreciation | ROI & Depicting Break Even Through Excel
  • Finding Data Co-Relation of Financial Data & Forecasting Data
CONTINUE TO ICDL CERTIFICATION
LEVEL 2: TAXATION
LEVEL 4: MARG-ERP, QUICKBOOKS
Fill Form For Free Classes