DCA (Diploma In Computer Applications) TRENDING

Course Fee: ₹ 6600

Duration: 6 Months

Monthly: ₹ 1100

(Note: Diploma Charges:– ₹ 400 Extra)

Diploma in Computer Application gives the advance knowledge of Computer Applications. DCA is a skill-based program for students. It is a six months course and job-oriented. In this course, you will gain practical knowledge of Computer Applications. We cover two modules in this course:-

Module 1: Computer Applications (3 Months)

Module 2: Advacned Excel (3 Months) or Website Desiginig (3 Months) or Graphic Designing (3 Months)

After completetion of 1st Module (Computer Applications) then we offers to student choose Module 2 according to their interest field.

Career Opportunities:- Data Entry Operator, Office Assistant, Office Coordinator, Backend Executive, Data Analyst, MIS Executive, Financial Analyst, Website Designer, Front End Designer, Graphic Designer

Course Content:

3 Months DCA
  • Computer Fundamentals
  • Notepad & WordPad
  • Paint
  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Internet & Web Browsing
  • Typing (15 Days)
  • Microsoft Outlook Mail Configuration
  • Microsoft DOS (CMD)
  • HTML (Basic)
  • Introduction to Hardware & Software Installation
  • Online Exam and Certificate
3 Months DCA
  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data : Charts & Graphsss
  • Analyzing data: Data Menu, Subtotal, Filtering Data
  • Working with functions & formulae Formatting worksheets
  • Securing & Protecting spreadsheets
  • Logical Test- IF & Nested
  • SUM IF & SUM IFS
  • Not and if Error
  • Auditing Tools
  • Text Functions
  • Date Function
  • Name Range & Name Range with Formulas
  • Macros
  • Count Function & Statistical Function
  • Maths & Trigonometry
  • V-Lookup
  • H-Lookup
  • Lookup Function & Lookup Full Record
  • Index function
  • Match Function
  • Protect Cell, Sheet, File, Workbook
  • Hyperlink to sheet, File, Webpage, Update
  • Data Sorting
  • Advance Filters
  • Filtering Data
  • Advance Table
  • SUM IF & SUM IFS
  • Column Chart
  • XY Scatter Chart
  • Spark Line Chart
  • Pivot Chart (Table)
  • Pie Bar, Column & Line Chart
  • Pivot Table (Grouping, Slicer, Timeline)
  • Consolidation
  • Consolidation Extended
  • Conditional Formatting & Advance Conditional Formatting
  • Data Validation Error Alert
  • Dependent Dropdown List
  • Import Live Data from Web
  • Insert, Create Object
  • NPV
  • PMT, PPMT, IPMT
3 Months DCA
  • Html5
  • CSS3
  • JavaScript
  • Photoshop (Basic)
3 Months DCA
  • Photoshop
  • CorlDraw
  • Illustrator
  • InDesign