SRI NARMADA IT TRAINING

DCA Course Content


  • Keyboard Skills
  • The desktop, the icon, taskbar
  • Basic mouse operations
  • My computer
  • Start button, the title bar
  • Desktop setting (background setting)
  • Search
  • Control panel
  • Calculator
  • Recycle bin
  • Closing windows & system
  • Folder or directory
    • Create a folder
    • Cut, copy, paste and rename folder
    • Sharing folder
    • Properties of folder
    • Deleting folder
  • Create a new notepad
  • Open already existing notepad
  • Save, save as options
  • Cut, copy, paste options
  • Page setup, printing options
  • Find, replace, goto and select option
  • Insert time and date
  • Formatting text, help
  • Close notepad
  • Create a new Paint
  • Open already existing Paint
  • Save, save as options
  • Cut, copy, paste options
  • Other Toolbar Options
  • Formatting text, help
  • Close Paint
  • Start MS-Word
  • Open a new and existing documents
  • Selecting and deleting text
  • Saving document in different format
  • Closing a document
  • Copying, moving, paste, inserting, overwriting text
  • Undo, repeat, find, replace, go to and office clipboard
  • Layout, toolbar, task pane
  • Header and footer
  • Comments objects
  • Break, page number, date & time, auto text
  • Symbols and equations
  • Inserting and formatting pictures
  • Online pictures and videos
  • Capture screen
  • Diagrams, auto shapes, and word art
  • Text box and file, hyperlink, bookmark and cross reference
  • Formatting fundamentals
    • Font, paragraph
    • Bullets and Numbering
    • Columns, tab, drop caps
    • Change case, background
    • Theme
  • Spelling and grammer, word count
  • Table of content, footnote, endnote, and captions
  • Tracking a document
  • Letters mailing
    • Envelops and labels
    • Mail merge
  • Macro
    • Create macro
    • Run macro
  • Security
  • Tables
    • Draw table, delete, select table
    • Insert, delete, select rows
    • Merge, split cell, split table, auto formte
    • Formulas
    • Convert text to table, convert table to text
    • Sorting
  • Page background
  • Page setup, print preview, print
  • Documents views, zoom and windows
  • Introduction to Excel
  • Contents of a work sheet
  • Opening a new and existing work book
  • Saving and printing a work book
  • Saving a document in different formats
  • Entering and Editing data in a sheet
  • Editing the work sheet
    • Inserting rows and columns
    • Deleting rows and columns
    • Deleting cells
  • Formatting the excel sheets
    • Set row height and column width
    • Hide and unhide rows & columns
    • Organize the sheets
    • Protection
  • Copying ,moving, inserting and paste and over writing text
  • Format printer
  • Undo ,repeat ,find ,replace, Goto and office clipboard
  • Number Formats
  • Conditional Formatting
  • Format as table and cell styles
  • Auto sum and clear cells
  • Header and Footer
  • Fill the cells
  • Illustrations [pictures, shapes and smart arts]
  • Online pictures and videos
  • Capture screen
  • Chart
    • Creating charts and Modifying charts
    • Chart tool bar
    • Moving and sizing charts
    • Adding and deleting chart from a data chart
    • Changing the scale value of the Axis
    • Changing the display unit on the value Axis
    • Saving & printing a chart
  • Formulas
    • Operators in formulas
    • Ranges Functions
    • The Function Wizard
    • Text Formulas
    • Data Formulas
    • Look up Formulas
    • Logical Formulas
    • Auto calculate
    • Defined Name
    • Formulas Auditing
  • Pivot table
  • Spelling, sort, filter
  • Advance the Filter
  • Import the data [notepad and webpages]
  • Data tools
    • Text columns
    • Remove the Duplicate
    • Data Validation
    • Consolidate
    • What-if- analysis
  • Page setup ,page review,print
  • Proofing and comments
  • Document view ,Zoom and Windows
  • Introduction to Presentation
  • Creating Presentations using Blank Presentation
  • Creating Presentations using Design Template
  • Open an Existing Presentation
  • Selecting and deleting text
  • Saving document in different format
  • Closing a document
  • Copying, moving, paste, inserting, overwriting text
  • Undo, repeat, find, replace, go to and office clipboard
  • Layout, toolbar, task pane
  • Header and footer
  • Comments objects
  • Break, page number, date & time, auto text
  • Symbols and equations
  • Inserting and formatting pictures
  • Online pictures and videos
  • Pictures and Drawings
  • SmartArt and Charts
  • Capture screen
  • Photo Album
  • Media
  • Diagrams, auto shapes, and word art
  • Text box and file, hyperlink, bookmark and cross reference
  • Formatting fundamentals
    • Font, paragraph
    • Bullets and Numbering
    • Columns, tab, drop caps
    • Change case, background
    • Theme
  • Spelling and grammer, word count
  • Table of content, footnote, endnote, and captions
  • Security
  • Tables
    • Draw table, delete, select table
    • Insert, delete, select rows
    • Merge, split cell, split table, auto formte
    • Formulas
    • Convert text to table, convert table to text
  • Page background
  • Page setup, print preview, print
  • Documents views, zoom and windows
  • Inserting a Graph
  • Inserting an Excel Chart
  • Animation and Transitions
  • Custom Animations
  • Multimedia Objects
  • Slide Show
  • Gmail Account Creation
  • Mail Send and Receive
  • How to Search Anything in Google