DCA

Courses
Objective of diploma in computer application course DCA:

In step with effort to attain the target of achieving laptop accomplishment in associate comprehensive manner, knife laptop Institute larger Noida has launched a replacement programme, “DCA”. the target of the course is to impart basic level also as advanced level laptop appreciation programme with a lot of stress on hands on coaching. Initially, the course was formed on boost the idea of introducing a course on laptop fundamentals, however, the course has gained quality amongst more classes.


The programme will equip an individual to use the computers in every day life for skilled and private use. once finishing the course the incumbent are pc literate and can be in a position to: any, we tend to encourage quality and skilled performing at knife pc Institute in larger Noida, Alfa one business belt, jagat farm, gamma, Beta, Delta, omicron, omega,Pari chowk, kasna, dankaur larger Noida. Our discounted schemes, quality coaching, and after-course support makes United States totally different from all different pc institutes in larger Noida Delhi/NCR.



  • Acquire confidence in using computer techniques available to users;
  • Recognize the basic components of computers and terminology;
  • Understand data, information and file management;
  • Create documents using Word processor, Spreadsheet & Presentation Software;
  • Understand computer networks, Internet;
  • Browse the internet, content search, email and collaborate with peers;
  • Use e-Governance applications;
  • Use computer to improve existing skills and learn new skills.
  • CONTENT’S IN SHORT’S

Fundamental of computers:

  • Paint,
  • Notepad,
  • Word Pad,
  • MS-Word,
  • MS-Excel,
  • MS-PowerPoint,
  • English Typing,
  • Internet
