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

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

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

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

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

• 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

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

Sort worksheet data
Sort data by using custom lists
Organize data into levels
Look up information in a worksheet
Key points
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
Key points

Practice tasks

• 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

• 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

• 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