Q

 

queries (Microsoft Access):adding fields to

Begin the Query

queries (Microsoft Access):calculating totals in

Calculate Total Orders Per Employee

queries (Microsoft Access):changing

Show Only Last Month’s Orders
Calculate Total Orders Per Employee

queries (Microsoft Access):charting results

Add a Chart to a Microsoft Access Form

queries (Microsoft Access):creating PivotTables from data

Summarize Data by Product and Salesperson

queries (Microsoft Access):creating reports from

Rank Your Sales Staff

queries (Microsoft Access):creating

Evaluate Sales Performance in a Microsoft Access Database
Begin the Query

queries (Microsoft Access):criteria for

Show Only Last Month’s Orders

queries (Microsoft Access):design grid

Begin the Query
Show Only Last Month’s Orders

queries (Microsoft Access):expressions in

Show Only Last Month’s Orders

queries (Microsoft Access):finding maximum and minimum values with

Calculate Total Orders Per Employee

queries (Microsoft Access):in Table Analyzer Wizard

View and Update Your Data in Microsoft Access

queries (Microsoft Access):parameters for

Begin the Query

queries (Microsoft Access):ranking results

Rank Your Sales Staff

queries (Microsoft Access):saving

Rank Your Sales Staff

queries (Microsoft Access):selecting fields for

Begin the Query

queries (Microsoft Access):simple

Begin the Query
Choose the Data You Want to Analyze

queries (Microsoft Access):sorting results

Rank Your Sales Staff

queries (Microsoft Access):tables to search

Evaluate Sales Performance in a Microsoft Access Database
Begin the Query

queries (Microsoft Access):totaling results with

Calculate Total Orders Per Employee

queries (Microsoft Access):using Simple Query Wizard

Choose the Data You Want to Analyze

queries (Microsoft Access):viewing results of

Show Only Last Month’s Orders

queries (Word), for mail merge

Target the Form Letter Recipients

Query Wizard

Get the Data from the Database
Filter the Data and Return It to the Worksheet

quitting Office applications

Start and Quit an Office Application

quotes, customer

Prepare a Customer Quote
Look Up Prices
Select Products that Meet Profit Requirements
Extract and Quote the Prices

R

 

ranges, worksheet

Work in Cells and Ranges
Modify the Data
Consolidate the Combined Input

ranking

Sort Records Alphabetically
Rank Your Sales Staff

read-only documents, opening databases as

Share Your Order Entry Database

record collection, organizing

Catalog Your Music Collection

recording macros

Record a Simple Task

records (Microsoft Access)

View Information in a Database
Sort Records Alphabetically
Find and Display Only the Information You Need
Make It Easier to Read Records
Add a Record to Your Database
Share Your Order Entry Database
View and Update Your Data in Microsoft Access
Create the Form
Find Selections by Your Favorite Artist

records, external database

Need Help Setting Up a Database?
Link Template Cells to Database Fields
Help Others Use the Form to Add Database Records
Use Data from Other Applications or Databases
View and Update Your Data in Microsoft Access

recurring appointments, scheduling

Schedule an Appointment

recurring meetings, scheduling

Track Meeting Responses

recurring tasks, organizing

Create a Task

redefining styles

Reuse Your Custom Formatting
Set Up the Page and Type the Standard Text

registering Office

Install Office on Your Computer

Registration Wizard

Install Office on Your Computer

regression analysis

Analyze Data from an Experiment
Predict Forward or Backward with a Trendline

rehearsing presentations

Check for Errors
Time and Rehearse Your Presentation

relational databases

View Information in a Database

relationships, table

Use Tables to Organize Data in Your Database
View Relationships Between Tables

remote computers

Take Notes and Track Action Items on Screen
Give a Presentation on a Remote Computer
Update a Public Folder When You’re Out of the Office

renaming

Add More Sheets to the Workbook
Add Supplier Information

repeating worksheet cell entries

Enter Your Contact Information

repetitive tasks, automating

Automate Repetitive Tasks
Automate Repetitive Tasks in Microsoft Access

report design view

Adjust the Report Layout
Customize the Appearance of Your Report

Report Wizard

Need Help Setting Up a Database?
Begin the Report (price list)
Create and Enhance an Inventory Report
Begin the Report (inventory report)
Calculate Totals

reports, business, creating in Word

Create a Business Report

reports, database:adding buttons to

Add Buttons That Open Forms and Reports

reports, database:adding charts to

