MOS-2019

Microsoft Office 2019

Learn how to effectively use Microsoft Office suite - Word, Excel & PowerPoint for your daily tasks.

Practice in 134 Hands-On Labs — nothing to install
59 Interactive Lessons and 178 topics mapped to the official exam objectives
546 Practice Test Questions

Beginner Self-paced · 1 year access 4.7/5 (40 Reviews)

134 Hands-On LiveLabs

Practice real IT tasks in guided environments.

Real environments
Auto-graded
No installation

59Interactive Lessons

178Topics

134LiveLab

546Practice Test Questions

40Videos

413Flashcards

413Glossary of terms

01 / Skills you'll get

What you will be able to do

Try Free → No credit card required

Microsoft Office 2019 is a training course that equips you with the skills and knowledge to pass the MS Office Specialist & Expert exams. Gain hands-on training to create polished documents, clean spreadsheets, and impactful presentations. Excellent Word skills will give you added advantage, you’ll be able to boost your productivity and streamline your workflow by using the features of Microsoft Office 2019.

Creating and formatting various types of documents
Ability to apply advanced formatting techniques like styles, themes, and page layouts
Table creation and manipulation within Word docs
Integrating graphics and images, and mail merge techniques
Expertise with data entry and manipulation on spreadsheets
Apply advanced formulas for calculations
Create and customize charts for visual data
Using PivotTables to analyze large datasets
Automating repetitive repetitive tasks with Macros
Create impactful slides and PPTs
Integrate multimedia, animation, and transition within the PPTs for visual impact

Target Career Roles

Office Manager
Research Analyst
Executive Assistant
Database Specialist
Project Coordinator
Workbook Developer
SharePoint Specialist
IT Support Technician
Administrative Assistant

02 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

59 Interactive Lessons · 178 topics

01 Introduction

02 Fundamentals 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

03 Formatting 5 topics · 7 LiveLab

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

7 LiveLab in this lesson — see the labs panel →

04 Document setup 5 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

05 Graphics 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

06 Tables 3 topics · 4 LiveLab

Module A: Creating tables
Module B: Formatting tables
Summary

4 LiveLab in this lesson — see the labs panel →

07 Introduction

08 Illustrations 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

09 Managing documents 5 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

10 Styles 3 topics · 1 LiveLab

Module A: Character styles
Module B: Paragraph styles
Summary

1 LiveLab in this lesson — see the labs panel →

11 References and hyperlinks 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

12 Navigation and organization 3 topics

Module A: Navigating documents
Module B: Master documents
Summary

13 Saving and sharing documents 4 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

14 Introduction

15 Advanced formatting 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

16 Advanced document management 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

17 Using references 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

18 Creating mailings 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

19 Macros and forms 3 topics

Module A: Macros
Module B: Forms
Summary

20 Appendix A: Internationalization and accessibility 2 topics

Module A: Internationalization
Module B: Managing accessibility in documents

21 Appendix B: Video Tutorials

22 Introduction

23 Fundamentals 3 topics · 1 LiveLab

Module A: Getting around
Module B: Workbook basics
Summary

1 LiveLab in this lesson — see the labs panel →

24 Creating worksheets 6 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

25 Formatting 6 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

26 Manipulating data 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

27 Charts 3 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

28 Output 4 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

29 Settings and templates 3 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

30 Introduction

31 Managing workbooks 3 topics · 1 LiveLab

Module A: Managing worksheets
Module B: Customizing Excel
Summary

1 LiveLab in this lesson — see the labs panel →

32 Named ranges 2 topics · 2 LiveLab

Module A: Using names in formulas
Summary

2 LiveLab in this lesson — see the labs panel →

33 Tables 6 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

34 Summarizing data 3 topics

Module A: Consolidation
Module B: Subtotals
Summary

35 PivotTables 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

36 Presentation features 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

37 Advanced charts 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

38 Collaboration 3 topics · 2 LiveLab

Module A: Permissions
Module B: Shared workbooks
Summary

2 LiveLab in this lesson — see the labs panel →

39 Introduction

40 Logical and Lookup Functions 3 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

41 Advanced Formulas 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

42 Special functions 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

43 Importing and Exporting 3 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

44 Analysis 3 topics

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

45 Macros and Forms 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

46 Appendix: Video Tutorials

47 Introduction

48 Fundamentals 2 topics

Module A: Exploring the PowerPoint environment
Summary

49 Creating a presentation 3 topics · 6 LiveLab

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

6 LiveLab in this lesson — see the labs panel →

50 Formatting 3 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

51 Working with shapes and images 3 topics · 7 LiveLab

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

7 LiveLab in this lesson — see the labs panel →

52 Working with charts and tables 3 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

53 Customization 4 topics · 2 LiveLab

Module A: Slide transitions
Module B: Additional text options
Module C: Printing
Summary

2 LiveLab in this lesson — see the labs panel →

54 Introduction

55 Advanced formatting 4 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

56 Animation, time effects, and media 3 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

57 Reviewing content, tracking changes, and saving in other formats 3 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

58 Custom slide shows 3 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

59 Sharing, collaborating, and security 7 topics · 1 LiveLab

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 LiveLab in this lesson — see the labs panel →

Hands-On Labs Our edge

134 LiveLabs

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

Labs run in your browser — nothing to install.

03 / Exam details

Microsoft Office 2019 Details

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.

Official exam objectives →

Questions 40-60 (per exam)

Duration 90 minutes (per exam)

Passing Score The passing score varies from exam to exam and is provided on the score report. (scaled score)

Exam Fee USD 100 (per exam)

Delivered by Certiport (in-person or online)

Question Format The exam consists of performance based questions and is... single/multiple choice, performance-based

Practice Tests 546 Practice Questions (mapped to official exam objectives)

Certification MOS-2019 uCertify credential

Ready to take the exam?

Add your official MOS-2019 exam voucher to your order.

Official Voucher · Fast delivery · Retake bundle available

Add Exam Voucher →

Exam voucher is sold separately and not included with standard course.

04 / FAQs

Questions before you start

Who is this course intended for?

This course is ideal for all those wanting to improve their computer skills and become more proficient in Microsoft Office 2019.

What is the duration of this course?

It is a self-paced course. You can study from anywhere at any time, and complete at your own pace. It is valid for 1 year from the date of purchase.

What kind of support is available for the students?

All uCertify learners have 24/7 access to our support teams. This is an instructor-led (on-demand) course that gives you access to learn from expert teachers and resolve all your doubts.

Do I need to install Microsoft Office 2019 for taking this course?

No, you don’t need to buy expensive software licenses. We provide a hands-on Lab facility to our students for their practice exercises.

Microsoft 365 vs Office 2019: what is the difference?

Both are the same software with different licensing. Microsoft 365 is a subscription service with regular updates whereas Office 2019 is a one-time purchase without future updates.

Learn Microsoft Office 2019

Use Word, Excel & PowerPoint to streamline your tasks.

1 year of full access
134 LiveLab included
Certificate of completion

Buy Now — $279.99 Try Free

No credit card required

Microsoft Office 2019

134 Hands-On LiveLabs

What you will be able to do

Target Career Roles

See exactly what you will learn and practice

Lessons

Hands-On Labs Our edge

Microsoft Office 2019 Details

Ready to take the exam?

Questions before you start

You might also like

Learn Microsoft Office 2019