True-commerce
The Institute of Professional Accountants
Address:-4Th Floor, Malhar Mega Mall, Near C-21 Mall, A. B. Road, Indore (M.P.)-452010 India
Tel. 9300930066, Website: www.truecommerce.in Email: info@truecommerce.in

Basic Computer Course including MS Word, MS Excel, MS Power point

Duration:- 1Month

Topics:- 

(Ms-Word)

1) Home Menu

  • New , open, save, save as, print settings
  • Cut, copy, & paste
  • Format painter
  • Theme fonts
  • Bold, italic, underline
  • Font size, strikethrough
  • Subscript, superscript
  • Clear formatting, change-case
  • Font color, text color
  • Bullets & numbering
  • Sort alphabets & numbers
  • Bullets & numbering
  • Sort alphabets & numbers
  • Paragraph alignment
  • Line spacing, shading
  • Customize border
  • Gallery of styles, change styles
  • Find, replace & select

2) Insert Menu

  • Page break, blank page
  • Table, picture, clip art
  • Shapes, insert smart-art graphic
  • Insert chart, hyperlink
  • Bookmark, header, footer
  • Page number, text box
  • Word art, drop cap
  • Date& time, object
  • Symbol, autocorrect

3) Page layout menu

  • Theme fonts, margins
  • Page orientation, page size
  • Columns
  • Breaks, line numbers
  • Watermark, page colour, page borders
  • Indent settings, paragraph spacing
  • Object position, text wrapping
  • Endnote, footnote

4) Mailings

  • Mail merge, letters, labels
  • Step by step mail merge wizard
  • Select & edit recipients lists
  • Insert merge field
  • Update labels, preview results
  • Finish & merge

5) Review

  • Spelling & grammar, research
  • Thesaurus, word count
  • New, edit, & delete comment
  • Track changes, accept & reject changes
  • Protect document, restrict formatting & editing

6) View

  • Print layout, full screen
  • Web layout, outline, draft
  • View rulers, gridlines, thumbnails
  • Zoom, one page, two pages, page width
  • New window, arrange all, split, view side by side,
  • Synchronous scrolling
  • 6.Switch windows, run macros
(MS Excel)

7) Home Menu

  • New, open, save, save as, print settings
  • Cut, copy,& paste
  • Format painter
  • Fill color, change font face
  • Bold, italic, underline
  • Font size, strikethrough
  • Subscript, superscript, font color
  • Customize border
  • Find, replace & select
  • Cell alignment, orientation, wrap text
  • Align text, merge & center, indents
  • Number format, percent, comma style
  • Increase & decrease decimal
  • Conditional formatting, format as table
  • Cell styles, insert, delete& format cells

8) Insert Menu

  • Pivot table, pivot chart, table
  • Picture, clip art, shapes, smart art
  • Column chart, hyperlink, text box
  • Header & footer, wordart, object, symbol
  • Page layout menu
  • Theme fonts, colors, fonts
  • Page margins, orientation, page size
  • Print area, page break, background
  • Page width, height & scale
  • Gridlines, headings, object selection
  • Bring to front, send to back, rotate

9) Formulas

  • Auto sum, average, max, min, count
  • If, sum if, today, now, upper, lower
  • Left, right, trim, true, false
  • Ceiling, mround, round down, roundup
  • Trace precedents, trace dependents
  • Show formula, evaluate formula, watch window

10) Data

  • Sort, filter, text to column
  • Remove duplicates, data validation
  • Consolidate, what if analysis
  • Goal seek, scenario manager
  • Subtotal, group, ungroup

11) Review

  • Spelling & grammar, research
  • Thesaurus, protect workbook
  • New, edit, & delete comment
  • Track changes, accept & reject changes
  • Protect sheet, restrict formatting & editing

12) View

  • Page layout, normal, full screen
  • Page break preview, custom views
  • View rulers, gridlines, formula bars
  • Headings, zoom, new window, arrange all, freeze
  • Panes, hide, unhide, split
  • Switch windows, macros
(MS Power Point)

13) Home Menu

  • New, open, save, save as, print settings
  • 2 Cut, copy,& paste, format painter
  • New slide, layout, delete
  • Bold, italic, underline
  • Font size, strikethrough, text shadow
  • Subscript, superscript
  • Clear formatting, change-case
  • Character spacing, font color
  • Bullets & numbering, text direction
  • Paragraph alignment, align text
  • Line spacing, columns
  • Shapes, arrange, quick styles
  • Shape fill, shape outline, shape effects
  • Find, replace & select

14) Insert Menu

  • table, picture, clip art, photo album
  • shapes, smart art, chart, hyperlink
  • action, text box, header & footer
  • word art, date & time, slide number
  • symbol, object, movie, sound

15) Design

  • Page setup, slide orientation
  • Slide design, colors, fonts, effects
  • Background styles, hide background graphics

16) Animation

  • Preview, animate, custom animation
  • Special effect, transition sound, transition speed

17) Slide Show

  • From beginning, from current slide
  • Custom slide show, setup slide show
  • Hide slide, rehearse timings, resolution

18) Review

  • Spelling, research, thesaurus, translate
  • New, edit & delete comment
  • Protect presentation

19) View

  • Normal, slide sorter, notes page
  • View rulers, gridlines, slide show
  • Zoom, fit to window, color ,gray scale
  • New window, arrange all,
  • Switch windows, formatting tools
Menu