Msoffice

MS WORD
MS EXCEL

MS WORD COURSE CONTENT

Text Basics

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

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
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

Header & Footers

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

Working with bullets and numbered lists

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

Tables

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

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

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

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

Proofing the document

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

Printing

Page Setup, Setting margins
Print Preview, Print

MS EXCEL Course Content

Introduction to Excel

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

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

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

Sort and Filter Data with Excel

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

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

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

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.

Use Macros to Automate Tasks

Creating and Recording Macros
Assigning Macros to the work sheets
Saving Macro enabled workbook

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