Course: Certificate in International Accounting

A comprehensive program for B.Com Graduates & Working professionals to build their career in Offshore Accounting.


Employer 's view on Increased Demand For Accounting Professionals In Outsourcing Domain

As outsourcing industry is reaching its peak level, there is a sudden increase in demand for accounting professionals. Lack of skilled professionals is costing a lot to industry so in coming years headhunting may go to third tier cities. We at Nippon Data Services have tied up with ICA to get trained manpower and have also shared our input for preparation of curriculum which is more of practical in nature. We believe subject specific training will achieve the goal and industry will get manpower which will be ready to deploy rather spending time on in house training.

Shailendra Sharma
Director
(Nippon Data Services Pvt. Ltd.)

Yes! I am interested...

Course Content

Module 1- Basic & Advanced Excel

Introduction to Excel 2013 | Basic Understanding of Menu and Toolbar | Entering Data in Cell | Types of Data you can Enter in Excel | Editing Data (Cut, Copy & Paste), Moving around a Worksheet | Saving Workbook | Opening an Existing Workbook | Working with Rows and Columns | Pre-defined Table Style | Format Painter

Cell References – Relative |Absolute | Mixed and Circular| Filling Series | Flash Fill | Custom List | Number Formatting | Simple Conditional Formatting | Removing Conditional Formatting | Name Range | Adding Comments & Formatting

Understanding Formula Basics | Math and Trigonometry Functions | Statistical Functions | Date-Related Functions | Logical Functions (If, If And, If Or, If Not & Nested If) | Lookup & Reference Functions (Vlookup & Hlookup) | Text Functions (Upper, Lower & Proper) | Financial Functions (PV, FV, PMT, PPMT, IPMT, Rate & Nper) | Database Functions

What if Analysis (Goal Seek, Solver and Scenario Manager) | Data Validation | Paste Special | Filtering of Data (Auto Filter and Advanced Filter) | Custom Sorting | Subtotaling of Data Formula Auditing | Tracing Cell Relationship| Consolidating Data | Macro | Data Form | Chart | Sparklines | Quick Analysis | Importing of Data | Freeze Panes

Pivot Table and Charts | Worksheet formatting and Print Display | Tracking Workbook Changes | Page Setup | Workbook and Worksheet Protection

Advanced uses of Number Formatting | Conditional Formatting and Data Validation | Vlookup from Multiple Tables | Dynamic Vlookup | Match & Index Function | Sumproducts

Data Table | Advanced use of Solver | Depreciation Function | Financial Functions (NPV, IRR, MIRR) | Advanced use of Macro | Array Functions | Common Error Messages in Excel | Apps for Office | Other Functions

Power BI Model – Power Pivot | Dashboard Creation | Power View | Power Map | Power Query

ASAP Utilities | Store files in One Drive | Introduction to Google Drive | Managing Files in Google Drive | Form Creation | Sending and Receiving Response | Mail Merge through Google Drive

Live Project 1 & 2

Module 2 – Accounting for Business

Introduction| Accounting Concepts | Accounts Receivable | Accounts Payable | Classification of Expenses | Journal Entries | Preparation of Ledgers / Schedules | BRS | Depreciation | Final Accounts | Rectification of Errors| Accounts Documents / Accounts Working Papers | Online Journal Entry Test- JET

Live Project 3, 4 & 5

Module 3- Taxation

Income Tax – Concepts & Provisions | Five heads of Income | Computation of Taxable Income & Computation of Tax Liability | Filing of Income Tax Return

Service Tax – Concepts & Provisions | Registration | Point of Taxation | Cenvat Credit | Service Tax Procedures | Payment of Service Tax | Service Tax Return Filing

VAT – Concepts & Provisions | Registration | Valuation | Computation of VAT | Input Tax Credit | Records | Payment of VAT | Filing of VAT Return

Live Project 6, 7 & 8

Module 4- QuickBooks

Log-in to QuickBooks | Configuration of company settings | Chart of Accounts | Creation of ledgers | Inventory | Journal Voucher | Contra Entry | Payment and Receipt Entry | Purchase and Sales Invoice | Return | Tax Centre | VAT and Service Tax using QuickBooks | Entries related to TDS | Generation of Reports | Payroll configuration and processing

Live Project 9 & 10

Module 5- SAGE Peachtree

Introduction| Master Creation | Passing Entries | Entries related to Purchase and Sales

Module 6- Tally.ERP 9

Company Creation, Modification & Deletion | Ledger & Group | Accounting Voucher | Inventory Voucher | Bill of Materials (BOM) | Purchase & Sales Cycle | Security Control | Back up & Restore | Other Utilities

Module 7- Advanced Accounts

Reconciliation of Accounts – Debtors, Creditors and Branch Reconciliation | Credit Card Reconciliation | Advanced Journal Entries | Year-end Process | Finalisation of Accounts | Basic concepts of GAAP and IFRS

Module 8- Orientation on Corporate Skills

Self Management | Business Correspondence Skills | Introduction to Corporate Lifestyle | Mock Drill Sessions

Not sure which course to pursue? Leave your contact detail and our counselor will get back to you

Top