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: Merging Documents

·      Typing new address list

·      Importing address list from Excel file

·      Write and insert field

·      Merging with outlook contact

·      Preview Result

·      Merging to envelopes

·      Merging to label

·      Setting rules for merges

·      Finish & Merge options

Module 9: 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 10: Proofing the document

·      Check Spelling As You Type.

·      Mark Grammar Errors As You Type.

·      Setting AutoCorrect Options

Module 11: Printing

·      Page Setup, Setting margins

·      Print Preview, Print

MS EXCEL

Module 12: Introduction to Excel

·      Introduction to Excel interface

·      Understanding rows and columns, Naming Cells

·      Working with excel workbook and sheets

Module 13: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 14: 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 15: Sort and Filter Data with Excel

·      Sort and filtering data

·      Using number filter, Text filter

·      Custom filtering

·      Removing filters from columns

·      Conditional formatting

Module 16: 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

Module 17: Analyze Data Using PivotTables and Pivot Charts

·       Understand PivotTables, Create a PivotTable

·       Framework Using the PivotTable and PivotChart

·       Create Pivot Chart from pivot Table.

·       Inserting slicer

·       Creating Calculated fields

Module 18: Protecting and Sharing the work book

·      Protecting a workbook with a password

·      Allow user to edit ranges

·      Track changes

·      Working with Comments

·      Insert Excel Objects and Charts in Word Document and Power point Presentation.

Module 19: Use Macros to Automate Tasks

·      Creating and Recording Macros

·      Assigning Macros to the work sheets

·      Saving Macro enabled workbook

Module 20: Proofing and Printing

·       Page setup, Setting print area, Print titles

·       Inserting custom Header and Footer

·       Inserting objects in the header and footer

·      Page Setup, Setting margins, Print Preview, Print

·      Enable back ground error checking

·      Setting AutoCorrect Options

MS POWERPOINT

Module 21: 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 22: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 23: Working with bullets and numbering

·      Multilevel numbering and Bulleting

·      Creating List

·      Page bordering

·      Page background

·      Aligning text

·      Text directions

·      Columns option

Module 24: 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 25: Hyperlinks and Action Buttons

·       Inserting Hyperlinks and Action Buttons

·       Edit Hyperlinks and Action Button

·       Word Art and Shapes