MOS-2019.AI1

Microsoft Office Suite 2019

Beginner Self-paced · 1 year access

155 Hands-On LiveLabs

Practice real IT tasks in guided environments.

Real environments
Auto-graded
No installation

01 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

74 Interactive Lessons · 221 topics

01 Introduction

02 Fundamentals 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

03 Formatting 5 topics · 7 LiveLab

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

7 LiveLab in this lesson — see the labs panel →

04 Document setup 5 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

05 Graphics 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

06 Tables 3 topics · 4 LiveLab

Module A: Creating tables
Module B: Formatting tables
Summary

4 LiveLab in this lesson — see the labs panel →

07 Introduction

08 Illustrations 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

09 Managing documents 5 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

10 Styles 3 topics · 1 LiveLab

Module A: Character styles
Module B: Paragraph styles
Summary

1 LiveLab in this lesson — see the labs panel →

11 References and hyperlinks 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

12 Navigation and organization 3 topics

Module A: Navigating documents
Module B: Master documents
Summary

13 Saving and sharing documents 4 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

14 Introduction

15 Advanced formatting 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

16 Advanced document management 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

17 Using references 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

18 Creating mailings 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

19 Macros and forms 3 topics

Module A: Macros
Module B: Forms
Summary

20 Appendix A: Internationalization and accessibility 2 topics

Module A: Internationalization
Module B: Managing accessibility in documents

21 Appendix B: Video Tutorials

22 Introduction

23 Fundamentals 3 topics · 1 LiveLab

Module A: Getting around
Module B: Workbook basics
Summary

1 LiveLab in this lesson — see the labs panel →

24 Creating worksheets 6 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

25 Formatting 6 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

26 Manipulating data 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

27 Charts 3 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

28 Output 4 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

29 Settings and templates 3 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

30 Introduction

31 Managing workbooks 3 topics · 1 LiveLab

Module A: Managing worksheets
Module B: Customizing Excel
Summary

1 LiveLab in this lesson — see the labs panel →

32 Named ranges 2 topics · 2 LiveLab

Module A: Using names in formulas
Summary

2 LiveLab in this lesson — see the labs panel →

33 Tables 6 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

34 Summarizing data 3 topics

Module A: Consolidation
Module B: Subtotals
Summary

35 PivotTables 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

36 Presentation features 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

37 Advanced charts 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

38 Collaboration 3 topics · 2 LiveLab

Module A: Permissions
Module B: Shared workbooks
Summary

2 LiveLab in this lesson — see the labs panel →

39 Introduction

40 Logical and Lookup Functions 3 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

41 Advanced Formulas 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

42 Special functions 4 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

43 Importing and Exporting 3 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

44 Analysis 3 topics

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

45 Macros and Forms 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

46 Appendix: Video Tutorials

47 Introduction

48 Fundamentals 2 topics

Module A: Exploring the PowerPoint environment
Summary

49 Creating a presentation 3 topics · 6 LiveLab

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

6 LiveLab in this lesson — see the labs panel →

50 Formatting 3 topics · 5 LiveLab

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

5 LiveLab in this lesson — see the labs panel →

51 Working with shapes and images 3 topics · 7 LiveLab

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

7 LiveLab in this lesson — see the labs panel →

52 Working with charts and tables 3 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

53 Customization 7 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

54 Introduction

55 Advanced formatting 4 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

56 Animation, time effects, and media 3 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

57 Reviewing content, tracking changes, and saving in other formats 3 topics · 4 LiveLab

Module A: Reviewing content and tracking changes
Module B: Saving a presentation in other formats
Summary

4 LiveLab in this lesson — see the labs panel →

58 Custom slide shows 3 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

59 Sharing, collaborating, and security 7 topics · 1 LiveLab

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 LiveLab in this lesson — see the labs panel →

60 Introduction

61 Fundamentals 3 topics · 4 LiveLab

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

4 LiveLab in this lesson — see the labs panel →

62 Email basics 5 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

63 Contacts 4 topics

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

64 Tasks 4 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

65 Scheduling 4 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

66 Customization 3 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

67 Appendix: 3D Avatar-based Simulation

