+91 9702570087

Diploma in Accounting(DIA)

OVERVIEW:

Diploma in Accounting is a 6-months short diploma course for those students who have passed their 10th examination. Under Graduates and graduates will also enrol for this course.

What is the benefit of Diploma in accounting?

After completing Diploma in Accounting candidates will get jobs in field like Book-Keeping Clerk,Junior Accountant, Tax Accountant, Financial Advisors, Accountant, Finance Managers, etc.

MODULE 1

OFFICE AUTOMATION

  • Typing speed
  • Introduction to computer
  • MS Word
  • MS Excel
  • MS PowerPoint
  • Windows
  • Internet resources

MODULE 2

TALLY PRIME

OPERATING TALLY

  • Basic accounting
  • Golden rules
  • Sales/purchase voucher
  • Receipt/payment voucher
  • Memorandum voucher
  • Contra voucher
  • Debit note/credit note
  • Interest calculation

ADVANCED TALLY

  • Order processing & tracking order
  • Manufacturing journal
  • Price list
  • Logo printing
  • Cost centers & cost categories
  • Multi-currency
  • Allowed 0 value/actual billed & quantity
  • Budget & control
  • Point of sales
  • Payroll
  • BRS (BANK RECONCILATION STATEMENT)

TAX

  • GST (GOODS AND SERIVES TAX)
  • TDS (TAX DEDUCTED AT SOURCES)
  • TCS (TAX COLLECTED AT SOURCES)
  • VAT (VALUE ADDED TAX)

MODULE 3

ADVANCED EXCEL

  • Introduction to excel
  • VLOOKUP
  • Hlookup
  • If VLOOKUP
  • VLOOKUP If
  • Multiple VLOOKUP
  • Indirect Function
  • Nested if condition
  • If and or function
  • Sum, sum if, sumifs function
  • Count, count if, countifs function
  • Date and time function
  • Financial function
  • Text function
  • Advance use of macros
  • MIS report
  • Dashboard creation, pivot table, & pivot charts
  • Advance data validation
  • Scenario manager
  • Index match
  • Choose function
  • Forecast
  • Is function
  • DSUM, DMAX, DMIN & DAVG
  • Master salary report and deduction

ELIGIBILITY

Any students who have cleared their 10 th OR 12 th exams from any school duly recognised by the Indian Government are eligible to apply for this course. Also B.COM, BBI, BAF, BMS etc student can join this course.

If you Have Any Questions Call Us On +91 970 257 0087