.jpg){kind=logo}
MOS-2021.AD1 ISBN: 978-1-64459-778-1
Microsoft Office 365
Beginner Self-paced · 1 year access
254 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
Lessons
68 Interactive Lessons · 212 topics01 Getting Started with Word 2021 6 topics · 7 LiveLab +
- 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
7 LiveLab in this lesson — see the labs panel →
02 Formatting Text and Paragraphs 5 topics · 12 LiveLab +
- 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
12 LiveLab in this lesson — see the labs panel →
03 Working More Efficiently 3 topics · 4 LiveLab +
- Topic A: Make Repetitive Edits
- Topic B: Apply Repetitive Formatting
- Topic C: Use Styles to Streamline Repetitive Formatting Tasks
4 LiveLab in this lesson — see the labs panel →
04 Managing Lists 2 topics · 2 LiveLab +
- Topic A: Sort a List
- Topic B: Format a List
2 LiveLab in this lesson — see the labs panel →
05 Adding Tables 4 topics · 2 LiveLab +
- Topic A: Insert a Table
- Topic B: Modify a Table
- Topic C: Format a Table
- Topic D: Convert Text to a Table
2 LiveLab in this lesson — see the labs panel →
06 Inserting Graphic Objects 2 topics · 6 LiveLab +
- Topic A: Insert Symbols and Special Characters
- Topic B: Add Images to a Document
6 LiveLab in this lesson — see the labs panel →
07 Controlling Page Appearance 4 topics · 3 LiveLab +
- Topic A: Apply a Page Border and Color
- Topic B: Add Headers and Footers
- Topic C: Control Page Layout
- Topic D: Add a Watermark
3 LiveLab in this lesson — see the labs panel →
08 Preparing to Publish a Document 4 topics · 4 LiveLab +
- Topic A: Check Spelling, Grammar, and Readability
- Topic B: Use Research Tools
- Topic C: Check Accessibility
- Topic D: Save a Document to Other Formats
4 LiveLab in this lesson — see the labs panel →
09 Organizing Content Using Tables and Charts 6 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
10 Customizing Formats Using Styles and Themes 4 topics · 7 LiveLab +
- Topic A: Create and Modify Text Styles
- Topic B: Create Custom List or Table Styles
- Topic C: Apply Document Themes
- Summary
7 LiveLab in this lesson — see the labs panel →
11 Inserting Content Using Quick Parts 4 topics · 3 LiveLab +
- Topic A: Insert Building Blocks
- Topic B: Create and Modify Building Blocks
- Topic C: Insert Fields Using Quick Parts
- Summary
3 LiveLab in this lesson — see the labs panel →
12 Using Templates to Automate Document Formatting 4 topics · 2 LiveLab +
- Topic A: Create a Document Using a Template
- Topic B: Create and Modify a Template
- Topic C: Manage Templates with the Template Organizer
- Summary
2 LiveLab in this lesson — see the labs panel →
13 Controlling the Flow of a Document 5 topics · 7 LiveLab +
- Topic A: Control Paragraph Flow
- Topic B: Insert Section Breaks
- Topic C: Insert Columns
- Topic D: Link Text Boxes to Control Text Flow
- Summary
7 LiveLab in this lesson — see the labs panel →
14 Simplifying and Managing Long Documents 7 topics · 10 LiveLab +
- 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
10 LiveLab in this lesson — see the labs panel →
15 Using Mail Merge to Create Letters, Envelopes, and Labels 3 topics · 2 LiveLab +
- Topic A: Use Mail Merge
- Topic B: Merge Envelopes and Labels
- Summary
2 LiveLab in this lesson — see the labs panel →
16 Appendix A: Microsoft® Office Word 2021 Common Keyboard Shortcuts +
17 Getting Started with Excel 2021 5 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
18 Performing Calculations 3 topics · 6 LiveLab +
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
6 LiveLab in this lesson — see the labs panel →
19 Modifying a Worksheet 3 topics · 6 LiveLab +
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
6 LiveLab in this lesson — see the labs panel →
20 Formatting a Worksheet 6 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
21 Printing Workbooks 3 topics · 1 LiveLab +
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
1 LiveLab in this lesson — see the labs panel →
22 Managing Workbooks 3 topics · 6 LiveLab +
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
6 LiveLab in this lesson — see the labs panel →
23 Appendix B: Adding Borders and Colors to Worksheets 1 topics +
- Topic A: Add Borders and Colors to Worksheets
24 Appendix C: Basic Excel Customization 2 topics +
- Appendix Introduction
- Topic A: Customize General Options and the Excel UI
25 Working with Functions 5 topics · 12 LiveLab +
- 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
12 LiveLab in this lesson — see the labs panel →
26 Working with Lists 4 topics · 3 LiveLab +
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 LiveLab in this lesson — see the labs panel →
27 Analyzing Data 3 topics · 3 LiveLab +
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
3 LiveLab in this lesson — see the labs panel →
28 Visualizing Data with Charts 3 topics · 6 LiveLab +
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
6 LiveLab in this lesson — see the labs panel →
29 Using PivotTables and PivotCharts 4 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
30 Appendix B: Financial Functions +
31 Appendix C: Working with Graphical Objects 3 topics +
- Topic A: Insert Graphical Objects
- Topic B: Modify Graphical Objects
- Topic C: Work with SmartArt
32 Working with Multiple Worksheets and Workbooks 3 topics · 4 LiveLab +
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
4 LiveLab in this lesson — see the labs panel →
33 Sharing and Protecting Workbooks 2 topics · 5 LiveLab +
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
5 LiveLab in this lesson — see the labs panel →
34 Automating Workbook Functionality 3 topics · 4 LiveLab +
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
4 LiveLab in this lesson — see the labs panel →
35 Using Lookup Functions, Dynamic Arrays, and Formula Auditing 4 topics · 12 LiveLab +
- Topic A: Use Lookup Functions
- Topic B: Use Dynamic Arrays and Dynamic Array Functions
- Topic C: Trace Cells
- Topic D: Watch and Evaluate Formulas
12 LiveLab in this lesson — see the labs panel →
36 Forecasting Data 4 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
37 Creating Sparklines and Mapping Data 2 topics · 1 LiveLab +
- Topic A: Create Sparklines
- Topic B: Map Data
1 LiveLab in this lesson — see the labs panel →
38 Appendix A: Microsoft® Excel® 2021 Common Keyboard Shortcuts +
39 Appendix B: Cube Functions +
40 Appendix C: Importing and Exporting Data 1 topics +
- Topic A: Import and Export Data
41 Appendix D: Internationalizing Workbooks 1 topics +
- Topic A: Internationalize Workbooks
42 Appendix E: Working with Power Pivot 1 topics +
- Topic A: Work with Power Pivot
43 Appendix F: Advanced Customization Options 1 topics +
- Topic A: Customize Advanced Options
44 Appendix G: Working with Forms and Controls 1 topics +
- Topic A: Work with Forms and Controls
45 Appendix H: Using Array Formulas 1 topics +
- Topic A: Use Array Formulas
46 Getting Started with PowerPoint 2021 4 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
47 Developing a PowerPoint Presentation 4 topics · 12 LiveLab +
- Topic A: Create Presentations
- Topic B: Edit Text
- Topic C: Work with Slides
- Topic D: Design a Presentation
12 LiveLab in this lesson — see the labs panel →
48 Formatting Text 2 topics · 2 LiveLab +
- Topic A: Format Characters
- Topic B: Format Paragraphs
2 LiveLab in this lesson — see the labs panel →
49 Adding and Arranging Graphical Elements 5 topics · 8 LiveLab +
- 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
8 LiveLab in this lesson — see the labs panel →
50 Modifying Graphical Elements 6 topics · 7 LiveLab +
- 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
7 LiveLab in this lesson — see the labs panel →
51 Preparing to Deliver Your Presentation 4 topics · 6 LiveLab +
- Topic A: Review Your Presentation
- Topic B: Apply Transitions
- Topic C: Print or Export a Presentation
- Topic D: Deliver Your Presentation
6 LiveLab in this lesson — see the labs panel →
52 Appendix B: Guidelines for Presentation Design 2 topics +
- Appendix Introduction
- Topic A: Presentation Design Principles
53 Customizing Design Templates 4 topics · 10 LiveLab +
- 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
10 LiveLab in this lesson — see the labs panel →
54 Adding Tables 4 topics · 2 LiveLab +
- Topic A: Create a Table
- Topic B: Format a Table
- Topic C: Insert a Table from Other Microsoft Office Applications
- Summary
2 LiveLab in this lesson — see the labs panel →
55 Adding Charts 4 topics · 1 LiveLab +
- Topic A: Create a Chart
- Topic B: Format a Chart
- Topic C: Insert a Chart from Microsoft Excel
- Summary
1 LiveLab in this lesson — see the labs panel →
56 Working with Media 4 topics · 3 LiveLab +
- Topic A: Add Audio to a Presentation
- Topic B: Add Video to a Presentation
- Topic C: Add a Screen Recording
- Summary
3 LiveLab in this lesson — see the labs panel →
57 Building Advanced Transitions and Animations 3 topics · 5 LiveLab +
- Topic A: Use the Morph Transition
- Topic B: Customize Animations
- Summary
5 LiveLab in this lesson — see the labs panel →
58 Finalizing a Presentation 5 topics · 4 LiveLab +
- Topic A: Review a Presentation
- Topic B: Enhance a Live Presentation
- Topic C: Record a Presentation
- Topic D: Set Up a Slide Show
- Summary
4 LiveLab in this lesson — see the labs panel →
59 Modifying Presentation Navigation 4 topics · 3 LiveLab +
- Topic A: Divide a Presentation into Sections
- Topic B: Add Links
- Topic C: Create a Custom Slide Show
- Summary
3 LiveLab in this lesson — see the labs panel →
60 Securing and Distributing a Presentation 3 topics · 1 LiveLab +
- Topic A: Secure a Presentation
- Topic B: Create Digital Media
- Summary
1 LiveLab in this lesson — see the labs panel →
61 Appendix A: Microsoft®PowerPoint® Common Keyboard Shortcuts +
62 Appendix B: Using Ink to Hand Draw Elements 2 topics +
- Topic A: Draw Objects
- Topic B: Write Math Equations
63 Getting Started with Access 2021 6 topics · 7 LiveLab +
- 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
7 LiveLab in this lesson — see the labs panel →
64 Creating Tables 4 topics · 4 LiveLab +
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
4 LiveLab in this lesson — see the labs panel →
65 Creating Queries 3 topics · 7 LiveLab +
- Topic A: Create Basic Queries
- Topic B: Perform Calculations in a Query
- Topic C: Sort and Filter Data in a Query
7 LiveLab in this lesson — see the labs panel →
66 Creating Forms 2 topics · 4 LiveLab +
- Topic A: Start a New Form
- Topic B: Enhance a Form
4 LiveLab in this lesson — see the labs panel →
67 Creating Reports 2 topics · 3 LiveLab +
- Topic A: Start a New Report
- Topic B: Enhance Report Layout
3 LiveLab in this lesson — see the labs panel →
68 Appendix A: Microsoft® Office Access® 2021 Common Keyboard Shortcuts +
Hands-On Labs Our edge
254 LiveLabs- 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
- 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
- Using Find and Replace to Edit
- Copying Paragraph Formatting Using Format Painter
- Creating a New Style
- Applying the Heading Style
- Sorting the Contents of a Table
- Changing a Bulleted List to a Numbered List
- Inserting a Table
- Formatting a Table
- Inserting a Symbol
- Inserting and Formatting a Picture
- Creating a Chart
- Adding a SmartArt
- Inserting a Shape
- Inserting a 3D Model
- Creating Header and Footer
- Controlling Page Layout
- Adding a Watermark to 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
- 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
- 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
- Using the Building Blocks Organizer Dialog Box
- Creating and Renaming a Building Block
- Creating a Footer
- Creating a Document Using a Template
- Adding a Text Placeholder
- 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
- 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
- Performing a Mail Merge
- Creating an Envelope Document
- Exporting Ribbon Customizations as a File
- Adding and Replacing Data in a Cell
- Creating and Saving a Workbook
- Copying and Pasting the Data
- Creating Worksheet Formulas
- Determining the Minimum Value
- Determining the Maximum Value
- Reusing Formulas
- Calculating the Sum
- Calculating the Average
- Hiding the Columns
- Deleting a Column
- Inserting a Cell Range
- Deleting a Row
- Hiding the Rows
- Adjusting the Columns
- Adding a Hyperlink
- Applying Fill Color
- Adding Borders
- Trimming the Decimal Places
- Adding the Date to a Worksheet
- Creating a Template
- Adding the Page Number to the Worksheet
- 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
- 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
- Filtering the Data for all Employees
- Creating a Custom Filter
- Using Database Functions
- Converting the Data into a Table
- Applying a Quick Style to a Table
- Adding New Entries to a Table
- 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
- 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
- Creating Links
- Creating External Links
- Creating a 3-D Formula
- Consolidating Data
- 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
- 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
- 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
- Creating a Two-Variable Data Table
- Creating a Forecast Sheet
- Creating Sparklines
- Using Underline in the Title Text
- Inserting Content into a Placeholder
- Creating and Saving a Basic 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
- Using the Mini Toolbar to Change the Color of the Text on a Slide
- Changing the Bullet Style
- 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
- 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
- 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
- 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
- Creating a Table
- Formatting a Table
- Formatting a Chart
- Adding the Playback Settings to a Video
- Adding the Video Style
- Adding a Screen Recording
- 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
- Comparing the Presentations
- Adding a Comment to a Slide
- Annotating a Presentation
- Recording a Presentation
- Adding and Managing Sections
- Adding an Action Button
- Creating and Modifying a Custom Slide Show
- Packaging a Presentation
- 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
- Creating a New Database
- Creating a New Table
- Preparing Keys for Table Relationships
- Establishing Table Relationships
- 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
- 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
- Creating a Simple Report
- Using the Report Wizard
- Enhancing a Report Layout
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Prepare for Microsoft Office 365
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
- 254 LiveLab included
- Certificate of completion
No credit card required