Microsoft

Microsoft Office 365

(MOS-2021.AD1) / ISBN : 978-1-64459-778-1
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

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

Download Course Outline

1

Getting Started with Word 2021

  • Topic A: Navigate in Microsoft Word
  • Topic B: Create and Save Word Documents
  • Topic C: Manage Your Workspace
  • Topic D: Edit Documents
  • Topic E: Preview and Print Documents
  • Topic F: Customize the Word Environment
2

Formatting Text and Paragraphs

  • Topic A: Apply Character Formatting
  • Topic B: Control Paragraph Layout
  • Topic C: Align Text Using Tabs
  • Topic D: Display Text in Bulleted or Numbered Lists
  • Topic E: Apply Borders and Shading
3

Working More Efficiently

  • Topic A: Make Repetitive Edits
  • Topic B: Apply Repetitive Formatting
  • Topic C: Use Styles to Streamline Repetitive Formatting Tasks
4

Managing Lists

  • Topic A: Sort a List
  • Topic B: Format a List
5

Adding Tables

  • Topic A: Insert a Table
  • Topic B: Modify a Table
  • Topic C: Format a Table
  • Topic D: Convert Text to a Table
6

Inserting Graphic Objects

  • Topic A: Insert Symbols and Special Characters
  • Topic B: Add Images to a Document
7

Controlling Page Appearance

  • Topic A: Apply a Page Border and Color
  • Topic B: Add Headers and Footers
  • Topic C: Control Page Layout
  • Topic D: Add a Watermark
8

Preparing to Publish a Document

  • Topic A: Check Spelling, Grammar, and Readability
  • Topic B: Use Research Tools
  • Topic C: Check Accessibility
  • Topic D: Save a Document to Other Formats
9

Organizing Content Using Tables and Charts

  • Topic A: Sort Table Data
  • Topic B: Control Cell Layout
  • Topic C: Perform Calculations in a Table
  • Topic D: Create a Chart
  • Topic E: Add an Excel Table to a Word Document (Optional)
  • Summary
10

Customizing Formats Using Styles and Themes

  • Topic A: Create and Modify Text Styles
  • Topic B: Create Custom List or Table Styles
  • Topic C: Apply Document Themes
  • Summary
11

Inserting Content Using Quick Parts

  • Topic A: Insert Building Blocks
  • Topic B: Create and Modify Building Blocks
  • Topic C: Insert Fields Using Quick Parts
  • Summary
12

Using Templates to Automate Document Formatting

  • Topic A: Create a Document Using a Template
  • Topic B: Create and Modify a Template
  • Topic C: Manage Templates with the Template Organizer
  • Summary
13

Controlling the Flow of a Document

  • Topic A: Control Paragraph Flow
  • Topic B: Insert Section Breaks
  • Topic C: Insert Columns
  • Topic D: Link Text Boxes to Control Text Flow
  • Summary
14

Simplifying and Managing Long Documents

  • Topic A: Insert Blank and Cover Pages
  • Topic B: Insert an Index
  • Topic C: Insert a Table of Contents
  • Topic D: Insert an Ancillary Table
  • Topic E: Manage Outlines
  • Topic F: Create a Master Document
  • Summary
15

Using Mail Merge to Create Letters, Envelopes, and Labels

  • Topic A: Use Mail Merge
  • Topic B: Merge Envelopes and Labels
  • Summary
A

Appendix A: Microsoft® Office Word 2021 Common Keyboard Shortcuts

17

Getting Started with Excel 2021

  • Topic A: Navigate the Excel User Interface
  • Topic B: Use Excel Commands
  • Topic C: Create and Save a Basic Workbook 
  • Topic D: Enter Cell Data 
  • Topic E: Use Excel Help 
18

Performing Calculations

  • Topic A: Create Worksheet Formulas 
  • Topic B: Insert Functions 
  • Topic C: Reuse Formulas and Functions
19

Modifying a Worksheet

  • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows 
  • Topic B: Search for and Replace Data 
  • Topic C: Use Proofing and Research Tools 
20

Formatting a Worksheet

  • Topic A: Apply Text Formats 
  • Topic B: Apply Number Formats
  • Topic C: Align Cell Contents 
  • Topic D: Apply Styles and Themes
  • Topic E: Apply Basic Conditional Formatting
  • Topic F: Create and Use Templates 
