• CATALOG
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN
University of Houston
Home > Training Programs > IT and Software Development > Administrative Professional with Microsoft Office Specialist 2010
CALL
NOW

855.520.6806

Fill out the form below

Close Window

Thank you for your interest in this program. We should be contacting you shortly.

Close Window

Administrative Professional with Microsoft Office Specialist 2010

online-training-microsoft-office-2010-specialist
$2,395.00 (USD)

OVERVIEW

OBJECTIVE

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

DETAILS

OUTLINE

REQUIREMENTS

PREREQUISITES

INSTRUCTOR

FAQS

University of Houston

102 CN Hilton Hotel - Conference Center
Continuing Education
Houston, TX 77204 US
MAIN CONTENT

Copyright © Education To Go. All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Education To Go. Education To Go and ed2go are registered trademarks of Education To Go, a part of Cengage Learning.