Microsoft Office 2010 QuickSteps | QuickSteps

Microsoft Office 2010 QuickSteps

Authors: Carole Matthews, Marty Matthews and John Cronan

Published: July 2010

eISBN: 9780071741613 0071741615 | ISBN: 9780071741606

Contents

Acknowledgments

Introduction

Chapter 1 Stepping into Office

Start and Leave an Office Program

Use the Start Menu to Start Office

Start an Office Program in Different Ways

Leaving an Office Program

Explore an Office Program

Understanding the Ribbon

Explore an Office Program Window

Use the Mouse

Using the Mini Toolbar

Use Tabs and Menus

Use Various Views

Personalize and Customize Office 2010 Programs

Work with the Quick Access Toolbar

Show or Hide Screen Tips

Changing the Screen Color

Add Identifying Information

Setting Preferences

Get Help

Open Help

Using the Help Toolbar

Do Research

Use the Thesaurus

Translate a Document

Accessing Microsoft Resources

Understanding Web Apps

Update Your Office Program

Use Web Apps for Office Programs

Use SkyDrive

Understanding SkyDrive Folders

Chapter 2 Working with Documents

Create a New Document

Start a New Document

Use a Unique Template

Open an Existing Document

Locate an Existing Document

Open a Recent Document

Search for an Existing Document

Import a Document

Entering Special Characters

Write a Document

Enter Text

Determine Where Text Will Appear

Insert Text or Type Over It

Insert Line or Page Breaks

Select Text

Using the Office Clipboard

Copy and Move Text

Delete Text

Edit a Document

Move Around in a Document

Find and Replace Text

Using Wildcards

Complete and Save a Document

Check Spelling and Grammar

Saving a Document

Save a Document for the First Time

Editing Documents in the Word Web App

Save a Document Automatically

Chapter 3 Formatting a Document

Format Text

Apply Character Formatting

Using the Font Dialog Box

Set Character Spacing

Change Capitalization

Create a Drop Cap

Format a Paragraph

Set Paragraph Alignment

Using Indentation

Indent a Paragraph

Using the Ruler for Indents

Determine Line and Paragraph Spacing

Use Numbered, Bulleted, and Multilevel Lists

Add Borders and Shading

Turning On Formatting Marks

Format a Page

Set Margins

Copying Formatting

Use a Dialog Box to Format a Page

Use Mirror Margins

Determine Page Orientation

Tracking Inconsistent Formatting

Specify Paper Size

Set Vertical Alignment

Chapter 4 Customizing a Document

Understanding Themes, Styles, and Templates

Use Styles

Work with Styles

Deleting a Style

Use Themes

Use Templates

Create and Change Templates

Work with Documents

Create Section Breaks

Create and Use Columns

Use Tabs

Add Headers and Footers

Using Different Left and Right Headers

Add Footnotes and Endnotes

Create an Index

Create a Table of Contents

Create and Use Outlines

Using View Buttons

Use Word Writing Aids

Use AutoCorrect and AutoFormat

Use Building Blocks

Enter an Equation

Count Characters and Words

Use Highlighting

Add Hyphenation

Exploring the Thesaurus

Chapter 5 Entering and Editing Data

Understanding Data Types

Enter Data

Enter Text

Enter Numeric Data

Completing an Entry

Enter Dates

Understanding Excel Dates and Times

Use Times

Format Numbers

Adding Data Quickly

Edit Data

Edit Cell Data

Remove Cell Contents

Selecting Cells and Ranges

Copy and Paste Data

Find and Replace Data

Editing Workbooks in the Excel Web App

Verify Spelling

Modify Automatic Corrections

Chapter 6 Formatting a Worksheet

Adding and Removing Rows, Columns, and Cells

Work with Cells, Rows, and Columns

Adjust Row Height

Adjust Column Width

Hide and Unhide Rows and Columns

Change Cell Borders

Add a Comment

Formatting Comments

Apply Formatting

Apply Themes

Understanding Excel Formatting

Create Custom Themes

Searching for Themes

Use Cell Styles

Change Fonts

Change Alignment and Orientation

Add a Background

Copy Formatting

Arrange and Organize Worksheets

Lock Rows and Columns

Split a Worksheet

Working with Worksheets

View Worksheets from Multiple Workbooks

Compare Workbooks

Chapter 7 Using Formulas and Functions

Understanding Cell Referencing Types

Reference Cells

Change Cell References

Change to R1C1 References

Name Cells

Using Cell Reference Operators

Go to a Named Cell

Use the Name Manager

Build Formulas

Create a Formula

Adding a Symbolic Formula

Edit a Formula

Using Formulas

Move Formulas

Copy Formulas

Recalculate Formulas

Use External References in Formulas

