Module 1: Text Basics

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