Government Recognition: The Indian Trusts Act,1882 IV-1901-00017/2026, NCT Certificate No. IN-DL64429509726740Y, Trademark No. 7737734, NITI Aayog. WB/2026/1010497, Department of Labour Certificate No. 2026017999

 Professional Course

Diploma in Computer Application

A comprehensive 1-year diploma covering everything from computer basics to Advanced Excel, MS Access, and financial analysis

1 Year
7,000
Diploma Awarded
Beginner to Intermediate

Course Overview

The Diploma in Computer Application (DCA) is a comprehensive 1-year program that builds on the fundamentals of CCA and extends into advanced territory. Students master Microsoft Office Suite, Advanced Excel with financial modeling, MS Access database management, and data analysis techniques used in professional environments.

DCA graduates are equipped for roles in data entry, office administration, accounting support, and junior analyst positions across industries.

Complete CCA curriculum included
Advanced Excel: 30+ formulas, Pivot Tables, PowerPivot
MS Access database design and queries
Financial functions: SLN, PMT, NPV, IRR, XIRR and more
Data validation, conditional formatting, and dashboards
Course Fee
₹7,000
1 Year Duration
Study Material Included
Practical Lab Sessions
Diploma Certificate
Project-Based Learning
Placement Assistance
Enroll Now

Course Curriculum

Includes complete CCA syllabus plus advanced modules

Module 01–07
CCA Foundation Modules
Computer Fundamentals & Windows
Typing, MS Word, MS PowerPoint
Internet & Email, Excel (30 Formulas)
Module 08
MS Access
Database design and tables
Queries, forms and reports
Data relationships and macros
Module 09
Advanced Excel — Data Tools
Data Validation & Conditional Formatting
Data Table, Solver, Financial Analysis
SUMPRODUCT, COUNTIF, SUMIF, AVERAGEIF
Module 10
Lookups, Logic & Charts
Conditional Logic functions (IF, IFS, nested)
VLOOKUP, HLOOKUP, INDEX, MATCH
Dynamic charts and dashboards
Module 11
Database Functions
DSUM, DPRODUCT, DCOUNT
Pivot Tables & Pivot Charts
Match Index and advanced filtering
Module 12
Financial Functions & PowerPivot
SLN, DB, PMT, PPMT, IPMT
NPV, XNPV, IRR, MIRR, XIRR
PowerPivot for data modeling

Why Choose DCA?

📊

Advanced Excel Mastery

Go beyond basics — master financial modeling, pivot tables, and data analysis tools used by professionals.

🗄️

Database Skills

Learn MS Access for database management — a skill valued in administrative and data roles.

🚀

Career Advancement

DCA opens doors to roles in data analysis, accounting support, and office management.

Take the Next Step

Enroll in DCA and gain the comprehensive computer skills that set you apart in today's competitive job market.