Microsoft Office 2016

(MOS-2016)/ISBN:978-1-61691-707-4

This course includes
Lessons
TestPrep
Lab

Here's what you will get

The Microsoft Office Specialist (MOS) 2016 certification exam has been designed to test a candidate's ability to use an Office application realistically. The MS Office 2016 exam task instructions do not include the command name, as in previous versions. Candidates of this exam must understand the purpose and common usage of the program functionality to complete the tasks in each project.

Lessons

49+ Lessons | 3+ Exercises | 265+ Quizzes | 301+ Flashcards | 301+ Glossary of terms

TestPrep

65+ Pre Assessment Questions | 2+ Full Length Tests | 80+ Post Assessment Questions | 160+ Practice Test Questions

Hand on lab

115+ LiveLab | 68+ Video tutorials | 12:57+ Hours

Video Lessons

98+ Videos | 03:48+ Hours

Here's what you will learn

Download Course Outline

Lessons 1: Taking Your First Steps with Word

  • Welcome to a New Word
  • The Office Look
  • Using the Word Start Screen
  • Touring the Word Screen
  • Exploring the File Tab
  • Undoing and Redoing Actions
  • Setting Word Options
  • Getting Help
  • Exiting Word
  • Summary

Lessons 2: Diving Into Document Creation

  • Creating a Blank File
  • Creating a File from a Template
  • Opening an Existing File
  • Saving and File Formats
  • Compatibility with Previous Versions of Word
  • Choosing the Right Word View for the Task at Hand
  • Printing a Document
  • Achieving Attractive Documents with Styles
  • Constructing Documents Faster with Outlining
  • Cleaning Up Content with AutoCorrect
  • Summary

Lessons 3: Working with Document Style and Content

  • Reviewing the Ways You Can Format Text in Word
  • Applying Character Formatting
  • Structuring Text with Paragraph Formatting
  • Setting Off Text with Paragraph Decoration
  • Using the Styles Group to Apply Styles
  • Checking Spelling and Grammar
  • Summary

Lessons 4: Cutting, Copying, and Pasting Using the Clipboard

  • Adding and Moving Document Content with Cut, Copy, and Paste
  • Managing Pasting Options
  • Searching with the Navigation Pane
  • Starting an Advanced Find from the Ribbon
  • Replacing Text via the Ribbon
  • Summary

Lessons 5: Cleaning Up with AutoCorrect and AutoFormat

  • Revisiting AutoCorrect
  • Using Quick Parts and Building Blocks
  • Inserting a Cover Page
  • Printing Envelopes and Labels Automatically
  • Printing an Envelope
  • Creating Labels
  • Creating PDF or XPS Output
  • Emailing a Document
  • Blogging
  • Summary

Lessons 6: Building Tables, Charts, and SmartArt to Show Data and Process

  • Getting a Quick Start with Quick Tables
  • Table Basics
  • Working with Table Layout and Design
  • Inserting SmartArt
  • Summary

Lessons 7: Adding Pictures and WordArt to Highlight Information

  • Inserting Pictures from a File
  • Adding an Online Picture
  • Pasting or Snapping a Picture
  • Manipulating Inserted Pictures (and Other Graphics)
  • Creating WordArt
  • Arranging Pictures and Other Objects
  • Summary

Lessons 8: Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

  • Adding a Drop Cap for Drama
  • Why Use Text Boxes?
  • Inserting a Text Box
  • Inserting a Shape
  • Adding a Basic Symbol
  • Inserting a Symbol from the Symbol Dialog Box
  • Summary

Lessons 9: Setting Up the Document with Sections, Headers/Footers, and Columns

  • Changing Basic Page Setup
  • Section Formatting
  • Headers and Footers Overview
  • Header and Footer Navigation and Design
  • Adding Header and Footer Material
  • Considering the Need for Columns
  • Changing the Number of Columns
  • Special Column Formatting
  • Summary

Lessons 10: Changing Other Page Features

  • Adding and Removing Page Borders
  • Formatting the Page Background
  • Applying Page Background Colors, Patterns, Textures, or Pictures
  • Adding a Watermark
  • Removing Watermarks and Page Backgrounds
  • Working More Effectively with Themes
  • Working with Bookmarks
  • Hyperlinks
  • Summary

Lessons 11: Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing

  • Automating Table of Contents Creation
  • Working with TOC Styles
  • Manually Creating a Table of Contents
  • Updating or Deleting a Table of Contents
  • Captions and Tables of Captioned Items
  • Indexing a Document
  • Footnotes and Endnotes Basics
  • Working with Footnote and Endnote Styling
  • Separators and Continuation
  • Making a Bibliography
  • Identifying the Sources for Your Bibliography
  • Editing Citations
  • Compiling the Citations into a Bibliography
  • Summary

