Best Seller Icon Bestseller

ADVANCED DIPLOMA In COMPUTER APPLICATIONS(M-CA-6964)

  • Last updated Jan, 2026
  • Certified Course
₹15,000 ₹20,000

Course Includes

  • Duration1 Years
  • Enrolled10
  • Lectures15
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

The ADCA (Advanced Diploma in Computer Applications) course is a comprehensive, job-oriented program designed to build strong computer and IT skills for students, job seekers, and working professionals. This course covers both basic and advanced computer applications required in offices, businesses, and professional workplaces.

Students will learn Computer Fundamentals, MS Word, MS Excel, MS PowerPoint, Internet & Email, Advanced Excel, Tally with GST, Basic Programming Concepts, Database Management, and Practical Computer Skills. The course focuses on hands-on training, real-time practice, and industry-relevant knowledge to boost confidence and employability.

After completing ADCA, students can work as Computer Operator, Office Executive, Accountant Assistant, Data Entry Operator, or IT Support Staff, and can also pursue higher computer or IT courses.

✅ Practical-based learning

✅ Industry-useful syllabus

✅ Suitable for beginners & advanced learners

✅ Career & job-oriented course

Show More

Course Syllabus

Fundamental of Computer

  •  Computer Introduction
  •  WordPad 
  •  MS Paint, 3D Paint
  •  Folder Create/Update
  •  Snipping Tool
  •  RAM, HDD, ODD
  •  Short-Cut Keys
  •  Desktop Options
  •  Basic Mother-Board
  •  Notepad
  •  Etc.

 Microsoft Word

  •  Why We Use MS Word
  •  Text Editing, Formatting
  •  Resume Making
  •  Table Creations
  •  Graphs & Layouts
  •  Shapes & Charts
  •  Pictures Formatting
  •  Screen-shorts & Other
  •  Header & Footer
  •  Format Making - 4
  •  Short-Cut Keys
  •  Print-Options
  •  Links/Cross References
  •  Maths Q/P Design
  •  Word to PDF Creation
  •  Password Protection
  •  Links/Cross References
  •  Design & Watermark
  •  Build in Themes
  •  Page Border & Color
  •  Layout & Page Setup
  •  References & Footnote
  •  Mail Merge Option
  •  Review & View
  •  Advanced Options
  •  Final Mini Project

 Microsoft Basic Excel

  •  Why We Use MS Excel
  •  Text Editing, Formatting
  •  Basic Tools & Use
  •  Sheet Options
  •  Basic Operators
  •  Fill Options & Tools
  •  Basic Functions
  •  Format Cell Options
  •  Conditional Formatting
  •  Styles Options
  •  Insert/Delete/Format
  •  Short & Filter/Editing
  •  Pivot Tables Tools
  •  Tables & It's Tools
  •  Excel to PDF Creation
  •  Password Protection
  •  Shapes/Pictures/Icons
  •  Charts & It's Types
  •  Sparklines & It's Tools
  •  Links & Symbols
  •  Attendance Sheet
  •  Office Salary Sheet
  •  School Result Card
  •  Paste Special Tools
  •  Basic IF Function
  •  Nested IF Function
  •  AND/ OR Operators
  •  Page Layouts & Setup
  •  TEXT Functions
  •  Simple VLOOKUP
  •  Simple HLOOKUP
  •  Format Making - 4
  •  Macros & Review
  •  Final Mini Project

 ADVANCED Excel


  •  Recap of Basic Excel Tools & Practicals
  •  Advanced Date Functions
  •  Stock Management System
  •  Financial Functions (PMT/PPMT/IPMT/Etc)
  •  Consolidate Function
  •  SUMIF & SUMIFS
  •  Advanced VLOOKUP
  •  LOOKUP + MATCH
  •  LOOKUP in Multiple Sheet
  •  Double LOOKUP in Multiple Wookbooks
  •  Advanced Attendance Sheet
  •  Automated Fee Management System
  •  Advanced Pivot Tables & Slicer
  •  Pivot Chart/ Timeline/Graphs
  •  Automated P& L Account
  •  Common Errors in Excel
  •  Automated Salary Sheet
  •  Data Validation & Restrictions
  •  Advanced Paste Special Tool
  •  Data Dashboard (MIS)
  •  Hotel Booking System
  •  Fee Record with Graphs
  •  Automated Certificated 
  •  Paste Special Tools
  •  Retail Management System (MIS)
  •  Automated Certificate Generation using Word
  •  MIS Dashboard (Format Making)
  •  2 Final Major Projects
  •  Multiple Employee ID Card Generate using Word
  •  Automated Multiple Report Card Generate for Students & Parents


 Microsoft PowerPoint 

  •  Use of PowerPoint
  •  Text Editing, Formatting
  •  Slide Option & Tools
  •  SmartArt & Pictures
  •  Shapes & Charts
  •  Making Presentation
  •  Transition & It's Tools
  •  Timing & Sound
  •  Animations & It's Tools
  •  Poster Making
  •  Invitation Card Design
  •  Password Protection
  •  PPT to PDF Conversion
  •  PPT to Video Creation
  •  Slide Show Options
  •  Slide Size & It's Options
  •  Background Format
  •  Recording Slides
  •  Review & View
  •  Final Mini Projects
  •  Microsoft Outlook
  •  Why We Use Outlook
  •  Account Creation
  •  Outlook v/s Gmail
  •  Email Management
  •  Office Apps Integration
  •  Calendar Management
  •  Tasks & To-Do List
  •  Contact Management
  •  Outlook Use in Office
  •  Microsoft Publisher
  •  Why We Use Publisher
  •  Text Editing, Formatting
  •  Page design & It's Tools
  •  Custom Template
  •  Template Designing
  •  Flex Designing
  •  Certificate Designing
  •  Visiting Card Designing
  •  Page Setup & It's Tools
  •  Mail Merge in Publisher
  •  Party-Invitation Design
  •  Review & View
  •  Final Mini Projects

 Internet with AI Tools

  •  Internet History
  •  PAN/LAN/MAN/WAN
  •  Remove Background
  •  PDF Editors & Tools
  •  Making QR Code of link
  •  Downloading Software
  •  ChatGPT AI Tool
  •  Gemini AI
  •  Server & Client
  •  Browsers & Websites
  •  Image Editing using AI

 Financial Accounting | Tally

  •  Need of Accounting
  •  Trade & Profession
  •  Goods/Inventory
  •  Purchase & Sale
  •  Purchase & Sale Return
  •  Debtor & Creditor
  •  Transaction
  •  Assets / Liabilities
  •  Income / Expense
  •  Playing with Ledgers
  •  Discount / Bad Debt
  •  Drawing / Capital
  •  Expense v/s Loss
  •  Income v/s Profit
  •  Golden Rules
  •  Journal Entries

 Tally Prime & Tally.ERP9 Software

  •  Tally Introduction
  •  Tally.ERP v/s Tally Prime
  •  Company Setup
  •  Ledger Creation/Alter
  •  Stock Creation/Alter
  •  Receipt/Payment Voucher
  •  Purchase/Sale/Contra Voucher
  •  Journal/Optional Voucher
  •  Debit and Credit Note
  •  2 Assignments
  •  Features Options
  •  Memorandum Voucher
  •  Posted-Dated Cheque
  •  Godowns & Categories
  •  Stock Journal
  •  Export & Import Data
  •  Financial Reports
  •  Balance Sheet
  •  Profit & Loss A/c
  •  Stock Summary & Ratio
  •  Day Book Report
  •  Sale /Purchase Register
  •  Stock Summary
  •  Dashboard & Cash Flow
  •  Cash Book Report
  •  Exception Reports
  •  TDS Deduction & Many more 

 Goods & Service Tax (GST)

  •  Why we need GST
  •  Types of GST (CGST, SGST, IGST, UT-GST)
  •  Tax Slabs (0%, 5%, 12%, 18%, 28%)
  •  GST Identification Number (GSTIN)
  •  HSN & SAC Code
  •  Different State Code 
  •  GST Enable & Alter Details
  •  Filliing GST Number & Other Details
  •  E-Invoicing Application
  •  Practical with Original Invoices
  •  Final Mini Project in Tally Prime

 Payroll Management System

  •  What is Payroll System
  •  Enable Payroll
  •  Employee Groups
  •  Units (Work) Creation
  •  Attendance/Production Type
  •  Pay Heads & Alter Details
  •  Payroll Voucher Type
  •  Employee Creation
  •  Employee Attendance
  •  Salary Creation using Autofill
  •  Salary Slip in Different Format (.pdf, .xls, etc.)

 HTML with CSS

  •  HTML Introduction
  •  HTML Components
  •  HTML Implementation
  •  Heading & Paragraph Tag
  •  <div> / <article> / <aside> Tag
  •  <span> / </br> / </hr> Tag
  •  Image <img> Tag
  •  Links in HTML
  •  Ordered & Un-Ordered Lists
  •  Forms Tag (<input>, <option>, <select>, Etc.)
  •  Tables Tag (<thead>, <tr>, <th>, <td>, Etc.)
  •  <header>, <footer>, <main>, <article>, <video>, Etc.
  •  Character and Symbol
  •  CSS Introduction
  •  CSS Syntax
  •  CSS Styling in HTML
  •  CSS Margin & Padding
  •  CSS Selector
  •  CSS Height & Width
  •  CSS Fonts Family & Size
  •  CSS Backgrounds
  •  Final Mini Project

 Google Product & Services (Bonus)

  •  Google Docs
  •  Google Sheets
  •  Google Slides
  •  Google Sites
  •  Google Forms

 Tools & Techniques (Bonus)

  •  Canva for Designs
  •  PosterMyWall


Course Fees

Course Fees
:
₹20000/-
Discounted Fees
:
₹ 15000/-
Course Duration
:
1 Years

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%



Call
Text Message
Review
Email
CHAT