CALL NOW!
855.520.6806
  • TRAINING PROGRAMS
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN

Microsoft Office Specialist 2010 (MOS) Certification Training

College of Staten Island - CUNY

Enroll Now!

Have More Questions?
855.520.6806
Career Training Program
Program Code: GES906
Hours: 380
Fees: $1995.00 USD

Overview

MOS

Learn basic to advanced skills in Microsoft Word, Excel, PowerPoint, Outlook, and Access 2010, while you prepare for certification. You will discover how to create and format documents, use tables, complete a mail merge, and more. This online certificate program is offered in partnership with major colleges, universities, and other accredited education providers.

Objectives

Upon successful completion of the Microsoft Office Specialist 2010 Program, you should be able to use the Microsoft Office suite of software effectively and knowledgeably. Each program and the skills you will learn are listed below:

Certification Exam 77-881: MOS: Microsoft Office Word 2010 Or

Microsoft Certification Exam 77-887: MOS: Microsoft Office Word 2010 Expert

  • Know how to create and customize documents
  • Learn to format content and control pagination
  • Become skilled in formatting illustrations, graphics, text, and text boxes
  • Understand how to use Quick Parts to organize content, modify tables, and merge documents
  • Know how to insert, modify, and delete comments
  • Learn to share and secure documents
  • Apply, create, remove and modify Styles on text, shapes, and pictures

Microsoft Certification Exam 77-882: MOS: Microsoft Office Excel 2010 Core Or Microsoft Certification Exam 77-888: MOS: Microsoft Office Excel 2010 Expert

  • Be able to enter, copy, paste, and fill data and formulas
  • Link worksheets, consolidate data, and calculate revenue from several worksheets
  • Understand how to use the PivotTable and PivotCharts to automatically format and analyze data
  • Know how to filter and outline data
  • Be able to use the VLookup and HLookup function
  • Save, send, and share workbooks
  • Insert and modify Charts, Sparklines, pictures, SmartArt, and shapes.
  • Apply QuickStyles to Charts, pictures, SmartArt, and Tables
  • Create and modify a Table

Certification Exam 77-883: MOS: Microsoft Office PowerPoint 2010

  • Know how to create and customize presentations
  • Learn to format content
  • Become skilled in formatting illustrations, graphics, text, and text boxes
  • Apply Animation and Transitions
  • Know how to insert and modify multimedia
  • Learn to share and secure presentations
  • Apply, create, remove and modify Styles on text, shapes, and pictures

Certification Exam 77-884: MOS: Microsoft Office Outlook 2010

  • Know how to create and customize messages
  • Learn to create, track and respond to messages automatically
  • Organize the Inbox with Rules and Quick Steps
  • Record and schedule appointments in the calendar
  • Learn to create, track and respond to meeting requests
  • Document Contacts, and Tasks Journal Entries
  • Manage Outlook E-mail accounts, data files and backup

Certification Exam 77-885: MOS: Microsoft Office Access 2010

  • Create and Manage databases
  • Create Tables, add Fields and specify the Data Type
  • Create Forms with a Wizard, Quick Parts and in Design View
  • Create Forms for data entry as well as list view
  • Use Queries to combine Fields, Group, Sort and Total
  • Create Reports and format the content, Header, Footer and layout
  • Manage and maintain an Access database
  • Create a strategy for archiving data with Action Queries

Contact Us

Submit