• 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