Create a Chart Report

reports, database:adding cover page from Microsoft Word

Add a Cover Sheet to Your Report

reports, database:calculating totals in

Calculate Totals

reports, database:changing layout

Adjust the Report Layout

reports, database:chart reports

Create a Chart Report

reports, database:copying formatting in

Customize the Appearance of Your Report

reports, database:creating

Present Data in the Format You Need
Create Reports from the Database
Begin the Report

reports, database:defined

Use Your First Microsoft Access Database

reports, database:for inventory database

Create and Enhance an Inventory Report

reports, database:formatting

Customize the Appearance of Your Report

reports, database:grouping data in

Present Data in the Format You Need
Begin the Report

reports, database:headings for

Customize the Appearance of Your Report

reports, database:labeling fields

Customize the Appearance of Your Report

reports, database:overview

Present Data in the Format You Need

reports, database:page size

Customize the Appearance of Your Report

reports, database:previewing

Type Your Contact Information
Print One Category Per Page

reports, database:printing one category per page

Print One Category Per Page

reports, database:printing

Present Data in the Format You Need
Print One Category Per Page
Add a Command Button That Prints a Report

reports, database:uses of

Present Data in the Format You Need

reports, database:viewing charts in

Create a Chart Report

reports, sales

What Method Should You Use to Analyze Your Sales Data?

resizing

View Information in a Database
Add the Art and Text
Format and Position the Legend
Format the Background and Size the Chart for Printing

Resume Wizard

Create a Resume and Cover Letter

resumes

Create a Resume and Cover Letter
Use the Resume Wizard to Get Started
Add Your Information to the Resume
Add a Second Page — or More
Write a Cover Letter

retyping data, avoiding

Create a Form for Online Invoices
Get Sales Information from a Database

reverse text

Fonts, Bold, Italic, and Other Text Enhancements

Review Comments toolbar

Prepare Your Workbook to Be Shared

reviewing documents

Choose How You Want to Distribute Documents
Route a Document
Have Your Team Review a Word Document
Decide How Reviewers Will Provide Feedback
Incorporate Changes

reviewing presentations

Add Comments to a PowerPoint Presentation

revisions

Have Your Team Review a Word Document
Decide How Reviewers Will Provide Feedback
Get a Document Ready for Review
Incorporate Changes

Rich Text Format

Transfer Information Between PowerPoint and Other Applications

right-aligning

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

rolling up budget data

Consolidate Budget Input
Find the Over- and Under-Budget Areas

rotating objects:3-D charts

Formatting a 3-D Chart

rotating objects:chart axis labels

Label the Data Markers
Format the Axes and Gridlines

rotating objects:data in worksheet cells

Adjust the Spacing and Alignment of Data
Organize with Colors and Borders

rotating text or graphics

Add a Logo or Other Graphics

routing

Link Template Cells to Database Fields
Choose How You Want to Distribute Documents
Route a Document
Have Your Team Review a Word Document

rows, table (Microsoft Access)

View Information in a Database

rows, table (Word)

Build the Form

rows, worksheet:adding

Adjust the Spacing and Alignment of Data

rows, worksheet:and PivotTables

What Information Is Buried in Your Data?

rows, worksheet:as chart data series

Create the Chart
Is Your Data More Complex?

rows, worksheet:changing height

Adjust the Spacing and Alignment of Data

rows, worksheet:converting to database records

View and Update Your Data in Microsoft Access

rows, worksheet:counting

Count Orders for a Product Across Regions

rows, worksheet:defined

What’s on the Screen?

rows, worksheet:filling automatically

Enter Data Automatically
Enter Your Contact Information

rows, worksheet:freezing heading row

What Should Your List Contain?

rows, worksheet:headings for

What’s on the Screen?
What Should Your List Contain?

rows, worksheet:hiding

Is Your Data More Complex?
Get Budget Projections from Each Department

rows, worksheet:inserting

Adjust the Spacing and Alignment of Data

rows, worksheet:selecting

Work in Cells and Ranges

R-squared value

Predict Forward or Backward with a Trendline

rulers

What’s on the Word Screen?
Custom Margins
Lay It Out

Rules Wizard

Automate Mail Management

running macros

Perform the Task Automatically
Create a Macro to Display a Message

running totals, viewing

Enter a Formula to Calculate a Value

S

 

sales data:analyzing

What Method Should You Use to Analyze Your Sales Data?
Create a Sales Summary

sales data:by product

