Contents

About the authors

i Introduction

Who this book is for

The Step by Step approach

Features and conventions

Download the practice files

E-book edition

Get support and give feedback

Errata and support

Stay in touch

Part 1: Microsoft Office 2019

1 Explore Office 2019

Work in the Office user interface

Identify app window elements

Work with the ribbon and status bar

Sidebar: Adapt procedures for your environment

Change Office and app options

Manage account information

Sidebar: Microsoft account options

Manage app options

Customize the Quick Access Toolbar

Customize the ribbon

Get help and provide feedback

Key points

Practice tasks

2 Create and manage files

Create files

Open and move around in files

Display different views of files

Display and edit file properties

Sidebar: File types and compatibility with earlier versions of Office apps

Save and close files

Key points

Sidebar: Save files to OneDrive

Practice tasks

Part 2: Microsoft Word 2019

3 Modify the structure and appearance of text

Apply paragraph formatting

Configure alignment

Configure vertical spacing

Configure indents

Sidebar: Configure paragraph borders and shading

Structure content manually

Apply character formatting

Sidebar: Character formatting and case considerations

Create and modify lists

Sidebar: Format text as you type

Apply built-in styles to text

Apply styles

Manage outline levels

Change the document theme

Key points

Practice tasks

4 Collaborate on documents

Mark up documents

Insert comments

Track changes

Display and review document markup

Display markup

Review and respond to comments

Review and process tracked changes

Sidebar: Remember to check for errors

Compare and merge documents

Compare and combine separate copies of a document

Compare separate versions of a document

Control content changes

Restrict actions

Restrict access by using a password

Coauthor documents

Key points

Practice tasks

5 Merge data with documents and labels

Understand the mail merge process

Start the mail merge process

Get started with letters

Get started with labels

Get started with email messages

Choose and refine the data source

Select an existing data source

Create a new data source

Refine the data source records

Sidebar: Refresh data

Insert merge fields

Preview and complete the merge

Create individual envelopes and labels

Generate individual envelopes

Generate individual mailing labels

Key points

Practice tasks

Part 3: Microsoft Excel 2019

6 Perform calculations on data

Name groups of data

Create formulas to calculate values

Sidebar: Operators and precedence

Summarize data that meets specific conditions

Set iterative calculation options and enable or disable automatic calculation

Use array formulas

Find and correct errors in calculations

Key points

Practice tasks

7 Manage worksheet data

Limit data that appears on your screen

Manipulate worksheet data

Select list rows at random

Summarize data in worksheets that have hidden and filtered rows

Find unique values within a data set

Define valid sets of values for ranges of cells

Key points

Practice tasks

8 Reorder and summarize data

Sort worksheet data

Sort data by using custom lists

Organize data into levels

Look up information in a worksheet

Key points

Practice tasks

9 Analyze alternative data sets

Examine data by using the Quick Analysis Lens

Define an alternative data set

Define multiple alternative data sets

Analyze data by using data tables

Vary your data to get a specific result by using Goal Seek

Find optimal solutions by using Solver

Analyze data by using descriptive statistics

Key points

Practice tasks

Part 4: Microsoft PowerPoint 2019

10 Create and manage slides

Add and remove slides

Insert new slides

Copy and import slides and content

Hide and delete slides

Apply themes

Change slide backgrounds

Sidebar: Non-theme colors

Divide presentations into sections

Rearrange slides and sections

Key points

Practice tasks

11 Insert and manage simple graphics

Insert, move, and resize pictures

Sidebar: Graphic formats

Edit and format pictures

Provide additional information about pictures

Create a photo album

Capture and insert screen clippings

Insert and format icons

Sidebar: Work with scalable vector graphics

Draw and modify shapes

Draw and add text to shapes

Sidebar: Locate additional formatting commands

Move and modify shapes

Format shapes

Sidebar: Connect shapes

Key points

Practice tasks

12 Add sound and movement to slides

Animate text and pictures on slides

Sidebar: Animate this

Sidebar: Morphing slide content into new forms

Customize animation effects

Sidebar: Bookmark points of interest in media clips

Add audio content to slides

Add video content to slides

Compress media to decrease file size

Sidebar: Hyperlink to additional resources

Key points

Practice tasks

Part 5: Microsoft Outlook 2019

13 Send and receive email messages

Create and send messages

Create messages

Troubleshoot message addressing

Save and send messages

Sidebar: Send from a specific account

Attach files and Outlook items to messages

Sidebar: New mail notifications

Display messages and message attachments

Display message content

Display attachment content

Display message participant information

Respond to messages

Sidebar: Resending and recalling messages

Key points

Practice tasks

14 Organize your Inbox

Display and manage messages

Select the primary Inbox content

Display and manage conversations

Arrange messages by specific attributes

Categorize items

Sidebar: Store information in Outlook notes

Organize messages in folders

Sidebar: Print messages

Key points

Practice tasks

15 Manage scheduling

Display different views of a calendar

Sidebar: Use the Date Navigator

Schedule appointments and events

Convert calendar items

Sidebar: Add holidays to your calendar

Configure calendar item options

Schedule and change meetings

Respond to meeting requests

Key points

Practice tasks

Appendix: Define Excel tables

Index