
_edited.png)
We Make You A Professional Accountant
ISO Certified Institute for Computer Education

COURSES

(DICA)
Diploma in Pro Accountant
The Diploma in Pro Accounting Course is a 15-months program designed for students who desire to specialize in accounting and taxation. Students having a thorough understanding of GST and income tax are given priority by corporates these days. We focus on providing hands-on training that meets industry standards.
Module 1 : Introduction to Computer Applications
Module 2 : Advance Excel
Module 3 :Corporate Accounting
Module 4 :Tally Prime, Payroll, TDs, GST
Module 5 : Goods & Services Tax Law (GST), GSTR
Module 6 : Income Tax with TDS Filing
Module 7 : Banking and Business Law
Module 8 : BUSY
Module 9 : Interview Preparation
(CIPA)
Certificate in Pro Accountant
The Certificate in Pro Accounting is an 8 months program designed for students who desire to specialize in accounting and finance courses. Those who are proficient in Advance Excel and Tally Prime have a better chance of being hired these days. Hands-on training that meets industry standards is extremely important to us.
Module 1 : Introduction to Computer Applications
"Module 1: Basic Computer (2 Months)"
Introduction to computer:
Types of Computer, Basic Computer Hardware & Software, Operating System, Trouble Shooting, Internet & Its Applications.
MS Paint:
Clipboard, Images Editing, Tools, Shapes, View tab.
MS Word:
Formatting Text, Editing Images, Shapes & Charts, Hyperlink, Print and set-up, Watermark, Insert, Smart Art, Charts, Design.
MS Power point:
Design, Transitions, Animation, Slide Show, Review Tab, Automatic PPT creation, PPT Enhancement Tools.
MS Excel:
Basic Excel Interface, Excel Cell, Name Range, Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, Insert Formulae, Syntax, Charts.
Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, +, -, *, /,
Advance Excel
-
MIS Reporting,
-
Preparation of Final Accounts on Excel,
-
GSTr-2A Reconcilation,
-
TDS Reporting,
-
Maintaining Payroll
-
Custom & conditional Formatting, Data Validation, Advance Formulae like
-
Text Function: LEFT, RIGHT, MID, FIND, SEARCH, LEN, UPPER, LOWER, PROPER, REPLACE, SUBSITUTE, REPT, CONVERT, TRIM, TRUNC, CONCATENATE.
-
Logical Function: IF, Nested IF, AND, OR, XOR, TRUE/FALSE.
-
Date & Time Function: DATE, DAY, SECOND, MINUTE, HOUR, MONTH, YEAR, NOW, TODAY (), NETWORKDAY, NETWORKDAY.INTL
-
Information Function: INFO, CELL, ERROR, TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISODD, ISTEXT, ISNUMBER, ISNONTEXT, TYPE.
-
Database: DSUM, DMAX, DMIN, DAVERAGE, DGET, DCOUNT, DCOUNTA.
-
-
Statistical Function: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, FORECAST, COUNTA, COUNTBLANK, MAXA, MINA, AVERAGEA.
-
Lookup & Reference Formulae: VLOOKUP, HLOOKUP, MATCH, INDEX, CHOOSE, OFFSET, ROW, COLUMN
-
Excel Tools: Auditing Tools, Flash Fill, Remove Duplicates, Go To, Hyperlinks.
-
Excel Table & Charts: Changing table styles, Formatting, Charts, Adding to
-
Pivot Tables, Charts & Dashboards: Creating Pivot table, Adding Fields, Adding Labels, Swapping Data, Changing Designs, Pivot Refresh, Summary, Subtotals, DASHBOARD Creation, Designing Report Creation. Workbook Protection, Running & Recording Macros, Goal Seek
"Module 2: Fundamentals of Accounting (2 Months)"
-
Accounting Concepts,
-
Golden Rules of Accounting,
-
Journal & Ledgers Creation,
-
Subsidiary books,
-
Rectification of Errors,
-
Bills of Exchange,
-
Depreciation,
-
Final Accounts of Sole Proprietorship,
Advance Accounting
-
Depreciation as per Schedule-II of Companies Act,2013,
-
Preparation of Final Accounts of Companies, As per Schedule-III of Companies Act,2013,
-
Accounting Standards.
"Module 3: TallyPrime (Latest Version) (3 Months)"
-
Introduction to TallyPrime,
-
Company creation
Accounts Management in TallyPrime
-
Groups & Ledger Creation,
-
Inventories Creation,
-
Voucher Entries,
-
Interest Calculation,
-
Cost Centres,
Inventory Management in TallyPrime
-
Stock Groups and Stock Group items Creation,
-
Godown Creation,
-
Inventory Voucher Entries
Taxation in TallyPrime
-
Enabling GST in TallyPrime,
-
Basic Concepts of GST,
-
Advance Transactions having CGST, SGST, IGST,
-
Advance GST Adjustments,
-
Enabling TDS/TCS in Tally.ERP9,
-
Basic Concepts of TDS,
-
Transactions of TDS/TCS in Tally.ERP9
Payroll Management in TallyPrime
-
Employees & Pay head Creation,
-
Basic Concepts of EPF, ESIC and EDLI,
-
Employees Salary Creation
Advance Topics in TallyPrime
-
Splitting Company Data,
-
Company Logo.
Backbone of Every Industry
"Module 4: Goods & Service Tax (GST) (2 Months)"
-
Basic Overview of CGST Act, 2017,
-
SGST Act, 2017,
-
IGST Act, 2017,
-
UTGST Act, 2017,
-
GST Rules,
Registration under GST
-
GST REG 01,
-
Registration as GST Practitioners,
CGST Law, SGST La, IGST Law & UTGST Law
-
Important definition,
-
Determination of nature of supply,
-
Zero rated Supply,
Composition Scheme
-
Registration under composition scheme,
-
Rates under composition scheme,
Input Tax Credit
-
Eligibility and Condition for taking ITC,
-
ITC for Job Work,
Returns
Types of Returns,
-
Annual Returns,
-
First Return,
-
Regular Return,
-
GSTr-1,
-
GSTr-2A (Auto filled),
-
GSTr-3B,
-
Interest, Late Fees, Offences.
"Module 5: Income Tax (3 Months)"
Income Tax under various heads
-
Income Under Salary,
-
Allowances,
-
Perquisites,
-
-
Income under House property,
-
Income under PGBP,
-
Income under Capital Gains,
-
Income under other sources.
Clubbing of Income
Deduction u/s 80C to 80U Computation for Income Tax Apply for PAN
Income Tax returns – ITR Forms
-
ITR – 1 (SAHAJ),
-
ITR – 2,
-
ITR – 3,
-
ITR – 4 (SUGAM),
Tax Deducted at Sources – TDS
-
TDS on Salary,
-
TDS on other than Salary,
-
TDS Returns (24Q and 26Q),
"Module 6: Banking and Business Laws (1 Month)"
Banking
Types of Accounts
-
Current Accounts
-
Saving Accounts
Banking Forms
Money Transfer
-
RTRG
-
NEFT
-
IMPS
-
Demand Draft
Loans
-
Short Term Loans
-
Long Term Loans
Investment Options
-
Fixed Deposit (FD)
-
Recurring Deposit (RD)
-
Public Provident Fund (PPF)
-
Mutual Funds
Interest Calculation
Bank Reconciliation
Internet Banking
Business Laws
-
Indian Contract Act, 1872
-
Negotiable Instruments Act, 1881
-
Sales of Goods Act, 1930
-
Indian Partnership Act, 1932
"Banking Seminar" Conducted at IPA Studies with Different Banks
"Module 7: Busy Accounting Software (1 Month)"
-
Financial Accounting (Multi-Currency)
-
Inventory Management (Multi-location)
-
Production / Bill of Material
-
Sales / Purchase Quotations
-
Sales / Purchase Order Processing
-
Fully User-configurable Invoicing
-
User-configurable Documents / Letters
-
User-configurable Columns in Reports
-
GST Invoicing & Reports
-
TDS & TCS