Microsoft Office 2019 Certification Prep & Training Course

Microsoft Office 2019

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

(MOS-2019) / ISBN : 978-1-64459-303-5

Lessons

Lab

TestPrep

AI Tutor (Add-on)

Instructor-Led (Add-on)

40 Reviews

Get A Free Trial

This course includes:

Free pre-assessment and first 2 lessons

59+ Interactive Lessons

Accessible on mobile and tablet too

Certificate of completion

Are you an instructor?

Access detailed information about the course content, learning objectives, activities, and assessments before adding it to your curriculum.

About This Course

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.

Skills You’ll Get

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

Get the support you need. Enroll in our Instructor-Led Course.

Get Started

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

Lesson Plan

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

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

Hands-on LAB Activities

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

Lessons Lab TestPrep AI Tutor

Keyboarding

ISBN: 9781644592632
KEYBOARD.AE1

Lessons TestPrep AI Tutor

MCA Microsoft 365 Teams Administrator Study Guide (MS-700)

ISBN: 9781644593509
MS-700.AE1

Lessons Lab TestPrep AI Tutor Instructor-Led

Microsoft Excel 2021

ISBN: 9781644593820
MSEXCEL.AD1

Lessons Lab TestPrep AI Tutor Instructor-Led

Microsoft Word 2021

ISBN: 9781644593837
MSWORD.AD1

Lessons Lab TestPrep AI Tutor Instructor-Led

Microsoft Powerpoint 2021

ISBN: 9781644593851
MSPOWERPOINT.AD1

Lessons Lab TestPrep AI Tutor Instructor-Led

Microsoft Access 2021

ISBN: 9781644593905
MSACCESS.AD1