Diploma in Computer Application

Expert

103 Lessons

194 Enrolled

320 hours

About Course

DCA or Diploma in Computer Application is one popular course among students completed their Secondary or Higher Secondary education. Get in depth knowledge about computer operation which will give extra benefit in professional life.

Course Content

Fundamentals of Computer

History of Computer

04:14
Computer Generations

08:30
Understanding Types of Computer

08:01
Understand Computer & Components

11:11
Understanding System & Application software

09:16
Understanding Programing Languages

03:09

Start & Manage Computer System

Understanding Common Applications

Speed Typing

Microsoft Advanced Word

Introduction to Microsoft Word Application

12:33
MS Word Back Stage View

19:53
MS Word Home Tab- Clipboard & Font group

20:33
MS Word Home Tab- Paragraph and Styles

16:27
MS Word Home Tab- Find Replace & Selection Panel

06:59
MS Word Insert tab- Cover page

06:27
MS Word Insert Tab- Table

15:28
MS Word Insert Tab- Working with Pictures

11:59
MS Word Insert Tab- Shape SmartArt & Chart

19:17
MS Word Insert Tab- Link Bookmark & Comment

09:16
MS Word Insert Tab- Header & Footer

08:59
MS Word Insert Tab- Text Box, Drop Cap, WordArt

12:06
MS Word Design Tab- Water Mark, Colour, Border, Theme

10:47
MS Word Layout Tab- Understanding Page Setup

12:58
Understanding Mail Merge

13:04
MS Word- Document Proofing

06:16
MS Word View Tab- Manage views

07:33
MS Word- Printing Setup

04:46
Ms Word- Use Macro effectively

07:53
MS Word- Track change

04:56

Microsoft Advanced Excel

Excel introduction

04:43
Understanding Excel Interface

15:46
Understanding Excel Tabs and ribbons

06:11
Excel Backstage View

16:55
Excel organize workbook, sheet, row & column

23:19
Excel data entry technique

12:51
Excel Data sorting & Filtering

09:37
Excel Data Conditional Formatting

10:46
Excel Table

16:39
Excel Keyboard Shortcuts
Excel Security Implementation

14:23
Excel Formula & Function anatomy

12:21
Excel Basic Formula- Add, Subtract, Multiple, Divide And Percentage

09:05
Excel Function- SUM, SUMIF, SUMIFS, SUMPRODUCT

22:14
Excel Function- Count, Counta, Countblank, Countif, Countifs

13:13
Excel Function- Average, Averageif, Averageifs

14:31
Excel Function- IF, Operator, Nestedif

14:19
MS Excel- Create Academic Marksheet

13:23
Excel Function- Change case, Trim, Len

09:31
Excel Function Left, Right, Mid, Find, Concatenate, Text to Column

19:29
Excel Function Product, SQRT, Power

07:26
Excel Function- AND & OR

08:46
Excel Function- DATE, DATEDIF, NOW, TIME

14:43
MS Excel- Create Age Calculator

20:11
Excel Function- VLOOKUP

16:56
Excel Function- HLOOKUP

09:38
Excel Function- INDEX MATCH

16:22
Excel Function- VLOOKUP with MATCH Function

04:36
Excel Function- HLOOKUP with Match Function

05:30
Excel Function- PMT, IPMT, PPMT (Financial)

16:50
Excel Function- PIVOT TABLE

17:57
Data Validation in Excel

13:31
Excel Automation- Automatic Numbering, Border, Link

08:23
Data Visualization usingCharts

08:29
Advance Attendance sheet using Checkbox

04:58
Excel Column With Auto Adjust

02:12
Lookup & Vlookup Function for grade calculation

03:43
Understanding Macro for quick work

09:11
Understanding Excel Formula Tab

18:04
Excel Page Layout Tab Functions

19:17
Understanding Excel Insert Tab

27:05

Microsoft Advanced PowerPoint

Introduction to PowerPoint

08:37
Create New Presentation

16:41
Saving option in PowerPoint

13:54
Manage PowerPoint Slides

08:28
Apply and Manage Theme

08:29
Insert objects including Text, Video, Audio, Shapes

15:59
Apply Transitions on Slides

09:59
Apply Object Animation (Advance)
Slide Master Introduction
Slide Show Presentation

Understanding Internet Technology

Understanding Email

Google Productivity & Cloud Tools

Basic concept of HTML

₹400

Certificate in Computer Application

49 Lessons 10 Enrolled

₹600

Certificate in Linux Administration [RHCE]

26 Lessons 6 Enrolled

₹800

Certificate in Computer Maintenance

43 Lessons 7 Enrolled

Diploma in Computer Application

About Course

What Will You Learn?

Course Content

Fundamentals of Computer

History of Computer

Computer Generations

Understanding Types of Computer

Understand Computer & Components

Understanding System & Application software

Understanding Programing Languages

Start & Manage Computer System

Setting up a Computer System

Understanding Keyboard & Mouse operation

Understanding Windows OS

Organize your files & folder

Understanding Common Applications

Basics of Paint

NotePad

WordPad basics

Speed Typing

Understanding Keyboard Layout & Speed Typing

Microsoft Advanced Word

Introduction to Microsoft Word Application

MS Word Back Stage View

MS Word Home Tab- Clipboard & Font group

MS Word Home Tab- Paragraph and Styles

MS Word Home Tab- Find Replace & Selection Panel

MS Word Insert tab- Cover page

MS Word Insert Tab- Table

MS Word Insert Tab- Working with Pictures

MS Word Insert Tab- Shape SmartArt & Chart

MS Word Insert Tab- Link Bookmark & Comment

MS Word Insert Tab- Header & Footer

MS Word Insert Tab- Text Box, Drop Cap, WordArt

MS Word Design Tab- Water Mark, Colour, Border, Theme

MS Word Layout Tab- Understanding Page Setup

Understanding Mail Merge

MS Word- Document Proofing

MS Word View Tab- Manage views

MS Word- Printing Setup

Ms Word- Use Macro effectively

MS Word- Track change

Microsoft Advanced Excel

Excel introduction

Understanding Excel Interface

Understanding Excel Tabs and ribbons

Excel Backstage View

Excel organize workbook, sheet, row & column

Excel data entry technique

Excel Data sorting & Filtering

Excel Data Conditional Formatting

Excel Table

Excel Keyboard Shortcuts

Excel Security Implementation

Excel Formula & Function anatomy

Excel Basic Formula- Add, Subtract, Multiple, Divide And Percentage

Excel Function- SUM, SUMIF, SUMIFS, SUMPRODUCT

Excel Function- Count, Counta, Countblank, Countif, Countifs

Excel Function- Average, Averageif, Averageifs

Excel Function- IF, Operator, Nestedif

MS Excel- Create Academic Marksheet

Excel Function- Change case, Trim, Len

Excel Function Left, Right, Mid, Find, Concatenate, Text to Column

Excel Function Product, SQRT, Power

Excel Function- AND & OR

Excel Function- DATE, DATEDIF, NOW, TIME

MS Excel- Create Age Calculator

Excel Function- VLOOKUP

Excel Function- HLOOKUP

Excel Function- INDEX MATCH

Excel Function- VLOOKUP with MATCH Function

Excel Function- HLOOKUP with Match Function

Excel Function- PMT, IPMT, PPMT (Financial)

Excel Function- PIVOT TABLE

Data Validation in Excel

Excel Automation- Automatic Numbering, Border, Link

Data Visualization usingCharts

Advance Attendance sheet using Checkbox

Excel Column With Auto Adjust