Here is the complete structured syllabus for ADFA – 1 Year Course based on your content, formatted professionally with modules, topics, practicals, projects, and outcomes.
🎓 ADFA – Advanced Diploma in Financial Accounting
Duration: 1 Year Eligibility: Fresher / Basic Computer Knowledge
📘 SEMESTER – I
Module 1: Understanding MS Excel
Topics
Practical / Activities
Excel Interface & Worksheet Structure
Navigation & data entry
Workbook, Worksheet, Rows, Columns
Create & manage multiple sheets
Page Layout & Printing
Print setup: margin, orientation
Module 2: Mathematical & Logical Excel Functions
Topics
Practical / Activities
Basic functions: SUM, AVERAGE, MAX, MIN
Salary & marksheet calculation
Logical functions: IF, AND, OR
Commission calculation
Date, Time, Text Functions
Daily attendance report
Lookup functions: VLOOKUP / HLOOKUP / XLOOKUP
Product price list search
Module 3: Banking & Data Entry
Topics
Practical / Activities
Bank account types & operations
Form fill-up: withdrawal, deposit
Cheque, Passbook, ATM, UPI
Online banking demo
Data entry scope & real field problems
Speed typing & verification
Module 4: Data Formatting & Table Management
Topics
Practical / Activities
Table format tools & styles
Project: Customer database
Conditional Formatting
Highlight overdue payments
Sorting & Filtering
Sales sheet filtering
Module 5: Advanced Excel for Accounting & Data Analysis
Topics
Practical / Activities
Data Cleaning & Error removal
Remove duplicate, trim, clean
Pivot Table & Pivot Chart
Monthly business report
Name Range, Data Validation
Automated receipt form
Dashboard creation
Company sales dashboard
Module 6: Introduction of A.I. Tools for Data Management
Topics
Practical / Activities
ChatGPT for report & formula generation
Auto formula creation
AI for data cleanup & analysis
Turn raw data into summary
AI for documentation
Write financial report
Real AI tools: SheetAI / Excel Formula Bot
Automatic financial insights
📗 SEMESTER – II
Module 1: Accounting Fundamentals
Topics
Practical
What is Accounting & its Process
Identify assets & liabilities
Types of Accounts
Personal, Real, Nominal
Golden Rules of Accounting
Debit-Credit exercise
Module 2: Accounting Statements
Topics
Practical
Journal Entry
Daily transaction problems
Ledger Posting
Prepare ledger
Trial Balance
Balance checking
Profit & Loss Account & Balance Sheet
Final accounting project
Module 3: Tally ERP9 / Tally Prime
Topics
Practical
Company creation & security
Create a new company
Ledger, Groups, Voucher Entry
Cash, Bank, Purchase, Sales
GST & Taxation
Enable GST & tax invoices
Bank Reconciliation
BRS project
Payroll & Employee Salary
Salary sheet creation
Module 4: Service & Trading Organization Management
Topics
Practical
Service organization accounting
Coaching centre account
Trading business accounting
Billing system entry
Inventory Management
Stock item, unit, godown
Sales Return / Purchase Return
Voucher handling
Module 5: GST (Goods & Service Tax)
Topics
Practical
GST concept & types
CGST, SGST, IGST
GST Invoice & E-Way Bill
Real-time invoice format
Filing Concepts
Understanding GST portal
📂 FINAL PROJECT
Tasks
Complete business project in Tally (Trading + GST)
Excel Sales Report Dashboard
AI-supported automated accounting report
Trial Balance – P&L – Balance Sheet
🎯 Learning Outcomes
✔ Strong command in Excel & Tally ✔ Practical accounting & GST knowledge ✔ Banking & business operational understanding ✔ Inventory & trading organization management ✔ AI-based data handling capability ✔ Job-ready skill development
