HDCA (Tally)

Students must complete two projects using Tally Prime and VBA Excel.

Objective

Upon completion of this course, the participant acquires the advantage in choosing his / her career as an Application Programmer, Computerised Accountant, and Web Programmer.

Prerequisites

No prior computer knowledge is required.

Overview

This course has been tailor made as per the software industry requirement. It is a stepping stone for those who aspire to be a software professional.

Target Audience

School final students / Graduates / Students pursuing a career in Computer.

Course Coverage

I. End-User Application

Windows

• Computer Fundamentals
• Introduction to OS / GUI
• Wordpad
• Notepad
• Paintbrush
• Windows Explorer
• Control Panel

MS Office

MS Word

• Creating Text and Documents
• Indexes and Tables
• Embedding Picture
• Table Manipulation
• Mail Merge
• Macro

MS Excel

• Formatting Cells
• Charts
• Pivot Table
• Data Table
• Forms
• Scenarios
• Goal Seek
• Macros and Modules

MS PowerPoint

• Creating Presentations
• OLE
• Enhancing Presentation
• Adding Audio & Video
• Special Effects

Internet

• Creating E-mail ID
• Receiving & Sending E-mail
• Chatting
• Locating Information
• Downloading

II. Front-End Language & Library

HTML5

• HTML Basics
• New Elements
• Canvas
• Multimedia
• Form Elements
• Semantic Elements

CSS3

• Syntax
• ID, Class, Tag Styling
• Using Text
• Fonts
• Links
• Lists and Tables
• Box Model
• Text Effects
• Transition
• Animations

III. Database Management System

MySQL

• Client / Server Concepts
• Relational Model
• Data Definition using SQL
• Modify Tables using ALTER TABLE Queries
• Add Column, Add Index, Add Primary Key
• INSERT and DELETE Queries
• UPDATE Queries
• SELECT Queries (WHERE, LIMIT, ORDER BY)
• GROUP BY, JOIN
• Constraints and Indexes
• Views
• Expressions and Grouping
• Using Functions
• JOIN and Subqueries
• Advanced MySQL Query Processing

IV. Financial Accounting (TallyPrime)

Introduction to TallyPrime

• Principles of Accounting
• 5 Steps
• Maintaining Company Data
• F11 Features and F12 Configure

Masters

• Group
• Ledger
• Chart of Accounts
• Stock Group
• Stock Category
• Unit of Measurement
• Godown
• Stock Item

Tally Vouchers

• Accounting Vouchers
• Inventory Vouchers

Reports

• Balance Sheet
• P & L Account
• Ratio Analysis
• Cash Flow and Fund Flow Statements
• Ageing Analysis
• Movement Analysis

Advanced Accounting

• Billwise Details
• Cost Centres and Cost Categories
• Voucher Classes and Cost Centre Classes
• Multiple Currencies
• Bank Reconciliation
• Interest Calculation
• Budgets & Scenario
• Job Costing

Advanced Inventory

• Order Processing
• Reorder Levels
• Tracking Numbers
• Batch wise Details
• Additional Cost Details
• Bill of Materials
• Price List

System Administration and Other Utilities

• Consolidation of Accounts
• Tally Vault
• Security Control
• Tally Audit
• Backup and Restore
• Split Company Data
• Export and Import of Data
• ODBC Compliance

Point of Sales (POS)

• Predetermination of Invoice
• Multi Payment Modes
• Small & Smart Bills
• POS Sales Register

Multi Language

• Supporting OS
• Translation / Transliteration
• System & Phonetic Keyboard
• Sourcing from other Software

Goods & Service Tax (GST)

• Accounting of Purchase or Sales Returns
• Inter State Trade Accounting
• Accounting of Exempted Items
• Purchases from Unregistered Dealers
• Input Credit on Capital Goods
• GST Computation & Forms

TDS & TCS

• Entry
• Calculator
• Reports
• E-Returns

Payroll

• Introduction to Payroll
• Configuring Tally for Payroll
• Creation of Payroll Masters
• Recording Attendance
• Payroll Vouchers based on Attendance
• Salary Disbursement Voucher
• Payroll Reports
• Attendance Sheet and Attendance Register
• Introduction to Provident Fund

Add-On Features

• WhatsApp Connect
• Import from Excel
• Dashboard

Project

Live simulated projects are given to students.

V. Advanced Excel & VBA Programming

Advanced Excel

• Introduction to MS Excel
• Formatting Worksheet
• Working with Formulas and Functions
• Lookup & Reference Functions
• Logical Functions
• Database Functions
• Date and Time Functions
• Information Functions
• Math and Trigonometry Functions
• Statistical Functions
• Text Functions
• Conditional Formatting
• Connect to other Database
• Data Sorting and Filtering
• Pivot Tables and Charts

VBA Programming

• VBA Overview
• Variables
• Conditional Logic
• String and String Functions
• Programming Loops
• Programming Arrays
• Subs and Functions
• Creating your First Macro
• Excel VBA Objects
• Excel Events
• Error Handling
• User Forms
• External Data Connection
• Automation Project

Project

Students are given projects using VBA Excel, which helps them explore automation tasks and develop applications/tools using VBA.

VI. Digital Marketing

• Introduction to Digital Marketing
• Traditional vs Digital Marketing
• Organic vs Inorganic Marketing
• Content Creation
• Graphic Designing
• Social Media Marketing
• Facebook, Instagram, YouTube
• Search Marketing
• Google Ads
• Google Analytics

VII. ChatGPT

ChatGPT is a free-to-use AI system. Use it for engaging conversations, gain insights, automate tasks, and witness the future of AI, all in one place.

⬅ Back to Diploma Courses