Training‎ > ‎

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