F

 

facing pages

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

Favorites folder

Create Shortcuts for Frequently Used Files

fax cover sheets

Create a Fax Cover Sheet and Send a Fax
Prepare Your Document for Faxing
Complete the Cover Sheet and Send the Fax

field buttons, selecting

How Well Are Products Selling over Time?
Compare Sales Results Graphically

fields (Outlook), adding to views

Add Information to the View

fields, database

View Information in a Database
Sort Records Alphabetically
Link Template Cells to Database Fields
Begin the Query
Calculate Total Orders Per Employee
Rank Your Sales Staff
View and Update Your Data in Microsoft Access
Adjust the Form’s Layout
Add Supplier Information
Connect Supplier and Product Information
Add Fields to a Table
View Relationships Between Tables
Make Data Entry Easy and Accurate
Let Microsoft Access Enter Information for You
Use Validation Rules to Minimize Data Entry Errors
Simplify Typing Phone Numbers
Summarize Data by Product and Salesperson
Automate Repetitive Tasks in Microsoft Access
Create a Macro to Display a Message
Begin the Report

figures, tables of

Finish by Adding a Table of Contents

files:adding hyperlinks

Add Hyperlinks to Your Files

files:adding maps to

Insert the Map in Other Applications

files:attaching to electronic mail messages

Send a Document

files:compatibility with previous Office versions

Answers to Questions About File Compatibility

files:creating and opening

About Creating and Opening Documents and Databases

files:creating based on templates

Create a New Document or Database by Using a Wizard or Template

files:creating based on wizards

Create a New Document or Database by Using a Wizard or Template

files:database

Turn Your Form into a Data-Tracking Template

Set Up a Link to Your Database

files:distributing using Web

Choose How You Want to Distribute Documents

files:finding from Start menu

Find and Open Documents and Databases

files:finding

Find and Open Documents and Databases
Make Your Documents and Databases Easier to Find

files:frequently used

Create Shortcuts for Frequently Used Files

files:linked vs. inserted

Insert Objects to Copy and Edit Information

files:minimizing size

Insert Objects to Copy and Edit Information

files:moving between Office applications

Can I Move My Contact Data to Another Application?

files:opening as templates

Create a New Document or Database by Using a Wizard or Template

files:opening

About Creating and Opening Documents and Databases
Find and Open Documents and Databases

files:posting online

Choose How You Want to Distribute Documents
Post a Document

files:routing online

Choose How You Want to Distribute Documents
Route a Document

files:saving as templates

Save Your Own Documents as Templates

files:sending online

Choose How You Want to Distribute Documents
Send a Document

files:sharing in workgroups

Distribute Documents Online

files:specifying properties for

Make Your Documents and Databases Easier to Find

files:starting new from Shortcut Bar

Get a Quick Start on Creating or Opening a Document

files:storing

Create Shortcuts for Frequently Used Files

files:version compatibility

Answers to Questions About File Compatibility

files:ways to share

Choose How You Want to Distribute Documents

files:where to store contact information

Where Should You Store Your Contact Information?

fill handle

Enter Data Automatically
Enter Your Contact Information

fills, as graphic effect

Use the Drawing Toolbar

filtering (Microsoft Access)

Find and Display Only the Information You Need
Get Critical Contact Information Fast
Find Selections by Your Favorite Artist

filtering (Microsoft Excel):advanced

Select Products that Meet Profit Requirements

filtering (Microsoft Excel):contact lists

Zero In on the Contacts You Want
Where Should You Store Your Contact Information?

filtering (Microsoft Excel):criteria for

Select Products that Meet Profit Requirements

filtering (Microsoft Excel):price list data

Select Products that Meet Profit Requirements

filtering (Microsoft Excel):sales data

Subtotal Each Region

filtering (Microsoft Excel):using AutoFilter

Select Products that Meet Profit Requirements
Subtotal Each Region

filtering (Microsoft Excel):worksheet lists

Are You Working with a List?
Zero In on the Contacts You Want
Select Products that Meet Profit Requirements

filtering Outlook contact lists

Filter the Information

finding:contact information

Where Should You Store Your Contact Information?

finding:databases

Find and Open Documents and Databases
Make Your Documents and Databases Easier to Find

finding:documents

Find and Open Documents and Databases
Make Your Documents and Databases Easier to Find

finding:files from Start menu

Find and Open Documents and Databases

finding:files

Find and Open Documents and Databases
Make Your Documents and Databases Easier to Find

finding:Help topics

Look Up Information in the Built-in Index or Contents

finding:highlighted document sections

Get a Document Ready for Review

finding:information in Outlook

Search for Information

finding:slides in electronic presentations

