Honours Diploma in Computer Application (Tally)
Office, TallyPrime, advanced Excel with VBA, MySQL and digital marketing.
HDCA (Tally) is a one-year course for a career in accounts and office work. You learn MS-Office, TallyPrime with GST and payroll, advanced Excel with VBA, MySQL and digital marketing, and complete two projects using Tally Prime and VBA Excel.
What you will learn
Windows & Internet
Computer fundamentals, Windows Explorer, Control Panel, email and online research.
MS Word
Documents, indexes and tables, mail merge and macros.
MS Excel
Formatting, charts, pivot tables, data tables, scenarios, goal seek and macros.
MS PowerPoint
Presentations, OLE, audio and video, special effects.
HTML5 & CSS3
Semantic HTML, forms, multimedia, styling, box model, transitions and animations.
MySQL
Tables, queries, joins, subqueries, views, constraints, functions and advanced query processing.
TallyPrime basics
Principles of accounting, company data, masters and vouchers.
Reports & advanced accounting
Balance sheet, profit and loss, ratio and cash flow analysis, bill-wise details, cost centres, bank reconciliation, budgets, job costing.
Inventory & POS
Order processing, reorder levels, batches, bill of materials, price lists and point of sales.
GST, TDS & TCS
GST computation and forms, TDS/TCS entries and e-returns.
Payroll
Payroll masters, attendance, salary vouchers, pay slips and provident fund.
Utilities
Consolidation, security, audit, backup, data import and export, WhatsApp connect, dashboard.
Advanced Excel & VBA
Lookup and logical functions, pivots, macros, user forms and automation.
Digital marketing
Social media, search marketing, content creation, Google Ads and Google Analytics.
ChatGPT
Using AI tools for research, writing and automating everyday tasks.
Two projects using TallyPrime and VBA Excel.
Interested in HDCA?
Find the branch nearest to you and ask about batch timings, fees and scholarships.