Lessons 12: Data Documents and Mail Merge

  • Previewing the Mail Merge Process
  • Data Considerations
  • Reviewing Data File Formats
  • Choosing the Data Document Type
  • Attaching a Data Source
  • Assembling a Merge Document
  • Mail Merge Pane/Wizard
  • Summary

Lessons 13: Managing Document Security, Comments, and Tracked Changes

  • Protection Types
  • Comments and Tracked Changes
  • Accepting and Rejecting Changes
  • Summary

Lessons 14: Customizing the Quick Access Toolbar and Ribbon

  • The QAT?
  • Changing the Buttons on the Quick Access Toolbar
  • The Customize Quick Access Toolbar Dialog Box
  • Making Changes to the Ribbon
  • Importing and Exporting Ribbon Customizations
  • Summary

Lessons 15: Word Options and Settings

  • Opening Word Options
  • General
  • Display (and Printing)
  • Proofing
  • Save
  • Language
  • Advanced
  • Summary

Lessons 16: Macros: Recording, Editing, and Using Them

  • Displaying Macro Tools and Creating a Macro
  • Managing Macros
  • Understanding More about Macro Security
  • Macro Storage
  • Automatic Macros
  • Visual Basic for Applications: Quick and Dirty Answers
  • Summary

Appendix A

  • Certification Objectives Map

Lessons 18: A First Look at PowerPoint

  • Who Uses PowerPoint and Why?
  • Learning Your Way around PowerPoint
  • Changing the View
  • Zooming In and Out
  • Customizing the Quick Access Toolbar
  • Summary

Lessons 19: Creating and Saving Presentation Files

  • Starting a New Presentation
  • Saving Your Work
  • Setting Passwords for File Access
  • Summary

Lessons 20: Creating Slides and Text Boxes

  • Creating New Slides
  • Inserting Content from External Sources
  • Managing Slides
  • Using Content Placeholders
  • Creating Text Boxes Manually
  • Working with Text Boxes
  • Understanding Layouts and Themes
  • Changing a Slide's Layout
  • Applying a Theme
  • Managing Themes
  • Changing Colors, Fonts, and Effects
  • Changing the Background
  • Managing Slide Masters
  • Summary

Lessons 21: Formatting Text

  • Changing the Font
  • Changing the Font Size
  • Changing Font Color/Text Fill
  • Applying Text Attributes
  • Applying WordArt Styles
  • Applying Text Effects
  • Finding and Replacing Text
  • Correcting Your Spelling and Grammar
  • Using AutoCorrect to Fix Common Problems
  • Using the Research Tools
  • Summary

Lessons 22: Formatting Paragraphs and Text Boxes

  • Formatting Bulleted Lists
  • Formatting Numbered Lists
  • Formatting Text Boxes
  • Summary

Lessons 23: Creating and Formatting Tables

  • Creating a New Table
  • Moving around in a Table
  • Selecting Rows, Columns, and Cells
  • Editing a Table's Structure
  • Applying Table Styles
  • Formatting Table Cells
  • Summary

Lessons 24: Drawing and Formatting Objects

  • Working with the Drawing Tools
  • Understanding Object Formatting
  • Resizing Objects
  • Arranging Objects
  • Merging Shapes
  • Applying Shape or Picture Styles
  • Understanding Color Selection
  • Applying an Object Border
  • Applying an Object Fill
  • Applying Object Effects
  • Using Action Buttons
  • Summary

Lessons 25: Creating SmartArt Graphics

  • Understanding SmartArt Types and Their Uses
  • Inserting a SmartArt Graphic
  • Formatting a SmartArt Graphic
  • Inserting Clip Art
  • Inserting Photos
  • Sizing and Cropping Photos
  • Adjusting and Correcting Photos
  • Compressing Images
  • Creating a Photo Album Layout
  • Summary

Lessons 26: Working with Charts

  • Understanding the Parts of a Chart
  • Starting a New Chart
  • Working with Chart Data
  • Chart Types and Chart Layout Presets
  • Working with Chart Elements
  • Formatting a Chart
  • Summary

Lessons 27: Adding Sound Effects, Music, and Soundtracks

  • How PowerPoint Uses Audio
  • When to Use Sounds - and When Not To
  • Inserting an Audio Clip as an Icon on a Slide
  • Assigning a Sound to an Object
  • Configuring Sound Playback
  • Understanding Video Types
  • Placing a Video on a Slide
  • Changing the Video's Formatting
  • Specifying Playback Options
  • Summary

