dca

DCA – Diploma in Computer Application (Online & Offline)

Build practical skills in Microsoft Office (intermediate), Multimedia Designing (Photoshop, CorelDraw), and Internet & Email workflows. Tailored for students and professionals who need job-ready digital productivity.

MS Office Intermediate Photoshop & CorelDraw Internet & Email

Mode

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

Duration

Offline: 6 Months  |  Online: 45 Hours

Includes

Practice Files, PDFs, Assignments, Doubt Support, Certificate

Online Class – Live & Recorded

  • Live sessions on Google Meet / Zoom / MS Teams
  • Access to session recordings, PDF notes & worksheets
  • Focused 45 hours of structured learning
  • Assignments and practical practice exercises

Offline Classroom – Noida (Bhangel)

  • Hands-on practice on MS Office & Multimedia tools
  • Guided tasks and assignments with feedback
  • Design portfolio creation with Photoshop/CorelDraw
  • Printed/soft copy study material

DCA – Detailed Syllabus

Microsoft Office – Intermediate (All Products)

  • MS Word: styles & themes, header/footer, table design, section breaks, page setup, references (TOC), mail-merge (letters/labels), review & track changes, PDF export.
  • MS Excel: relative/absolute references, essential formulas (SUM, AVERAGE, IF, COUNTIF, VLOOKUP/XLOOKUP intro), sorting & filtering, conditional formatting, data validation, charts, intro to PivotTables & slicers.
  • MS PowerPoint: slide masters, layout & consistency, images/shapes/icons, animations & transitions, timings & rehearse, exporting video/PDF, presenter view & delivery tips.
  • MS Access (Basics): database concepts, tables & data types, primary keys, simple queries, basic forms & reports (printing), import/export to Excel.
  • MS Outlook: professional email writing, CC/BCC, attachments, signatures, folders & rules, calendar & meetings, tasks & reminders.
  • MS Publisher: ready-to-print flyers, brochures, certificates; margins/bleed; export to high-quality PDF.

Internet & Email – Productivity & Safety

  • Web browsing basics, search operators, downloads & uploads, filling online forms, PDFs & scanners.
  • Email etiquette & formats, attaching files, sharing drive links, requesting information, acknowledgements & follow-ups.
  • Safety: strong passwords, two-step verification, identifying spam/phishing, safe downloads, basic backups.

Projects & Certificate

  • Word: resume & letter (mail-merge); PowerPoint: 8–10 slide deck
  • Excel: sales sheet with charts, basic dashboard & pivots
  • Design portfolio: poster, flyer, visiting card (print-ready)
  • Internet & Email: formal email tasks with attachments/links
✅ On successful completion, you’ll receive a Certificate of Completion from Fin Computer Class.

Your Trainers

Govind Sir - Offline DCA Trainer, Fin Computer Class

Govind Sir

Offline Trainer – Bhangel, Noida

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

Yatendra Kumar Awana

Online Trainer – Pan-India Live Classes

WhatsApp: +91 98717 15299

Home Tuition & Corporate Training

We deliver DCA upskilling for individuals and corporate teams with practical, job-oriented modules.

  • Tracks: Office Productivity, Designing, Digital Communication
  • Assignments, worksheets, recordings & certificates
  • Customized corporate training (onsite/online)

FAQs – DCA

Who can join DCA?
Students, beginners, and professionals who want strong office & communication skills.
Do you provide a certificate?
Yes, a Certificate of Completion is awarded after course completion.
How is DCA different from ADCA?
DCA focuses on intermediate MS Office, multimedia basics, and internet/email in a shorter duration, while ADCA adds broader topics (accounting, web/programming) over a longer period.