Create a Detailed Sales Report

sales data:by region

Create a Detailed Sales Report

sales data:comparing in PivotTables

View Sales Data by Quarter

sales data:counting orders

Count Orders for a Product Across Regions

sales data:creating reports in Microsoft Access

Present Data in the Format You Need
Create Reports from the Database
Begin the Report

sales data:creating reports in Word

Create a Business Report

sales data:determining trends

Create a Sales Forecast

sales data:filtering

Subtotal Each Region

sales data:forecasting

Create a Sales Forecast

sales data:grouping

Arrange the Data by Product and Region

sales data:hiding detail

View the Summary Without the Detail

sales data:importing, which application to use

What Method Should You Use to Analyze Your Sales Data?

sales data:linking Microsoft Excel data to Word summaries

Write a Draft of Your Report

sales data:linking, which application to use

What Method Should You Use to Analyze Your Sales Data?

sales data:mapping

Compare Sales Results Graphically

sales data:outlining

Subtotal Each Region
View the Summary Without the Detail

sales data:preparing customer quotes

Prepare a Customer Quote

sales data:printing

Subtotal Each Region

sales data:ranking

Rank Your Sales Staff

sales data:retrieving from external databases

Get Sales Information from a Database

sales data:sorting

Arrange the Data by Product and Region

sales data:summarizing data in Microsoft Access databases

Create a Sales Summary from a Microsoft Access Database

sales data:summarizing using PivotTables

Create a Sales Summary

sales data:summarizing with subtotals

Create a Detailed Sales Report

sales data:summarizing, which method to use

What Method Should You Use to Analyze Your Sales Data?

sales data:totaling

Create a Detailed Sales Report

sales data:when to use Microsoft Access

What Method Should You Use to Analyze Your Sales Data?

sales data:when to use Microsoft Excel

What Method Should You Use to Analyze Your Sales Data?

sales forecasts

Create a Sales Forecast

saving:customized Outlook views

Save the View

saving:database records

Add a Record to Your Database

saving:document formats as styles

Reuse Your Custom Formatting

saving:fax cover sheets as templates

Complete the Cover Sheet and Send the Fax

saving:files as templates

Save Your Own Documents as Templates

saving:online documents

Save Your Document and Protect It from Changes

saving:presentations as templates

Save Time with Templates

saving:queries

Rank Your Sales Staff

saving:related documents in Binders

Store and Organize Related Project Files in a Binder

saving:resumes as templates

Add a Second Page — or More

saving:undoing

Add a Record to Your Database

saving:Word document versions

To Outline or Not to Outline?

saving:Word documents

Save, Preview, and Print a Document

saving:workbooks

Save, Preview, and Print a Sheet
Add a Chart That Stays Up-To-Date

scale, chart

Format the Axes and Gridlines

scatter charts

Find the Best Chart Type for Your Data
Change the Data Markers
Analyze Data from an Experiment
Display Scientific Data in a Chart
Create a Scatter Chart

scenarios

Set Up a Model
Compare Alternatives
Reallocate Fairly

scientific charts

Create a Scatter Chart

scientific data

Analyze Data from an Experiment
Display Scientific Data in a Chart

screen display

What’s on the Word Screen?
Adjust Your Screen Workspace

ScreenTips

Find Out What’s on the Screen

scroll bars

What’s on the Word Screen?
Move Around in the Document
What’s on the Screen? (Microsoft Excel)

secondary value axis, adding to charts

Find the Best Chart Type for Your Data
Format the Axes and Gridlines

sections, dividing documents into

Multiple Columns
Add Headers and Footers

Select Browse Object button

Move Around in the Document

selecting:data for Microsoft Excel charts

Create the Chart

selecting:text in Word

Select the Text You Want to Change

selecting:worksheet cells

What’s on the Screen?
Work in Cells and Ranges

self-running presentations

Create a Self-Running Presentation
Set the Timing for Each Slide
Set Up the Presentation to Run Unattended
Help Your Presentation Run Smoothly

sending documents within workgroups

Choose How You Want to Distribute Documents
Send a Document

Setup program

Install Office on Your Computer
Add or Remove Components

shading:adding to Microsoft Excel worksheets

Organize with Colors and Borders

shading:adding to Word documents

Lines, Boxes, and Shaded Backgrounds

shading:for letterhead

Add a Logo or Other Graphics

shading:in online forms

Build the Form

shading:in Word tables

Build the Form

shading:removing from Word documents

