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

Administrative Professional with Microsoft Office Specialist 2007 Training

Union County College

Enroll Now!

Have More Questions?
855.520.6806
Career Training Program
Program Code: GES801
Hours: 480
Fees: $2395.00 USD

Overview

MOS

This Administrative Professional with Microsoft Office Specialist 2007 (MOS) Training Program will teach you the skills needed to become a successful administrative professional using the Microsoft Office 2007 suite of programs. You'll receive training on the most popular Microsoft Office 2007 programs, including Word, Excel, Access, PowerPoint, and Outlook, running on the Vista operating system. Upon successful completion of this program, you'll be prepared to take the MOS 2007 certification exam offered by Microsoft.

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 with Microsoft Office Specialist 2007 Training 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 section of the Administrative Professional with Microsoft Office Specialist Program, you should be able to use the Microsoft Office suite of software effectively and knowledgeably.  Each program and the skills you'll learn are listed below.

This program teaches the exam objectives for the following certification tests:

  • Exam 77-601:  Microsoft® Word 2007
  • Exam 77-602:  Microsoft® Excel 2007
  • Exam 77-603:  Microsoft® PowerPoint 2007
  • Exam 77-604:  Microsoft® Outlook 2007
  • Exam 77-605:  Microsoft® Access 2007

Microsoft Excel
You'll learn to:

  • Create a spreadsheet
  • Create formulas with the Function Wizard or manually
  • Audit equations and troubleshoot errors
  • Analyze data by using Sort, Filter, Subtotal, and PivotTables
  • Format spreadsheets, graphs, and lists for printing

Microsoft Word
You'll learn to:

  • Create a document
  • Format fonts, paragraphs, bullets, and tables
  • Use tables for online forms and Web page designs
  • Automate mail merges
  • Share documents with a workgroup

Microsoft PowerPoint
You'll learn to:

  • Create a slideshow
  • Format fonts, paragraphs, bullets, and text boxes
  • Use custom animation, slide transitions, and effects
  • Use graphics, sound, and on-screen navigation
  • Prepare a slideshow for live presentations and kiosk demonstrations

Microsoft Outlook
You'll learn to:

  • Use e-mail and Contacts, and work with attachments safely
  • Organize the Inbox and filter junk mail
  • Schedule meetings, recurring appointments, and tasks
  • Analyze Outlook data in Microsoft Excel or Access

Microsoft Access
You'll learn to:

  • Create tables, forms, and reports
  • Use queries to find, filter, update, and calculate
  • Create forms that handle data automatically
  • Optimize the database for easy navigation and data input

Contact Us

Submit