Mastery In MS Office

The course is designed to equip a student, common person, females who are self-employed to use MS Office tools for professional as well as day to day use. It provides theoretical background as well as in depth practical approach of MS Office.

Target Audience:

Graduate or Post Graduate in Arts, Commerce, Science andManagement Stream.

Syllabus:

• Module - 1   Word Processing
• Unit 1 : Introduction to MS Word
• Word Processing Basics
• Opening Word Processing Package
• Title Bar, Menu Bar
• Toolbars & Sidebar
• Creating a New Document
• Opening and Closing Documents
• Opening Documents
• Save and Save As
• Closing Document
• Using the Help
• Unit 2 : Printing of Document
• Page Setup
• Print Preview
• Printing of Documents
• PDF file and Saving a Document as PDF
• Unit 3 : Text Selection Methods and Formatting
• Document Creation
• Editing Text
• Text Selection
• Cut, Copy and Paste 3.4.5 Font, Color, Style and Size Selection
• Alignment of Text
• Undo & Redo
• AutoCorrect, Spelling & Grammar
• Find and Replace
• 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
• Shortcut Keys
• Module - 2   Working with Spreadsheet
• Unit 1 : Introduction of MS Excel
• 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 Spread sheet
• Opening and Closing
• Unit 2 : Working With Worksheets
• Manipulation of Cells & Worksheet
• Modifying / Editing Cell
• Formatting Cell (Font, Alignment, Style)
• Cut, Copy, Paste & Paste Special
• Changing Cell Height and width
• Inserting and Deleting Rows, Column
• AutoFill
• Unit 3 : Working with Formulas and Functions
• Formulas, Functions and Charts
• Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division)
• AutoSum
• Functions (Sum, Count, MAX, MIN, AVERAGE)
• Unit 4 : Pivot Tables & Data Validation
• Introduction to Pivot Tables
• Implementation of Pivot Tables
• V-Lookup, H-lookup
• Module - 3   Creating Presentations
• Unit 1 : Introduction of PowerPoint
• Creation of Presentation
• Creating a Presentation Using a Template
• Creating a Blank Presentation
• Inserting & Editing Text on Slides
• Inserting and Deleting Slides in a Presentation
• Saving a Presentation
• Manipulating Slides
• Unit 2 : Working with Presentation Slides
• Inserting Table
• Adding ClipArt Pictures
• Inserting Other Objects
• Resizing and Scaling an Object
• Presentation of Slides
• Choosing a Set Up for Presentation
• Running a Slide Show
• Transition and Slide Timings
• Automating a Slide Show
• Printing Slides and Handouts