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

Administrative Professional with Microsoft Office Specialist 2010

Seattle Central Community College

Enroll Now!

Have More Questions?
855.520.6806
Career Training Program
Program Code: GES907
Hours: 460
Fees: $2395.00 USD

Overview

MOS

This unique program will teach you the skills you need to become a successful administrative professional. In addition, you will gain efficiency using the following Microsoft Office 2010 products: Word, Excel, PowerPoint, Outlook, and Access.

Learn business and administrative applications of the Microsoft 2010 suite, while you prepare for the Microsoft Office Specialist 2010 certification. Discover how to use the Microsoft Suite features to create and format documents, use tables, complete a mail merge, and more.

Microsoft Office Specialist 2010 is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Excel, Word, Power Point, Outlook, and Access 2010.

This online certificate program is offered in partnership with major colleges, universities, and other accredited education providers.

Objectives

Upon successful completion of the Administrative Professional portion of the Administrative Professional with Microsoft Office Specialist 2010 Program, you should be able to:

  • Determine major business challenges and provide possible solutions
  • Set clear business goals and make informed decisions
  • Demonstrate effective verbal, nonverbal, and written communication
  • Create and deliver business presentations using visuals
  • Develop and train staff on effective customer service skills
  • Describe types of computers, input and storage devices, and networks commonly found in businesses
  • Understand the importance of records management
  • Demonstrate efficient meeting management
  • Develop a clear career plan and advancement strategies

Upon successful completion of the Microsoft Office Specialist portion of the Administrative Professional with 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