uCertify

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

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.

Download Course Outline

1

Introduction

2

Fundamentals

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

Formatting

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

Document setup

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

Graphics

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

Tables

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

Introduction

8

Illustrations

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

Managing documents

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

Styles

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

References and hyperlinks

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

Navigation and organization

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

Saving and sharing documents

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

Introduction

15

Advanced formatting

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

Advanced document management

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

Using references

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

Creating mailings

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

Macros and forms

  • Module A: Macros
  • Module B: Forms
  • Summary
A

Appendix A: Internationalization and accessibility

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

Appendix B: Video Tutorials

22

Introduction

23

Fundamentals

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

Creating worksheets

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

Formatting

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

Manipulating data

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

Charts

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

Output

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

Settings and templates

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

Introduction

31

Managing workbooks

  • Module A: Managing worksheets
  • Module B: Customizing Excel
  • Summary
32

Named ranges

  • Module A: Using names in formulas
  • Summary
33

Tables

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

Summarizing data

  • Module A: Consolidation
  • Module B: Subtotals
  • Summary
35

PivotTables

  • Module A: Creating and formatting PivotTables
  • Module B: Manipulating PivotTables
  • Module C: PivotCharts
  • Summary
36

Presentation features

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

Advanced charts

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

Collaboration

  • Module A: Permissions
  • Module B: Shared workbooks
  • Summary
39

Introduction

40

Logical and Lookup Functions

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

Advanced Formulas

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

Special functions

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

Importing and Exporting

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

Analysis

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

Macros and Forms

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

Appendix: Video Tutorials

47

Introduction

48

Fundamentals

  • Module A: Exploring the PowerPoint environment
  • Summary
49

Creating a presentation

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

Formatting

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

Working with shapes and images

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

Working with charts and tables

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

Customization

  • Module A: Slide transitions
  • Module B: Additional text options
  • Module C: Printing
  • Summary
54

Introduction

55

Advanced formatting

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

Animation, time effects, and media

  • Module A: Animating slide content
  • Module B: Inserting and formatting media
  • Summary
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
  • Summary
58

Custom slide shows

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

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

1

Fundamentals

  • Zooming a Document
  • Creating and Saving a Document
2

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
3

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
4

Graphics

  • Inserting a Picture from a File
5

Tables

  • Formatting the Table Border
  • Inserting Rows and Columns
  • Inserting a Table
  • Modifying the Table Design
6

Illustrations

  • Inserting a Shape
  • Using WordArt
  • Adding a SmartArt
  • Inserting a 3D Model
7

Managing documents

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

Styles

  • Inserting a Symbol
9

References and hyperlinks

  • Inserting an Endnote
  • Modifying and Inserting Footnotes
  • Inserting a Table of Contents Using Marked Entries
  • Creating an Email Hyperlink
10

Saving and sharing documents

  • Creating PDF and XPS Documents
  • Creating a Blog Post
  • Adding and Modifying a Comment
  • Editing Restrictions
  • Finding and Replacing Text
11

Advanced formatting

  • Creating a Chart
  • Inserting a Formula
12

Advanced document management

  • Combining Documents
  • Using Document Tracking
13

Using references

  • Adding a Bookmark
  • Indexing a Document
  • Inserting a Bibliography
  • Editing a Citation
14

Creating mailings

  • Creating a Signature Line
  • Creating a Mail Merge
15

Fundamentals

  • Saving a Workbook
16

Creating worksheets

  • Creating a New Workbook
  • Performing Calculations with Formulas
  • Entering a Function
  • Using Relative, Absolute, and Mixed References
17

Formatting

  • Changing the Date Format
  • Formatting Numbers
  • Merging a Heading
  • Applying a Theme
18

Manipulating data

  • Deleting and Editing the Cell Content
19

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
20

Output

  • Splitting a Large Worksheet
  • Setting Page Margin
  • Setting and Saving the Print Area
  • Adding a Header
  • Saving a Workbook as a PDF File
21

Settings and templates

  • Checking Compatibility
  • Creating a Workbook from a Template
22

Managing workbooks

  • Inserting Hyperlink to an Image
23

Named ranges

  • Creating Names for Cell Ranges
  • Editing Names
24

Tables

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

PivotTables

  • Creating a PivotTable Automatically
26

Presentation features

  • Inserting WordArt
  • Inserting SmartArt
27

Advanced charts

  • Inserting a Trendline on a Chart
  • Customizing Sparklines
28

Collaboration

  • Adding Comments
  • Merging Shared Workbooks
29

Logical and Lookup Functions

  • Using the IF Function
  • Using the SUMIF Function 
  • Using the SUMIFS Function
  • Using VLOOKUP
  • Using the MATCH Function
30

Advanced Formulas

  • Using an Array Formula
  • Using an Array Function
31

Special functions

  • Performing Calculations Using Date Functions
  • Performing Simple Time Calculations
  • Using the Concatenate Function
  • Calculating the Minimum and Maximum Sales Value
32

Importing and Exporting

  • Importing Data from a File
  • Creating Relationships Between Tables
  • Exporting to a Text File
33

Macros and Forms

  • Creating a Blank Form
34

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
35

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
36

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
37

Working with charts and tables

  • Adding a Chart to a Presentation
  • Working with Tables
  • Importing and Editing a Table
38

Customization

  • Applying the Transition
  • Creating WordArt from the Text
39

Advanced formatting

  • Inserting SmartArt and Arranging the Picture's Position
  • Converting a List into SmartArt
  • Inserting and Modifying a 3D Model
40

Animation, time effects, and media

  • Applying Animation on an Online Picture
  • Animating Text
  • Animating a 3D Model
  • Adding a Video
41

Reviewing content, tracking changes, and saving in other formats

  • Checking the Spelling Automatically
  • Adding a Comment
  • Modifying the Text Style
  • Customizing the Handout Master
42

Custom slide shows

  • Adding Notes
  • Creating a Custom Slide Show
  • Rehearsing Slide Timings
43

Sharing, collaborating, and security

  • Making a Presentation Read-Only

Any questions?
Check out the FAQs

Here are some of the most commonly asked questions about this Microsoft Office 2019 training course.

Contact Us Now

This course is ideal for all those wanting to improve their computer skills and become more proficient in Microsoft Office 2019.

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.

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.

No, you don’t need to buy expensive software licenses. We provide a hands-on Lab facility to our students for their practice exercises.

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.

$279.99

Buy Now

Related Courses

All Courses