← Back to Computer Courses
04
COURSE SYLLABUS

PGDCA & DCA

Explore the complete course syllabus, topics and practical learning areas.

WHAT YOU WILL LEARN

Course Syllabus

A structured learning path covering the topics included in this course.

01

Computer Fundamentals

  • Introduction to Computers
  • Computer Hardware & Software
  • Input & Output Devices
  • Operating Systems
  • Windows
  • File & Folder Management
  • Internet & Basic Networking
02

MS Office

  • MS Word
  • MS Excel
  • MS PowerPoint
  • MS Outlook
  • Printing & PDF
  • Office Documentation
03

Internet & Digital Skills

  • Internet & Web Browsing
  • Email Communication
  • Google Search
  • Online Forms
  • File Upload & Download
  • Cloud Storage Basics
  • Digital Office Tools
04

Advanced Excel Basics

  • Formulas & Functions
  • VLOOKUP / XLOOKUP
  • Sorting & Filtering
  • Charts
  • Pivot Tables
  • Basic Reports
05

Tally Prime with GST

  • Accounting Fundamentals
  • Company Creation
  • Ledger & Groups
  • Purchase & Sales
  • GST Transactions
  • GST Reports
  • Inventory
  • Basic Banking & BRS
06

Practical Office Skills

  • Resume Preparation
  • Business Letters
  • Invoice Preparation
  • Attendance Sheets
  • Salary Sheets
  • Office Reports
  • Data Entry