MS Office

MS Excel

Course Contents

    • Workbooks.

    • Worksheets.

    • Clipboard, Font, Alignment, and styles

    • Columns and Rows

    • Cells, Formula bar, and address bar

    • Relative and absolute references

    • Name Ranges

    • Data Types

    • Enter, delete, and edit data.

    • Functions and formulas.

    • Charts and graphics.

    • Filter and sort table data.

    • Pivot tables and charts.

    • Import and export data.

    • Charts and Graphics

    • Analyze the Data

    • Text to Columns

    • Macros and the Web

    • Dashboard

    • XL Shortcut keys

Certification

    • Exam code 77-882 Excel 2010

MS PowerPoint

Course Contents

    • Add, Delete, and Insert Slides

    • Sections

    • PowerPoint Themes and Layout

    • Drawing and Grouping

    • PowerPoint File-options

    • Slide Outline and Notes

    • Applying Design Theme

    • Inserting Multimedia and Smartart

    • Inserting Picture and clipart

    • Inserting Chart and Table

    • Inserting shapes and Hyperlink

    • Inserting Header and Footer

    • Insetting Wordart and Textbox

    • Inserting Video and Audio

    • Screen capture

    • Photo Albums

    • Annotating Presentation

    • Narrations and record slide show

    • Background styles and Effects

    • Applying Animation and Transitions

    • Changing the Slide Master

    • Packaging presentation for CD

    • Function Keys

MS Word

Course Contents

    • Microsoft Word Basics

    • Word Options

    • Clipboard, Fonts, Paragraph, and Styles

    • Hidden characters

    • Format Documents

    • Page layout and Page Margins

    • Line and Paragraph spacing

    • Bullets and Numbering

    • Indentation, Tabs and Tables

    • Page Breaks and Book Marks

    • Text Objects

    • Headers and footers

    • Sort

    • Clip art, pictures, Shapes and SmartArt

    • Labels and Mail merge

    • Table of Contents

    • Footnotes and Endnotes

    • Citation and Bibliography

    • Track Changes

    • Templates and Columns

    • Document Inspector

    • Document Protection

    • Shortcut Keys

Certification

    • Exam Code 77-881 Word 2010