Skip to main content

Pellissippi HOME | Library Site A-Z

Microsoft Office Training: Study Guides & Tutorials

Information about Microsoft Imagine Academy: online training, access, and certification.

Exam Format

About the MOS Exam

Pass with 700/1000 points to obtain certification. Scores appear immediately after the exam, and a certificate will be emailed to you.

Exam Format

50 minutes to complete a series of tasks in a Microsoft Office simulation.

Accommodations

An accommodation request form may be submitted at the link below. The form must be submitted with documentation of a disability. Review of the request may take 10-14 business days, so please submit as early as possible.

LinkedIn Learning/Lynda.com Training

Cert Prep: Word 2016 Microsoft Office Specialist (77-725)

This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Microsoft Office Specialist (MOS) exam for Word 2016, which focuses on creating and managing documents, formatting text in paragraphs and sections, creating tables and lists, creating and managing references, and inserting graphic elements.

The course begins with an overview of the MOS certification program and how to prepare for the exam. Next, Jennifer walks you through all of the certification objectives, facilitating the ability to gain hands-on experience with downloadable sample documents. She wraps up with a full-length practice test that emulates exam 77-725, together with solutions to each of the exam challenges.

Topics include:
  • Creating and managing documents, styles, and properties
  • Formatting text
  • Creating tables and lists
  • Creating and managing references
  • Inserting and formatting graphic elements

Cert Prep: Word 2016 Microsoft Office Expert (77-726)

This course, created by Microsoft Certified Trainer Jennifer McBee, helps test-takers prepare for the 2016 Expert exam, which focuses on four main areas: managing document options and settings, designing advanced documents with sections and built-in styles, creating advanced references such as footnotes, and creating custom Word elements.

The course begins with an overview of the certification program and its costs. It then walks test-takers through all of the certification objectives, including hands-on experience with downloadable sample documents so viewers can practice as they go. The course concludes with a full-length practice test that emulates the Word 2016 MOS Expert exam, together with solutions to each of the exam challenges.

Topics include:
  • Preparing for the test
  • Reviewing the exam format and objectives
  • Modifying templates
  • Copying styles, macros, and building blocks
  • Comparing and combining documents
  • Tracking changes
  • Designing advanced documents
  • Linking text boxes
  • Modifying styles
  • Creating advanced references
  • Creating mail merge documents
  • Creating custom elements such as Quick Parts and style sets

Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Microsoft Office Specialist (MOS) exam for Excel 2016, which focuses on creating and managing worksheets and workbooks, managing data cells and ranges, creating tables, performing operations with formulas and functions, and creating charts and objects.

The course begins with an overview of the certification program and how to prepare for the exam. Next, Jennifer walks you through all the certification objectives. Throughout the course, she provides you with opportunities for hands-on practice with exercises and chapter challenges, and wraps up with a full-length practice test that emulates exam 77-727.

Topics include:
  • Creating and managing worksheets and workbooks
  • Managing data cells and ranges
  • Creating tables
  • Performing operations with formulas and functions
  • Creating charts and objects

Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

This course, created by Microsoft Certified Trainer Jennifer McBee, helps you prepare for the Microsoft Office Specialist (MOS) Expert exam for Excel 2016, which focuses on managing workbook options and settings, applying custom data formats and layouts, creating advanced formulas, and creating advanced charts and tables.

The course begins with an overview of the certification program and its costs. Next, Jennifer walks you through all of the certification objectives, including hands-on experience with downloadable sample documents. She wraps up with a full-length practice test that emulates exam 77-728, together with solutions to each of the exam challenges.

Topics include:
  • Managing workbooks
  • Referencing data in another workbook
  • Protecting worksheets and workbooks
  • Creating custom formats
  • Creating custom styles and themes
  • Creating advanced formulas
  • Defining named ranges and objects
  • Crafting advanced charts and tables

Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

This course, created by Certified MOS Master Instructor Jennifer McBee, helps viewers prepare for exam 77-730, the Access 2016 MOS Certification Exam. Jennifer covers the five main areas of the exam: managing the Access environment, building tables, building forms, creating and managing queries, and designing reports.

The course begins with an overview of the certification program. Jennifer then walks you through all of the certification objectives. You can gain hands-on experience using the downloadable sample documents to practice as you follow along. The course concludes with a full-length practice test that emulates the Access 2016 MOS exam. Solutions are provided to each of the included challenges.

Topics include:
  • Creating and managing a database
  • Building tables
  • Creating queries
  • Creating forms
  • Creating reports

Cert Prep: PowerPoint 2016 Microsoft Office Specialist (77-729)

This course, created by certified MOS Master Instructor Megan Hoffman, prepares you for exam 77-729. She covers the five main areas of the PowerPoint 2016 MOS exam: creating and managing presentations; inserting and formatting text, shapes, and images; inserting tables, charts, SmartArt, and media; applying transitions and animations; and managing multiple presentations.

Megan begins with an overview of the certification program. She then walks through all of the certification objectives, and provides you with downloadable sample documents so you can get hands-on experience with each of the concepts as you go. The course concludes with a full-length practice test that emulates the PowerPoint 2016 MOS exam, together with solutions to each of the exam challenges.

Topics include:
  • Comparing the Microsoft Office Specialist certifications
  • Creating blank presentations
  • Formatting presentations with slide masters
  • Configuring and presenting slide shows
  • Inserting text, tables, charts, SmartArt, images, and media
  • Applying slide transitions
  • Animating slide content
  • Setting timing for transitions and animations
  • Merging content from multiple presentations
  • Finalizing presentations

Cert Prep: Outlook 2016 Microsoft Office Specialist (77-731)

In this course, certified MOS Master instructor Megan Hoffman helps you get ready for exam 77-731 by diving into the four main areas of the Outlook 2016 MOS exam: managing the Outlook environment for productivity, managing messages, managing schedules, and managing contacts and groups.

Megan begins with an overview of the certification program, and then walks through all of the certification objectives. As you review each topic, you can use downloadable sample documents to practice as you go. Megan wraps up the course with a full-length practice test that emulates the Outlook 2016 MOS exam, together with solutions to each of the exam challenges.

Topics include:
  • Comparing the Microsoft Office Specialist certifications
  • Reviewing the user interface
  • Customizing settings
  • Printing and saving information
  • Performing search operations in Outlook
  • Configuring mail settings
  • Automating messages
  • Creating messages
  • Formatting, organizing, and managing messages
  • Creating and managing calendars
  • Creating and organizing appointments, events, and meetings
  • Managing contacts and groups
Loading ...