Microsoft Office 2019
(MOS-2019) / ISBN : 978-1-64459-303-5
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
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.
Get the support you need. Enroll in our Instructor-Led Course.
Interactive Lessons
59+ Interactive Lessons | 624+ Quizzes | 413+ Flashcards | 413+ Glossary of terms
Gamified TestPrep
77+ Pre Assessment Questions | 80+ Post Assessment Questions |
Hands-On Labs
134+ LiveLab | 00+ Minutes
Introduction
Fundamentals
- Module A: Getting around
- Module B: Creating documents
- Module C: Document views
- Summary
Formatting
- Module A: Formatting characters
- Module B: Formatting paragraphs
- Module C: Quick Styles
- Module D: Making lists
- Summary
Document setup
- Module A: Page layout
- Module B: Proofing documents
- Module C: Printing, headers, and footers
- Module D: Templates
- Summary
Graphics
- Module A: Inserting pictures
- Module B: Formatting pictures
- Module C: Picture layout
- Summary
Tables
- Module A: Creating tables
- Module B: Formatting tables
- Summary
Introduction
Illustrations
- Module A: Shapes and text
- Module B: SmartArt
- Module C: 3D models
- Summary
Managing documents
- Module A: Custom themes
- Module B: Building blocks
- Module C: Section breaks
- Module D: Page backgrounds
- Summary
Styles
- Module A: Character styles
- Module B: Paragraph styles
- Summary
References and hyperlinks
- Module A: Reference notes
- Module B: Table of contents
- Module C: Hyperlinks
- Summary
Navigation and organization
- Module A: Navigating documents
- Module B: Master documents
- Summary
Saving and sharing documents
- Module A: Saving and sending
- Module B: Comments
- Module C: Protecting documents
- Summary
Introduction
Advanced formatting
- Module A: Tables and charts
- Module B: Creating building blocks
- Module C: Linking text
- Summary
Advanced document management
- Module A: Configuring Word options
- Module B: Working with templates
- Module C: Tracking and reviewing changes
- Summary
Using references
- Module A: Internal references
- Module B: Indexing
- Module C: Citing external sources
- Summary
Creating mailings
- Module A: Recipient lists
- Module B: Performing mail merges
- Module C: Envelopes and labels
- Summary
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
Introduction
Fundamentals
- Module A: Getting around
- Module B: Workbook basics
- Summary
Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
- Summary
Formatting
- Module A: Text formatting
- Module B: Number formatting
- Module C: Alignment
- Module D: Borders and highlighting
- Module E: Styles and themes
- Summary
Manipulating data
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
- Summary
Charts
- Module A: Creating charts
- Module B: Chart types and elements
- Summary
Output
- Module A: Managing worksheet windows
- Module B: Printing worksheets
- Module C: Sharing workbooks
- Summary
Settings and templates
- Module A: Workbook options and properties
- Module B: Templates
- Summary
Introduction
Managing workbooks
- Module A: Managing worksheets
- Module B: Customizing Excel
- Summary
Named ranges
- Module A: Using names in formulas
- Summary
Tables
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
- Summary
Summarizing data
- Module A: Consolidation
- Module B: Subtotals
- Summary
PivotTables
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
- Summary
Presentation features
- Module A: Conditional formats
- Module B: Custom Formats
- Module C: Graphics
- Summary
Advanced charts
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis
- Summary
Collaboration
- Module A: Permissions
- Module B: Shared workbooks
- Summary
Introduction
Logical and Lookup Functions
- Module A: Decision-making functions
- Module B: Lookup and reference functions
- Summary
Advanced Formulas
- Module A: Auditing and error-trapping
- Module B: Formula options
- Module C: Arrays
- Summary
Special functions
- Module A: Date and time functions
- Module B: Text functions
- Module C: Other functions
- Summary
Importing and Exporting
- Module A: The Power Pivot Data Model
- Module B: Exporting data
- Summary
Analysis
- Module A: What-if analysis
- Module B: The Analysis Toolpak
- Summary
Macros and Forms
- Module A: Recording macros
- Module B: Running macros
- Module C: Forms
- Summary
Appendix: Video Tutorials
Introduction
Fundamentals
- Module A: Exploring the PowerPoint environment
- Summary
Creating a presentation
- Module A: Creating a presentation
- Module B: Creating and modifying slide content
- Summary
Formatting
- Module A: Working with slide masters and layouts
- Module B: Formatting slides and text
- Summary
Working with shapes and images
- Module A: Creating and formatting shapes
- Module B: Working with images
- Summary
Working with charts and tables
- Module A: Working with charts
- Module B: Working with tables
- Summary
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
Introduction
Advanced formatting
- Module A: Inserting and formatting SmartArt
- Module B: Inserting and formatting 3D models
- Module C: Additional formatting options
- Summary
Animation, time effects, and media
- Module A: Animating slide content
- Module B: Inserting and formatting media
- Summary
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
Custom slide shows
- Module A: Working with notes pages
- Module B: Configuring, rehearsing, and presenting slide shows
- Summary
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
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
Any questions?Check out the FAQs
Still have unanswered questions and need to get in touch?
Contact Us NowThere 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
- 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.
For life