Master the Element of Surprise

first-line indent

Text Spacing and Alignment

flyers

Create a Flyer
Lay It Out
Add the Art and Text
Add Borders to Pages

folders

Add a Chart That Stays Up-To-Date

fonts:and character spacing

Fonts, Bold, Italic, and Other Text Enhancements

fonts:changing default

Fonts, Bold, Italic, and Other Text Enhancements

fonts:changing

Change the Way Text and Data Look

fonts:in flyers

Change the Appearance of Text

fonts:using in Microsoft Excel

Change the Way Text and Data Look
Make the Data Readable

fonts:using in Word

Change the Appearance of Text
Fonts, Bold, Italic, and Other Text Enhancements

footnotes

Add Footnotes

FORECAST function

Forecast Next Month’s Sales

forecasting

Create a Sales Forecast

form design view (Microsoft Access)

Create the Chart and Design the Form
Adjust the Form’s Layout
Emphasize Important Information

form fields (Word)

Add Text Fields, Drop-Down Lists, and Check Boxes
In Case Your Users Need Help

form view

Make It Easier to Read Records
Add a Record to Your Database

Form Wizard

Make It Easier to Read Records
Need Help Setting Up a Database?
Create a Great-Looking Product Form
Create the Form
Work with Data from More Than One Table

Format Painter (Microsoft Access)

Emphasize Important Information
Customize the Appearance of Your Report

Format Painter (Microsoft Excel)

Reuse Your Custom Formatting

Format Painter (Word)

Reuse Your Custom Formatting

Formatting toolbar (Microsoft Access)

Emphasize Important Information

Formatting toolbar (Microsoft Excel)

What’s on the Screen?
Change the Way Text and Data Look
Use the Best Number Format
Make the Data Readable

Formatting toolbar (Word)

Change the Appearance of Text

formatting:2-D charts

Customize the Look of a Chart

formatting:3-D charts

Customize the Look of a Chart

formatting:business reports

Make Formatting Easy

formatting:cells in worksheets

Change the Way Text and Data Look
Use the Best Number Format
What Should Your List Contain?

formatting:characters in text

Change the Appearance of Text
Fonts, Bold, Italic, and Other Text Enhancements

formatting:characters vs. paragraphs

Change the Appearance of Text

formatting:charts

Customize the Look of a Chart

formatting:conditional, in worksheets

Use the Best Number Format
Build Alarms into Your Model

formatting:contact lists in worksheets

What Should Your List Contain?

formatting:copying in databases

Emphasize Important Information
Customize the Appearance of Your Report

formatting:copying in Word documents

Reuse Your Custom Formatting

formatting:copying in worksheets

Reuse Your Custom Formatting

formatting:database forms

Emphasize Important Information

formatting:database reports

Customize the Appearance of Your Report

formatting:dates

What Information Is Buried in Your Data?

formatting:defining as worksheet cell styles

Reuse Your Custom Formatting

formatting:envelopes

Print an Envelope

formatting:flyers

Add the Art and Text

formatting:for charts, defined

Customize the Look of a Chart

formatting:graphic objects in Microsoft Excel

Emphasize Important Data

formatting:inventory database reports

Customize the Appearance of Your Report

formatting:map displays in Microsoft Map

Change the Data Display and Format
Add Emphasis and Detail

formatting:Microsoft Excel charts

Customize the Look of a Chart

formatting:modifying in Microsoft Access

Emphasize Important Information

formatting:numbers in worksheets

Change the Way Text and Data Look
Use the Best Number Format
Who Is Selling the Most Product?

formatting:online forms

Turn Your Form into a Data-Tracking Template

formatting:paragraphs

Change the Appearance of Text
Text Spacing and Alignment

formatting:plot area

Format the Background and Size the Chart for Printing

formatting:PowerPoint outlines from other applications

Insert a Word Outline

formatting:PowerPoint presentations

Customize the Appearance of Your Presentation

formatting:removing in Word documents

Change the Appearance of Text

formatting:saving as styles

Reuse Your Custom Formatting

formatting:single PowerPoint slides

Determine the Overall Appearance of Your Presentation

formatting:text in Word documents

Change the Appearance of Text
Let Word Do the Formatting for You
Fonts, Bold, Italic, and Other Text Enhancements

formatting:turning off in Word

Change the Appearance of Text

formatting:using Style box

Make Formatting Easy

formatting:using Style Gallery

Let Word Do the Formatting for You

formatting:Word documents

Change the Appearance of Text
Make Your Word Document Look Great

formatting:worksheets

Change the Way Text and Data Look
Make Your Microsoft Excel Worksheet Look Great

