Basic Computer MS Word- MS Excel- MS Power point Internet & Email course

Topics Ms-Word Training

1. HOME MENU

1. New , open, save, save as, print settings
2. Cut, copy, & paste
3. Format painter
4. theme fonts
5. bold,italic,underline
6. font size, strikethrough
7. subscript, superscript
8. clear formatting, change-case
9. font color, text color
10. bullets & numbering
11. sort alphabets & numbers
12. bullets & numbering
13. sort alphabets & numbers
14. paragraph alignment
15. line spacing, shading
16. customize border
17. gallery of styles, change styles
18. find, replace & select\

2. INSERT MENU

1. Page break, blank page
2. Table,picture,clip art
3. Shapes, insert smart-art graphic
4. Insert chart, hyperlink
5. Bookmark,header,footer
6. Page number, text box
7. Word art, drop cap
8. Date& time, object
9. Symbol,autocorrect

3. Page layout menu

1  theme fonts, margins
2  page orientation, page size
3  columns
4  breaks, line numbers
5  watermark, page colours,page borders
6  indent settings, paragraph spacing
7  object position, text wrapping
8  endnote, footnote

Topics Ms-Word Training

4. MAILINGS

1  mail merge, letters, labels
2  step by step mail merge wizard
3  select  & edit recipients lists
4  insert merge field
5  update labels, preview results
6  finish & merge

5. Review

1  spelling & grammar, research
2  thesaurus, word count
3 new, edit, & delete comment
4 track changes, accept & reject changes
5 protect document, restrict formatting & editing

6)  VIEW
       1  print layout, full screen
       2  web layout, outline, draft
       3  view rulers, gridlines, thumbnails
       4  zoom, one page, two pages, page width
       5  new window, arrange all, split, view side by side, synchronous scrolling
6. switch windows, run macros

Topics covered in MS Excel Training

1. HOME MENU

1 new,open,save,saveas,print settings
2  cut, copy,& paste
3 format painter
4 fill color, change font face
5 bold,italic,underline
6 font size, strikethrough
 7 subscript, superscript, font color
8  customize border
9  find, replace & select
10 cell alignment, orientation, wrap text
11 align text, merge & center, indents
12 number format, percent, comma style
13 increase & decrease decimal
14 conditional formatting, format as table
15 cell styles, insert, delete& format cells
16 autosum,sort,filter, find & select

2.   INSERT MENU
1  Pivot table, pivot chart, table
2  picture, clip art, shapes, smart art
3  column chart,hyperlink,text box
4  header & footer, wordart,object,symbol

3.   Page layout menu
1  theme fonts, colors, fonts
2  page margins, orientation, page size
3  print area, page break, background
4  page width, height & scale
5  gridlines, headings, object selection
6 bring to front, send to back, rotate

4.   formulas
1  auto sum, average, max, min,count
2  if, sumif,today,now, upper, lower
3  left,right,trim,true,false
4  ceiling, mround,rounddown,roundup
5  trace precedents, trace dependents
6  show formula, evaluate formula, watch window

5.   DATA
1   sort, filter, text to column
 2  remove duplicates, data validation
 3  consolidate, what if analysis(
         goal seek, scenario manager)
 4  subtotal, group, ungroup

6.   REVIEW
1  spelling & grammar, research
2  thesaurus, protect workbook
3 new, edit, & delete comment
4 track changes, accept & reject changes
5 protect sheet, restrict formatting & editing

6. VIEW
1  page layout, normal, full screen
 2  page break preview, custom views
 3  view rulers, gridlines, formula bars
 4  headings, zoom, new window, arrange all, freeze panes, hide, unhide, split
 5  switch windows, macros

Topics covered in MS Power Point Training

HOME MENU

1. new, open, save, save as, print settings
2  cut, copy,& paste, format painter
3  new slide, layout, delete
4  bold,italic,underline
5  font size, strikethrough, text shadow
6  subscript, superscript
7  clear formatting, change-case
Character spacing, font color
8 bullets & numbering, text direction
9  paragraph alignment, align text
10 line spacing, columns
11 shapes, arrange, quick styles
12 shape fill, shape outline, shape effects
13 find, replace & select

2.   INSERT MENU
1 table, picture, clip art, photo album
2 shapes, smart art, chart, hyperlink
3 action, text box, header & footer
4 word art, date & time, slide number
5 symbol, object, movie, sound

3   DESIGN
1 page setup, slide orientation
2 slide design,colors,fonts,effects
3 background styles, hide background graphics

4.   ANIMATIONS
1 preview, animate, custom animation
2 special effect, transition sound, transition speed

5.  SLIDE SHOW
1  from beginning, from current slide
2  custom slide show, setup slide show
3  hide slide, rehearse timings, resolution

6)   REVIEW
        6.1 spelling, research,thesaurus,translate
        6.2 new, edit & delete comment
        6.3 protect presentation

6.  VIEW
1  normal, slide sorter, notes page
2  view rulers, gridlines, slide show
3  zoom, fit to window,color,grayscale
4  new window, arrange all,
6   switch windows, formatting tools