Certificate in Pro Accountant (CIPA)

• Instructor: proipastudies

IT literacy has become a requirement for everyone in the current digital age. The usage of computers is widespread throughout industries, including education, transportation, marketing, communication, and medicine. Students, professionals, and stay-at-home moms can all benefit from accounting literacy thanks to the Certificate in Pro Accounting course. The Certificate in Pro Accountant course is a chance to start your career as an IT professional while gaining in-depth computer expertise

MODULE 1 : BASIC COMPUTER WITH ADVANCE EXCEL

• 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

ADVANCE EXCEL

• Basic Formulae like SUM, AVERAGE, MAX, MIN, COUNT, +,-, *, /, Custom &
  Conditional Formatting, Data Validation,
• Advance Formulae like Text Formulae: LEFT, RIGHT, MID, FIND, SEARCH, LEN, UPPER, LOWER,
  PROPER, REPLACE, SUBSITUTE, REPT, CONVERT, TRIM, TRUNC,
  CONCATENATE.
• Logical Formulae: IF, Nested IF, AND, OR, XOR, TRUE/FALSE.
• Date & Time Formulae: DATE, DAY, SECOND, MINUTE, HOUR, MONTH,
  YEAR, NOW, TODAY (), NETWORKDAY, NETWORKDAY.INTL
• Information Formulae: INFO, CELL, ERROR, TYPE, ISBLANK, ISERR,
  ISERROR, ISEVEN, ISODD, ISTEXT, ISNUMBER, ISNONTEXT, TYPE.
• Financial Function, Lookup formulas, References

MODULE 2  : FUNDAMENTALS OF ACCOUNTING

• Accounting Concepts
• Golden Rules of Accounting
• Journal & Ledgers Creation
• Subsidiary books
• Rectification of Errors
• Depreciation
• Bills of Exchange
• 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 : TALLY PRIME WITH GST (3 MONTHS)

• Introduction to Tally Prime
• Company creation
• 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, UTGST & Advance GST Adjustments
• Payroll: PF, ESI, EPF Scheme , EPS, EDLI, PF Admin Charges
• TDS: TDS on salary, TDS on commission, TDS on rent, TDS On Professional Services,
• TDS Returns (24Q) and (26Q)