Forms toolbar

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, database:adding charts

Add a Chart to a Microsoft Access Form

forms, database:adding fields

Adjust the Form’s Layout

forms, database:adding hyperlinks

Display a Hyperlink on a Form

forms, database:adding records

Add a Record to Your Database

forms, database:adjusting controls

Adjust the Form’s Layout

forms, database:borders on

Emphasize Important Information

forms, database:buttons on

Add Buttons That Open Forms and Reports
Add a Command Button That Prints a Report

forms, database:changing formatting

Emphasize Important Information

forms, database:changing layout

Adjust the Form’s Layout size="2"

forms, database:copying formatting

Emphasize Important Information

forms, database:creating subforms within

Work with Data from More Than One Table

forms, database:creating

Make It Easier to Read Records
Create the Form
Work with Data from More Than One Table

forms, database:default values for fields

Let Microsoft Access Enter Information for You

forms, database:defined

Use Your First Microsoft Access Database

forms, database:entering data with

Create a Contact Management Database
Type Your Contact Information
Make Data Entry Easy and Accurate

forms, database:entering today's date automatically

Let Microsoft Access Enter Information for You

forms, database:facilitating data entry

Make Data Entry Easy and Accurate

forms, database:for contact management database

Create a Contact Management Database
Type Your Contact Information

forms, database:for inventory database

Create a Great-Looking Product Form

forms, database:for music collection database

Add Information About Your Music Collection

forms, database:for startup

Turn Your Inventory Database into an Application

forms, database:limiting data entry

Use Validation Rules to Minimize Data Entry Errors
Simplify Typing Phone Numbers

forms, database:lines on

Emphasize Important Information

forms, database:macros for

Create a Macro to Display a Message

forms, database:opening from Windows desktop

Create the Form

forms, database:titles for

Emphasize Important Information

forms, database:using with Microsoft Excel

Zero In on the Contacts You Want

forms, database:viewing charts in

Create the Chart and Design the Form

forms, database:viewing records in

Make It Easier to Read Records

forms, online and printed:automating

In Case Your Users Need Help

forms, online and printed:borders on

Build the Form

forms, online and printed:calculation fields

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:check box fields

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:controlling data entry

In Case Your Users Need Help
Protect the Form from Changes

forms, online and printed:creating Help text for

In Case Your Users Need Help

forms, online and printed:creating in Microsoft Access

Make It Easier to Read Records
Create the Form
Work with Data from More Than One Table

forms, online and printed:creating in Microsoft Excel

Create a Form for Online Invoices
Prepare a Customer Quote

forms, online and printed:creating in Word

Create an Online or Printed Form in Word

forms, online and printed:defined

What’s the Best Way to Create a Form?

forms, online and printed:designing

Build the Form
Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:drop-down list fields

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:fields in

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:fill-in fields

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:filling out online

Help Others Use the Form to Add Database Records

forms, online and printed:for customer orders

Create an Online or Printed Form in Word

forms, online and printed:for customer quotes

Prepare a Customer Quote

forms, online and printed:for Web pages

Create Forms for Web Pages

forms, online and printed:formatting

Turn Your Form into a Data-Tracking Template

forms, online and printed:linking to databases

Turn Your Form into a Data-Tracking Template
Link Template Cells to Database Fields
The Template You Need May Already Exist

forms, online and printed:macros for

Add Text Fields, Drop-Down Lists, and Check Boxes
In Case Your Users Need Help

forms, online and printed:Microsoft Excel templates for

Turn Your Form into a Data-Tracking Template
The Template You Need May Already Exist

forms, online and printed:overview

Create an Online or Printed Form in Word

forms, online and printed:passwords for

Protect the Form from Changes

forms, online and printed:protecting

Add Text Fields, Drop-Down Lists, and Check Boxes
Protect the Form from Changes

forms, online and printed:saving as templates

Build the Form

forms, online and printed:shading in

Build the Form

forms, online and printed:tables for

Build the Form

forms, online and printed:testing

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:text fields

Add Text Fields, Drop-Down Lists, and Check Boxes

forms, online and printed:uses for

What’s the Best Way to Create a Form?

forms, online and printed:ways to create

What’s the Best Way to Create a Form?

forms, online and printed:which application to create in

What’s the Best Way to Create a Form?

formula bar

Enter a Formula to Calculate a Value

Formula Palette

Enter a Formula to Calculate a Value

formulas, worksheet:arrays

Determine Sales Trends

formulas, worksheet:AutoSum

Enter a Formula to Calculate a Value

formulas, worksheet:calculating values in

Enter a Formula to Calculate a Value

formulas, worksheet:cell references in

