Microsoft Office 2019

(MOS-2019)/ISBN:978-1-64459-303-5

This course includes
Lessons
TestPrep
Hand-on Lab
Instructor Led (Add-on)
AI Tutor (Add-on)

Gain the skills required to pass the Microsoft Office certification exam with the Microsoft Office 2019 course and lab. The lab is versatile and delivers a hands-on experience, replacing expensive physical labs. The Microsoft Office training course covers objectives of the Microsoft Office Specialist and Expert exams for Word 2019 and offers an interactive learning experience in creating and saving documents and using different document views; inserting, formatting, and laying out pictures; inserting and formatting tables; and more. 

Here's what you will get

The Microsoft Word (Word and Word 2019) certification validates candidates' competency in the correct application of the principal features of Word by creating and editing documents for a variety of purposes and situations. The MOS Word 2019 exam covers the ability to create and maintain professional-looking reports, multi-column newsletters, resumes, and business correspondence.

Lessons

59+ Lessons | 624+ Quizzes | 413+ Flashcards | 413+ Glossary of terms

TestPrep

77+ Pre Assessment Questions | 80+ Post Assessment Questions |

Hand on lab

134+ LiveLab | 00+ Minutes

Here's what you will learn

Download Course Outline

Lessons 1: Introduction

Lessons 2: Fundamentals

  • Module A: Getting around
  • Module B: Creating documents
  • Module C: Document views
  • Summary

Lessons 3: Formatting

  • Module A: Formatting characters
  • Module B: Formatting paragraphs
  • Module C: Quick Styles
  • Module D: Making lists
  • Summary

Lessons 4: Document setup

  • Module A: Page layout
  • Module B: Proofing documents
  • Module C: Printing, headers, and footers
  • Module D: Templates
  • Summary

Lessons 5: Graphics

  • Module A: Inserting pictures
  • Module B: Formatting pictures
  • Module C: Picture layout
  • Summary

Lessons 6: Tables

  • Module A: Creating tables
  • Module B: Formatting tables
  • Summary

Lessons 7: Introduction

Lessons 8: Illustrations

  • Module A: Shapes and text
  • Module B: SmartArt
  • Module C: 3D models
  • Summary

Lessons 9: Managing documents

  • Module A: Custom themes
  • Module B: Building blocks
  • Module C: Section breaks
  • Module D: Page backgrounds
  • Summary

Lessons 10: Styles

  • Module A: Character styles
  • Module B: Paragraph styles
  • Summary

Lessons 11: References and hyperlinks

  • Module A: Reference notes
  • Module B: Table of contents
  • Module C: Hyperlinks
  • Summary

Lessons 12: Navigation and organization

  • Module A: Navigating documents
  • Module B: Master documents
  • Summary

Lessons 13: Saving and sharing documents

  • Module A: Saving and sending
  • Module B: Comments
  • Module C: Protecting documents
  • Summary

Lessons 14: Introduction

Lessons 15: Advanced formatting

  • Module A: Tables and charts
  • Module B: Creating building blocks
  • Module C: Linking text
  • Summary

Lessons 16: Advanced document management

  • Module A: Configuring Word options
  • Module B: Working with templates
  • Module C: Tracking and reviewing changes
  • Summary

Lessons 17: Using references

  • Module A: Internal references
  • Module B: Indexing
  • Module C: Citing external sources
  • Summary

Lessons 18: Creating mailings

  • Module A: Recipient lists
  • Module B: Performing mail merges
  • Module C: Envelopes and labels
  • Summary

Lessons 19: Macros and forms

  • Module A: Macros
  • Module B: Forms
  • Summary

Appendix A: Internationalization and accessibility

  • Module A: Internationalization
  • Module B: Managing accessibility in documents

Appendix B: Video Tutorials

Lessons 22: Introduction

Lessons 23: Fundamentals

  • Module A: Getting around
  • Module B: Workbook basics
  • Summary

Lessons 24: Creating worksheets

  • Module A: Entering data
  • Module B: Formulas
  • Module C: Functions
  • Module D: Moving and copying data
  • Module E: Reference types
  • Summary

Lessons 25: Formatting

  • Module A: Text formatting
  • Module B: Number formatting
  • Module C: Alignment
  • Module D: Borders and highlighting
  • Module E: Styles and themes
  • Summary

Lessons 26: Manipulating data

  • Module A: Data entry shortcuts
  • Module B: Paste options
  • Module C: Inserting, deleting, and hiding
  • Summary

Lessons 27: Charts

  • Module A: Creating charts
  • Module B: Chart types and elements
  • Summary

