uCertify

Microsoft Office 2019

(MOS-2019) / ISBN : 9781644593035

This course includes
Lessons
TestPrep
LiveLab

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Module A: Using names in formulas
  • Summary

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

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

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

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

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

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

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

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

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

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

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

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

  • Module A: Exploring the PowerPoint environment
  • Summary

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

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

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

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

  • 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

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

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

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

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

  • 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

  • Zooming a Document
  • Creating and Saving a Document

  • 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

  • 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

  • Inserting a Picture from a File

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

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

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

  • Inserting a Symbol

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

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

  • Creating a Chart
  • Inserting a Formula

  • Combining Documents
  • Using Document Tracking

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

  • Creating a Signature Line
  • Creating a Mail Merge

  • Saving a Workbook

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

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

  • Deleting and Editing the Cell Content

  • 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 

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

  • Checking Compatibility
  • Creating a Workbook from a Template

  • Inserting Hyperlink to an Image

  • Creating Names for Cell Ranges
  • Editing Names

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

  • Creating a PivotTable Automatically

  • Inserting WordArt
  • Inserting SmartArt

  • Inserting a Trendline on a Chart
  • Customizing Sparklines

  • Adding Comments
  • Merging Shared Workbooks

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

  • Using an Array Formula 
  • Using an Array Function

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

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

  • Creating a Blank Form

  • 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

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

  • 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

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

  • Applying the Transition
  • Creating WordArt from the Text

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

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

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

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

  • 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