Microsoft Office Suite

The Microsoft Office Suite is a package of office productivity software released by Microsoft and is available for Microsoft Windows and Macintosh operating systems.

This course provides an overview of Microsoft applications including Windows, the Office Suite: Word, PowerPoint, Excel, Access and Outlook.

 

One of the most widely used office suites is Microsoft Office. This includes Word, Excel, PowerPoint, and Access. Originally developed for the Windows operating system, this office suite also has a version for Mac OS. Open Office by Apache is a free and open source office suite.

 

Course Outlines

 

  • MS Word

    Module 1: Text Basics

    • Typing the text, Alignment of text
    • Editing Text: Cut, Copy, Paste, Select All, Clear
    • Find & Replace

    Module 2: Text Formatting and saving file

    • New, Open, Close, Save, Save As
    • Formatting Text: Font Size, Font Style
    • Font Color, Use the Bold, Italic, and Underline
    • Change the Text Case
    • Line spacing, Paragraph spacing
    • Shading text and paragraph
    • Working with Tabs and Indents

    Module 3: Working with Objects

    • Shapes, Clipart and Picture, Word Art, Smart Art
    • Columns and Orderings – To Add Columns to a Document
    • Change the Order of Objects
    • Page Number, Date & Time
    • Inserting Text boxes
    • Inserting Word art
    • Inserting symbols
    • Inserting Chart

    Module 4: Header & Footers

    • Inserting custom Header and Footer
    • Inserting objects in the header and footer
    • Add section break to a document

    Module 5: Working with bullets and numbered lists

    • Multilevel numbering and Bulleting
    • Creating List
    • Customizing List style
    • Page bordering
    • Page background

    Module 6: Tables

    • Working with Tables, Table Formatting
    • Table Styles
    • Alignment option
    • Merge and split option

    Module 7: Styles and Content

    • Using Build- in Styles, Modifying Styles
    • Creating Styles, Creating a list style
    • Table of contents and references
    • Adding internal references
    • Adding a Footnote
    • Adding Endnote

    Module 8: Sharing and Maintaining Document

    • Changing Word Options
    • Changing the Proofing Tools
    • Managing Templates
    • Restricting Document Access
    • Using Protected View
    • Working with Templates
    • Managing Templates
    • Understanding building blocks

    Module 9: Proofing the document

    • Check Spelling As You Type.
    • Mark Grammar Errors As You Type.
    • Setting AutoCorrect Options

    Module 10: Printing

    • Page Setup, Setting margins
    • Print Preview, Print

    MS EXCEL

    Module 11: Introduction to Excel

    • Introduction to Excel interface
    • Understanding rows and columns, Naming Cells
    • Working with excel workbook and sheets

    Module 12:Formatting excel work book:

    • New, Open, Close, Save, Save As
    • Formatting Text: Font Size, Font Style
    • Font Color, Use the Bold, Italic, and Underline
    • Wrap text, Merge and Centre
    • Currency, Accounting and other formats
    • Modifying Columns, Rows & Cells

    Module 13: Perform Calculations with Functions

    • Creating Simple Formulas
    • Setting up your own formula
    • Date and Time Functions, Financial Functions
    • Logical Functions, Lookup and Reference
    • Functions Mathematical Functions
    • Statistical Functions, Text Functions.

    Module 14: Sort and Filter Data with Excel

    • Sort and filtering data
    • Using number filter, Text filter
    • Custom filtering
    • Removing filters from columns
    • Conditional formatting

    Module 15: Create Effective Charts to Present Data Visually

    • Inserting Column, Pie chart etc.
    • Create an effective chart with Chart Tool
    • Design, Format, and Layout options
    • Adding chart title
    • Changing layouts
    • Chart styles
    • Editing chart data range
    • Editing data series
    • Changing chart

    MS POWERPOINT

    Module 16: Setting Up PowerPoint Environment:

    • New, Open, Close, Save, Save As
    • Typing the text, Alignment of text
    • Formatting Text: Font Size, Font Style
    • Font Color, Use the Bold, Italic, and Underline
    • Cut, Copy, Paste, Select All, Clear text
    • Find & Replace
    • Working with Tabs and Indents

    Module 17:Creating slides and applying themes

    • Inserting new slide
    • Changing layout of slides
    • Duplicating slides
    • Copying and pasting slide
    • Applying themes to the slide layout
    • Changing theme color
    • Slide background
    • Formatting slide background
    • Using slide views

    Module 18: Working with bullets and numbering

    • Multilevel numbering and Bulleting
    • Creating List
    • Page bordering
    • Page background
    • Aligning text
    • Text directions
    • Columns option

    Module 19: Working with Objects

    • Shapes, Clipart and Picture, Word Art, Smart Art
    • Change the Order of Objects
    • Inserting slide header and footer
    • Inserting Text boxes
    • Inserting shapes, using quick styles
    • Inserting Word art
    • Inserting symbols
    • Inserting Chart

    Module 20: Animation and Slide Transition

    • Default Animation, Custom Animation
    • Modify a Default or Custom Animation
    • Reorder Animation Using Transitions
    • Apply a Slide Transition, Modifying a
    • Transition, Advancing to the Next Slide

    Module 21: Slide show option

    • Start slide show
    • Start show from the current slide
    • Rehearse timing
    • Creating custom slide show

     

Duration: 1 week

 

Date:

Batch A: 6th – 10th May

 

Fee:  45,000.00

To register, fill the form below or call 08033146625