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