Microsoft Office Specialist 2007 MOS

Image for Microsoft Office Specialist 2007 MOS

Take Your Career to a New Level with Microsoft Certified Office Specialist Training from Gatlin International

See how a Course Works: Intro to Online Learning





Description

Microsoft Certified Office Specialist Training from Gatlin International

MOS

Microsoft Certified Office Specialist training from Gatlin International is ideal for both full-time students and busy working professionals looking to advance their careers. The Microsoft Office Specialist 2007 (MOS) program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Windows Vista and Microsoft Office 2007: Excel, Word, Power Point, Access, and Outlook.  MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2007 suite of programs.

Microsoft certified Office Specialist training can help you differentiate yourself in today's competitive job market, broaden your employment opportunities, and garner greater earning potential. Certification can also help you advance in your current job. Mastering more skills increases your effectiveness and efficiency. Research indicates that certified professionals are more confident and productive with Microsoft programs.

Many employers consider certification when determining who to hire. Certification can be the difference in whether or not you get a job or get a better job. Students who complete MOS certification training earn more (about 12% more) than employees who aren't certified. In addition, 82% of the students who get certified report getting a bonus upon receiving their certification.

Microsoft Approved Courseware
When you use Approved Courseware for the Microsoft Office Specialist programs to help prepare for Microsoft Office certification exams, you know you're using the very best study materials available.

In order for courseware to receive the Approved Courseware distinction, it must go through a rigorous review to ensure it meets the skill standards set forth by Microsoft. This is the first online MOS 2007 certification training course approved by Microsoft.

Upon successful completion of the Microsoft Office Specialist 2007 section of this program, you should be able to use the Microsoft Office suite of software effectively and knowledgeably. 

Upon successful completion of this program, students will be able to:

  • Create and Customize Documents
  • Format, Organize, Share and Secure Content
  • Work with Visual Content and Review Documents
  • Create and Manipulate Data
  • Format Data and Content
  • Create and Modify Formulas
  • Create and Format Presentations
  • Create and Format Slide Content
  • Collaborate on and Deliver Presentations
  • Manage Email Messaging
  • Manage Calendars, Tasks, Contacts, and Information
  • Structure and Maintain Databases
  • Enter and Modify Data
  • Create and Modify Queries

Enrolling in the Microsoft Certified Office Specialist training programme is convenient and 100% secure.

Outline