68 Introduction

69 Organizing Outlook 6 topics · 3 LiveLab

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

3 LiveLab in this lesson — see the labs panel →

70 Managing your mail 4 topics · 2 LiveLab

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

2 LiveLab in this lesson — see the labs panel →

71 Advanced email settings 3 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

72 Notes and Journal entries 3 topics · 1 LiveLab

Module A: Notes
Module B: Using the Journal
Summary

1 LiveLab in this lesson — see the labs panel →

73 Collaboration 4 topics · 1 LiveLab

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

1 LiveLab in this lesson — see the labs panel →

74 Appendix: 3D Avatar-based Simulation

Hands-On Labs Our edge

155 LiveLabs

Zooming a Document
Creating and Saving a Document
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
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
Creating a Custom Theme
Inserting a Cover Page
Using Section Breaks
Adding Color to a Page
Adding a Watermark
Inserting a Symbol
Inserting an Endnote
Modifying and Inserting Footnotes
Inserting a Table of Contents Using Marked Entries
Creating an Email Hyperlink
Creating PDF and XPS Documents
Creating a Blog Post
Adding and Modifying a Comment
Editing Restrictions
Finding and Replacing Text
Creating a Chart
Inserting a Formula
Combining Documents
Using Document Tracking
Adding a Bookmark
Indexing a Document
Inserting a Bibliography
Editing a Citation
Creating a Signature Line
Creating a Mail Merge
Saving a Workbook
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
Deleting and Editing the Cell Content
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
Splitting a Large Worksheet
Setting Page Margin
Setting and Saving the Print Area
Adding a Header
Saving a Workbook as a PDF File
Checking Compatibility
Creating a Workbook from a Template
Inserting Hyperlink to an Image
Creating Names for Cell Ranges
Editing Names
Sorting Data
Sorting by Multiple Columns
Filtering Data
Creating Formulas Using Structured References
Creating a PivotTable Automatically
Inserting WordArt
Inserting SmartArt
Inserting a Trendline on a Chart
Customizing Sparklines
Adding Comments
Merging Shared Workbooks
Using the IF Function
Using the SUMIF Function
Using the SUMIFS Function
Using VLOOKUP
Using the MATCH Function
Using an Array Formula
Using an Array Function
Performing Calculations Using Date Functions
Performing Simple Time Calculations
Using the Concatenate Function
Calculating the Minimum and Maximum Sales Value
Importing Data from a File
Creating Relationships Between Tables
Exporting to a Text File
Creating a Blank Form
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
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
Adding a Chart to a Presentation
Working with Tables
Importing and Editing a Table
Applying the Transition
Creating WordArt from the Text
Inserting SmartArt and Arranging the Picture's Position
Converting a List into SmartArt
Inserting and Modifying a 3D Model
Applying Animation on an Online Picture
Animating Text
Animating a 3D Model
Adding a Video
Checking the Spelling Automatically
Adding a Comment
Modifying the Text Style
Customizing the Handout Master
Adding Notes
Creating a Custom Slide Show
Rehearsing Slide Timings
Making a Presentation Read-Only
Logging into Outlook
Opening Outlook Items
Using the Tell Me Box
Collapsing a Group
Marking Messages as Read/Unread
Creating a Signature
Creating and Copying a Task
Creating a Recurring Task
Assigning a Task
Creating an Appointment
Adding Holidays
Changing the Calendar Color
Customizing the Quick Access Toolbar
Creating a Search Folder
Creating a Folder
Accessing Search Options
Marking a Safe Sender
Configuring AutoArchive Defaults
Setting Automatic Out-of-Office Replies
Viewing the Journal
Changing the Permissions of a Folder

Labs run in your browser — nothing to install.

02 / FAQs

Questions before you start

Prepare for Microsoft Office Suite 2019

One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.

1 year of full access
155 LiveLab included
Certificate of completion

Try Free

No credit card required

Microsoft Office Suite 2019

155 Hands-On LiveLabs

See exactly what you will learn and practice

Lessons

Hands-On Labs Our edge

Questions before you start

You might also like

Prepare for Microsoft Office Suite 2019