Administrative Professional with Microsoft Office Specialist 2007 Training

Image for Administrative Professional with Microsoft Office Specialist 2007 Training

Take Your Career to the Next Level with Microsoft Office Specialist Certification from Gatlin International

See how a Course Works: Intro to Online Learning





Description

Microsoft Office Specialist Certification from Gatlin International

Our Microsoft Office Specialist Certification program makes learning more convenient and affordable than ever. Our MCAS program is 100% online and provides self-paced, instructor-led instruction.

MOS

Over 4.3 million secretaries and administrative assistants are employed in the United States, according to  statistics from the U.S. Bureau of Labor, making administrative professionals the largest segment of the office workforce! This online career training program will provide you with administrative professional training and will prepare you to become a Microsoft Office Specialist (MOS). MOS training will teach you how to use the new  Microsoft Office 2007 suite of programs (Word, Excel, Access, Outlook, and PowerPoint) on the Vista operating system.

Administrative professionals are handling a wider variety of duties beyond strictly clerical roles. Today's administrative professional often plans meetings and special events; works closely with vendors and suppliers; creates and gives presentations; interviews, orients, and supervises other staff; writes and edits documents; and more. This program will prepare you for all of the varied tasks you might encounter in a typical day.

About Microsoft Office Specialist certification training:
The Microsoft Office Specialist (MOS) Training Program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills in the Microsoft Office Suite.  This program provides computer-program literacy, measures proficiency, and identifies opportunities for skills enhancement. You will receive a certificate of completion from the college upon successfully  finishing this program. You'll then be well prepared to take the Microsoft Office Specialist 2007 Tests.

Students who complete Microsoft Office certification training earn more (about 12%) than employees who aren't certified. In addition, 82% of the students who become certified report getting a raise upon receiving their certification. The need for Microsoft Office training is vast—it's now a requirement in education, as well as in virtually all business, technical, and professional jobs.

How  to Become Microsoft Office Specialist Certified
To earn the Microsoft Office Specialist (MOS) certification you must pass one or more certification exams offered by Microsoft.

Standards and Alignment
The Microsoft Office Specialist Training program is aligned with the following standards:

  • MOS Microsoft Office Specialist Certification Requirements
  • ISTE NETS Standards for Teachers, Administrators, and Students
  • Michigan Grade Level Expectations and Benchmarks for 6th Grade Technology, Math, and Science

Note: You should have these Microsoft products already loaded on your computer in order to take this course: Word 2007, Excel 2007, Access 2007, Outlook 2007, and PowerPoint 2007. See the PC Requirements page  for more technical requirements.

Upon registering in the Microsoft Office Specialist certification programme, you're given an initial six months to complete the program. Should you need more time, you may request a six-month extension at no additional charge.

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.

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

Get the training you need to take your career to the next level with Microsoft Office Specialist certification training from Gatlin International.

Outline

  1. Administrative Professional
    1. The Dynamic Workplace
      1. The Workplace—Constantly Changing
      2. Workplace Team and Environment
      3. The Virtual Workplace
    2. Workforce Behaviors
      1. Your Professional Image
      2. Anger, Stress, and Time Management
      3. Ethical Theories and Behaviors
    3. Communication Essentials
      1. Written Communications
      2. Verbal Communication and Presentations
      3. Customer Service
    4. Technology Basics
      1. Technology Update
      2. Workplace Mail and Copying
      3. Telecommunications—Technology and Etiquette
    5. Records and Financial Management
      1. Managing Records
      2. Personal Finance
    6. Meetings and Travel
      1. Event Planning
      2. Travel Arrangements
    7. Career Advancement
      1. Job Search and Advancement
      2. Leadership
  2. Microsoft Certified Application Specialist Units
    1. Beginning Windows
      1. Format Text and Use Commands
      2. Beginning Hardware Troubleshooting
      3. File Management and Administration Features and Procedures
    2. Word
      1. Beginning
        1. Editing Functions
        2. Insert and Resize Pictures
        3. Time-stamp Documents
      2. Intermediate
        1. Create and Format Tables
        2. Use Mail Merge
        3. Save as Web Page
      3. Advanced
        1. Create and Modify Forms
        2. Protect the Document
    3. Excel
      1. Beginning
        1. Insert and Delete Rows and Columns
        2. Apply Number Format (Currency and Percent)
        3. Use Functions: Average and IF
      2. Intermediate
        1. Worksheets
        2. Absolute and Relative References
        3. Auditing Tool Bar
      3. Advanced
        1. Pivot tables
        2. Online Form With Drop-down Lists
        3. VLookup Function
    4. PowerPoint
      1. Beginning
        1. Create a Presentation From a Template or Wizard
        2. Work With Graphics and Text Boxes
        3. Animation Effects
      2. Advanced
        1. Sound Effects
        2. Import Slides From Other Programs
    5. Access
      1. Beginning
        1. Create Queries
        2. Use and Design Tables
        3. Write and Test Update Queries
      2. Intermediate
        1. Create Forms With Subforms
        2. Use Criteria and Parameters
        3. Sorting and Grouping
      3. Advanced
        1. Automate Data Entry
        2. Create Mail Merge
        3. Optimize a Database for Multiple Users
    6. Outlook
      1. Use Mail Features
      2. Create a Distribution List
      3. Work With Attachments
      4. Archive Messages
      5. Handle Junk Mail

