Microsoft Office 2019

Name: Microsoft Office 2019
Brand: uCertify
Rating: 4.1 (16 reviews)

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

This course includes

Lessons

TestPrep

LiveLab

Mentoring (Add-on)

$144

Buy Now

Try this course Pre-Assessment and first two Lessons free No credit card required

Are you an instructor? Teach using uCertify products

Request a free evaluation copy

Microsoft Office 2019

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

LiveLab

134+ LiveLab

Here's what you will learn

Download Course Outline

Lesson 1: Introduction

Lesson 2: Fundamentals

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

Lesson 3: Formatting

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

Lesson 4: Document setup

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

Lesson 5: Graphics

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

Lesson 6: Tables

Module A: Creating tables
Module B: Formatting tables
Summary

Lesson 7: Introduction

Lesson 8: Illustrations

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

Lesson 9: Managing documents

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

Lesson 10: Styles

Module A: Character styles
Module B: Paragraph styles
Summary

Lesson 11: References and hyperlinks

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

Lesson 12: Navigation and organization

Module A: Navigating documents
Module B: Master documents
Summary

Lesson 13: Saving and sharing documents

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

Lesson 14: Introduction

Lesson 15: Advanced formatting

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

Lesson 16: Advanced document management

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

Lesson 17: Using references

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

Lesson 18: Creating mailings

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

Lesson 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

Lesson 22: Introduction

Lesson 23: Fundamentals

Module A: Getting around
Module B: Workbook basics
Summary

Lesson 24: Creating worksheets

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

Lesson 25: Formatting

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

Lesson 26: Manipulating data

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

Lesson 27: Charts

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

Lesson 28: Output

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

Lesson 29: Settings and templates

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

Lesson 30: Introduction

Lesson 31: Managing workbooks

Module A: Managing worksheets
Module B: Customizing Excel
Summary

Lesson 32: Named ranges

Module A: Using names in formulas
Summary

Lesson 33: Tables

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

Lesson 34: Summarizing data

Module A: Consolidation
Module B: Subtotals
Summary

Lesson 35: PivotTables

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

Lesson 36: Presentation features

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

Lesson 37: Advanced charts

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

Lesson 38: Collaboration

Module A: Permissions
Module B: Shared workbooks
Summary

Lesson 39: Introduction

Lesson 40: Logical and Lookup Functions

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

Lesson 41: Advanced Formulas

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

Lesson 42: Special functions

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

Lesson 43: Importing and Exporting

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

Lesson 44: Analysis

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

Lesson 45: Macros and Forms

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

Appendix: Video Tutorials

Lesson 47: Introduction

Lesson 48: Fundamentals

Module A: Exploring the PowerPoint environment
Summary

Lesson 49: Creating a presentation

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

Lesson 50: Formatting

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

Lesson 51: Working with shapes and images

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

Lesson 52: Working with charts and tables

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

Lesson 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

Lesson 54: Introduction

Lesson 55: Advanced formatting

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

Lesson 56: Animation, time effects, and media

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

Lesson 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

Lesson 58: Custom slide shows

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

Lesson 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 Activities (Live Labs)

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

What are the prerequisites for this exam?	There are no technical prerequisites for the certification exam.
What is the exam registration fee?	USD 100
Where do I take the exam?	Certiport
What is the format of the exam?	The exam consists of performance based questions and is conducted in a live or simulated environment.
How many questions are asked in the exam?	The exam contains 40-60 questions.
What is the duration of the exam?	90 minutes
What is the passing score?	The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?	Microsoft Office Specialist (MOS) exam retake policy 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. 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. A two-day waiting period will be imposed between each subsequent exam retake. There is no annual limit on the number of attempts on the same exam. If a candidate achieves a passing score on an Office exam, the candidate may take it again.
What is the validity of the certification?	For life
Where can I find more information about this exam?	Know more about the Microsoft Office 2019
What are the career opportunities after passing this exam?	Office Manager Research Analyst Executive Assistant Database Specialist Project Coordinator Workbook Developer SharePoint Specialist IT Support Technician Administrative Assistant

Microsoft Office 2019

Microsoft Office 2019

Hands on Activities (Live Labs)

Share with your friends and colleagues