What's the Curriculum of a Microsoft Office User Specialist Certification Program?

Get information about the Microsoft Office User Specialist (MOS) Certification. Learn about how this certification can help you find a new job or be more successful in your current position. Learn what options are available when it comes to test prep for the MOS Certifications Schools offering Computer Programming degrees can also be found in these popular choices.

Microsoft Office Certification Overview

Students enrolled in a MOS Certification program become proficient in various component applications of Microsoft Office - Word, Excel, Outlook, PowerPoint and Access. The curriculum varies depending on the application.

Important Facts About Microsoft Office Certification

Exam Topics Microsoft Office 2013, MS Office 2010, MS Office 2007
Test Prep Options Microsoft publishes several books designed to help students prepare for the MOS test, and Microsoft Learning Partners offer test prep classes that can be done in a classroom or online.
Potential Benefits MOS certification might lead to a pay increase or job promotion. For those who are searching for jobs, having a MOS can make a resume stand out.
Possible Careers Help Desk Technician, Technical Support Analyst, and Service Desk Representative
Median Salary (2018) $50,210 (Computer User Support Specialists)
Job Outlook (2016-2026) 11% growth (Computer Support Specialists)

Source: U.S. Bureau of Labor Statistics

Microsoft Word Curriculum

The Specialist Certification program for Microsoft Word covers a number of basic and more advanced skills. Students learn to create and format a document, including using the layout tools, organizing the content and customizing Word to personal specifications. Document preparation covers arranging paragraphs, manipulating text and using the pagination tools. Students also learn to insert and format graphics, including pictures, graphs and charts. The curriculum should also include organizational techniques, such as using tables, lists, references and captions. Courses also cover merging documents, using track changes and managing comments. Students also learn how to secure and share a document and include a digital signature.

Microsoft Excel Curriculum

The Specialist Certification program for Microsoft Excel covers formatting and manipulating data. Students learn basic skills, such as using the AutoFill feature, modifying cells and controlling worksheets. Formatting basics include inserting, deleting and modifying columns and rows and organizing data in tables. Courses cover manipulating data and text with formulas and subtotals. The curriculum may cover visual presentations and creating and organizing charts and illustrations. Students also learn to secure data or prepare it for sharing.

Microsoft PowerPoint Curriculum

The Specialist Certification program for Microsoft PowerPoint covers creating and customizing presentations through slides. Students learn about text boxes, links and animations. The curriculum covers SmartArt diagrams, illustrations, shapes, charts, tables and other content. Courses teach the best way to prepare an effective presentation.

Microsoft Outlook Curriculum

To prepare for Specialist Certification in Microsoft Outlook, students learn the basics of managing e-mails, such as signatures, automated messages, attachments, security settings and delivery options. Courses cover the scheduling and task tools in the software that teach students to create appointments, meetings, events and meeting requests, using the calendar tool. Students learn to manage contacts, using electronic business cards, distribution lists and the address book. The curriculum also includes organizational tools, such as organizing by color, filtering e-mail using rules, using the search function and customizing preferences.

Microsoft Access Curriculum

The Specialist Certification program for Microsoft Access teaches students to create and manage a database. Students learn to manage tables, field properties, forms and reports. The curriculum includes managing and navigating among records, manipulating and importing data and attaching documents to databases. Courses teach students to sort and filter data, make charts, export data and use database objects. Finally, students also learn how to manage a database using basic database operations.

To continue researching, browse degree options below for course curriculum, prerequisites and financial aid information. Or, learn more about the subject by reading the related articles below:

  • 1. Degree Options:
The schools in the listing below are not free and may include sponsored content but are popular choices among our users. Tuition and costs will vary across programs and locations. Be sure to always request tuition information before starting a program.

Popular Schools

  • Colorado State University Global

    Colorado State University Global responds quickly to information requests through this website.

    Popular programs at Colorado State University Global:

    • Certificates

    Online Programs Available

  • Walla Walla Community College

    Campus Locations:

    • Washington: Walla Walla
  • Valencia College

    Campus Locations:

    • Florida: Orlando
  • St Petersburg College

    Campus Locations:

    • Florida: Clearwater
  • Seminole State College of Florida

    Campus Locations:

    • Florida: Sanford
  • Sarasota County Technical Institute

    Campus Locations:

    • Florida: Sarasota
  • Santa Fe College

    Campus Locations:

    • Florida: Gainesville
  • Saint Johns River State College

    Campus Locations:

    • Florida: Palatka
  • Yavapai College

    Campus Locations:

    • Arizona: Prescott
  • Richland Community College

    Campus Locations:

    • Illinois: Decatur