Enter a Formula to Calculate a Value

formulas, worksheet:copying with AutoFill

Consolidate the Combined Input

formulas, worksheet:defined

Enter a Formula to Calculate a Value

formulas, worksheet:displaying

Enter a Formula to Calculate a Value

formulas, worksheet:editing

Enter a Formula to Calculate a Value

formulas, worksheet:entering

Enter a Formula to Calculate a Value
Set Up a Model

formulas, worksheet:errors in

Count Orders for a Product Across Regions

formulas, worksheet:for consolidating budgets

Consolidate the Combined Input

formulas, worksheet:hiding

Prepare Your Workbook to Be Shared

formulas, worksheet:in 3-D references

Consolidate the Combined Input

formulas, worksheet:named cells in

Set Up a Model

formulas, worksheet:natural language

Enter a Formula to Calculate a Value
Set Up a Model
About Natural Language Formulas

formulas, worksheet:subtraction in

Find the Over- and Under-Budget Areas

formulas, worksheet:tracing errors

Count Orders for a Product Across Regions

formulas, worksheet:worksheet names in

Consolidate the Combined Input

Fourier analysis

Analyze Data from an Experiment

FoxPro files

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

freezing panes

What Should Your List Contain?

FrontPage

Extend Office 97 with Additional Microsoft Applications

full screen view

Adjust Your Screen Workspace

functions, worksheet :COUNTBLANK

Count Orders for a Product Across Regions

functions, worksheet :COUNTIF

Count Orders for a Product Across Regions

functions, worksheet :defined

Enter a Formula to Calculate a Value

functions, worksheet :entering

Enter a Formula to Calculate a Value
Forecast Next Month’s Sales

functions, worksheet :for summarizing

Subtotal Each Region

functions, worksheet :FORECAST

Forecast Next Month’s Sales

functions, worksheet :GROWTH

What If Sales Don’t Follow a Simple Trend?

functions, worksheet :reference information

Forecast Next Month’s Sales

functions, worksheet :SUM

Enter a Formula to Calculate a Value
Subtotal Each Region

functions, worksheet :SUMIF

Count Orders for a Product Across Regions

functions, worksheet :TREND

Determine Sales Trends

functions, worksheet :VLOOKUP

Look Up Prices

G

 

Genigraphics

Create Printed Materials

geographic displays using Microsoft Map

Display Data on a Map

goal seeking for budget alternatives

Test Alternative Strategies

grammar, checking

Check Spelling and Grammar
Make Writing Easier

grand totals:calculating from subtotals

Subtotal Each Region

grand totals:in PivotTables

Who Is Selling the Most Product?

graphics:adding to charts

Title the Chart and Its Axes

graphics:adding to documents

Clip Art, Graphics, and Drawings
Add a Logo or Other Graphics
Add the Art and Text
Get Your Point Across with Graphics

graphics:adding to Microsoft Access forms and reports

Add a Record to Your Database

graphics:adding to worksheets

Emphasize Important Data

graphics:as objects

Get Your Point Across with Graphics

graphics:attaching to worksheet cells

Emphasize Important Data

graphics:clip art

Add Graphics
Clip Art, Graphics, and Drawings
Insert Clips

graphics:creating for Word documents

Clip Art, Graphics, and Drawings

graphics:creating in PowerPoint

Add Graphics

graphics:cropping

Clip Art, Graphics, and Drawings
Add the Art and Text
Add Your Content to the Newsletter

graphics:formatting in Microsoft Excel

Emphasize Important Data

graphics:importing into PowerPoint

Add Graphics

graphics:in Clip Gallery

Add Graphics

graphics:in envelope design

Create a Matching Envelope

graphics:in letterhead design

Add a Logo or Other Graphics

graphics:inserting from other programs

Add Graphics from Other Programs

graphics:resizing

Add the Art and Text

graphics:rotating in Word

Add a Logo or Other Graphics

graphics:symbols as

Clip Art, Graphics, and Drawings

graphics:watermarks as

Add a Watermark

graphics:wrapping text around

Add Your Content to the Newsletter

grid, worksheet

What’s on the Screen?

gridlines:chart

Format the Axes and Gridlines

gridlines:worksheet

Organize with Colors and Borders

grouping:data in database reports

Present Data in the Format You Need
Begin the Report

grouping:data in Outlook contact lists

Group Information in the View

grouping:PivotTable data

How Well Are Products Selling over Time?
View Sales Data by Quarter

grouping:worksheet data

Arrange the Data by Product and Region

GROWTH function

What If Sales Don’t Follow a Simple Trend?

growth trend

Determine Sales Trends

What If Sales Don’t Follow a Simple Trend?