Blog

Microsoft-IT-Certifications

Getting Certified in Microsoft Office: Special Insights

Are you interested in earning a higher salary, Do you like being on the fast track to a possible new promotion? Are you attracted to the idea of earning recognition for your hard-earned knowledge and skills? Then a Microsoft Office Specialist (MOS) certification may be just right for you! It certainly would add something extra on your resume and set you apart from your coworkers or other job seekers.

This article will share some helpful insights into the certification process including describing the different levels of achievement available, the best methods to study and practice for the exams, practical tips from a recent completer (me!), and much more.

What is the Microsoft Office Specialist (MOS) certification?

The Microsoft Office Specialist (MOS) certification is for anyone looking to demonstrate proficiency in one or more Office programs. Exams for 2016 Microsoft Office are available in Word, Excel, PowerPoint, Access, and Outlook (SharePoint and OneNote are available for the 2013 version). Expert level certification is also available in Word and Excel. Furthermore, you can earn Master level certification by passing three required exams (Word Expert, Excel Expert, and PowerPoint) and then one of the elective exams (Access or Outlook).

Office-Specialist-Badge Expert-Badges Master-Office-Specialist

Where do I Take an Exam?

Certiport administers Microsoft Office Specialist exams. You can locate a testing center in your area by going to http://www.certiport.com/Locator.

What is the Exam Format?

Exams are primarily performance-based and conducted in a “live,” or simulated, environment. This creates a real-world testing experience for candidates. A candidate will complete several tasks that build on each other to develop projects. Candidates must understand the purpose and common usage of the program functionality in order to complete the tasks successfully in each of the projects. For example, a Word exam might ask a user to create a newspaper article using several design, layout, and formatting options. A typical exam consists of approximately 5 projects with approximately 5 tasks per project. These are timed exams and the typical amount of time allotted is 50 minutes.

When Will I Know My Results?

After you complete an exam, your results will display on your screen immediately, and you can print, if desired. A passing score is 700 out of 1000 points. The score report will also display a section-by-section analysis. Those who pass will receive by mail an official certificate within approximately two to three weeks. Digital badges to share on your social media profiles will be available almost immediately.

How do I Prepare to Insure Success?

The good news is that Centriq students who have completed any of the classes in Microsoft Office programs at the basic, intermediate, and advanced levels are well prepared to take and pass these exams. The books Centriq uses in all Microsoft Office classes include exercises and activities that tie directly to MOS exam objectives. For easy reference, an appendix in the back of each book lists each MOS objective tested and the corresponding activity or exercise.

Candidates can also consider purchasing practice tests at Gmetrix at https://gmetrix.com or study guides from Microsoft Press at https://www.microsoftpressstore.com. Another option is to connect with other candidates and engage in good conversations regarding the certification process by following Microsoft Learning’s Twitter feed at https://twitter.com/MSLearning.

Finally, just going to Microsoft Learning at https://www.microsoft.com/en-us/learning and reviewing the skills measured on the exam and making sure you can perform them (and if you can’t, study or use Help to learn) will pay big dividends in making sure you are prepared. Below is an example from the PowerPoint exam:

Microsoft-Office-Specialist

Some Practical Tips for Taking an Exam

  • Watch your time. Remember you only have 50 minutes to complete 5 projects so that is approximately 10 minutes per project. Furthermore, remember each project has approximately 5 tasks so that is approximately 2 minutes per task. Do not get stuck on a difficult question early on and run out of time at the end. Mark the question instead and return to it later after answering other, perhaps easier, questions. Knowing exactly how many questions you can miss and still pass can relieve some of the stress (usually no more than 6 or 7 total). Use any keyboard shortcuts available to you to help save time.
  • Read questions carefully and answer them even more carefully. Do not allow the time pressure affect your ability to understand completely what is being asked. Questions on Access queries and Excel functions/formulas are especially difficult to read and comprehend. Make sure you are completely clear on the steps you are going to take before jumping in to solve the task. Make sure you do not miss important distinctions when reading. In Excel for example, did the question state to use a function or a formula or select a column range or a table range? When typing your answers, a misplaced or missing comma, quote mark, or parentheses may mean the difference between getting the question right or wrong.

