Home Page Icon
Home Page
Table of Contents for
Survey
Close
Survey
by Curtis Frye, Joan Lambert
Microsoft Office 2016 Step by Step
Cover
Title Page
Copyright Page
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
Work with the ribbon and status bar
Change Office and app options
Manage account information
Manage app options
Customize the Quick Access Toolbar
Customize the ribbon
Skills review
Practice tasks
Work in the Office user interface
Change Office and app options
Customize the Quick Access Toolbar
Customize the ribbon
2. Create and manage files
Create files
Open and move around in files
Display different views of files
Display and edit file properties
Save and close files
Skills review
Practice tasks
Create files
Open and move around in files
Display different views of files
Display and edit file properties
Save and close files
Part 2: Microsoft Word 2016
3. Modify the structure and appearance of text
Apply paragraph formatting
Configure alignment
Configure vertical spacing
Configure indents
Structure content manually
Apply character formatting
Create and modify lists
Apply built-in styles to text
Apply styles
Manage outline levels
Change the document theme
Skills review
Practice tasks
Apply paragraph formatting
Structure content manually
Apply character formatting
Create and modify lists
Apply built-in styles to text
Change the document theme
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
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
Skills review
Practice tasks
Mark up documents
Display and review document markup
Compare and merge documents
Control content changes
Coauthor documents
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
Insert merge fields
Preview and complete the merge
Create individual envelopes and labels
Generate individual envelopes
Generate individual mailing labels
Skills review
Practice tasks
Understand the mail merge process
Start the mail merge process
Choose and refine the data source
Insert merge fields
Preview and complete the merge
Create individual envelopes and labels
Part 3: Microsoft Excel 2016
6. Perform calculations on data
Name groups of data
Define Excel tables
Create formulas to calculate values
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
Name groups of data
Create formulas to calculate values
Define Excel tables
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
7. Manage worksheet data
Limit data that appears on your screen
Manipulate worksheet data
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
Limit data that appears on your screen
Manipulate worksheet data
Define valid sets of values for ranges of cells
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
Sort worksheet data
Sort data by using custom lists
Organize data into levels
Look up information in a worksheet
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
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
Part 4: Microsoft PowerPoint 2016
10. Create and manage slides
Add and remove slides
Insert new slides
Copy and import slides and content
Hide and delete slides
Divide presentations into sections
Rearrange slides and sections
Apply themes
Change slide backgrounds
Skills review
Practice tasks
Add and remove slides
Divide presentations into sections
Rearrange slides and sections
Apply themes
Change slide backgrounds
11. Insert and manage simple graphics
Insert, move, and resize pictures
Edit and format pictures
Draw and modify shapes
Draw and add text to shapes
Move and modify shapes
Format shapes
Capture and insert screen clippings
Create a photo album
Skills review
Practice tasks
Insert, move, and resize pictures
Edit and format pictures
Draw and modify shapes
Capture and insert screen clippings
Create a photo album
12. Add sound and movement to slides
Animate text and pictures on slides
Customize animation effects
Add audio content to slides
Add video content to slides
Compress media to decrease file size
Skills review
Practice tasks
Animate text and pictures on slides
Customize animation effects
Add audio content to slides
Add video content to slides
Compress media to decrease file size
Part 5: Microsoft Outlook 2016
13. Send and receive email messages
Create and send messages
Create messages
Troubleshoot message addressing
Save and send messages
Attach files and Outlook items to messages
Display messages and message attachments
Display message content
Display attachment content
Display message participant information
Respond to messages
Skills review
Practice tasks
Create and send messages
Attach files and Outlook items to messages
Display messages and message attachments
Display message participant information
Respond to messages
14. Organize your Inbox
Display and manage conversations
Arrange messages by specific attributes
Categorize items
Organize messages in folders
Skills review
Practice tasks
Display and manage conversations
Arrange messages by specific attributes
Categorize items
Organize messages in folders
15. Manage scheduling
Schedule appointments and events
Convert calendar items
Configure calendar item options
Schedule and change meetings
Respond to meeting requests
Display different views of a calendar
Skills review
Practice tasks
Schedule appointments and events
Convert calendar items
Configure calendar item options
Schedule and change meetings
Respond to meeting requests
Display different views of a calendar
Index
About the authors
Acknowledgments
Survey
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Microsoft Office 2016 Step by Step
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset