CERTIFICATE IN COURSE ON COMPUTER CONCEPT ( S-0051 )

Text Creation and manipulation 

Document Creation 

 Editing Text

 Text Selection 

Cut, Copy and Paste

 Font, Color, Style and Size selection 

Alignment of Text 

Undo & Redo 

AutoCorrect, Spelling & Grammar 

 Find and Replace 3.5 Formatting the Text 

Paragraph Indentation

  Bullets and Numbering 

Change case 

Header & Footer 

Table Manipulation 

 Insert & Draw Table 

Changing cell width and height

  Alignment of Text in cell 

Delete / Insertion of Row, Column and Merging & Splitting of Cells 

 Border and Shading 

Mail Merge

 Shortcut Keys

 Elements of Spread Sheet 

Creating of Spread Sheet 

 Concept of Cell Address [Row and Column] and selecting a Cell 

 Entering Data [text, number, date] in Cells 

 Page Setup 

 Printing of Sheet 

 Saving Spreadsheet 

 Opening and Closing 

 Manipulation of Cells & Sheet 

 Modifying / Editing Cell Content

  Formatting Cell (Font, Alignment, Style )

  Cut, Copy, Paste & Paste Special 

Changing Cell Height and Width

  Inserting and Deleting Rows, Column

  AutoFill

 Sorting & Filtering

  Freezing panes 

 Formulas, Functions and Charts

  Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division) 

 AutoSum 

 Functions (Sum, Count, MAX, MIN, AVERAGE)

  Charts (Bar, Pie, Line) 

10 pass