Microsoft Certified Office Specialist Training Outline

  1. I.         Beginning Microsoft Word
    1. Getting Started: How to use the online course
    2. Go Blue:  Formatting Text
    3. Horses and Zebras:  Formatting Pictures
    4. Mice and Men:  Mouse options and tools
    5. First Prize: Shapes and SmartArt
    6. First Impressions:  Create Business Stationery
  1. II.         Intermediate Microsoft Word
    1. Rain Washes Out Hamburg:  Make a Newsletter
    2. The Guests Are Invited:  Create A Mail Merge
    3. Charlotte’s Web Site:  Create a Web Page
  1. III.        Advanced Microsoft Word
    1. Table for Two:  Advanced Table Functions
    2. Doing It With Style:  Create Styles
    3. Who Done It?  Create an On-Line Form
  1. IV.       Beginning Guide to Microsoft Excel 2007
    1. Hello, Excel! Enter data and use basic text formatting
    2. It All Adds Up: enter data, labels and formulas
    3. A Question of Balance: Use and audit formulas from Excel’s formula library
  1. V.        Intermediate Guide to Microsoft Excel 2007
    1. The Table is Set: Create Format and sort a list
    2. Working Overtime: Use drop down lists and conditional formatting
    3. Legs, Eggs, and Pigs:  Troubleshooting formulas and data
  1. VI.       Advanced Guide to Microsoft Excel 2007
    1. Sounds Good to Me: Create formulas that calculate, compare, and format text
    2. Work Smarter, Not Harder:  Use Sort, Filter,  Outline, and Goal Seeking Tools
    3. What Happened? (Pivot Tables) Create and modify Pivot Tables
  1. VII.      Complete Guide to Microsoft PowerPoint
    1. Super Star: Introduction to PowerPoint text and content
    2. Reach for the Stars: Using and modifying a Slide Master
    3. Outstanding in your Field: SmartArt, Charts, and other content
    4. On the Road Again: preparing for presentation
    5. Picture This: Using Microsoft Explorer to display photos as a slide show
    6. Make it Digital: Scanners and Scanning options
  1. VIII.     Complete Guide to Microsoft Outlook
    1. Wait a Minute Mr. Postman: Email in Outlook
    2. Big Time: Outlook: customizing email with pictures and signatures
    3. Tracking my Promises: Using a calendar with appointments and tasks
    4. Save a Tree: Control printing
    5. When did that Happen: Advanced options and functions in Outlook
    6. Along Came a Spider: Viruses, phishing scams, and malware
  1. IX.       Beginning Access
    1. Getting Started: Welcome
    2. Now Playing: Data Entry and Data Tables
    3. Quiet on the Set: Form Design
    4. The Plot Thickens: Creating and Using Queries
    5. Intermission: Compact and Repair Databases
    6. Daily Reporter: Viewing and Sorting Record Sources
    7. Databases Come and Databases Go
  1. X.        Intermediate Access
    1. Editing the Screen Play: Tables and Subforms
    2. Meet the Stars: Create a Switchboard
    3. Designing for Users: manage databases and database properties
    4. Dress Rehearsal: Testing the Database
    5. Box Office Receipts: Modify form controls
    6. The Quest: Databases in gaming
  1. XI.       Advanced Access
    1. Independent Investigation: Create a Search Form
    2. Search and Research: Filter queries and use sub-queries
    3. The Producers: Create and modify reports and Mail Merges
    4. Performance Network: optimize your database and improve performance
    5. Rave Reviews: archive, import and export data

Additional Info

Languages
English
Course Length
380.00 hours
Duration of Access

You have 6 months to complete this course.

Instructor

Clair Dickson has a B.S. in Secondary English Education from Eastern Michigan University.  She currently works as an online course facilitator in a lab setting, working with students taking courses towards their high school diploma.  She also completed her Graduate Certificate in Educational Media and Technology through Eastern Michigan University Online, doing all of the work online. 

She earned the Microsoft Office 2007 Master certification by passing the tests for Word, Excel, PowerPoint, and Outlook 2007.  In addition, she has Microsoft Word 2003 Expert level certification.  She has used every version of Office since 1995 and still enjoys finding new ways to use the software.

In her spare time, Clair writes short crime stories and chases after her young son. 

Elizabeth Ann Nofs is the designer and developer of the Computer Mama guides.  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.

She’s the author of 44 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) and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training

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

Prerequisites/Audience

To enroll in this program, you should have basic computer skills and be comfortable using an Internet browser and selecting commands from a menu or toolbar.

This program is for you if you're an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft skills immediately. This program is also suitable for you if you're looking to learn about this software and expand your job possibilities.

Requirements/Materials Included

In order to take our online programs, you must have access to a computer and the Internet (high-speed Internet access is recommended).  You can access the program contents from any Web-enabled computer.

You will need the following Microsoft products already installed on your computer in order to take this program:  Word, Excel, PowerPoint and Outlook 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
  • 128 MB of graphics memory
  • DVD-ROM drive
  • Audio output
  • Adobe Acrobat Reader
  • Flash Player
Certification

This course is also an exam study guide for the following certification tests:

Exam 70:601: Using Microsoft Word 2007

Exam 70:602: Using Microsoft Excel 2007

Exam 70-603: Using Microsoft PowerPoint 2007

Exam 70-604: Using Microsoft Outlook 2007

Exam70-605: Using Microsoft Office Access 2007