21

Printing Workbooks

  • Topic A: Preview and Print a Workbook 
  • Topic B: Set Up the Page Layout 
  • Topic C: Configure Headers and Footers 
22

Managing Workbooks

  • Topic A: Manage Worksheets 
  • Topic B: Manage Workbook and Worksheet Views 
  • Topic C: Manage Workbook Properties
B

Appendix B: Adding Borders and Colors to Worksheets

  • Topic A: Add Borders and Colors to Worksheets 
C

Appendix C: Basic Excel Customization

  • Appendix Introduction 
  • Topic A: Customize General Options and the Excel UI 
25

Working with Functions

  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date and Time Functions
  • Topic E: Work with Text Functions
26

Working with Lists

  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
27

Analyzing Data

  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
28

Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
29

Using PivotTables and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers
D

Appendix B: Financial Functions

E

Appendix C: Working with Graphical Objects

  • Topic A: Insert Graphical Objects
  • Topic B: Modify Graphical Objects
  • Topic C: Work with SmartArt
32

Working with Multiple Worksheets and Workbooks

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
33

Sharing and Protecting Workbooks

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
34

Automating Workbook Functionality

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
35

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • Topic A: Use Lookup Functions
  • Topic B: Use Dynamic Arrays and Dynamic Array Functions
  • Topic C: Trace Cells
  • Topic D: Watch and Evaluate Formulas
36

Forecasting Data

  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecast Data Trends
37

Creating Sparklines and Mapping Data

  • Topic A: Create Sparklines
  • Topic B: Map Data
F

Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts

G

Appendix B: Cube Functions

H

Appendix C: Importing and Exporting Data

  • Topic A: Import and Export Data
I

Appendix D: Internationalizing Workbooks

  • Topic A: Internationalize Workbooks
J

Appendix E: Working with Power Pivot

  • Topic A: Work with Power Pivot
K

Appendix F: Advanced Customization Options

  • Topic A: Customize Advanced Options
L

Appendix G: Working with Forms and Controls

  • Topic A: Work with Forms and Controls
M

Appendix H: Using Array Formulas

  • Topic A: Use Array Formulas
46

Getting Started with PowerPoint 2021

  • Topic A: Navigate the PowerPoint Environment
  • Topic B: View and Navigate a Presentation
  • Topic C: Create and Save a Basic Presentation
  • Topic D: Use PowerPoint Help
47

Developing a PowerPoint Presentation

  • Topic A: Create Presentations
  • Topic B: Edit Text
  • Topic C: Work with Slides
  • Topic D: Design a Presentation
48

Formatting Text

  • Topic A: Format Characters
  • Topic B: Format Paragraphs
49

Adding and Arranging Graphical Elements

  • Topic A: Insert Images
  • Topic B: Insert Shapes
  • Topic C: Create SmartArt
  • Topic D: Insert Stock Media, Icons, and 3D Models
  • Topic E: Size, Group, and Arrange Objects
50

Modifying Graphical Elements

  • Topic A: Format Images
  • Topic B: Format Shapes
  • Topic C: Customize SmartArt
  • Topic D: Format Icons
  • Topic E: Format 3D Models
  • Topic F: Animate Objects
51

Preparing to Deliver Your Presentation

  • Topic A: Review Your Presentation
  • Topic B: Apply Transitions
  • Topic C: Print or Export a Presentation
  • Topic D: Deliver Your Presentation
N

Appendix B: Guidelines for Presentation Design

  • Appendix Introduction
  • Topic A: Presentation Design Principles
53

Customizing Design Templates

  • Topic A: Modify Slide Masters and Slide Layouts
  • Topic B: Modify the Notes Master and the Handout Master
  • Topic C: Add Headers and Footers
  • Summary
54

Adding Tables

  • Topic A: Create a Table
  • Topic B: Format a Table
  • Topic C: Insert a Table from Other Microsoft Office Applications
  • Summary
55

Adding Charts

  • Topic A: Create a Chart
  • Topic B: Format a Chart
  • Topic C: Insert a Chart from Microsoft Excel
  • Summary
56

Working with Media

  • Topic A: Add Audio to a Presentation
  • Topic B: Add Video to a Presentation
  • Topic C: Add a Screen Recording
  • Summary
57

