Microsoft Office 2019

(MOS-2019) / ISBN : 978-1-64459-303-5
This course includes
Lessons
TestPrep
Hands-On Labs
Instructor Led (Add-on)
AI Tutor (Add-on)
40 Review
Get A Free Trial

About This Course

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. 

Skills You’ll Get

Lessons

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

TestPrep

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

Hands-On Labs

134+ LiveLab | 00+ Minutes

1

Introduction

2

Fundamentals

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

Formatting

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

Document setup

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

Graphics

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

Tables

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

Introduction

8

Illustrations

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

Managing documents

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

Styles

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

References and hyperlinks

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

Navigation and organization

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

Saving and sharing documents

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

Introduction

15

Advanced formatting

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

Advanced document management

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

Using references

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

Creating mailings

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

Macros and forms

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

Appendix A: Internationalization and accessibility

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

Appendix B: Video Tutorials

22

Introduction

23

Fundamentals

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

Creating worksheets

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

Formatting

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

Manipulating data

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

Charts

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

Output

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

Settings and templates

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

Introduction

31

Managing workbooks

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

Named ranges

  • Module A: Using names in formulas
  • Summary
33

Tables

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

Summarizing data

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

PivotTables

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

Presentation features

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

Advanced charts

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

Collaboration

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

Introduction

40

Logical and Lookup Functions

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

Advanced Formulas

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

Special functions

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

Importing and Exporting

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

Analysis

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

Macros and Forms

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

Appendix: Video Tutorials

47

Introduction

48

Fundamentals

  • Module A: Exploring the PowerPoint environment
  • Summary
49

Creating a presentation

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

Formatting

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

Working with shapes and images

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

Working with charts and tables

  • Module A: Working with charts
  • Module B: Working with tables
  • Summary
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
54

Introduction

55

Advanced formatting

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

Animation, time effects, and media

  • Module A: Animating slide content
  • Module B: Inserting and formatting media
  • Summary
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
58

Custom slide shows

  • Module A: Working with notes pages
  • Module B: Configuring, rehearsing, and presenting slide shows
  • Summary
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

1

Fundamentals

  • Zooming a Document
  • Creating and Saving a Document
2

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
3

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
4

Graphics

  • Inserting a Picture from a File
5

Tables

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

Illustrations

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

Managing documents

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

Styles

  • Inserting a Symbol
10

References and hyperlinks

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

Saving and sharing documents

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

Advanced formatting

  • Creating a Chart
  • Inserting a Formula
15

Advanced document management

  • Combining Documents
  • Using Document Tracking
16

Using references

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

Creating mailings

  • Creating a Signature Line
  • Creating a Mail Merge
22

Fundamentals

  • Saving a Workbook
23

Creating worksheets

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

Formatting

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

Manipulating data

  • Deleting and Editing the Cell Content
26

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
27

Output

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

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template
30

Managing workbooks

  • Inserting Hyperlink to an Image
31

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names
32

Tables

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

PivotTables

  • Creating a PivotTable Automatically
35

Presentation features

  • Inserting WordArt
  • Inserting SmartArt
36

Advanced charts

  • Inserting a Trendline on a Chart
  • Customizing Sparklines
37

Collaboration

  • Adding Comments
  • Merging Shared Workbooks
39

Logical and Lookup Functions

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

Advanced Formulas

  • Using an Array Formula
  • Using an Array Function
41

Special functions

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

Importing and Exporting

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

Macros and Forms

  • Creating a Blank Form
48

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
49

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
50

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
51

Working with charts and tables

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

Customization

  • Applying the Transition
  • Creating WordArt from the Text
54

Advanced formatting

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

Animation, time effects, and media

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

Reviewing content, tracking changes, and saving in other formats

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

Custom slide shows

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

Sharing, collaborating, and security

  • Making a Presentation Read-Only

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

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

Microsoft Office 2019

$150.00

Buy Now

Related Courses

All Course
scroll to top