Office & Basics · HDCA

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.

Duration1 year
Training hours450 hrs
Who it's forSchool final students, graduates and computer career seekers
PrerequisitesNo prior computer knowledge needed

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.

Project

Two projects using TallyPrime and VBA Excel.

Interested in HDCA?

Find the branch nearest to you and ask about batch timings, fees and scholarships.

Find a branch

Related courses

WhatsApp us