Building Advanced Transitions and Animations

  • Topic A: Use the Morph Transition
  • Topic B: Customize Animations
  • Summary
58

Finalizing a Presentation

  • Topic A: Review a Presentation
  • Topic B: Enhance a Live Presentation
  • Topic C: Record a Presentation
  • Topic D: Set Up a Slide Show
  • Summary
59

Modifying Presentation Navigation

  • Topic A: Divide a Presentation into Sections
  • Topic B: Add Links
  • Topic C: Create a Custom Slide Show
  • Summary
60

Securing and Distributing a Presentation

  • Topic A: Secure a Presentation
  • Topic B: Create Digital Media
  • Summary
O

Appendix A: Microsoft®PowerPoint® Common Keyboard Shortcuts

P

Appendix B: Using Ink to Hand Draw Elements

  • Topic A: Draw Objects
  • Topic B: Write Math Equations
63

Getting Started with Access 2021

  • Topic A: Launch Access and Open a Database
  • Topic B: Use Tables to Store Data 
  • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
  • Topic D: Use Forms to View, Add, and Update Data
  • Topic E: Use Reports to Present Data 
  • Topic F: Get Help and Configure Options in Microsoft Access 
64

Creating Tables

  • Topic A: Plan an Access Database
  • Topic B: Start a New Access Database
  • Topic C: Create a New Table
  • Topic D: Establish Table Relationships
65

Creating Queries

  • Topic A: Create Basic Queries
  • Topic B: Perform Calculations in a Query
  • Topic C: Sort and Filter Data in a Query
66

Creating Forms

  • Topic A: Start a New Form
  • Topic B: Enhance a Form
67

Creating Reports

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout
Q

Appendix A: Microsoft® Office Access® 2021 Common Keyboard Shortcuts

1

Getting Started with Word 2021

  • Sandbox MSOffice
  • Setting the Zoom Level of a Document
  • Creating and Saving a Document
  • Saving a Document within Another Document
  • Formatting the Text to Bold
  • Copying and Saving a Text
  • Enabling Paragraph Marks
2

Formatting Text and Paragraphs

  • Formatting the Text to Italic
  • Changing the Font Style and Font Size
  • Changing the Heading Style
  • Changing the Text Color
  • Changing the Capitalization of a Text
  • Highlighting a Text
  • Changing the Paragraph Formatting
  • Indenting the First Line of a Paragraph
  • Enabling Automatic Hyphenation
  • Setting the Tab Stop
  • Creating a Bulleted List
  • Inserting a Border Around a Paragraph
3

Working More Efficiently

  • Using Find and Replace to Edit
  • Copying Paragraph Formatting Using Format Painter
  • Creating a New Style
  • Applying the Heading Style
4

Managing Lists

  • Sorting the Contents of a Table
  • Changing a Bulleted List to a Numbered List
5

Adding Tables

  • Inserting a Table
  • Formatting a Table
6

Inserting Graphic Objects

  • Inserting a Symbol
  • Inserting and Formatting a Picture
  • Creating a Chart
  • Adding a SmartArt
  • Inserting a Shape
  • Inserting a 3D Model
7

Controlling Page Appearance

  • Creating Header and Footer
  • Controlling Page Layout
  • Adding a Watermark to a Document
8

Preparing to Publish a Document

  • Configuring Spelling and Grammar Options
  • Using the Thesaurus Tool
  • Translating a Chunk of Text into a Document
  • Saving a Document in a Different File Format
9

Organizing Content Using Tables and Charts

  • Merging the Cells and Alignment of the Column
  • Adding the Data Labels and Title to the Chart
  • Creating a Chart
  • Adding and Linking an Excel Table to a Word Document
10

Customizing Formats Using Styles and Themes

  • Formating the Text
  • Creating a New Style
  • Modifying the Text Style
  • Creating and Applying the New Table Style
  • Creating a Bulleted List
  • Applying a Customized Theme
  • Applying a Page Color
11

Inserting Content Using Quick Parts

  • Using the Building Blocks Organizer Dialog Box
  • Creating and Renaming a Building Block
  • Creating a Footer
12

Using Templates to Automate Document Formatting

  • Creating a Document Using a Template
  • Adding a Text Placeholder
13

Controlling the Flow of a Document

  • Configuring the Keep with Next Option
  • Creating a Custom Margins
  • Setting the Header and Footer
  • Inserting a Column Break
  • Formatting the Text into Columns
  • Linking the Text Box to another Text Box
  • Inserting the Text Box
