Microsoft 365 Apps certification preparation materials

Welcome to the Microsoft Office Specialist (MOS) Microsoft 365 Apps certification exam prep study guides. These exam prep study guides are for use by educators to help students practice and prepare for the MOS Microsoft 365 Apps certification exams. The study guides can be either educator or student-led and provide flexibility for both classroom and remote learning environments.

The study guides include hands-on projects to help students assess their readiness for each certification exam. These scenario-based projects consist of multiple real-world tasks that map to the certification exam objectives. Accompanying the projects is the Learning Directory, which allows students to research and practice specific concepts until mastery. Solution files are provided for educators to assess and remediate student progress.

See the statistics that validate that these certifications give learners the tools to build a brighter future and prepare themselves for a successful career: Microsoft Office Specialist Productivity Study.

Comprehensive educator resources

Each product exam prep resource contains:

Educator materials

• Introduction_Educator.docx – introduction and details for the educator
• Project_SolutionFiles – solutions in multiple formats for each project including:
  • Project_StepbyStepSolution.docx
  • Project_VideoStepbyStepSolution.pptx
  • Project_SolutionFile.docx

Student materials

• StudentStudyGuide_PDF.pdf – Introduction, Student projects, and Learning Directory compiled in one PDF file
• StudentStudyGuide_WordDocumentVersion – Student Study Guide PDF available as individual customizable Word documents
• Project_Files – supporting data and media files needed to complete projects

Microsoft Office Specialist (Microsoft 365 Apps) Exam release schedule

Microsoft Word (Microsoft 365 Apps)

This educator-led course helps prepare students for Exam MO-110: Microsoft Word (Microsoft 365 Apps). The course includes comprehensive student and educator materials with guidance for educators, and a series of student lessons, activities, and assessments. Based around a single business scenario, students learn how to apply the principal features of Word to specific tasks and real-world challenges helping them to understand the relevance, context, and connections to the power and usefulness of Microsoft Word. By building proficiency in Word, students can expand on their written communication skills, gain valuable insights into strategies for achieving clarity and impact, and create documents that clearly and effectively deliver their messages and ideas.

Course level: Beginner

Exam: Exam MO-110: Microsoft Word (Microsoft 365 Apps)

English downloads: Course materials

Microsoft Excel (Microsoft 365 Apps)

This educator-led course helps prepare students for Exam MO-210: Microsoft Excel (Microsoft 365 Apps). The course includes comprehensive student and educator materials with guidance for educators, and a series of student lessons, activities, and assessments. Based around a single business scenario, the course guides students through specific tasks and real-world challenges to help them understand the relevance, power, and usefulness of Microsoft Excel. By becoming proficient in Excel, students improve the ways they organize ideas and information, gain valuable insights into the ways they can filter and present data, and create spreadsheets that clearly and effectively deliver targeted data and computations.

Course level: Beginner

Exam: Exam MO-210: Microsoft Excel (Microsoft 365 Apps)

English downloads: Course materials

Microsoft Excel Expert (Microsoft 365 Apps)

This educator-led course helps prepare students for Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). The course includes comprehensive student and educator materials with guidance for educators, and a series of student lessons, activities, and assessments. By mastering advanced Excel capabilities, students optimize the ways they organize ideas and information and gain valuable insights into the ways they can filter and present data. Students create spreadsheets that deliver their targeted data and computations to their intended audiences in clearer and effective ways.

Course level: Intermediate

Exam: Exam MO 211: Microsoft Excel Expert (Microsoft 365 Apps)

English downloads: Course materials

Microsoft PowerPoint (Microsoft 365 Apps)

This educator-led course helps prepare students for Exam MO-310: Microsoft PowerPoint (Microsoft 365 Apps). The course includes comprehensive student and educator materials with guidance for educators, and a series of student lessons, activities, and assessments. Based around a single business scenario, students learn how to apply the principal features of PowerPoint to specific tasks and real-world challenges helping them to understand the relevance, context, and connections to the power and usefulness of Microsoft PowerPoint. By becoming adept at using PowerPoint features, students can expand their visual communication skills and gain valuable insights into the best ways to organize ideas on slides to maximize engagement and impact.

Course level: Beginner

Exam: MO-310: Microsoft PowerPoint (Microsoft 365 Apps)

English downloads: Course materials