Contents

Introduction

Who this book is for

The Step by Step approach

Download the practice files

Ebook edition

Get support and give feedback

Errata and support

We want to hear from you

Stay in touch

Part 1: Microsoft Office 2016

1 Explore Office 2016

Work in the Office user interface

Identify app window elements

Sidebar: Tell me what you want to do

Work with the ribbon and status bar

Sidebar: Adapt exercise steps

Change Office and app options

Manage account information

Manage app options

Customize the Quick Access Toolbar

Customize the ribbon

Skills review

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

Sidebar: Save files to OneDrive

Skills review

Practice tasks

Part 2: Microsoft Word 2016

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

Skills review

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

Sidebar: Restrict access by using rights management

Coauthor documents

Skills review

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

Skills review

Practice tasks

Part 3: Microsoft Excel 2016

6 Perform calculations on data

Name groups of data

Define Excel tables

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

Skills review

Practice tasks

7 Manage worksheet data

Limit data that appears on your screen

Manipulate worksheet data

Sidebar: 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

Skills review

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

Skills review

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

Skills review

Practice tasks

Part 4: Microsoft PowerPoint 2016

10 Create and manage slides

Add and remove slides

Insert new slides

Copy and import slides and content

Sidebar: SharePoint slide libraries

Hide and delete slides

Divide presentations into sections

Rearrange slides and sections

Apply themes

Change slide backgrounds

Sidebar: Non-theme colors

Skills review

Practice tasks

11 Insert and manage simple graphics

Insert, move, and resize pictures

Sidebar: Graphic formats

Edit and format pictures

Draw and modify shapes

Draw and add text to shapes

Sidebar: Locate additional formatting commands

Move and modify shapes

Format shapes

Sidebar: Connect shapes

Capture and insert screen clippings

Create a photo album

Skills review

Practice tasks

12 Add sound and movement to slides

Animate text and pictures on slides

Sidebar: Animate this

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

Skills review

Sidebar: Hyperlink to additional resources

Practice tasks

Part 5: Microsoft Outlook 2016

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

Skills review

Practice tasks

14 Organize your Inbox

Display and manage conversations

Arrange messages by specific attributes

Categorize items

Sidebar: Store information in Outlook notes

Organize messages in folders

Sidebar: Print messages

Skills review

Practice tasks

15 Manage scheduling

Schedule appointments and events

Sidebar: Add holidays to your calendar

Convert calendar items

Configure calendar item options

Schedule and change meetings

Respond to meeting requests

Display different views of a calendar

Sidebar: Use the Date Navigator

Skills review

Practice tasks

Index

About the authors