14

Simplifying and Managing Long Documents

  • Inserting a Cover Page
  • Indexing a Document
  • Inserting a Table of Contents
  • Marking Legal Citations
  • Inserting a Table of Authorities
  • Creating a Table of Tables
  • Creating a Table of Figures
  • Creating an Outline
  • Promoting and Demoting Topics
  • Creating a Master Document
15

Using Mail Merge to Create Letters, Envelopes, and Labels

  • Performing a Mail Merge
  • Creating an Envelope Document
16

Getting Started with Excel 2021

  • Exporting Ribbon Customizations as a File
  • Adding and Replacing Data in a Cell
  • Creating and Saving a Workbook
  • Copying and Pasting the Data
17

Performing Calculations

  • Creating Worksheet Formulas
  • Determining the Minimum Value
  • Determining the Maximum Value
  • Reusing Formulas
  • Calculating the Sum
  • Calculating the Average
18

Modifying a Worksheet

  • Hiding the Columns
  • Deleting a Column
  • Inserting a Cell Range
  • Deleting a Row
  • Hiding the Rows
  • Adjusting the Columns
19

Formatting a Worksheet

  • Adding a Hyperlink
  • Applying Fill Color
  • Adding Borders
  • Trimming the Decimal Places
  • Adding the Date to a Worksheet
  • Creating a Template
20

Printing Workbooks

  • Adding the Page Number to the Worksheet
21

Managing Workbooks

  • Deleting a Worksheet
  • Hiding a Worksheet
  • Adding a New Worksheet
  • Adding Color to the Worksheet Tab
  • Making a Copy of the Worksheet
  • Freezing the Top Row
22

Working with Functions

  • Creating Named Ranges
  • Editing Range Names
  • Using an Existing Range in a Function
  • Using the Formula AutoComplete Method to Enter Range Names
  • Using the TODAY Function
  • Calculating the Years of Service for Each Employee
  • Adding the Arguments for the IF Portion of the Nested Function
  • Calculating the 1 Percent Goal Bonus for Employees
  • Using the NETWORKDAYS Function
  • Extracting the Building Code from the Combined Field
  • Extracting the Floor Code from the Combined Field
  • Concatenating the Names in a Single Field
23

Working with Lists

  • Filtering the Data for all Employees
  • Creating a Custom Filter
  • Using Database Functions
24

Analyzing Data

  • Converting the Data into a Table
  • Applying a Quick Style to a Table
  • Adding New Entries to a Table
25

Visualizing Data with Charts

  • Creating a Clustered Column Chart
  • Changing the Labels of the Line Chart
  • Changing the Chart Type
  • Creating the Combo Chart
  • Adding the Trendline
  • Saving a Chart as a Template
26

Using PivotTables and PivotCharts

  • Adding Fields to the PivotTable
  • Building the PivotTable Report
  • Sorting the Values
  • Modifying the Formatting of the PivotTable Report
  • Modifying the PivotTable Report
  • Inserting a Timeline
27

Working with Multiple Worksheets and Workbooks

  • Creating Links
  • Creating External Links
  • Creating a 3-D Formula
  • Consolidating Data
28

Sharing and Protecting Workbooks

  • Fixing the Missing Alternative Text Error by Using the Accessibility Checker
  • Exporting the Workbook in the PDF File Format
  • Hiding the Worksheet
  • Enabling Worksheet Protection
  • Hiding the Formulas
29

Automating Workbook Functionality

  • Enabling and Configuring the Settings for Data Validation
  • Checking the Worksheet For Errors In Formulas
  • Finding and Fixing Invalid Data Entries
  • Saving the Workbook as a Macro-Enabled Workbook
30

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

  • Using the HLOOKUP Function
  • Using the INDEX Function
  • Using the MATCH Function
  • Using the FILTER Function
  • Using the SEQUENCE Function
  • Using the SORT Function
  • Using the LET Function
  • Using the XLOOKUP Function
  • Using the TRANSPOSE Function
  • Using the VLOOKUP Function
  • Using the UNIQUE Function
  • Using the XMATCH Function
31

Forecasting Data

  • Creating a Two-Variable Data Table
  • Creating a Forecast Sheet
32

