Microsoft Office 2019

This Course Includes:

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.

What will you 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 1: Introduction

Lessons 2: Fundamentals

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

Lessons 3: Formatting

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

Lessons 4: Document setup

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

Lessons 5: Graphics

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

Lessons 6: Tables

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

Lessons 7: Introduction

Lessons 8: Illustrations

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

Lessons 9: Managing documents

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

Lessons 10: Styles

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

Lessons 11: References and hyperlinks

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

Lessons 12: Navigation and organisation

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

Lessons 13: Saving and sharing documents

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

Lessons 14: Introduction

Lessons 15: Advanced formatting

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

Lessons 16: Advanced document management

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

Lessons 17: Using references

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

Lessons 18: Creating mailings

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

Lessons 19: Macros and forms

  • Module A: Macros
  • Module B: Forms

Appendix A: Internationalisation and accessibility

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

Appendix B: Video Tutorials

Lessons 22: Introduction

Lessons 23: Fundamentals

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

Lessons 24: Creating worksheets

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

Lessons 25: Formatting

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

Lessons 26: Manipulating data

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

Lessons 27: Charts

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

Lessons 28: Output

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

Lessons 29: Settings and templates

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

Lessons 30: Introduction

Lessons 31: Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customising Excel

Lessons 32: Named ranges

  • Module A: Using names in formulas

Lessons 33: Tables

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

Lessons 34: Summarising data

  • Module A: Consolidation
  • Module B: Subtotals

Lessons 35: PivotTables

  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: Pivot Charts

Lessons 36: Presentation features

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

Lessons 37: Advanced charts

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

Lessons 38: Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks

Lessons 39: Introduction

Lessons 40: Logical and Lookup Functions

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

Lessons 41: Advanced Formulas

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

Lessons 42: Special functions

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

Lessons 43: Importing and Exporting

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

Lessons 44: Analysis

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

Lessons 45: Macros and Forms

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

Appendix: Video Tutorials

Lessons 47: Introduction

Lessons 48: Fundamentals

  • Module A: Exploring the PowerPoint environment

Lessons 49: Creating a presentation

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

Lessons 50: Formatting

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

Lessons 51: Working with shapes and images

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

Lessons 52: Working with charts and tables

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

Lessons 53: Customisation

  • Module A: Slide transitions
  • Module B: Additional text options
  • Module C: Printing
  • Creating a Presentation and its Slide and Exploring the PowerPoint Environment: Interactive Exercise

Lessons 54: Introduction

Lessons 55: Advanced formatting

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

Lessons 56: Animation, time effects and media

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

Lessons 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

Lessons 58: Custom slide shows

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

Lessons 59: Sharing, collaborating and security

  • Module A: Protecting your presentations
  • Module B: Sharing your presentations
  • Working with slide masters and layouts, creating and formatting shapes and images: Interactive Exercise
  • Working with slide masters and layouts, creating and formatting shapes and images: Interactive Exercise
  • Working with slide masters and layouts, and creating and formatting shapes and images: Interactive Exercise
  • Working with charts and tables, applying slide tables in WordArt from text, and setting printer settings

Hands-on LAB Activities


  • Zooming a Document
  • Creating and Saving a Document


  • Formatting the Text to Bold
  • Changing the Font Style and Font Size
  • Changing the Text Colour
  • 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


  • 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

Managing documents

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


  • 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


  • Saving a Workbook

Creating worksheets

  • 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

Manipulating data

  • Deleting and Editing the Cell Content


  • Creating a Simple Chart
  • Changing the Chart Colour
  • 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

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


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


  • Creating a PivotTable Automatically

Presentation features

  • Inserting WordArt
  • Inserting SmartArt

Advanced charts

  • Inserting a Trendline on a Chart
  • Customising Sparklines


  • 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


  • 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


  • 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
  • Customising 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

FAQ's are not Available for this course.



MS Office 2019


59+ Lessons

Delivery Method:




Scroll to Top