Lessons 28: Output

  • Module A: Managing worksheet windows
  • Module B: Printing worksheets
  • Module C: Sharing workbooks
  • Summary

Lessons 29: Settings and templates

  • Module A: Workbook options and properties
  • Module B: Templates
  • Summary

Lessons 30: Introduction

Lessons 31: Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customizing Excel
  • Summary

Lessons 32: Named ranges

  • Module A: Using names in formulas
  • Summary

Lessons 33: Tables

  • Module A: Sorting
  • Module B: Filtering tables
  • Module C: Structured references
  • Module D: Validation
  • Module E: Transposing data
  • Summary

Lessons 34: Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals
  • Summary

Lessons 35: PivotTables

  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: PivotCharts
  • Summary

Lessons 36: Presentation features

  • Module A: Conditional formats
  • Module B: Custom Formats
  • Module C: Graphics
  • Summary

Lessons 37: Advanced charts

  • Module A: Special chart types
  • Module B: Sparklines
  • Module C: Quick Analysis
  • Summary

Lessons 38: Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks
  • Summary

Lessons 39: Introduction

Lessons 40: Logical and Lookup Functions

  • Module A: Decision-making functions
  • Module B: Lookup and reference functions
  • Summary

Lessons 41: Advanced Formulas

  • Module A: Auditing and error-trapping
  • Module B: Formula options
  • Module C: Arrays
  • Summary

Lessons 42: Special functions

  • Module A: Date and time functions
  • Module B: Text functions
  • Module C: Other functions
  • Summary

Lessons 43: Importing and Exporting

  • Module A: The Power Pivot Data Model
  • Module B: Exporting data
  • Summary

Lessons 44: Analysis

  • Module A: What-if analysis
  • Module B: The Analysis Toolpak
  • Summary

Lessons 45: Macros and Forms

  • Module A: Recording macros
  • Module B: Running macros
  • Module C: Forms
  • Summary

Appendix: Video Tutorials

Lessons 47: Introduction

Lessons 48: Fundamentals

  • Module A: Exploring the PowerPoint environment
  • Summary

Lessons 49: Creating a presentation

  • Module A: Creating a presentation
  • Module B: Creating and modifying slide content
  • Summary

Lessons 50: Formatting

  • Module A: Working with slide masters and layouts
  • Module B: Formatting slides and text
  • Summary

Lessons 51: Working with shapes and images

  • Module A: Creating and formatting shapes
  • Module B: Working with images
  • Summary

Lessons 52: Working with charts and tables

  • Module A: Working with charts
  • Module B: Working with tables
  • Summary

Lessons 53: Customization

  • Module A: Slide transitions
  • Module B: Additional text options
  • Module C: Printing
  • Summary
  • Creating a Presentation and its Slide and Exploring the PowerPoint Environment: Interactive Exercise
  • testing
  • test2

Lessons 54: Introduction

Lessons 55: Advanced formatting

  • Module A: Inserting and formatting SmartArt
  • Module B: Inserting and formatting 3D models
  • Module C: Additional formatting options
  • Summary

Lessons 56: Animation, time effects, and media

  • Module A: Animating slide content
  • Module B: Inserting and formatting media
  • Summary

Lessons 57: Reviewing content, tracking changes, and saving in other formats

  • Module A: Reviewing content and tracking changes
  • Module B: Saving a presentation in other formats
  • Summary

Lessons 58: Custom slide shows

  • Module A: Working with notes pages
  • Module B: Configuring, rehearsing, and presenting slide shows
  • Summary

Lessons 59: Sharing, collaborating, and security

  • Module A: Protecting your presentations
  • Module B: Sharing your presentations
  • Summary
  • Working with slide masters and layouts, creating...rmatting shapes and images: Interactive Exercise
  • Working with slide masters and layouts, creating...rmatting shapes and images: Interactive Exercise
  • Working with slide masters and layouts, and crea...rmatting shapes and images: Interactive Exercise
  • Working with charts and tables, applying slide t... WordArt from text, and setting printer settings

Hands-on LAB Activities

Fundamentals

  • Zooming a Document
  • Creating and Saving a Document

Formatting

  • Formatting the Text to Bold
  • Changing the Font Style and Font Size
  • Changing the Text Color
  • Showing the Paragraph Marks
  • Changing the Heading Style
  • Creating a Bulleted List
  • Inserting and Editing a Citation

Document setup

  • Changing the Basic Page Setup
  • Formatting the Text into Columns
  • Adding an AutoCorrect Shortcut
  • Setting the Header and Footer
  • Creating a Document Using a Template

Graphics

  • Inserting a Picture from a File

