Microsoft Office 2019 - Seven Learning

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

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

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

Customisation

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.

Summary

Standard:

MS Office 2019

Lessons:

59+ Lessons

Delivery Method:

Online

Language:

English

Add to cart