Microsoft Office 2010 Master Certification Training

Learn basic to advanced skills in Microsoft Word, Excel, PowerPoint, and Outlook 2010 while you prepare for Microsoft Office Specialist (MOS) Master certification. You’ll discover how to create and format documents, how to use tables, how to complete a mail merge, and more! Certification can help you differentiate yourself in today’s competitive job market, broaden your employment opportunities, garner greater earning potential, and advance in your current job.

Objective

Certification Exam 77-881: MOS: Microsoft Office Word 2010 OR 
Microsoft Certification Exam 77-887: MOS: Microsoft Office Word 2010 Expert
By completing the Microsoft Word 2010 Online Training Program, you’ll:

  • 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


Certification Exam 77-882: MOS: Microsoft Office Excel 2010 OR 
Microsoft Certification Exam 77-888: MOS: Microsoft Office Excel 2010 Expert
By completing the Microsoft Excel 2010 program, you’ll:

  • 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

By completing the Microsoft PowerPoint 2010 Online Training Program, you’ll:

  • 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
By completing the Microsoft Outlook Online Training Program, you’ll:

  • 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

Details

Learn basic to advanced skills in Microsoft Word, Excel, PowerPoint, and Outlook, while preparing for the Microsoft Office Specialist (MOS) Master certification.

Through this program, you can equip yourself for Microsoft Office Specialist (MOS) Master certification, the globally recognized standard for validating expertise with the Microsoft Office 2010 suite. Certification can help you differentiate yourself in today’s competitive job market, broaden your employment opportunities, garner greater earning potential, and advance in your current job.

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

In Word, you'll gain the skills you need to create and customize documents, format illustrations, and share and secure documents. In Excel, you’ll cover basic through advanced topics, including formatting cells, applying number formats, linking worksheets, creating a PivotTable, and more. In PowerPoint, you’ll discover how to create and format presentations, apply Transitions and animations, and set up presentations. In Outlook, you'll design and format E-mail, track and respond to messages, manage the Inbox with Rules and Quick Steps, and create appointments and tasks.

Many employers consider certification when determining who to hire. Certification can make the difference when you're seeking a new job or looking to advance in your career. Students who complete Microsoft Office Specialist training earn about 12% more than employees who aren’t certified, and 82% of students report getting a bonus upon receiving certification.

Microsoft Approved Courseware
When you use Approved Courseware for the Microsoft Office Specialist programs, 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 Microsoft Office 2010 Master certification training course approved by Microsoft.

