DOA — Diploma in Office Automation

Windows • Office Suite (Word • Excel • PowerPoint • Access) • Internet & Email + Tally Prime (Accounts & Inventory)
Office + Accounts, One Course.

9 Months Theory + Practical Objective + Practical Office + Accounts
Enroll Now Download Syllabus (PDF) Talk to Counselor
Why DOA @ MCA
Office Automation Skills

Windows, files, printing, shortcuts — day‑to‑day office tasks.

MS Office Mastery

Word, Excel, PowerPoint, Access — docs से MIS reports.

Internet & Email

Professional email, search, cloud/attachments, etiquette.

Accounts + Tally Prime

Journal→Ledger→TB→P&L/BS; invoices, stock & GST basics.

Full Syllabus
Part A

Office Automation (Windows + MS Office + Internet)

Duration: 6 Months · Mode: Theory + Practical
1
Basics of Computer
  • What is a Computer? · Data vs Information · Pros/Cons · History · Generations
  • Applications in various fields · Intro to AI
2
Microsoft Windows OS
  • Desktop, File Explorer/This PC, Control Panel/Settings, Shortcuts, Printing
  • Module‑End Test: Windows
3
MS Word 2019
  • Editing/Formatting · Paragraph/Page setup · Styles · Tables · Images/Shapes
  • Mail Merge · Macros · Review/Track Changes · Printing
  • Module‑End Test: Word
4
MS Excel 2019
  • Formatting · Data entry best‑practices · Sort/Filter · Conditional Formatting
  • Functions: SUM, AVERAGE, IF, VLOOKUP/XLOOKUP (intro), COUNTIF/COUNTIFS
  • Pivot Table & Charts · Shortcuts
  • Module‑End Test: Excel
5
MS PowerPoint 2016
  • Slides, Masters, Objects, Animations & Transitions, Presenting & Printing
  • Module‑End Test: PowerPoint
6
MS Access 2016
  • Tables · Relationships · Queries · Forms · Reports
  • Module‑End Test: Access
7
Internet & Email
  • Safe browsing · Search · Gmail/Attachments · Calendar/Drive (intro)
  • Module‑End Test: Internet & Email
Part B

Financial Accounting with Tally Prime

Duration: 3 Months · Mode: Theory + Practical
1
Basics of Accounting
  • Terminologies · Accounting Equation · Classification of Accounts · DR/CR rules
  • Journal → Ledger → Trial Balance → Financial Statements (P&L, Balance Sheet)
2
Tally Prime — Setup & Masters
  • Company creation · F11/F12 configuration · Security & Users
  • Ledgers/Groups · Stock Items/Units · Godowns · Cost Centers · Voucher Types
3
Tally Prime — Accounting Vouchers
  • Contra · Payment · Receipt · Purchase · Sales · Journal · Debit/Credit Note · Memorandum
  • Bill‑wise details · Cost center allocation · Day Book & basic reports
4
Tally Prime — Inventory & Invoicing
  • Inventory Masters · Item pricing · GST‑ready invoicing · Stock Summary
  • Receipt/Delivery Note · Rejection In/Out · Purchase/Sales Order · Stock Journal · Discounts
5
GST Basics in Tally
  • Concepts · HSN/SAC · Input/Output Tax · Tax Ledgers · Voucher configuration · GSTR overview
6
Reporting & MIS
  • Trial Balance · P&L · Balance Sheet · Outstanding · Ratio Analysis · Print/Export/Backup
Tools · Career · Fees
Software & Tools
Windows
MS Word
MS Excel
PowerPoint
MS Access
Internet & Email
Tally Prime
Career Paths
Office Assistant
Docs, email, printing, scheduling
Data Entry & MIS
Excel reporting, basic dashboards
Accounts Assistant (Tally)
Daily vouchers, invoicing, stock & GST basics
Fees & Duration
  • DOA: 9 Months (Office: 6M + Accounts: 3M)
  • Mode: Theory + Practical
  • Assessment: Objective + Practical + Mini Projects
Note: Fee batch/time‑slot के अनुसार बदल सकता है। नवीनतम details के लिए counselor से संपर्क करें।
Apply Ask a Question
FAQs

हाँ — पहले Office Automation, फिर Accounts/Tally; step‑by‑step flow से beginners आसानी से सीखते हैं।

Windows, Word, Excel, PowerPoint, Access, Internet & Email, और Tally Prime।

Objective + Practical — Office tasks, Excel reports, Tally voucher entries, और short projects।

Center schedule के अनुसार batches—कृपया counselor से latest slots पूछें।