
- 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)
Comments are closed.