Microsoft 365 Office

Getting Your Bearings

• Changing the Heading Style

Populating Documents with Text

• Changing the Capitalization of a Text
• Inserting a Symbol
• Copying and Saving a Text
• Changing the Text Color
• Changing the Font Style and Font Size
• Formatting the Text to Italic
• Formatting the Text to Bold

Becoming Enviously Efficient

• Setting the Zoom Level of a Document
• Checking the Spelling Automatically

Making Office 365 Your Own

• Exporting Ribbon Customizations as a File

Handling Graphics and Photos

• Inserting a Shape
• Adding a SmartArt
• Applying a Shape Style
• Applying a Gradient Fill to the Shape

Getting Up to Speed with Word

• Creating and Saving a Document

Laying Out Pages Just So

• Indenting the First Line of a Paragraph
• Creating a Bulleted List
• Setting the Tab Stop
• Enabling Automatic Hyphenation

Making Looking Good Look Easy: Styles

• Creating a New Style
• Modifying the Text Style
• Creating a Document Using a Template

Building a Table with Your Bare Hands

• Inserting a Table
• Sorting the Contents of a Table
• Creating and Applying the New Table Style
• Merging the Cells and Alignment of the Column

Polishing Your Prose

• Configuring Spelling and Grammar Options
• Using the Thesaurus Tool
• Using Find and Replace to Edit

Designing Fancy-Schmancy Documents

• Applying a Customized Theme
• Adding a Watermark to a Document
• Formatting the Text into Columns
• Linking the Text Box to another Text Box
• Controlling Page Layout

Printing Envelopes and Labels

• Creating an Envelope Document
• Performing a Mail Merge

Advanced (But Useful) Document Design

• Creating an Outline
• Promoting and Demoting Topics
• Inserting a Table of Contents
• Creating a Table of Figures
• Marking Legal Citations
• Indexing a Document

Excel: The 50-Cent Tour

• Creating and Saving a Workbook

Sprucing Up a Worksheet

• Adjusting the Columns
• Hiding the Rows
• Hiding the Columns

Fiddling with Your Worksheets

• Adding and Replacing Data in a Cell
• Deleting a Row
• Inserting a Cell Range
• Freezing the Top Row
• Copying and Pasting the Data

Taming Your Worksheets

• Deleting a Column
• Adding Color to the Worksheet Tab
• Making a Copy of the Worksheet
• Adding a New Worksheet
• Hiding a Worksheet
• Deleting a Worksheet

Building Basic Formulas

• Creating Worksheet Formulas
• Calculating the Sum
• Using the TODAY Function
• Adding the Arguments for the IF Portion of the Nested Function
• Creating Named Ranges
• Editing Range Names

Analyzing Data

• Creating a Forecast Sheet
• Converting the Data into a Table
• Adding Fields to the PivotTable

Visualizing Data with Charts

• Creating the Combo Chart
• Changing the Chart Type
• Changing the Labels of the Line Chart

Automating Excel with Copilot

• Using the MATCH Function
• Using the INDEX Function
• Using the VLOOKUP Function
• Using the HLOOKUP Function
• Using the SORT Function
• Using the FILTER Function
• Creating Sparklines

Putting Together a PowerPoint Presentation

• Creating and Saving a Basic Presentation
• Moving a Slide in the Normal View
• Arranging a Slide in the Slide Sorter View
• Inserting a New Slide into the Presentation
• Reusing Slides from Another Presentation
• Inserting Content into a Placeholder
• Inserting an Image from the Desktop
• Modifying the Slide Layout
• Hiding a Slide

Formatting Slides

• Applying a New Theme to the Slide Master
• Modifying the Background Style of the Slide Master
• Converting Text to a SmartArt Graphic
• Using Underline in the Title Text
• Using the Mini Toolbar to Change the Color of the Text on a Slide

Creating Dynamic Presentations

• Applying the Morph Transition to a Shape
• Applying and Modifying Animation Effects to a Graphic
• Animating a SmartArt Graphic
• Adding an Action Button

Delivering a Presentation

• Recording a Presentation
• Creating and Modifying a Custom Slide Show
• Annotating a Presentation

Sending and Receiving Email

• Logging into Microsoft Outlook
• Marking Messages as Read/Unread in Microsoft Outlook
• Creating an Email Signature in Microsoft Outlook
• Working with Microsoft Teams Notifications and Appearance Settings
• Setting Automatic Out-of-Office Replies in Microsoft Outlook

Managing Your Contacts

• Sorting and Exporting Contacts in Microsoft Outlook
• Sorting and Exporting Contacts in Microsoft Outlook
• Managing and Importing Contacts in Microsoft Outlook
• Exploring Copilot's Features
• Creating and Managing Channels

Keeping Track of Appointments

• Changing the Calendar Color
• Creating an Appointment
• Creating a Recurring Task

Forging Databases and Tables

• Creating a New Database
• Creating a New Table
• Creating a Form by Using the Form Wizard

Entering, Sorting, and Filtering Data

• Adding a Total Row to a Datasheet
• Revising and Entering Table Data
• Sorting and Filtering Records
• Preparing Keys for Table Relationships
• Establishing Table Relationships

Querying Data

• Creating a Query Using Query Design
• Using Queries
• Filtering a Query Using Dates
• Filtering a Query Using a Comparison Operator
• Performing Calculations in a Query
• Sorting a Query and Reordering Fields

Getting around in Teams

Getting Up to Speed with Teams and Channels

• Creating a Teams

Chin-wagging with Channels and Chats

Fiddling with Files in Teams

Getting Together for Online Meetings

• Scheduling Meetings in Microsoft Teams

Sharing Files

• Logging into OneDrive

Making the Most of OneDrive

• Navigating and Sharing Files in OneDrive

Collaborating in SharePoint

• Creating and Managing SharePoint Team Sites

Collaborating on Documents

• Managing Comments in Microsoft Word