Content
1.      MS Word Introduction
2.      Save, Save As, Open
3.      Close And Exit
4.      Cut Copy And Paste
5.      Format Painter
6.      Bold Italic And Underline
7.      Grow And Shrink
8.      Font Style And Size
9.      Subscript And Superscript
10.  Strike Through
11.  Change Case
12.  Text Effects
13.  Text Highlighting And Font Color
14.  Clear Formatting
15.  Clipboard
16.  Styles
17.  Paragraph Alignment
18.  Paragraph Bullet
19.  Decrease Increase Indents
20.  Sort And Sorting
21.  Show And Hide
22.  Text Shading
23.  Text Border
24.  Line And Paragraph Spacing
25.  Find
26.  Replace
27.  Select
28.  Cover Page
29.  Blank Page
30.  Page Break
31.  Insert Table
32.  Draw Table
33.  Convert Text To Table
34.  Excel Spreadsheet
35.  Quick Tables
36.  Tables Formatting
37.  Insert Picture And Remove Bg
38.  Insert Picture And Adjust
39.  Insert Picture And Styles
40.  Insert Picture And Arrange
41.  Insert Picture Size And Crop
42.  Insert Clip Art
43.  Insert Shapes
44.  Insert Shapes And Edit
45.  Undo And Redo
46.  Insert Smart Art
47.  Insert Chart
48.  Insert Screen Shot
49.  Insert Hyperlink
50.  Insert Bookmark
51.  Cross Reference
52.  Headers And Footers
53.  Headers And Footers Customize One
54.  Headers And Footers Customize Two
55.  Insert Page Number
56.  Insert Text Box Part One
57.  Insert Text Box Part Two
58.  Insert Text Box Part Three
59.  Insert Text Box Part Four
60.  Word art
61.  Drop Cap
62.  Insert Date And Time
63.  Insert Object
64.  Insert Equation Part One
65.  Insert Equation Part Two
66.  Insert Symbols And Formatting
67.  Insert Margins
68.  Orientation
69.  Page Size And Setting
70.  Columns
71.  Breaks Page Columns Section
72.  Add Line Numbers
73.  Add Hyphenation
74.  Add Watermark Part One
75.  Add Watermark Part Two
76.  Add Page Color
77.  Page Borders
78.  Indent And Hanging
79.  Paragraph Spacing
80.  Tab Part One
81.  Tab Part Two
82.  Tab Part Three
83.  Tables Of Content’s
84.  Insert Footnotes And Endnotes
85.  Insert Situation
86.  Insert Caption Part One
87.  Insert Caption Part Two
88.  Index
89.  Envelopes
90.  Labels Part One
91.  Labels Part One
92.  Labels Part One
93.  Labels Part One
94.  Spelling And Grammar Checker
95.  Word Count
96.  Translate
97.  Comments
98.  Document Views
99.  Show
100.                      Zoom
101.                      New Window
102.                      Split Windows
103.                      Print And Setting
104.                      Recent Files
1.    Introduction To Excel 2013
2.    New Open And Save
3.    Cut Copy And Paste
4.    Clip Board
5.    Bold Italic And Underline
6.    Increase And Decrease Font
7.    The Font Style
8.    The Border
9.    The Cell Back Ground
10.  The Format Painter
11.  Alignment
12.  The Indent Or Cell Margin
13.  Orientation Text Merge Cell Wrap
14.  Number Cell Formatting
15.  Number Cell Formatting
16.  The Conditional Formatting
17.  The Conditional Formatting
18.  The Format As Table
19.  The Cells Style
20.  The Insert
21.  The Delete
22.  The Delete Sheet
23.  The Cell Size
24.  The Visibilit Hide And Unhide
25.  The Organize Sheet
26.  The Protection
27.  The Autosum
28.  The Average
29.  The Count Number
30.  The Maximum Number
31.  The Minimum Number
32.  The Undo Redo
33.  The Fill Series
34.  The Fill Justify
35.  The Clear
36.  The Sort
37.  The Filter
38.  The Find And Replace
39.  The Go To
40.  The Find Next
41.  The Selection
42.  The Alt Keys
43.  The Cell Address
44.  The Insert Picture Adjust
45.  The Insert Picture
46.  The Insert Picture Arrange
47.  The Insert Picture Crop And Size
48.  The Insert Picture Clipart
49.  The Insert Picture Shapes
50.  The Insert Picture Shapes
51.  The Insert Smart Art
52.  The Insert Smart Art
53.  The Insert Smart Art Formatting
54.  The Insert Table
55.  The Insert Table Part Two
56.  The Pivot Table
57.  Download Office Templates
58.  The Text Box
59.  The Header And Footer
60.  The Word Art
61.  The Signature Line
62.  The Object
63.  The Hyperlink
64.  The Symbols
65.  The Charts
66.  The Margins Setup
67.  The Orientation Pagesetup
68.  The Size Page Set Up
69.  The Print Area Page Set Up
70.  The Page Break Page Set Up
71.  The Background Page Setup
72.  The Print Titles Page Setup
73.  The Gridlines And Headlines
74.  The Functions Library
75.  The Show Formulaes
76.  The Get External Data
77.  The Text To Columns
78.  The Remove Duplicates
79.  The Data Validations
80.  The Group And Ungroup
81.  The Spellings
82.  Research Thesaurus
83.  The Comments
84.  The Workbook Views
85.  The Zoom In Or Out
86.  The New Windows
87.  The Freeze Row And Column
88.  The Split
89.  The Window Hide And Unhide
90.  The Macros
91.  Sum Plus Add Formulae P1
92.  Sum Plus Add Formulae P2
93.  Sum Plus Add Formulae P3
94.  Minus Formulae
95.  Multiply And Multiplication
96.  Divide And Division Formulae
97.  Brackets In Formulae
98.  Abs Formulae
99.  Cell Address And Cell Name
100.  Counta
101.  Countblanck
102.  Count Counta
103. Count If Part 1
104.  Count If Part 2
1.    auto sum function in excel
2.    max function in excel
3.    how to find average in excel
4.    count blank formula in excel
5.    count and counta formula in excel
6.    master logical statement true of false in excel
7.    logical statement true of false in excel
8.    average, count ,min ,max ,or sum easily see in status bar in excel
9.    auto fill-automatically create serial number list in excel
10.  sort data – largest to smallest in excel
11.  sort data-a to z (Alphabetically ) in excel
12.  sort data  – dates (oldest to news ) in excel
13.  sort by color in excel
14.  how to filter data & then calculating sum in excel
15.  filtering data correctly in excel
16.  working with filtered data in excel
17.  filtering row with values more then 10,000 in excel
18.  remove duplicate in excel
19.  drop down list in excel
20.  how to remove a drop down list in excel
21.  freeze panes in excel
22.  format painter-copy $ paste cell format in excel
23.  freeze panes in excel
24.  format painter-copy $ paste cell format in excel
25.  table formatting trick -wrapping long table headers in excel
26.  create a hyperlink to another worksheet in excel
27.  how to change text case in excel
28.  trim function remove excess space in excel
29.  how to use mround function in excel
30.  how to store number as text in excel
31.  value function to clean up number stored as text in excel
32.  how to use Len function in excel
33.  how to extract data using left ,right , made function In excel
1.    how to create a pivot table in excel
2.    how to use vlookup vs hlookup in excel
3.    exce vlookup
4.    best way to learn vlookup formula in excel
5.    how to use vlookup formula in excel  part 3
6.    vlookup-basic part 4
7.    vlookup – basic part 5
8.    learn excel vlookup with multiple sheets
9.    debtors ageing analysis using vlookup () in excel
10.  learn vlookup formula in excel
11.  vlookup best example in excel
12.  using correct services tax rate using vlookup() in excel
13.  excel login functions – and funcation, or funcation
14.  If  funcation  and nested if funcation in excel
15.  countif in excel
16.  excel sumif function
17.  how to use averageif function in excel
18.  sumproduct formula for total cost calucation in excel
19.  calculating year on year % growth in excel
20.  add serial numbers column before sorting in excel
21.  2 level sorting in excel
22.  using format painter continously in excel
23.  color multiple sheet tabs together in excel
24.  change cell color based on cell color based on cell values using conditinonal formatting in excel
25.  how to change cell color based on error or blanks in excel
26.  adding leading  zeroes to incomplete cheque nos. in excel
27.  calculating fixed deposit maturity amount -1 in excel
28.  calculating fixed deposit maturity amount -2 in excel
29.  formating trick to write x^3 in excel
30.  how to combine cells in excel
1.    Introduction To Excel 2010
2.    Excel Interface
3.    Introduction To Excel Sheets
4.    Excel Cells
5.    How To Use Sum Formulae In Excel
6.    How To Use Average Formulae In Excel
7.    How To Use Averageif Formulae In Excel
8.    How To Use Sumif Formulae In Excel
9.    Count And Counta
10.  Isnumber And Isblank Formulae In Excel
11.  Rows And Columns Formula In Excel
12.  Max And Min Formula In Excel
13.  Transpose Formulae In Excel
14.  Date, Time And Now Formulae In Excel
15.  If Formulae In Excel
16.  Rank Formulae In Excel
17.  Power And Fact Formula In Excel
18.  Countif Formula In Excel
19.  How To Use Sumifs Formulae In Excel
20.  How To Use Countifs Formulae In Excel
21.  How To Use Auto Filter In Excel
22.  How To Do Data Validation In Excel
23.  How To Use Vlookup Formulae
24.  How To Use Hlookup Formulae
25.  How To Use Advanced Filter In Excel
26.  How To Do Custom Data Validation In Excel
27.  How To Do Conditional Formatting Part-1
28.  How To Do Conditional Formatting Part-2
29.  How To Do Conditional Formatting Part-3
30.  How To Use Date With If Function
31.  How To Use Absolute Cell Reference
32.  How To Use Text Function Part 1
33.  How To Use Text Function Part 2
34.  How To Use Pmt Formula
35.  How To Use Fv Formulae In Excel
36.  How To Use Ipmt Formulae In Excel
37.  How To Use Ppmt Formulae In Excel
38.  How To Use Present Value In Excel
39.  How To Use Nper Formulae In Excel
40.  How To Use Rate Formulae In Excel
41.  How To Use Cumipmt Formulae In Excel
42.  How To Use Upper, Lower, Proper Formulae In Excel
43.  How To Use Left, Right, Mid & Concatenate Formula
44.  How To Use Trim, Len, Replace Formulae In Excel
45.  How To Use Countblank Formula In Excel
46.  How To Use Hyperlink Formulae In Excel
47.  How To Use Autofill In Excel
48.  How To Use Isblank Formula With If Function In Excel
49.  How To Use Chart In Excel
50.  How To Use Line Chart In Excel
51.  How To Use Pie Chart In Excel
52.  How To Use Bar Chart In Excel
53.  How To Use Pivot Table In Excel
54.  How To Use Area Chart In Excel
1.    powerpivot add-in-excel in hindi
2.    excel shortcut ctrl + enter in excel
3.    consolidate / separate worksheet in to master worksheet
4.    delet error cells in excel
5.    fill blank cells with above value in excel
6.    excel formula match example 1
7.    match formula in excel  part 2
8.    match funcation with vlookup in excel part 1
9.    using vlookup with match for 2d lookup example  2 in excel
10.  using vlookup with match for 2d lookup example  3 in excel
11.  vlookup with match formula in excel
12.  roundup & rounddown basic 02- round off numbers in excel
13.  roundup and rounddown formula with example in excel
14.  round trick for excel superstars in excel
15.  substitute function to replace characters in excel
16.  active developer tab in 2007-2016 in excel
17.  dashbord trick / create a scroll bar in excel
18.  dashboard trick / create a spin button in excel
19.  create a hyperlinked shape (with shortcut )in excel
20.  horizonal sort – re arrange coloumns easily in excel
21.  how to add a blank row after row after every data row in excel
22.  sort data as per your own custom list inexcel your own custom list in excel
23.  learn advanced excel / online workshop on 12th august
24.  basic of index + match formula in excel 
25.  basic of index + match formula in excel  / part 2
26.  index + match formula in excel/ part 3
1.    why do we learn excel macro
2.    how to learn excel vba macros
3.    how to enable developer tab in excel
4.    basic of developer in excel
5.    important macro security setting in excel
6.    how to save a macro in excel
7.    how to create a macro in excel
8.    how to run a macro in excel
9.    using a button to run a macros in excel
10.  running a macros in different ways in excel
11.  understanding vba workspace in excel
12.  watch a macros being recorded in excel
13.  excel vba macro webinar
14.  excel vba conept of object ,propties methods part 1
15.  excel vba: object ,propties,methods /part 2
16.  excel vba: object ,propties,methods /part 3
17.  excel vba: object, propties, method /part 4
18.  do until loop vba excel macro
19.  do while loops or for next excel vba
20.  for next loops vba excel
21.  for next loop visual basic applications
22.  if then else with for next loops vba
23.  for each next vs. for next vba /part 1
24.  pivat table
25.  for each next vs. for next loops vba part 2
26.  input box visual basic – part 1
27.  input box visual basic – part 2
28.  input box visual basic -part 3
29.  input box visual basic – part 4
30.  range & cells object part 1 excel vba
1.      The Powerpoint,titlebar,ribbon,scrollbar
2.      File And Back Stage View
3.      Quick Access Toolbar
4.      Shortcut Keys
5.      Presentations View Buttons
6.      The Mini Toolbar
7.      Creating A New Presentation
8.      Inserting New Slides
9.      Applying Slide Layouts
10.  Save And Send
11.  Working With Different File Formats
12.  Opening A Presentation
13.  Opening A Presentation
14.  Savind And Closing
15.  Normal Views
16.  Notes Page Views
17.  Reading View
18.  Slide Sorter View
19.  Slide Show View
20.  Running A Slide Show
21.  Using A Custom Show
22.  Header And Footer
23.  Adding Text To Slides
24.  Inserting Audios, videos
25.  Using Smart Art
26.  Graphics Manipulations
27.  Changing Text Case
28.  Cutting, Copying And Paste
29.  Undo And Redo Button
30.  Font Formatting
31.  Formatting Color Lines
32.  Object Manipulations
33.  Inserting Shapes
34.  Inserting Clip Arts
35.  Using Tabs
36.  Setting Text Box Options
37.  Moving, Resizing, Deleting
38.  Paragraph Formatting
39.  Line Spacing
40.  Bullets And Numbering
41.  Slide Transition Animation
42.  Animation Multimedia
43.  Adding Object Animation
44.  Spell Check,pagesetup
  • Acquire confidence in using computer techniques available to users;
  • Recognize the basic components of computers and terminology;
  • Understand data, information and file management;
  • Create documents using Word processor, Spreadsheet & Presentation Software;
  • Understand computer networks, Internet;
  • Browse the internet, content search, email and collaborate with peers;
  • Use e-Governance applications;
  • Use computer to improve existing skills and learn new skills.
  • CONTENT’S IN SHORT’S

Fundamental of computers:

  • Paint,
  • Notepad,
  • Word Pad,
  • MS-Word,
  • MS-Excel,
  • MS-PowerPoint,
  • English Typing,
  • Internet
Shadule my Free Trial Class

DCA

  • Duration : 6 Months
  • Price :  6000/-
Join This Course

Courses We Provide

Advance Excel
Microsoft Office
Tally
Basic Computer Course
CCC
DCA
ADCA Cource
Photoshop
CoralDraw
DTP Training
Data Structure
C
C++
Wordpress
Industrial Training
Digital Marketing
Android
PHP
PHP Framework & MVC
Web Designing
.Net
C#
.Net MVC Technology