Lessons 28: Creating Animation Effects and Transitions

  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary

Lessons 29: Creating Support Materials

  • The When and How of Handouts
  • Creating Handouts
  • Summary

Lessons 30: Preparing for a Live Presentation

  • Starting and Ending a Show
  • Using the On-Screen Show Controls
  • Using the On-Screen Pen
  • Using Custom Shows
  • Creating and Using Sections
  • Recording Narration and Timings
  • Summary

Lessons 31: Sharing and Collaborating

  • Working with Comments
  • Comparing and Merging Presentations
  • Summary

Lessons 32: Getting Started With Outlook 2016

  • Navigate the Outlook Interface
  • Perform Basic Email Functions
  • Use Outlook Help
  • Summary

Lessons 33: Composing Messages

  • Create an Email Message
  • Check Spelling and Grammar
  • Format Message Content
  • Attach Files and Items
  • Enhance an Email Message
  • Manage Automatic Message Content
  • Summary

Lessons 34: Reading and Responding to Messages

  • Customize Reading Options
  • Work with Attachments
  • Manage Your Message Responses
  • Summary

Lessons 35: Managing Your Messages

  • Manage Messages Using Tags, Flags, and Commands
  • Organize Messages Using Folders
  • Summary

Lessons 36: Managing Your Calendar

  • View the Calendar
  • Manage Appointments
  • Manage Meetings
  • Print Your Calendar
  • Summary

Lessons 37: Managing Your Contacts

  • Create and Update Contacts
  • View and Organize Contacts
  • Summary

Lessons 38: Working With Tasks and Notes

  • Manage Tasks
  • Manage Notes
  • Summary

Lessons 39: Customizing the Outlook Environment

  • Customize the Outlook Interface
  • Create and Manage Quick Steps
  • Summary

Lessons 40: Configure Advanced Message Options

  • Insert Advanced Characters and Objects
  • Modify Message Settings, Properties, and Options
  • Use Automatic Replies
  • Summary

Lessons 41: Advanced Message Management

  • Sort Messages
  • Filter Messages
  • Organize Messages
  • Search Messages
  • Manage Junk Mail
  • Manage Your Mailbox
  • Summary

Lessons 42: Advanced Calendar Management

  • Manage Advanced Calendar Options
  • Manage Additional Calendars
  • Manage Meeting Responses
  • Summary

Lessons 43: Advanced Contact Management

  • Edit an Electronic Business Card
  • Manage Advanced Contacts Options
  • Forward Contacts
  • Export Contacts
  • Summary

Lessons 44: Managing Activities by Using Tasks and Journal Entries

  • Assign and Manage Tasks
  • Record and Modify Journal Entries
  • Summary

Lessons 45: Sharing Workspaces with Others

  • Delegate Access to Mail Folders
  • Share Your Calendar
  • Share Your Contacts
  • Summary

Lessons 46: Managing Outlook Data Files

  • Back Up Outlook Items
  • Change Data File Settings
  • Summary

Appendix A: Configuring Email Message Security Settings

  • Configure Email Message Security Settings

Appendix B: Microsoft Outlook 2016 Common Keyboard Shortcuts

Appendix C: Videos of Outlook 2016

Hands-on LAB Activities (Performance Labs)

Taking Your First Steps with Word

  • Using the Word Count Option
  • Exploring the File tab
  • Understanding undoing and redoing actions

Diving Into Document Creation

  • Understanding Inserting versus Overtyping
  • Creating a file from a template
  • Saving a Document
  • Identifying file formats
  • Zooming in the Document
  • Changing the Text to Bold

Working with Document Style and Content

  • Modifying the Font
  • Changing the Text Color
  • Showing Paragraph Marks and Zooming in the Document 
  • Increasing the Line Spacing
  • Creating a Signature Line
  • Inserting Page Breaks
  • Inserting Bullets
  • Changing the Heading Style

Cutting, Copying, and Pasting Using the Clipboard

  • Using the Cut and Paste Functions
  • Understanding the Navigation pane
  • Finding and Replacing the Text

Cleaning Up with AutoCorrect and AutoFormat

  • Revisiting AutoCorrect
  • Inserting a Cover Page
  • Printing an envelope

Building Tables, Charts, and SmartArt to Show Data and Process

  • Inserting a Table
  • Formatting the Table Border
  • Inserting Rows and Columns
  • Drag the table style option to its description.
  • Modifying the Table Design and Border
  • Inserting SmartArt

