MS OFFICE 2007-10

If you have any further question please feel free to contact with us 11AM to 8PM only business days.

ONLINE FREE OFFICE AUTOMATION COURSE 2007-10

Microsoft brings Office to everyone, at any spot ,all over the world .

at www.onlinediploma.pk

 

MS OFFICE 2007-10 course consist of 44 lessons. You must complete them all to get certificate.

OFFICE AUTOMATION (Course Outline)

(Version 2007-2010 and onward)

WORD PROCESSING

Ms-Word, Word processing, Manual and electronic Word processing.

Screen Layouts

Menus

Shortcut

Toolbars

Customization of Toolbars.

Title Bar, Status Bar, Scroll

Bars  and Rulers.

Working with files

Create, Open, Save, Rename and Close a document.

Working on  Multiple Documents.

Cut, Copy, Paste, Special Undo and Redo Operations.

Find Replace and go to Commands.

Text, Paragraph and Page Formatting.

Header and Footer.

Date and Time.

Bullets and Numbering.

Columns and Drop Caps.

Tabs and Margins.

Comments and Foot Notes.

Insert a picture and its Formatting.

Use of Spelling and Grammar Check , Auto Correct Synonyms Theasurus.

Page Break Section Break and Background Printing.

Table of contents Glossary,

Hyperlink and Bookmark.

Insert a Table, Add,

Delete Columns Rows and

Cells.

Merge and Split Cells.

Formula Implementations.

Document Printing

Selection of a printer.

Printing Setting.

Print Preview.

Print and Page Setup.

Shortcut Keys.

MS- EXCEL

Basic Terminology of Ms- Excel

Creating, Opening, Renaming, Saving and Closing Workbook/ Spread Sheet.

Editing Functions: Undo, Redo. Fill, Auto Fill, Delete, Cut, Copy, Paste, Clear, Find and Replace.

Inserting: Header & Footer Cells Rows / Columns and Worksheet.

Working with Formulas: Entering Formula with the help of Formula Bar Entering Formula.

Directly into the cells, sue of Arithmetic and Logical Formulas.

Use of Built- in functions Time and Date Concatenation, Sum if, Nested Max, Min.

Average, Count, Now, Month, Day, Year Upper , Lower, Left & Right.

Tools and Date: Spell Check, Auto Correction, Workbook protection Data Sorting and filtering.

Formatting Cells and Text, Borders and Shading, Positioning Cells and Text, Auto Format.

Categories, of numbers, Cell / Range Referencing, Alignment, Date & Time Working With Charts, Creating Editing and Formatting of various types of Charts.

Printing: Selecting Printer, Print selected areas page selection.

Sorter View.

POWER POINT

Define Power Point?

PRESENTAION.

Power point presentation environment

View icon of Power Point,

Start Power Point, Open a Presentation,

Creating a new presentation using

MS- Power point by

Creating By Design Template.

Creating By Blank Presentation.

What is slide?

Choose an Auto Layout, Using Auto Layout.

Editing and Formatting a Text Box.

Choose a Common Text Tool in the

Formatting Tool Bar.

Apply design Template.

Set Background & Layout of Slides.

Adding Pictures and Graphics in a slide.

Apply Custom Animation.

Apply present animation.

Apply Action Setting.

Adding Sound to an Animation.

Add Sound and Music effects

to the presentation.

14. Set view Options

Normal View

Outline View

Slide View

Sorter View

Notes Page View

Slide Show

Slides Show Off

Important Short cut keys


Sponsored Links

Certificate Sample

TOPPER STUDENTS OF LAST MONTH

These are the students which completed course with extraordinary Marks.