MS OFFICE 2010

Who can learn this Course:

Individuals who want to take up office administration , desktop jobs , accounting

Pre Requisite:

Basic computer knowledge

End Objective:

· By the end of this course trainee will be able to create word documents using MS Office Word,

which Includes text, graphics and proper formatting. Participants will learn to use

advanced functions of Excel to improve productivity,

· Enhance spreadsheets with templates, charts, graphics, and formulas and streamline their

operational work. They will apply visual elements and advanced formulas to a worksheet

to display data in various formats.

· They will also learn how to automate common tasks, apply advanced analysis

techniques to more complex data sets, collaborate on worksheets with others,

and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

Course Duration: 40 Hours

 

MS WORD

EXPLORING THE MS-WORD INTERFACE

· Explore the User Interface

· Work with the Ribbon

· Work with Contextual Tabs

· Use the Word Galleries

· Customize the Word Interface

· Create Professional-Looking Content

EDITING TOOLS

· Using spell-check and grammar

· Using thesaurus

· Auto correct options

· Advance Search and Replace Text

FORMATTING DOCUMENTS

· Results-Oriented User Interface

· Simple Approach: Building Blocks

· Find and Replace Text Formatting

· Add Special Effects to Text

· Faster formatting text using quick styles

· Paragraph alignment

· Setting indents

· Paragraph and line spacing

· Bullets and numbering

· Multilevel bullets

· Borders and shading

· Format painter

· Tab setting

· Adding drop cap

TABLES

· Creating tables

· Deleting and inserting rows and columns

· Sorting tables

· Formulas in tables

· Updating formulas

· Add Equations in a Table

· Using Quick Tables Styles

ADVANCE FORMATTING FEATURES

· Modify existing styles

· Creating own styles

· Copying styles

· Create, Insert and Modify Building Blocks

· Working with multiple columns

WORKING WITH LARGE DOCUMENTS

· Inserting Headers and Footers

· Inserting Page numbers

· Control Text Flow between Text Boxes

· Creating and modifying table of contents

· Inserting section breaks

· Adding bookmarks to existing document

· Adding footnotes and endnotes

· Inserting Columns

· Adding Hyperlinks

MAIL MERGE

· Performing mail merge on existing documents

· Using Word documents to create data sources

· Using query option with mail merge

· Using envelopes and labels options

· Use Word to Create a Data Source

PROTECTING AND SHARE DOCUMENTS

· Track Changes as you Edit

· Merge Document Changes

· Review Track Changes and Comments

· Protecting documents with passwords

USING MICROSOFT WORD WITH OTHER PROGRAMS

· Saving Word documents in a different formats

· Save as PDF or XPS

· Linking Word documents to Excel worksheets

·

MS EXCEL 2010

INTRODUCTION TO EXCEL 2010

· Quick Access toolbar

· Tabs and Groups

· Contextual tabs

REFERENCES

· Absolute

· Mixed

· Relative

WORKING WITH IF FUNCTION

· IF function

· IF with AND

· IF with OR

· IF with DATE

· IF with NOT

· Nested IF

WORKING WITH VLOOKUP FUNCTION

· VLOOKUP with TRUE

· VLOOKUP with FALSE

APPLYING VALIDATION TO ALLOW CORRECT DATA

· Validation for cell

· Validation for range

LIMITATION OF USING VLOOKUP

· Working with INDEX and MATCH

WORKING WITH PROTECTION

· Lock Cells

· Hide Formula

TEMPLATES

SORT

· Quick

· Custom

FILTER

· Auto

· Advanced

SUBTOTALS

· Single

· Multiple

PIVOT TABLE WITH TECHNIQUES AND TIPS

· Show value as

· Layout

· Grouping

· Report filter

· Pivot charts

WORKING WITH FUNCTIONS

· Date functions

· Text functions

· Database functions

· Financial functions

·

ANALYSIS TOOLS

· Goal seek

· Data table

CONDITIONAL FORMAT

· Cell

· Row

· Formula

CONSOLIDATE AND TEXT TO COLUMN

MACROS

· Recording simple macros

· Understanding relative and absolute reference

· Editing and modifying existing macros

· Writing macros using vba editor

 

 

MS POWERPOINT 2010

GETTING STARTED

· Introduction to PowerPoint

· Navigating through a presentation

· Different views in PowerPoint (Normal, Sorter, Outline, Notes Page, Slide Show)

· Create new presentation

· Saving, opening, and closing presentations

· Apply customization options

LAYOUTS

· Using title slide / different slide layouts

· Creating and formatting tables

· Creating chart

· Editing elements of chart

· Create a professional diagram using Smart Art

· Insert a table from Microsoft word

· Paste a chart from Microsoft excel

·

SLIDE FORMATTING

· Paragraph alignment

· Line spacing

· Bullets and numbering

· Customize bullets and numbering

· Format painter

· Replacing fonts

· Working with themes

· Slide colour schemes

· Background colours

· Working with header and footers

TEXT FORMATTING

· Enter text

· Edit text

· Apply character formatting

· Apply text formatting

· Format placeholder

SPECIAL EFFECTS

· Applying preset animation/animation scheme for slides

· Custom animations

· Graphic effects

· Smart art tool

· Live previews

· Slide transitions

· Rehearse timing for slides

· Working with media files

THE DRAWING TOOLBAR

· Using textboxes

· Using WordArt

· Insert clip art, diagram and draw shapes

· Line and Fill Colour

· Using AutoShapes

· Applying 3-D effects to objects

· Object alignment and rotation

· Grouping and ungrouping

CUSTOM DESIGN TEMPLATES

· Designing layout for templates

· Creating custom colour schemes

· Side master and title master

· Adding a logo and custom bullets in slide master

· Saving custom design templates

· Customize slide layout

DELIVERING PRESENTATIONS

· Create speaker notes

· Print and package a presentation

· Using the action button

· Working with hyperlinks using Word, Excel, and Internet

· Delivering presentations using custom show

· Saving a PowerPoint Presentation with different extension