Creating Sparklines and Mapping Data

  • Creating Sparklines
33

Getting Started with PowerPoint 2021

  • Using Underline in the Title Text
  • Inserting Content into a Placeholder
  • Creating and Saving a Basic Presentation
34

Developing a PowerPoint Presentation

  • Creating a Presentation from a Word Outline
  • Using the Clipboard to Paste the Text
  • Copying Text from the Document and Pasting into a Slide
  • Changing the Title Text on the Title Slide
  • Arranging a Slide in the Slide Sorter View
  • Reusing Slides from Another Presentation
  • Moving a Slide in the Normal View
  • Deleting Non-Contiguous Slides in the Slide Sorter View
  • Modifying the Slide Layout
  • Deleting a Series of Three Slides in the Normal View
  • Inserting a New Slide into the Presentation
  • Applying a Fill to the Background
35

Formatting Text

  • Using the Mini Toolbar to Change the Color of the Text on a Slide
  • Changing the Bullet Style
36

Adding and Arranging Graphical Elements

  • Adding an Online Image
  • Inserting an Image from the Desktop
  • Converting Text to a SmartArt Graphic
  • Converting SmartArt Graphics to Text
  • Inserting Cutout People
  • Inserting a Video
  • Inserting an Icon
  • Showing Gridlines
37

Modifying Graphical Elements

  • Adding Alternate Text to the Image
  • Applying a Gradient Fill to the Shape
  • Applying a Shape Style
  • Adding a Fill to a Text Box
  • Adding a Text Box to the Slide
  • Applying an Animation Effect to a Shape
  • Animating Bulleted Text
38

Preparing to Deliver Your Presentation

  • Fixing the Missing Alternative Text Errors
  • Adding Missing Slide Titles
  • Fixing Text Contrast Warnings
  • Checking the Spelling Automatically
  • Adding a Transition Between Slides
  • Hiding a Slide
39

Customizing Design Templates

  • Changing the Background of an Image
  • Inserting a Logo into the Slide Master and Modifying its Alternative Text
  • Creating and Saving a New Template
  • Scaling the Image in the Slide Master
  • Modifying the Background Style of the Slide Master
  • Applying a New Theme to the Slide Master
  • Modifying the Handout Master
  • Modifying the Notes Master
  • Creating a Custom Slide Layout
  • Adding Footers
40

Adding Tables

  • Creating a Table
  • Formatting a Table
41

Adding Charts

  • Formatting a Chart
42

Working with Media

  • Adding the Playback Settings to a Video
  • Adding the Video Style
  • Adding a Screen Recording
43

Building Advanced Transitions and Animations

  • Applying the Morph Transition to a Shape
  • Using the Morph Naming Scheme to Transform One Shape into Another
  • Adding a Triangular Motion Path
  • Animating a SmartArt Graphic
  • Applying and Modifying Animation Effects to a Graphic
44

Finalizing a Presentation

  • Comparing the Presentations
  • Adding a Comment to a Slide
  • Annotating a Presentation
  • Recording a Presentation
45

Modifying Presentation Navigation

  • Adding and Managing Sections
  • Adding an Action Button
  • Creating and Modifying a Custom Slide Show
46

Securing and Distributing a Presentation

  • Packaging a Presentation
47

Getting Started with Access 2021

  • Revising and Entering Table Data
  • Preventing AutoCorrect Corrections
  • Using the Find and Replace Feature
  • Adding a Total Row to a Datasheet
  • Sorting and Filtering Records
  • Using Queries
  • Using Reports
48

Creating Tables

  • Creating a New Database
  • Creating a New Table
  • Preparing Keys for Table Relationships
  • Establishing Table Relationships
49

Creating Queries

  • Creating a Query Using the Query Wizard
  • Creating a Query Using Query Design
  • Performing Calculations in a Query
  • Sorting a Query and Reordering Fields
  • Filtering a Query Using a Comparison Operator
  • Filtering a Query Using Dates
  • Prompting a User for Query Parameters
50

Creating Forms

  • Creating a Form by Using the Form Wizard
  • Creating and Testing a Form Based on a Selected Table
  • Filtering and Sorting Data in a Form
  • Configuring a Form Lookup Field
51

Creating Reports

  • Creating a Simple Report
  • Using the Report Wizard
  • Enhancing a Report Layout

Related Courses

All Courses