Understanding the Trust Center

Format Conditionally

Using Functions Quickly

Use Functions

Enter a Function

Enter a Sum in Columns or Rows Quickly

Find and Correct Errors

Check for Errors

Trace Precedent and Dependent Cells

Watch a Cell

Evaluate a Formula in Pieces

Chapter 8 Creating the Presentation

Defining Themes, Layouts, and Master Slides

Create a Presentation

Create a Presentation from Another Presentation

Create a Presentation Using a Standard Theme

Create a Template

Working with Themes

Create a Presentation from Scratch

Select a Layout

Adding Content to a Slide

Outline a Presentation

Create an Outline

Insert an Outline from Other Sources

Understanding the Outlining Feature

Preview and Print the Outline

Indenting with the Keyboard

Using the Outlining Commands

Protecting Your Presentation

Set Passwords for a Presentation

Remove Password Restrictions

Strip File Information from the Presentation

Chapter 9 Working with Slides

Navigate and Manipulate Slides

Navigating with the Keyboard

Navigate from Slide to Slide

Insert a Slide

Display Multiple Presentations at Once

Duplicate a Slide

Copy a Design Using Browse

Moving or Copying Slides

Use Zoom

Using a Keyboard with Slides

Change the Look and Feel of Slides

Change a Theme

Create a Custom Theme

Copy Attributes with Format Painter

Using Footers on Slides

Work with Hyperlinks

Chapter 10 Working with Notes, Masters, and Slide Text

Work with Notes

Create a Note

Preview Speaker Notes

Print Notes and Handouts

Using Headers and Footers on Notes and Handouts

Work with Slide, Note, and Handout Masters

Manage Slide Appearance

Changing Font Attributes

Working with Slide Masters

Work with the Notes Master

Change the Handout Master

Work with Text

Use a Text Layout

Insert a New Text Box

Work with Text Boxes

Setting Margins, Word Wrap, AutoFit, and Columns

Using Lists

Use the Font Dialog Box

Align Text

Editing with the Keyboard

Moving or Copying Text

Copy Formatting with Format Painter

Use AutoCorrect

Using the Office Clipboard

Use the Spelling Checker

Chapter 11 Using Outlook and Receiving E-mail

Explore Outlook

Explore the Outlook Window

Change Views

Use the Navigation Pane

Use Outlook Today

Customize the To-Do Bar

Find a Message

Set Up E-mail

Get Online

Use the Startup Wizard

Upgrade to Outlook

Getting a Gmail Account

Receive E-mail

Check for E-mail

Read E-mail

Download Sender and Subject Information Only

Filter Junk Mail

Handle E-mail Messages

Mark Messages as Read or Unread

Change the Time for Being Read

Flag Your Messages for Follow-up

Arrange Messages in a Folder

Manipulating the Rules

Make Up Your Own Rules

Delete Messages

Archiving Messages

Manage Attachments

Print Messages

Chapter 12 Creating and Sending E-mail

Write Messages

Create a Message

Address a Message

Use a Contact Group

Add Carbon and Blind Copies

Edit a Message

Use Stationery

Formatting Messages

Attach Files

Including Hyperlinks

Sign Messages

Using Signatures

Use Digital Signatures

Check Spelling

Send Messages

Change the From Address

Reply to Messages

Forward Messages

Sending Messages

Set Message Priority

Request Receipts

Delay Delivery with a Rule

Chapter 13 Scheduling and the Calendar

Explore the Calendar

Create Calendar Appointments and Tasks

Customize the Calendar

Navigating the Calendar

Using the Navigation and Reading Panes

Customize Calendar Views

Set Up the Calendar

Maintain Multiple Calendars

Share a Calendar

Use the Calendar

Create Appointments

Understanding Internet Calendars

Entering Dates and Times

Enter Recurring Appointments

Move Appointments

Use Reminders

Print Calendars

Plan Meetings and Request Attendance

Schedule a Meeting

Respond to an Invitation

Chapter 14 Printing, Using Mail Merge, and Graphics

Print Documents

Set a Default Printer

Define How a Document Is Printed

Print a Document

Print an Envelope in Word

Print Labels in Word

E-Mailing

Merge Lists with Letters and Envelopes

Begin a Mail Merge

Set Up a Name and Address List

Create a Merge Document

Preview a Merge

Using Rules

Complete a Merge

Linking Picture Files

Work with Pictures

Add Pictures

Using the Picture Tools Format Tab

Remove Unwanted Areas

Add Shapes

Create a Diagram

Modify Graphics

Resize and Rotate Graphics Precisely

Understanding Graphic Positioning in Word

Position Graphics

Use Handles and Borders to Position Graphics

Working with Graphics

Combine Graphics by Grouping

Index