OFFICE AUTOMATION (Course Outline)

Version 2007-2010 and onward

Word Processing

• Ms-Word, Word processing, Manual and electronic Word processing.
• Screen Layouts
• Menus
• Shortcut
• Toolbars
• Customization of Toolbars.
• Title Bar, Status Bar, Scroll
• Bars and Rulers.

Working with Files

• Create, Open, Save, Rename and Close a document.
• Working on Multiple Documents.
• Cut, Copy, Paste, Special Undo and Redo Operations.
• Find Replace and go to Commands.
• Text, Paragraph and Page Formatting.
• Header and Footer.
• Date and Time.
• Bullets and Numbering.
• Columns and Drop Caps.
• Tabs and Margins.
• Comments and Foot Notes.
• Insert a picture and its Formatting.
• Use of Spelling and Grammar Check , Auto Correct Synonyms Theasurus.
• Page Break Section Break and Background Printing.
• Table of contents Glossary,
• Hyperlink and Bookmark.
• Insert a Table, Add,
• Delete Columns Rows and
• Cells.
• Merge and Split Cells.
• Formula Implementations.

Document Printing

• Selection of a printer.
• Printing Setting.
• Print Preview.
• Print and Page Setup.
• Shortcut Keys.

MS- Excel

• Basic Terminology of Ms- Excel
• Creating, Opening, Renaming, Saving and Closing Workbook/ Spread Sheet.
• Editing Functions: Undo, Redo. Fill, Auto Fill, Delete, Cut, Copy, Paste, Clear, Find and Replace.
• Inserting: Header & Footer Cells Rows / Columns and Worksheet.
• Working with Formulas: Entering Formula with the help of Formula Bar Entering Formula.
• Directly into the cells, sue of Arithmetic and Logical Formulas.
• Use of Built- in functions Time and Date Concatenation, Sum if, Nested Max, Min.
• Average, Count, Now, Month, Day, Year Upper , Lower, Left & Right.
• Tools and Date: Spell Check, Auto Correction, Workbook protection Data Sorting and filtering.
• Formatting Cells and Text, Borders and Shading, Positioning Cells and Text, Auto Format.
• Categories, of numbers, Cell / Range Referencing, Alignment, Date & Time Working With Charts, Creating Editing and Formatting of various types of Charts.
• Printing: Selecting Printer, Print selected areas page selection.
• Sorter View.

Power Point

• Define Power Point
• PRESENTAION.
• Power point presentation environment
• View icon of Power Point,
• Start Power Point, Open a Presentation,
• Creating a new presentation using
• MS- Power point by
• Creating By Design Template.
• Creating By Blank Presentation.
• What is slide?
• Choose an Auto Layout, Using Auto Layout.
• Editing and Formatting a Text Box.
• Choose a Common Text Tool in the
• Formatting Tool Bar.
• Apply design Template.
• Set Background & Layout of Slides.
• Adding Pictures and Graphics in a slide.
• Apply Custom Animation.
• Apply present animation.
• Apply Action Setting.
• Adding Sound to an Animation.
• Add Sound and Music effects
• To the presentation.
• 14. Set view Options
• Normal View
• Outline View
• Slide View
• Sorter View
• Notes Page View
• Slide Show
• Slides Show Off
• Important Short cut keys