So there you have it, some basic facts and suggestions to help you pursue a Microsoft Office Specialist certification. Obviously, the extrinsic benefits (salary, promotion, recognition) are all well worth the time, effort, and cost. But the intrinsic benefits of self-confidence and pride that come by validating your expertise to yourself is just as important if not more important. Good luck in your endeavors!

More information at https://www.microsoft.com/en-us/learning/certification-overview-mos.aspx.

Craig Gerdes earned his Microsoft Office Specialist (MOS) Master certification in July 2017. He has taught Microsoft Office software to adult students in a variety of settings since 1989. Craig has a Master’s degree in Adult, Occupational, and Continuing Education.

Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 23, 2023
Jul 27, 2023
Eve
4/3/23-4/7/23
5/22/23-5/26/23
7/3/23-7/7/23
CSSP-V
Jan 30, 2023
May 5, 2023
Day
3/6/23-3/10/23
4/10/23-4/14/23
CSSP-V
Feb 6, 2023
May 19, 2023
Day
3/27/23-3/31/23
FSCP-V
Mar 20, 2023
Jun 23, 2023
Day
4/24/23-4/28/23
5/22/23-5/26/23
CSSP-V
Apr 10, 2023
Jul 28, 2023
Day
5/29/23-6/2/23
7/3/23-7/7/23
FSCP-V
Apr 24, 2023
Oct 19, 2023
Eve
7/3/23-7/7/23
8/21/23-8/25/23
CSSP-V
May 15, 2023
Dec 14, 2023
Eve
7/3/23-7/7/23
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Jun 5, 2023
Sep 8, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-V
Jun 19, 2023
Oct 6, 2023
Day
7/3/23-7/7/23
9/4/23-9/8/23
FSCP-V
Jul 24, 2023
Jan 25, 2024
Eve
10/2/23-10/6/23
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Aug 14, 2023
Nov 17, 2023
Day
9/5/23-9/8/23
10/16/23-10/2/23
CSSP-V
Aug 28, 2023
Dec 15, 2023
Day
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Oct 30, 2023
Feb 2, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Oct 30, 2023
May 2, 2024
Eve
11/20/23-11/23/23
3/4/23-3/7/23
CSSP-V
Nov 6, 2023
Mar 1, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
1/29/24-2/2/24
FSCP-V
If you don't see the Cohort Start date you are looking for don't forget to check out our campus calendars.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Feb 29, 2024
Mar 24, 2024
Day
3/25/24-3/29/24
4/22/24-4/26/24
CSSP-I
May 13, 2024
Aug 16, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Aug 19, 2024
Nov 22, 2024
Day
9/2/24-9/6/24
10/21/24-10/25/24
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 15, 2024
Apr 19, 2024
Day
2/19/24-2/23/24
3/18/24-3/22/24
CSSP-I
Feb 26, 2024
May 24, 2024
Day
4/1/24-4/5/24
CSSP-I
Apr 08, 2024
Jul 12, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
May 20, 2024
Aug 23, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Jun 24, 2024
Sep 27, 2024
Day
7/1/24-7/5/24
9/2/24-9/6/24
CSSP-I
Jul 29, 2024
Feb 6, 2025
Eve
9/2/24-9/5/24
11/25/24-11/28/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Aug 5, 2024
Nov 8, 2024
Day
9/2/24-9/6/24
10/7/24-10/11/24
CSSP-I
Sep 9, 2024
Dec 13, 2024
Day
10/14/24-10/18/24
11/25/24-11/29/24
CSSP-I
Oct 21, 2024
Jan 31, 2025
Day
11/25/24-11/29/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.