Adding Pictures and WordArt to Highlight Information

  • Inserting and Modifying the Picture
  • Inserting an Online Picture
  • Understanding resizing, rotating, and cropping
  • Inserting a WordArt

Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

  • Applying a Drop Cap
  • Inserting Symbols
  • Inserting a Shape
  • Drag the features of the Symbol dialog box to match them with their descriptions.

Setting Up the Document with Sections, Headers/Footers, and Columns

  • Changing the Basic Page Setup
  • Adding a Header
  • Inserting Page Numbers
  • Changing the Number of Columns and the Basic Page Setup
  • Breaking Content into Columns

Changing Other Page Features

  • Adding and Removing Page Borders
  • Adding the Page Color
  • Adding a Custom Text Watermark
  • Identifying shortcut for inserting bookmark

Data Documents and Mail Merge

  • Identifying Mail merge options
  • Identifying fields of the Rules feature

Managing Document Security, Comments, and Tracked Changes

  • Understanding Track Changes
  • Understanding Accept and Reject Changes

Customizing the Quick Access Toolbar and Ribbon

  • Understanding the Quick Access Toolbar

Word Options and Settings

  • Identifying formatting marks

Macros: Recording, Editing, and Using Them

  • Identifying Macro file formats

A First Look at PowerPoint

  • Identifying font dialog controls
  • Adding notes in MS PowerPoint 2016
  • Changing document view in MS PowerPoint 2016

Creating Slides and Text Boxes

  • Showing gridlines in MS PowerPoint 2016
  • Duplicating slide in MS PowerPoint 2016
  • Understanding Outline view
  • Understanding themes and template
  • Adding a layout in MS PowerPoint 2016
  • Applying themes in MS PowerPoint 2016

Formatting Text

  • Identifying text effects
  • Customizing AutoCorrect Options in MS PowerPoint 2016
  • Marking a document as final in MS PowerPoint 2016

Formatting Paragraphs and Text Boxes

  • Formatting bulleted lists
  • Setting fill transparency

Drawing and Formatting Objects

  • Aligning objects in MS PowerPoint 2016
  • Identifying merge operations
  • Inserting and formatting shapes in MS PowerPoint 2016
  • Understanding border attributes

Creating SmartArt Graphics

  • Inserting SmartArt and arranging picture position in MS PowerPoint 2016
  • Adding multiple screenshots in MS PowerPoint 2016
  • Applying artistic effects in MS PowerPoint 2016
  • Creating an album in MS PowerPoint 2016

Working with Charts

  • Understanding the parts of a chart
  • Identifying chart elements

Adding Sound Effects, Music, and Soundtracks

  • Inserting audio in MS PowerPoint 2016
  • Inserting a video in MS PowerPoint 2016

Creating Animation Effects and Transitions

  • Applying transition on the slide in MS PowerPoint 2016
  • Applying animation on images in MS PowerPoint 2016
  • Adding a motion path to an object
  • Applying animation on an online picture

Creating Support Materials

  • Customizing the handout master in MS PowerPoint 2016
  • Previewing the handout master in MS PowerPoint 2016

Preparing for a Live Presentation

  • Identifying shortcuts

Getting Started With Outlook 2016

  • Identifying Message Form tabs
  • Creating and Sending an Email
  • Deleting Email Messages

Composing Messages

  • Understanding AutoCorrect feature
  • Checking Spelling and Grammar in a Message
  • Identifying paste options
  • Attaching a File to a Message
  • Understanding SmartArt

Reading and Responding to Messages

  • Understanding reading options
  • Working with Attachments

Managing Your Messages

  • Using Flags to Manage Messages

Managing Your Calendar

  • Identifying the Calendar Grid Arrangement options
  • Responding to a Meeting Request
  • Printing a Calendar

Managing Your Contacts

  • Creating Contacts

Working With Tasks and Notes

  • Managing Notes

Customizing the Outlook Environment

  • Understanding Quick Steps

Configure Advanced Message Options

  • Understanding chart type
  • Modifying message settings

Advanced Message Management

  • Sorting Messages
  • Filtering Messages
  • Managing Junk Mail

Advanced Calendar Management

  • Managing Advanced Calendar Display Options

Advanced Contact Management

  • Editing an Electronic Business Card
  • Forwarding contacts
  • Exporting contacts

Sharing Workspaces with Others

  • Identifying share calendar options
  • Sharing Contacts

Managing Outlook Data Files

  • Changing Data File Settings

Exam FAQs

There are no technical prerequisites for the certification exam.

USD 100

The exam consists of performance based questions and is conducted in a live or simulated environment. 

The exam contains 40-60 questions.

90 minutes

The passing score varies from exam to exam and is provided on the score report.

Microsoft Office Specialist (MOS) exam retake policy

  1. If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.

For life