dfa

DFA – Diploma in Financial Accounting (Online & Offline)

Become job-ready in financial accounting with Excel spreadsheets, GST basics, and computerized accounts (Tally ERP). Build skills for accounting roles in MSMEs & startups with hands-on practice.

Financial Accounting Excel for Accounts GST Basics Tally ERP

Mode

Online (Live) & Offline (Classroom – Bhangel, Noida)

Duration

Offline: 6 Months  |  Online: 60 Days

Includes

Practice Data, Excel Sheets, PDFs, Assignments, Doubt Support, Certificate

Online Class – Live & Recorded

  • Live sessions on Google Meet / Zoom / MS Teams
  • Downloadable Excel practice files & case studies
  • Session recordings + PDF notes
  • Interview Q&A and mini-projects

Offline Classroom – Noida (Bhangel)

  • Hands-on ledger posting & voucher entries in Tally
  • Excel for accounting dashboards & MIS
  • GST documentation demos (invoice, e-waybill overview)
  • Printed/soft copy study material

DFA – Detailed Syllabus

MS Office Fundamentals

    Word:
    • Introduction to the Word interface
    • Creating and typing documents
    • Applying text formatting (fonts, sizes, colors, alignment, line spacing)
    • Using bullet and numbered lists
    • Working with tables
    • Inserting images and shapes
    • Saving documents in different formats
    • Setting page layout (margins, orientation, size)
    • Preparing documents for printing
    PowerPoint:
    • Introduction to the PowerPoint interface
    • Creating a new presentation
    • Working with different slide layouts and designs
    • Inserting text, images, and shapes
    • Applying themes and transitions
    • Arranging slide order
    • Using basic animations
    • Running a slideshow presentation

Accounting Foundations

  • Basics: journal, ledger, trial balance
  • Debit/credit rules, contra & journal entries
  • Year-end adjustments: depreciation, provisions

Excel for Accounting & MIS

  • Structured sheets, data validation, text/number cleanup
  • Functions: SUMIFS, IF, VLOOKUP/XLOOKUP (intro), ROUND, EOMONTH
  • PivotTables, charts, basic dashboards for P&L & sales
  • Bank reconciliation templates & aging reports

Computerized Accounting – Tally ERP

  • Company creation, chart of accounts, cost centres
  • Voucher entries: purchase, sales, payment, receipt, JV
  • Inventory basics: items, units, godowns
  • Reports: Day book, Ledger, P&L, Balance Sheet

GST Basics & Compliance Overview

  • GST concepts: CGST/SGST/IGST, input tax credit basics
  • GST configuration in Tally, GST ledgers & tax rates
  • GST-compliant invoices, e-invoice overview
  • Returns overview: GSTR-1 / GSTR-3B (hands-on in Tally)

Payroll & Banking (Intro)

  • Salary components, attendance & simple payroll sheets
  • Bank reconciliation & petty cash management
  • TDS basics concept overview

MIS Reporting & Finalization

  • P&L, Balance Sheet, Cash Flow (interpretation)
  • Variance analysis & monthly MIS pack
  • Exporting reports & documentation best practices

Projects & Certificate

  • Excel: Sales register → Pivot dashboard (month & product)
  • Tally: Full month ledger posting & GST invoices
  • Bank reconciliation & aging analysis in Excel
  • Final P&L and Balance Sheet export with notes
✅ On successful completion, you’ll receive a Certificate of Completion from Fin Computer Class.

Your Trainers

Govind Sir - Offline DFA Trainer, Fin Computer Class

Govind Sir

Offline Trainer – Bhangel, Noida

WhatsApp: +91 62035 11683
Yatendra Kumar Awana - Online DFA Trainer, Fin Computer Class

Yatendra Kumar Awana

Online Trainer – Pan-India Live Classes

WhatsApp: +91 98717 15299

Home Tuition & Corporate Training

We deliver DFA upskilling for individuals and corporate teams with practical, accounting-first modules.

  • Tracks: Excel for Finance, Tally ERP, GST Basics, MIS Reports
  • Assignments, worksheets, recordings & certificates
  • Customized corporate training (onsite/online)

FAQs – DFA

Who should join DFA?
Students, freshers, and small-business owners who want hands-on accounting with Excel, GST basics, and Tally ERP.
Is prior accounting knowledge required?
No. We cover fundamentals first and progress to GST-ready invoicing and MIS reporting.
Do you provide a certificate?
Yes, a Certificate of Completion is awarded after finishing DFA.