uCertify

Microsoft Office Suite 2019

(MOS-2019.AI1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

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
  • Creating a Presentation and its Slide and Exploring the PowerPoint Environment: Interactive Exercise
  • testing
  • test2
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
60

Introduction

61

Fundamentals

  • Module A: Getting around
  • Module B: Viewing Outlook items
  • Summary
62

Email basics

  • Module A: Creating messages
  • Module B: Acting on messages
  • Module C: Adding content
  • Module D: Signatures
  • Summary
63

Contacts

  • Module A: Managing contacts
  • Module B: Using contact groups
  • Module C: Using contact cards
  • Summary
64

Tasks

  • Module A: Creating tasks
  • Module B: Managing tasks
  • Module C: Assigning tasks
  • Summary
65

Scheduling

  • Module A: Appointments
  • Module B: Meetings
  • Module C: Using the calendar
  • Summary
66

Customization

  • Module A: Customizing the ribbon
  • Module B: Customizing Outlook
  • Summary
D

Appendix: 3D Avatar-based Simulation

68

Introduction

69

Organizing Outlook

  • Module A: Account management
  • Module B: Using folders
  • Module C: Categorizing items
  • Module D: Searching and filtering
  • Module E: Quick steps
  • Summary
70

Managing your mail

  • Module A: Managing junk mail
  • Module B: Using rules
  • Module C: Cleaning up your mailbox
  • Summary
71

Advanced email settings

  • Module A: Message options
  • Module B: Customizing message appearance
  • Summary
72

Notes and Journal entries

  • Module A: Notes
  • Module B: Using the Journal
  • Summary
73

Collaboration

  • Module A: Performing mail merges
  • Module B: Sharing items
  • Module C: Outlook integration
  • Summary
E

Appendix: 3D Avatar-based Simulation

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
44

Fundamentals

  • Logging into Outlook
  • Opening Outlook Items
  • Using the Tell Me Box
  • Collapsing a Group
45

Email basics

  • Marking Messages as Read/Unread
  • Creating a Signature
46

Tasks

  • Creating and Copying a Task
  • Creating a Recurring Task
  • Assigning a Task
47

Scheduling

  • Creating an Appointment
  • Adding Holidays
  • Changing the Calendar Color
48

Customization

  • Customizing the Quick Access Toolbar
49

Organizing Outlook

  • Creating a Search Folder
  • Creating a Folder
  • Accessing Search Options
50

Managing your mail

  • Marking a Safe Sender
  • Configuring AutoArchive Defaults
51

Advanced email settings

  • Setting Automatic Out-of-Office Replies
52

Notes and Journal entries

  • Viewing the Journal
53

Collaboration

  • Changing the Permissions of a Folder

Related Courses

All Courses