Home > Training Programs > Microsoft > Microsoft Office Specialist (MOS) Expert Certification Training

phone Call Us: 855.520.6806

First name *

Attention Enter your first name.

Last name *

Attention Enter your last name.

Email *

Attention Enter your email.

Phone number *

Attention Enter your phone number.

Microsoft Office Specialist (MOS) Expert Certification Training

This in-depth course will prepare you to sit for and pass the Microsoft Office Specialist (MOS) certification exams for Word, Excel, PowerPoint, Access, and Outlook and earn your Microsoft Office Specialist (MOS) Expert Certification.

$2,395.00 (USD)

ENROLL NOW phone Call Us: 855.520.6806

schedule
                                335 Course Hrs
                            

                                Code
                                    GES890
                            
calendar_today
                                6 Months
                            
grid_onOpen enrollment
speedSelf paced

Have a question?We're here to help

REQUEST INFO

ENROLL NOW

phone Call Us:

855.520.6806

Overview

Objective

What you will learn

Master the crucial Microsoft Office suite skills: Word, Excel, PowerPoint, Access, and Outlook to enhance your productivity
Craft and refine Word documents with ease and precision
Create visually stunning Excel spreadsheets to make data analysis engaging
Design persuasive PowerPoint presentations to captivate audiences
Optimize database management and boost efficiency with Access
Streamline communication, scheduling, and collaboration using Outlook's powerful features

How you will benefit

Increased employability: Enhance your resume with the widely-recognized and in-demand Microsoft Office skills, making you more attractive to potential employers
Improved productivity: Streamline your daily tasks and processes by utilizing the various tools and features available in the Office suite
Enhanced communication: Craft professional and visually appealing documents, presentations, and emails to clearly convey your message to colleagues and clients
Data-driven decision-making: Leverage Excel's powerful data analysis capabilities to make informed decisions based on quantitative insights
Efficient collaboration: Utilize Outlook and other Office applications to seamlessly collaborate with team members, share documents, and keep everyone on the same page
Time-saving automation: Use Excel and Access to automate repetitive tasks, saving you valuable time and reducing the risk of manual errors
Customized solutions: Tailor PowerPoint presentations and Word documents to suit various audiences and purposes, adapting to the specific needs of your projects
Superior organization: Manage your schedule, tasks, and contacts effectively using Outlook's calendar and task management features, ensuring you stay on top of your commitments
Advanced reporting: Generate sophisticated reports and visualizations using Excel and Access to better understand your data and communicate your findings
Professional growth: Continuously develop your skills and stay relevant in the ever-evolving workplace by mastering the latest updates and features within the Microsoft Office suite

Outline

Introduction to Excel
1. Microsoft Office Basics
2. Creating a Microsoft Excel Workbook
3. The Ribbon
4. The Backstage View (The File Menu)
5. The Quick Access Toolbar
6. Entering Data in Microsoft Excel Worksheets
7. Formatting Microsoft Excel Worksheets
8. Editing Worksheets
9. Working with Rows and Columns
10. Using Formulas in Microsoft Excel
11. Finalizing Microsoft Excel Worksheets
12. Introduction to Excel Exam
Intermediate Excel
1. Common Functions
2. Working with Lists
3. Visualizing Your Data
4. Working with Tables
5. Advanced Formatting
6. Intermediate Excel Exam
Advanced Excel
1. Using PivotTables
2. Advanced Functions
3. Auditing Workbooks
4. Data Tools
5. Working with Others
6. Recording and Using Macros
7. Advanced Excel Exam
8. Final Excel Exam
Introduction to Word
1. Microsoft Office Basics
2. Creating a Microsoft Word Document
3. The Ribbon
4. The Quick Access Toolbar
5. Formatting Microsoft Word Documents
6. Editing Documents
7. Finalizing Microsoft Word Documents
8. Introduction to Word Exam
Intermediate Word
1. Advanced Formatting
2. Working with Tables
3. Working with Images
4. Page Layout
5. Working with Illustrations
6. Viewing Your Documents
7. Intermediate Word Exam
Advanced Word
1. Working with Long Documents
2. Reviewing and Collaborating on Documents
3. Comparing and Combining Documents
4. Forms
5. Managing Mailings
6. Protecting Documents
7. Macros
8. Advanced Word Exam
9. Final Word Exam
Introduction to PowerPoint
1. Microsoft Office Basics
2. Creating a Presentation
3. The Ribbon
4. The Quick Access Toolbar
5. Formatting Presentations
6. Working with Images
7. Working with Tables and Charts
8. Preparing and Presenting
9. Introduction to PowerPoint Exam
Advanced PowerPoint
1. Customizing Presentations
2. Presentation Masters
3. Working with Special Effects
4. Using SmartArt
5. Multimedia
6. Setting up the Slide Show
7. Outlines and Slides
8. Managing Multiple Presentations
9. Finalizing Presentations
10. Advanced PowerPoint Exam
11. Final PowerPoint Exam
Introduction to Microsoft Outlook
1. The Outlook Interface
2. Performing Popular Tasks in Outlook
3. Working with Messages
4. Working with the Calendar
5. Organizing Contacts
6. Introduction to Microsoft Outlook Exam
Advanced Microsoft Outlook
1. Working with Tasks and Notes
2. Using Signature and Themes
3. Managing Your Inbox
4. Working with Multiple Email Accounts
5. Advanced Microsoft Outlook Exam
6. Final Outlook Exam
Introduction to Access
1. Quick Overview of the Access User Interface
2. Fundamentals
3. Tables and Their Views
4. Tables
5. Queries
6. Forms
7. Reports
8. Introduction to Access Final Exam
Advanced Access
1. Relationships
2. Queries
3. Table Functions
4. Form
5. Reports
6. Macros
7. Completing the Desktop Application
8. Advanced Access Final Exam
9. Access Final Access Exam

