Navigate in Microsoft Word

Create and Save Word Documents

Manage Your Workspace

Edit Documents

Preview and Print Documents

Customize the Word Environment

Apply Character Formatting

Control Paragraph Layout

Align Text Using Tabs

Display Text in Bulleted or Numbered Lists

Apply Borders and Shading

Make Repetitive Edits

Apply Repetitive Formatting

Use Styles to Streamline Repetitive Formatting Tasks

Sort a List

Format a List

Insert a Table

Modify a Table

Format a Table

Convert Text to a Table

Insert Symbols and Special Characters

Add Images to a Document

Apply a Page Border and Color

Add Headers and Footers

Control Page Layout

Add a Watermark

Check Spelling, Grammar, and Readability

Use Research Tools

Check Accessibility

Save a Document to Other Formats

Sort Table Data

Control Cell Layout

Perform Calculations in a Table

Create a Chart

Add an Excel Table to a Word Document (Optional)

Create and Modify Text Styles

Create Custom List or Table Styles

Apply Document Themes

Insert Building Blocks

Create and Modify Building Blocks

Insert Fields Using Quick Parts

Create a Document Using a Template

Create and Modify a Template

Manage Templates with the Template Organizer

Control Paragraph Flow

Insert Section Breaks

Insert Columns

Link Text Boxes to Control Text Flow

Insert Blank and Cover Pages

Insert an Index

Insert a Table of Contents

Insert an Ancillary Table

Manage Outlines

Create a Master Document

Use Mail Merge

Merge Envelopes and Labels

Use Excel Commands

Create and Save a Basic Workbook

Enter Cell Data

Use Excel Help

Create Worksheet Formulas

Insert Functions

Reuse Formulas and Functions

Insert, Delete, and Adjust Cells, Columns, and Rows

Search for and Replace Data

Use Proofing and Research Tools

Apply Text Formats

Navigate the Excel User Interface

Apply Number Formats

Align Cell Contents

Apply Styles and Themes

Apply Basic Conditional Formatting

Create and Use Templates

Preview and Print a Workbook

Set Up the Page Layout

Configure Headers and Footers

Manage Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

Work with Ranges

Use Specialized Functions

Work with Logical Functions

Work with Date and Time Functions

Work with Text Functions

Sort Data

Filter Data

Query Data with Database Functions

Outline and Subtotal Data

Create and Modify Tables

Apply Intermediate Conditional Formatting

Apply Advanced Conditional Formatting

Create Charts

Modify and Format Charts

Use Advanced Chart Features

Create a PivotTable

Analyze PivotTable Data

Present Data with PivotCharts

Filter Data by Using Timelines and Slicers