Diploma In Computer & Financial Accounting-DCFA

Course Code :	BA254	Duration :	06 month
Course Type :	Standard	Eligibility :	10
Enquiry

???? Month 1: Computer Fundamentals & Operating Systems

• Introduction to Computers

• Types of Computers and Devices

• Hardware & Software Concepts

• Operating System Basics (Windows/Linux)

• File and Folder Management

• Keyboard Shortcuts & Troubleshooting

???? Month 2: MS Office Suite

MS Word

• Creating, Editing, Formatting Documents

• Tables, Mail Merge, Templates

MS Excel

• Data Entry, Formatting, Formulas

• Charts, Graphs, Basic Functions (SUM, AVERAGE, IF)

MS PowerPoint

• Creating Presentations

• Animations & Transitions

???? Month 3: Advanced Excel & Financial Functions

• Excel Advanced Formulas: VLOOKUP, HLOOKUP, COUNTIF, SUMIF

• Data Validation, Conditional Formatting

• Pivot Tables & Charts

• Payroll Preparation

• MIS Reporting

???? Month 4: Tally Prime with GST

• Introduction to Tally Prime

• Company Creation, Ledger, Group Creation

• Voucher Entry (Purchase, Sales, Payment, Receipt)

• GST Basics in Tally

• Inventory Management

• Bank Reconciliation

???? Month 5: Taxation & Payroll Accounting

• Introduction to Indian Tax System

• GST Filing Overview (GSTR-1, GSTR-3B)

• TDS & TCS Basics

• Payroll in Tally (Salary Configuration, Payslip, PF & ESI)

• Generating Reports (Trial Balance, P&L, Balance Sheet)

???? Month 6: Project Work & Soft Skills

• Mini Accounting Project (with real-life data)

• Resume Making

• Basic Interview Skills

• Email Writing & Communication

• Online Job Portals and Career Guidance

???? Final Assessment

• Theory Exam

• Practical Exam (Excel + Tally)

• Project Submission

• Viva