Lines, Boxes, and Shaded Backgrounds

shapes, adding to worksheets

Emphasize Important Data

shared databases

Track Orders in a Shared Database
Create an Order Entry Database
Share Your Order Entry Database
Use Data from Other Applications or Databases

shared workbooks

A Shared Workbook Makes Getting the Input Easier
Share a Workbook with a Co-Worker
Prepare Your Workbook to Be Shared
Collaborate, and Watch Everyone’s Progress

sharing

Use Office Applications Together
Distribute Documents Online
Create an Online Manual

shortcut menus in Microsoft Excel

Work in Cells and Ranges

shortcuts:creating for public folders

Check Permissions Granted for a Public Folder

shortcuts:in Outlook

What’s on the Screen?

shortcuts:sending to public folder users

Add a Calendar to the Public Folder

shortcuts:storing in Favorites folder

Create Shortcuts for Frequently Used Files

shortcuts:tips for entering text in Word

Add Text to Your Document

Show/Hide Paragraph button

What’s on the Word Screen?

Shrink to Fit feature

Change the Way Text and Data Look

Adjust the Spacing and Alignment of Data

side heads

Put It All Together: Design a “Facing Pages” Layout

signatures in electronic mail

Use Word for Windows as Your E-mail Editor

simple queries

Begin the Query
Choose the Data You Want to Analyze

Simple Query Wizard

Begin the Query
Choose the Data You Want to Analyze

size handles, graphic

Add the Art and Text

Slide Meter

Time and Rehearse Your Presentation

Slide Navigator

Master the Element of Surprise

slide show view

Getting Around in PowerPoint

slide sorter view

Getting Around in PowerPoint
Use Slide Sorter View

slide view

Getting Around in PowerPoint

slides, presentation :adding graphics to

Get Your Point Across with Graphics

slides, presentation:animations

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

slides, presentation:applying formatting to all

Determine the Overall Appearance of Your Presentation

slides, presentation:black and white

Quickly Prepare a Black-and-White Presentation

slides, presentation:branching among

Branch to Other Locations

slides, presentation:creating charts for

Add a Chart That Stays Up-To-Date

slides, presentation:creating in outline view

Enter Your Own Text

slides, presentation:customizing

Customize the Appearance of Your Presentation

slides, presentation:expanding one slide to multiple slides

Organize Your Presentation

slides, presentation:finding with Slide Navigator

Master the Element of Surprise

slides, presentation:formatting individually

Determine the Overall Appearance of Your Presentation

slides, presentation:grouping as custom show

Organize Your Presentation

slides, presentation:headers and footers in

Determine the Overall Appearance of Your Presentation

slides, presentation:hidden

Be Prepared with Hidden Slides
Master the Element of Surprise

slides, presentation:images in audience handouts

Create Audience Handouts

slides, presentation:images in notes pages

Create Speaker Notes

slides, presentation:in outline view

Enter Your Own Text

slides, presentation:in self-running presentations

Create a Self-Running Presentation

slides, presentation:inserting from other applications

Insert a Word Outline

slides, presentation:inserting Word tables in

Special Objects in Office Programs

slides, presentation:jumping between

Branch to Other Locations

slides, presentation:linking to Word documents

Does Your Audience Need a Book?

slides, presentation:masters for

Apply Master Formatting

slides, presentation:miniature views

Enter Your Own Text
Quickly Prepare a Black-and-White Presentation

slides, presentation:output options

Create Printed Materials
Give a Great Presentation on Paper

slides, presentation:overview

Create Your First PowerPoint Presentation

slides, presentation:presentation designs

Choose the Appearance You Want

slides, presentation:printing overheads

Create Printed Materials

slides, presentation:progressive disclosure

Prepare for an Electronic Presentation
Prepare Animations and Slide Transitions

slides, presentation:templates for

Customize the Appearance of Your Presentation

slides, presentation:thumbnail views

Enter Your Own Text
Quickly Prepare a Black-and-White Presentation

slides, presentation:timing

Time and Rehearse Your Presentation

slides, presentation:titles for

Create a New Presentation
Apply Master Formatting

slides, presentation:transitions between

Prepare for an Electronic Presentation
Prepare Animations and Slide Transitions
Be Prepared with Hidden Slides
Branch to Other Locations
Use Slide Sorter View

slides, presentation:using Pen to draw on

Take Notes and Track Action Items on Screen

slides, presentation:viewing from outline view