Tables

  • Formatting the Table Border
  • Inserting Rows and Columns
  • Inserting a Table
  • Modifying the Table Design

Illustrations

  • Inserting a Shape
  • Using WordArt
  • Adding a SmartArt
  • Inserting a 3D Model

Managing documents

  • Creating a Custom Theme
  • Inserting a Cover Page
  • Using Section Breaks
  • Adding Color to a Page
  • Adding a Watermark

Styles

  • Inserting a Symbol

References and hyperlinks

  • Inserting an Endnote
  • Modifying and Inserting Footnotes
  • Inserting a Table of Contents Using Marked Entries
  • Creating an Email Hyperlink

Saving and sharing documents

  • Creating PDF and XPS Documents
  • Creating a Blog Post
  • Adding and Modifying a Comment
  • Editing Restrictions
  • Finding and Replacing Text

Advanced formatting

  • Creating a Chart
  • Inserting a Formula

Advanced document management

  • Combining Documents
  • Using Document Tracking

Using references

  • Adding a Bookmark
  • Indexing a Document
  • Inserting a Bibliography
  • Editing a Citation

Creating mailings

  • Creating a Signature Line
  • Creating a Mail Merge

Fundamentals

  • Saving a Workbook

Creating worksheets

  • Creating a New Workbook
  • Performing Calculations with Formulas
  • Entering a Function
  • Using Relative, Absolute, and Mixed References

Formatting

  • Changing the Date Format
  • Formatting Numbers
  • Merging a Heading
  • Applying a Theme

Manipulating data

  • Deleting and Editing the Cell Content

Charts

  • Creating a Simple Chart
  • Changing the Chart Color
  • Changing the Chart Style
  • Editing a Legend in the Chart
  • Creating a Column Chart and Switching its Rows and Columns

Output

  • Splitting a Large Worksheet
  • Setting Page Margin
  • Setting and Saving the Print Area
  • Adding a Header
  • Saving a Workbook as a PDF File

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template

Managing workbooks

  • Inserting Hyperlink to an Image

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names

Tables

  • Sorting Data
  • Sorting by Multiple Columns
  • Filtering Data 
  • Creating Formulas Using Structured References

PivotTables

  • Creating a PivotTable Automatically

Presentation features

  • Inserting WordArt
  • Inserting SmartArt

Advanced charts

  • Inserting a Trendline on a Chart
  • Customizing Sparklines

Collaboration

  • Adding Comments
  • Merging Shared Workbooks

Logical and Lookup Functions

  • Using the IF Function
  • Using the SUMIF Function 
  • Using the SUMIFS Function
  • Using VLOOKUP
  • Using the MATCH Function

Advanced Formulas

  • Using an Array Formula 
  • Using an Array Function

Special functions

  • Performing Calculations Using Date Functions
  • Performing Simple Time Calculations
  • Using the Concatenate Function
  • Calculating the Minimum and Maximum Sales Value

Importing and Exporting

  • Importing Data from a File
  • Creating Relationships Between Tables
  • Exporting to a Text File

Macros and Forms

  • Creating a Blank Form

Creating a presentation

  • Creating a Presentation Using a Template
  • Duplicating a Slide
  • Inserting Content into a Placeholder
  • Inserting a Hyperlink on a Slide
  • Inserting an Online Image
  • Inserting an Image from the Desktop

Formatting

  • Adding and Modifying a Footer
  • Applying a Theme
  • Modifying the Slide Layout
  • Formatting a Slide's Background
  • Applying and Formatting Bulleted and Numbered Lists

Working with shapes and images

  • Showing Gridlines
  • Inserting and Formatting Shapes
  • Applying the Artistic Effect
  • Applying Effects to a Shape
  • Applying Styles and Effects to a Picture
  • Applying Image Alt Text
  • Inserting a Screenshot

Working with charts and tables

  • Adding a Chart to a Presentation
  • Working with Tables
  • Importing and Editing a Table

Customization

  • Applying the Transition
  • Creating WordArt from the Text

Advanced formatting

  • Inserting SmartArt and Arranging the Picture's Position
  • Converting a List into SmartArt
  • Inserting and Modifying a 3D Model

Animation, time effects, and media

  • Applying Animation on an Online Picture
  • Animating Text
  • Animating a 3D Model
  • Adding a Video

Reviewing content, tracking changes, and saving in other formats

  • Checking the Spelling Automatically
  • Adding a Comment
  • Modifying the Text Style
  • Customizing the Handout Master

Custom slide shows

  • Adding Notes
  • Creating a Custom Slide Show
  • Rehearsing Slide Timings

Sharing, collaborating, and security

  • Making a Presentation Read-Only

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