Upon registering, you're given six months to complete this program.

 

  • Registration + Fees

    Begins: Open enrollment | REGISTER

    Course: OMOX800.03

    Tuition: $2,145

  • Outline

    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. Fancy Colors: Picture Tools
        6. First Prize: Shapes and SmartArt
        7. First Impressions: Create Business Stationery

    II. Intermediate Microsoft Word

        1. Rain Washes Out Hamburg: Make a Newsletter
        2. Open for Business: Building blocks and templates
        3. The Guests Are Invited: Create a Mail Merge
        4. Add Me to the List: Advanced Mail Merge and troubleshooting
        5. Charlotte’s Web Site: Create a Web Page
        6. Online All the Time: Word and the Internet

    III. Advanced Microsoft Word

        1. Table for Two: Advanced Table Functions
        2. The Table is Set: Quick Tables and Quick Styles for Tables
        3. Doing It With Style: Create Styles
        4. Going in Style: Headers and Footers, and References
        5. Who Done It? Create an On-Line Form
        6. Prepare to Share: Proofing Tools and Tack Changes
        7. Working with Macros: Create and use Macros

    IV. Beginning Guide to Microsoft Excel 2010

        1. Getting Started: How to use the online course
        2. Hello, Excel! Enter data and use basic text formatting
        3. It All Adds Up: enter data, labels and formulas
        4. A Question of Balance: Use and audit formulas from Excel’s formula library
        5. Charts and Chart Tools: Insert and modify Charts
        6. Picture the Data: Insert and format pictures
        7. Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change Views

    V. Intermediate Guide to Microsoft Excel 2010

        1. Legs, Eggs, and Pigs: Troubleshooting formulas and data
        2. Piggy Goes to Market: Use and modify TEXT formulas
        3. Name that Tune: Create, use and troubleshoot Named Ranges
        4. Sound Advice: Create and use Lookup Tables, use IF functions
        5. Excel In Print: Use page Layout and Page Set up to modify print settings
        6. Excel Online: Use and modify Sparklines and hyperlinks

    VI. Advanced Guide to Microsoft Excel 2010

        1. Works for Me! Create and modify Tables and apply Quick Styles
        2. Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools
        3. What Happened? (Pivot Tables) Create and modify Pivot Tables
        4. What Did You See (Pivot Charts) Create and modify Pivot Charts and Slicers
        5. Working Overtime: Create drop-down lists and use Data Validation
        6. Prepare to Share: Use reviewing tools and permissions
        7. Working with Macros: Create and use Macros

    VII. Beginning Microsoft PowerPoint

        1. Getting Started: How to use the online course
        2. P is for Paragraph: Entering text in presentations
        3. Working with Text Boxes: Formatting Shapes and Themes
        4. Picture, Picture: Formatting Pictures
        5. Shapes and SmartArt: Formatting and Using SmartArt
        6. Photo Albums and Views: Create a Photo Album

    VIII. Advanced Microsoft PowerPoint
        1. Tables and Spreadsheets: Adding and Using Tables
        2. Charts and Chart Tools: Adding and Formatting Charts
        3. Reach for the Starts: Slide Masters and Transitions
        4. Top Ten Reasons: Apply Animations
        5. Animating Multimedia: Adding and Formatting Videos
        6. Show Time: Delivering Presentations
        7. Prepare to Share: Proof and Protect Presentations
        8. Live! Online and in Print: Options for saving and sharing

    IX. Microsoft Outlook E-mail

        1. Getting Started: How to use the online course
        2. Hello, Outlook: Formatting Messages
        3. Messages and Messengers: Message Options
        4. From Me to You: Graphics, SmartArt and Attachments
        5. Signed, Seal and Delivered: Organize the Inbox with Rules and Quicksteps
        6. Contacts and Connections

    X. Working with the Calendar

        1. Eight Days a Week: Scheduling
        2. Tasks and Time Management

    XI. Sharing, Collaboration and Management
        1. Outlook Online
        2. Outlook in Print
        3. Advanced Options
        4. The Administrator: E-mail Accounts, Setup, Backup

  • Requirements

    This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with the Windows XP and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and e-mail account. You should also have the following full-retail version Microsoft Office 2010 Products already installed: Word, Excel, PowerPoint, and Outlook.

    It is recommended that you use the latest version of Internet Explorer in place of other Web browsers.

    Adobe Flash Player and Adobe Acrobat Reader are required for this program.

    Click here to download the Acrobat Reader.
    Click here to download the Flash Player.

    • ed2go will provide the required textbooks for this program
    • Beginning Guide to Microsoft® Word 2010
    • Intermediate Guide to Microsoft® Word 2010
    • Advanced Guide to Microsoft® Word 2010
    • Beginning Guide to Microsoft® Excel 2010
    • Intermediate Guide to Microsoft® Excel 2010
    • Advanced Guide to Microsoft® Excel 2010
    • Complete Guide to Microsoft® PowerPoint 2010 Complete Guide to Microsoft® Outlook 2010

    Prerequisites

    To enroll in the Microsoft Office 2010 Master Certification Training program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar. You should be able to manage files, including saving, updating, and backing up files.

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

  • Instructors

    Clair Dickinson 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 2010 Master Certification by passing the tests for Word, Excel, PowerPoint, and Outlook 2010. 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.

  • FAQs

    1. Can I register for programs if I am an international student?

    Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.

    2. How long does it take to complete a program?

    This program allows you 180 days after you register for completion.

    3. Do I have to buy additional materials?

    You must have the Microsoft Office 2010—Word, Excel, PowerPoint and Outlook—software already installed on your computer before taking this program. This course cannot be completed with the Microsoft Word 2010 Starter or Excel 2010 Starter, which comes free on new PCs. This course requires the full retail version of Word 2010 and Excel 2010. Otherwise, all the materials you’ll need are included, and their cost will be covered in your tuition. Ed2go will ship all materials ground service upon enrollment.

    4. Can I get financial assistance?

    ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses.

    5. What happens when I complete the program?

    Upon successful completion of the program, you will be awarded a certificate of completion.

    6. Am I guaranteed a job?

    ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don't provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.

    7. Who will be my instructor?

    Each student is paired up with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

    8. What software or hardware do I need in order to take online programs and what are the system requirements?

    In order to take our online programs, you must have access to a computer and the Internet. You can access the program contents from any Web-enabled computer. You don't have to use the same computer to log-in to the program every time. We recommend that you have a word-processing program (Microsoft Word is best) and the latest version of Internet Explorer.

    9. Can I use a Mac?

    No, you must access this program from a PC or IBM-compatible computer.

    10. How can I get more information about the program?

    If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button toward the top of the page). If you are visiting us during non-business hours, please feel free to send us a question using the "Contact Us" form to the right. You may also call us at 1-855-520-68061-855-520-6806 FREE. We will answer your questions promptly.

    11. When can I start the program?

    Our programs are all open enrollment. You can register and start the program as soon as you are ready.

    Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.

    12. What if I don't have enough time to complete my program within the time frame provided?

    The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee will be charged for an extension.

  • Reviews

    "I had a very helpful and encouraging facilitator. I really enjoyed taking this course from the comfort of my home on my schedule." 
- K.W., Odessa College