ADFA Course

ADFA Course Details

ADFA (Advanced Diploma in Financial Accounting) is a one-year professional course designed to provide in-depth knowledge of computer operations and financial accounting. It includes subjects like Tally Prime, GST, Income Tax basics, MS Excel, and Banking fundamentals. The course is ideal for students seeking jobs in accounts, data entry, or office administration. With practical training in Tally and Excel, it prepares students for both private and government job roles in the accounting and finance sector. No prior experience is required.

ADFA – Advanced Diploma in Financial Accounting (Syllabus)

Semester 1: Computer & Office Basics

1. Fundamentals of Computer

• History and Generations of Computers
• Input/Output Devices
• Operating System Basics (Windows/Linux)
• Computer Hardware & Software Concepts

2. MS Office Suite

• MS Word: Typing, Formatting, Tables, Mail Merge
• MS Excel: Formulas, Functions, Charts, Sorting/Filtering
• MS PowerPoint: Slide Design, Animations, Transitions
• MS Access (Basics): Tables, Queries, Reports

3. Internet & Email

• Web Browsers, Search Engines
• Email Sending/Receiving
• Online Forms, PDFs, Cyber Safety

Semester 2: Accounting & Financial Applications

1. Tally Prime / Tally ERP 9

• Company Creation & Configuration
• Ledger, Groups, Vouchers
• Inventory Management
• GST Configuration & Return Filing
• Bank Reconciliation Statement (BRS)
• Payroll in Tally

2. Advanced Excel for Accounting

• Logical Functions (IF, AND, OR)
• Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
• Pivot Tables, Data Validation
• Charts & Graphs
• Data Analysis Tools

3. GST & Taxation (India-Specific)

• Basics of GST
• Input Tax Credit (ITC)
• Filing GSTR-1, GSTR-3B
• Income Tax Basics
• PAN/TAN application process

4. Banking & Finance Basics

• Types of Accounts
• Cheques, RTGS/NEFT, UPI
• Financial Statements (Balance Sheet, P&L)
• Basic Loan & EMI Concepts