# (pound sign):in Microsoft Excel worksheet cells

Change the Way Text and Data Look
Use the Best Number Format

= (equal sign) in worksheet formulas

Enter a Formula to Calculate a Value

35mm slides

Create Printed Materials

3-D charts

Find the Best Chart Type for Your Data
Customize the Look of a Chart
Formatting a 3-D Chart

3-D references

Consolidate the Combined Input

A

 

abstracts, drafting with AutoSummarize

Make Writing Easier

accessibility for people with disabilities

Accessibility for People with Disabilities

action items

Take Notes and Track Action Items on Screen

actions, macro

Create a Macro to Display a Message

active settings

Branch to Other Locations

add-ins

Look Up Information in the Built-in Index or Contents
Create a Form for Online Invoices
Display Data on a Map
Analyze Data from an Experiment
Get Sales Information from a Database

address books, electronic

Start the Letter Wizard When You’re Ready
Set Up the Page and Type the Standard Text
Prepare Your Document for Faxing
Specify or Create the Mailing List
Print Addresses on Mailing Labels
Write a Cover Letter

addresses

Start the Letter Wizard When You’re Ready
Print an Envelope
Set Up the Page and Type the Standard Text
Prepare Your Document for Faxing
Print Addresses on Mailing Labels
Create a Business Contact List in Microsoft Excel
What Should Your List Contain?
Write a Cover Letter
Where Should You Store Your Contact Information?
Can I Move My Contact Data to Another Application?

alarms, in cell formatting

Build Alarms into Your Model

aligning

Change the Appearance of Text
Text Spacing and Alignment
Adjust the Spacing and Alignment of Data

Analysis ToolPak

Analyze Data from an Experiment
Set Up Your Data
Run the Analysis

analysis, statistical

Analyze Data from an Experiment

Analyze It With MS Excel button

What Method Should You Use to Analyze Your Sales Data?

analyzing data

Analyze Data from an Experiment
What Method Should You Use to Analyze Your Sales Data?
Create a Sales Summary from a Microsoft Access Database

animating charts

Modify the Chart

animations, slide

Create Audience Handouts
Prepare for an Electronic Presentation
Prepare Animations and Slide Transitions
Use Slide Sorter View

Anova (statistical analysis of variance)

Analyze Data from an Experiment

applications

Install and Start Microsoft Office
Add or Remove Components
Start and Quit an Office Application
Use Office Applications Together
Customize Office
What’s the Best Way to Create a Form?
Add a Chart That Stays Up-To-Date
Transfer Information Between PowerPoint and Other Applications
Branch to Other Locations
Where Should You Store Your Contact Information?
Can I Move My Contact Data to Another Application?
Turn Your Inventory Database into an Application
What Method Should You Use to Analyze Your Sales Data?

appointments

Schedule a Conference Call
Add Activities to the Calendar
Schedule an Appointment
Print the Calendar

area charts

Find the Best Chart Type for Your Data

Arial font

Fonts, Bold, Italic, and Other Text Enhancements

arrays

Determine Sales Trends

arrow keys

Move Around in the Document

arrows:adding to charts

Title the Chart and Its Axes

arrows:adding to worksheets

Emphasize Important Data

attaching database tables

Use Data from Other Applications or Databases

attaching documents to electronic mail messages

Send a Document

AutoComplete feature

Enter Your Contact Information

AutoContent Wizard

Create a New Presentation
Enter Your Own Text

AutoCorrect feature:in Microsoft Access

Check Spelling and Correct Mistakes

AutoCorrect feature:in Microsoft Excel

Enter Your Contact Information

AutoCorrect feature:in PowerPoint

Check for Errors

AutoCorrect feature:in Word

Check Spelling and Grammar
Add Text to Your Document

AutoFill feature

Enter Data Automatically
Enter Your Contact Information
Consolidate the Combined Input
Determine Sales Trends

AutoFilter feature

Zero In on the Contacts You Want
Find the Over- and Under-Budget Areas
Select Products that Meet Profit Requirements
Subtotal Each Region

AutoForm feature

Make It Easier to Read Records

AutoFormat feature

Change the Way Text and Data Look
Let Word Do the Formatting for You
Reuse Your Custom Formatting
Don’t Want to Spend Time Formatting Manually?
Insert a Word Outline
Emphasize Important Information
Make Formatting Easy
Finish by Adding a Table of Contents

automatic spelling checking

Check Spelling and Grammar

automatic subtotals

Subtotal Each Region

automatic word selection

Select the Text You Want to Change

AutoShape feature

Create AutoShapes
Manipulate Objects

AutoSum feature

Enter a Formula to Calculate a Value

AutoSummarize feature

Make Writing Easier

AutoText feature

Add Text to Your Document
Page Numbers, Headers, and Footers
Start the Letter Wizard When You’re Ready
Complete the Cover Sheet and Send the Fax
Make Writing Easier
Create and Format the Contract

averages

Calculate Total Orders Per Employee
Chart a Trendline
What If Sales Don’t Follow a Simple Trend?

Avery labels

Print Addresses on Mailing Labels

axes, chart

Create the Chart
Add Data to the Chart
Find the Best Chart Type for Your Data
Title the Chart and Its Axes
Format the Axes and Gridlines
Create a Scatter Chart

B

 

background spell checking

Check Spelling and Grammar

background, chart

Format the Background and Size the Chart for Printing

banner headlines

Multiple Columns

bids, online form for preparing

Prepare a Customer Quote

Binder

Add Buttons to Create Your Own Shortcuts
Use Office Applications Together
Store and Organize Related Project Files in a Binder
The Handout Binder

black and white presentations

Save Time with Templates
Quickly Prepare a Black-and-White Presentation
Give a Great Presentation on Paper

blank presentation template

Create a New Presentation

boldfacing text:in Microsoft Access

Emphasize Important Information

boldfacing text:in Microsoft Excel

Change the Way Text and Data Look
Make the Data Readable

boldfacing text:in Word

Change the Appearance of Text

borders

Change the Appearance of Text
Lines, Boxes, and Shaded Backgrounds
Organize with Colors and Borders
Change the Text Design
Lay It Out
Build the Form
What Should Your List Contain?
Emphasize Important Information

branching

Branch to Other Locations

bubble charts

Create a Scatter Chart

budgets

Consolidate Budget Input
Develop Budgeting Alternatives
Find the Over- and Under-Budget Areas
Test Alternative Strategies
Compare Alternatives
Reallocate Fairly

bulleted lists:changing bullet style

Bulleted and Numbered Lists

bulleted lists:creating in Word

Bulleted and Numbered Lists

bulleted lists:in PowerPoint outlines

Create a New Presentation
Enter Your Own Text

bulleted lists:selecting option on Word Formatting toolbar

Change the Appearance of Text

business letters

Write a Business Letter
Start the Letter Wizard When You’re Ready
Create Letterhead and Matching Envelopes
Create a Mailing
Write a Cover Letter

business reports, creating in Word

Create a Business Report