Demo

Click here to view a demonstration of the Administrative Professional 2008 section of the program.

Click here to view a demonstration of the Microsoft Office Specialist 2007 Training section of the program.

Additional Info

Languages
English
Course Length
320.00 hours
Duration of Access

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. Most programs allow you 180 days after you register to complete them. If you need more time, extensions are

Instructor

Clair Dickinson earned her B.S. in secondary English at Eastern Michigan University in Ypsilanti, Michigan, and is certified to teach English and history at the high school level. She also met all of the standards for teaching with technology as outlined by COATT (Consortium for Outstanding Achievement in Teaching with Technology.) Clair is considered highly qualified to teach computer courses, including Microsoft Office 2003 and 2007, Windows XP, and Windows Vista.

Clair is currently working on a Master's degree in educational media and technology through Eastern Michigan University's online distance learning program. The program explores ways to infuse technology into the learning experience so that learning is interactive.

Elizabeth Ann Nofs is co-founder and the creative director for Comma Project, LLC. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

Elizabeth is the designer and developer of the Complete Computer Guide series. The teaching methodology incorporated into the guide series is a breakthrough in producing gender-balanced training with outstanding student completion, retention, and mastery rates.

Elizabeth has been a network administrator for many businesses as well as a Microsoft course instructor. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education. She has developed Microsoft Office solutions and databases since 1993.

She's the author of several books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), and The Complete Computer Guide (2005).

Elizabeth received her B.A. degree in Biology from the University of Michigan, Ann Arbor.

Prerequisites/Audience

The certification training is available to adult learners online in partnership with major colleges and universities. This program is for you if you're looking to improve your Microsoft Office computer skills and want to start a new career or advance your current one.

Requirements/Materials Included

This program is compatible with the Windows XP but students will need access to a system operating Windows Vista.

Your tuition includes the following textbooks:

  • Procedures & Theory for Administrative Professionals, 6th Edition
  • Beginning Guide to Microsoft Word 2007
  • Intermediate Guide to Microsoft Word 2007
  • Advanced Guide to Microsoft Word 2007
  • Beginning Guide to Microsoft Excel 2007
  • Intermediate Guide to Microsoft Excel 2007
  • Advanced Guide to Microsoft Excel 2007
  • Beginning Guide to Microsoft Access 2007
  • Intermediate Guide to Microsoft Access 2007
  • Advanced Guide to Microsoft Access 2007
  • Complete Guide to Microsoft PowerPoint 2007
  • Complete Guide to Microsoft Outlook 2007
  • Complete Guide to Microsoft Windows Vista

This course includes a 180-day free trial of Microsoft Office 2007 Professional and Microsoft Office 2007 CourseNotes from Course Technology.

You'll need the following Microsoft products already loaded on your computer: Windows Vista Business Edition and Word, Excel, Access, Outlook, and PowerPoint 2007.

Hardware requirements:

  • IBM-compatible (PC) computer
  • Processor: 1 GHz 32-bit (x86) or 64-bit (x64)
  • RAM: 1 GB of system memory
  • Hard Drive: 40 GB with at least 15 GB of available space
  • Video: Support for DirectX 9 graphics with
  • WDDM Driver
  • 128 MB of graphics memory
  • Pixel Shader 2.0 in hardware
  • 32 bits per pixel
  • DVD-ROM drive
  • Audio output

Adobe Flash Player and Adobe Acrobat Reader are required for this course.
Click here to download the Acrobat Reader.
Click here to download the Flash Player.

Internet connectivity:
You'll need Internet access. If your Internet service provider uses only dial-up, a minimum of 56K connection rate is recommended; however, high-speed access (cable or DSL) is preferred. This program cannot be taken on a Mac computer.

Certification

This program provides you with the training needed to pass the exam. Once you complete your online certification program, it's time to take your certification exam. Microsoft certification testing is administered by third-party vendors such as Prometric and Virtual University Enterprises (VUE), two leading providers of technology-based testing. Both offer a network of computer-based testing centers with thousands of locations worldwide.

For more information about Prometric, visit www.2test.com. For more information about VUE, visit www.vue.com.