Requirements

Prerequisites

Prerequisites:

There are no prerequisites to take this course. However, you should be comfortable using a personal computer and be familiar with operating Microsoft Office software.

Certification Requirements:

To earn a Microsoft Office Specialist Expert certification, you must complete the following requirements:

Earn a Microsoft Office Specialist Associate certification by passing three of the following Associate exams:
- For students using Microsoft Office 2019/2021:
  - MO-100: Microsoft Word
  - MO-200: Microsoft Excel
  - MO-300: Microsoft PowerPoint
  - MO-400: Microsoft Outlook
- For students using Microsoft Office 365:
  - MO-110: Microsoft Word
  - MO-210: Microsoft Excel
  - MO-310: Microsoft PowerPoint
  - MO-400: Microsoft Outlook
And pass any two of the following three Expert exams:
- For students using Microsoft Office 2019/2021:
  - MO-101: Microsoft Word Expert
  - MO-201: Microsoft Excel Expert
  - MO-500: Microsoft Access Expert
- For students using Microsoft Office 365:
  - MO-111: Microsoft Word Expert
  - MO-211: Microsoft Excel Expert
  - MO-500: Microsoft Access Expert

You've got questions.
We're here to help.

Our highly knowledgeable Enrollment Specialists will answer any questions you might have about the course and payment options.

REQUEST INFO

Instructor

FAQs

What is the MOS certification?

The Microsoft Office Specialist certification, or MOS certification, is the only globally recognized certification designed to validate your knowledge and expertise using the programs in the Microsoft Office Suite. Earning this certification shows employers that you are able to utilize the full functionality and features available within these office-productivity software programs resulting in increased productivity and confidence on the job.

Does this course prepare you for a certification?

Yes, you will be prepared for the Microsoft Office Specialist (MOS) certification exams: Word, Excel, PowerPoint, Outlook, and Access. To earn the Microsoft Office Specialist (MOS) Expert Certification, you must earn the Associate certification by completing three of the following exams:

For students using Microsoft Office 2019/2021: MO-100 (Word), MO-200 (Excel), MO-300 (PowerPoint), or MO-400 (Outlook)
For students using Microsoft Office 365: MO-110 (Word), MO-210 (Excel), MO-310 (PowerPoint), or MO-400 (Outlook)

And complete two of the following expert exams:

For students using Microsoft Office 2019/2021: MO-101 (Word Expert), MO-201 (Excel Expert), or MO-500 (Access Expert)
For students using Microsoft Office 365: MO-111 (Word Expert), MO-211 (Excel Expert), or MO-500 (Access Expert)

This course offers enrollment with or without vouchers. The vouchers are prepaid access to sit for a certifying exam of your choosing upon eligibility. Proctor fees may apply, which are not included.

How many exam vouchers will I receive with this course?

You will receive five exam vouchers with the voucher included version.

Can I register for a course if I am an international student?

Yes, ed2go courses are completely online. However, keep in mind that not all certifying bodies or industry-specific certifications are recognized internationally. Please review your country's regulations prior to enrolling in courses that prepare for certification.

When can I start the course?

This course is open enrollment, so you can register and start the course as soon as you are ready. Access to your course can take 24-48 business hours.

How long does it take to complete this course?

This course is self-paced and open enrollment, so you can start when you want and finish at your own pace. When you register, you'll receive six (6) months to complete the course.

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

The time allotted for course completion has been calculated based on the number of course hours. However, if you are unable to complete the course, contact the student advising team to see what options you may have available to work out a suitable completion date. Please note that an extension fee may be charged.

What kind of support will I receive?

The course instructor will be available by email to answer any questions and provide feedback on your performance. Occasionally, your course may be supported by a team of industry experts. You will also receive support from the student advising team.

What happens when I complete the course?

Upon successful completion of the course, you will be awarded a Certificate of Completion.

Am I guaranteed a job?

This course will provide you with the skills you need to obtain an entry-level position in most cases. Potential students should always do research on the job market in their area before registering.

Can I get financial assistance?

This course is non-credit, so it does not qualify for federal aid, FAFSA and Pell Grant. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements. Financing is available from select schools. Learn more about financial assistance.

How can I get more information about this course?

If you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the "Contact Us" form.