Enter Your Own Text

slogans for letterhead

Change the Text Design

small caps

Fonts, Bold, Italic, and Other Text Enhancements

Solver

Test Alternative Strategies

sorting:budget data

Find the Over- and Under-Budget Areas

sorting:contact information

Enter Your Contact Information
Zero In on the Contacts You Want
Group Information in the View
Where Should You Store Your Contact Information?

sorting:database query results

Rank Your Sales Staff

sorting:database records

Sort Records Alphabetically

sorting:for ranking

Rank Your Sales Staff

sorting:lists in Microsoft Excel

Are You Working with a List?
Enter Your Contact Information
Zero In on the Contacts You Want
Arrange the Data by Product and Region

sorting:on multiple worksheet columns

Set Up a Link to Your Database
Subtotal Each Region

sorting:worksheet data

Are You Working with a List?
Find the Over- and Under-Budget Areas

sound objects

Add Multimedia Effects
Master the Element of Surprise
Get a Document Ready for Review

spacing

Fonts, Bold, Italic, and Other Text Enhancements
Text Spacing and Alignment

speaker notes:creating

Create Speaker Notes
Master the Element of Surprise

speaker notes:exporting to Word

Does Your Audience Need a Book?

speaker notes:headers and footers on

Create Audience Handouts

speaker notes:hidden slides in

Be Prepared with Hidden Slides

speaker notes:overview

Create Your First PowerPoint Presentation
Getting Around in PowerPoint

speaker notes:printing

Create Printed Materials
Create Speaker Notes

speaker notes:resizing slide images

Create Speaker Notes

speaker notes:viewing on screen during presentations

Master the Element of Surprise

speaker notes:when to use

Create Audience Handouts and Speaker Notes
Create Speaker Notes

speaker notes:writing style

Create Audience Handouts

special characters

Add Text to Your Document
Enter Your Own Text

special effects, in online presentations

Master the Element of Surprise

speed dialing

Use Outlook to Call Your Contact

spelling checking:automatic vs. on demand

Check Spelling and Grammar

spelling checking:in databases

Check Spelling and Correct Mistakes

spelling checking:in presentation slides

Check for Errors

spelling checking:in Word documents

Check Spelling and Grammar

spelling checking:in worksheets

Modify the Data

splitting databases in two

Share Your Order Entry Database

splitting tables and table cells (Word)

Build the Form

SQL Server files

Turn Your Form into a Data-Tracking Template
Set Up a Link to Your Database

standard deviation

Show “Plus or Minus” with Error Bars

standard error

Show “Plus or Minus” with Error Bars

starting Office applications

Start and Quit an Office Application

startup forms, database

Turn Your Inventory Database into an Application
Create a Startup Form
Display the Startup Form Automatically

statistical analysis:experimental data

Analyze Data from an Experiment

statistical analysis:forecasting sales

Create a Sales Forecast

statistical analysis

Analyze Data from an Experiment
Create a Sales Forecast

storing

Create Shortcuts for Frequently Used Files
Where Should You Store Your Contact Information?
Can I Move My Contact Data to Another Application?

Style box, for business reports

Make Formatting Easy

Style Checker

Check for Errors

Style Gallery

Let Word Do the Formatting for You
Start with an Existing Letterhead Design

styles, document

Reuse Your Custom Formatting
Make Formatting Easy

styles, heading

Insert a Word Outline
Create an Easy-to-Read Design
To Outline or Not to Outline?
Finish by Adding a Table of Contents

styles, worksheet cell

Reuse Your Custom Formatting

subtotals

Is Your Data More Complex?
Consolidate the Combined Input
Subtotal Each Region

subtracting in worksheet formulas

Find the Over- and Under-Budget Areas

SUM function

Enter a Formula to Calculate a Value
Subtotal Each Region

SUMIF function

Count Orders for a Product Across Regions

summarizing

Consolidate Budget Input
Reallocate Fairly
What Method Should You Use to Analyze Your Sales Data?
Create a Detailed Sales Report
Create a Sales Summary

summary functions

Subtotal Each Region

suppliers

Store a Hyperlink in a Table
Display a Hyperlink on a Form
Add a Suppliers Table to Your Inventory Database
Connect Supplier and Product Information

switchboard, database

Create a Chart Report
Create a Contact Management Database
Create an Order Entry Database
Create a Music Database

symbols

Add Text to Your Document
Clip Art, Graphics, and Drawings
Change the Text Design