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
Lessons
59 Interactive Lessons · 178 topics01 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.
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
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
No credit card required