N

 

named worksheet cells

Consolidate the Combined Input
Reallocate Fairly
Look Up Prices

named worksheets

Consolidate the Combined Input

names, personal

Create a Business Contact List in Microsoft Excel
What Should Your List Contain?
Where Should You Store Your Contact Information?
Can I Move My Contact Data to Another Application?

naming:chart sheets

Add More Sheets to the Workbook

naming:worksheet cells

Set Up a Model
Reallocate Fairly

naming:worksheet tabs

Add More Sheets to the Workbook

naming:worksheets

Add More Sheets to the Workbook

natural language formulas

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

navigating:in Word documents

Move Around in the Document

navigating:in worksheets

What’s on the Screen?
Enter Data Automatically

Navigator, Slide

Master the Element of Surprise

negative indents

Put It All Together: Design a “Facing Pages” Layout
Text Spacing and Alignment

nesting subtotals

Subtotal Each Region

networks

Install Office on Your Computer
Install Office on a Network
Take Notes and Track Action Items on Screen
A Shared Workbook Makes Getting the Input Easier
Share a Workbook with a Co-Worker
Share Your Order Entry Database

new Office features

What’s New in Office 97?

Newsletter Wizard

Create a Newsletter
Use the Newsletter Wizard to Get Started

newsletters

Create a Newsletter
Add Your Content to the Newsletter

nonprinting characters, turning on and off (Word)

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

normal view

Change Your View of the Document

Northwind database

Use Your First Microsoft Access Database
Evaluate Sales Performance in a Microsoft Access Database
Create a Price List

Notes feature

Create a Note

notes page view

Getting Around in PowerPoint

null modem cable

Connect to a Single Computer Using a Null Modem Cable

numbered lists

Change the Appearance of Text
Bulleted and Numbered Lists

numbering

Page Numbers, Headers, and Footers
Add Footnotes
Add Headers and Footers
Add Numbering to Headings and Paragraphs

numbers:custom formatting in worksheets

Use the Best Number Format

numbers:entering series automatically

Enter Data Automatically

numbers:formatting in worksheets

Use the Best Number Format
Who Is Selling the Most Product?

numbers:viewing as percentages

Set Up a Model

O

 

objects:maps as

Insert the Map in Other Applications

ODBC drivers

Get Sales Information from a Database
Set Up a Link to Your Database

Office Assistant

Get Assistance While You Work
For Help, Ask the Office Assistant

office memos, creating

Create a Memo

Office Shortcut Bar

Take a Shortcut to Work
Get a Quick Start on Creating or Opening a Document
Add Buttons to Create Your Own Shortcuts

Office Web, using to distribute documents

Choose How You Want to Distribute Documents

OfficeLinks feature

Other Easy Ways to Share Office Information

offline folders

Update a Public Folder When You’re Out of the Office

on-exit macro

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

online documents

Create an Online Manual
Create an Easy-to-Read Design
What View Should Online Readers Use?
For Easy Navigation, Create Hyperlinks
Save Your Document and Protect It from Changes

online index

Look Up Information in the Built-in Index or Contents

online information sources

Look Up Information in the Built-in Index or Contents

online layout view

Change Your View of the Document
What View Should Online Readers Use?

online manuals, creating

Create an Online Manual

Open Database Connectivity (ODBC) drivers

Get Sales Information from a Database
Set Up a Link to Your Database

opening

Save, Preview, and Print a Document
About Creating and Opening Documents and Databases
Find and Open Documents and Databases

operators, in worksheet formulas

Count Orders for a Product Across Regions

orders

Create an Online or Printed Form in Word
Track Orders in a Shared Database
What Information Is Buried in Your Data?

organizational charts

Special Objects in Office Programs

organizing collections

Catalog Your Music Collection

outline view (PowerPoint)

Getting Around in PowerPoint
Enter Your Own Text

outline view (Word)

To Outline or Not to Outline?

outlines (Microsoft Excel)

Subtotal Each Region
View the Summary Without the Detail

outlines (PowerPoint)

Create a New Presentation
Enter Your Own Text
Create Printed Materials
Export a Presentation to Word

outlines (Word)

Insert a Word Outline
To Outline or Not to Outline?
Write a Draft of Your Report

Outlining toolbar

Enter Your Own Text

Overtype mode

Insert and Delete Text

OVR status indicator

Insert and Delete Text

P

 

Pack and Go Wizard

Give an Electronic Presentation

Page Break Preview feature

View and Adjust the Sheet Layout

page breaks (Microsoft Excel)

View and Adjust the Sheet Layout

page breaks (Word)

Custom Margins

page fields

How Well Are Products Selling over Time?

page layout view

Change Your View of the Document

page layout:for database reports

Adjust the Report Layout

page layout:for worksheets

View and Adjust the Sheet Layout
Save, Preview, and Print a Sheet

page layout:in Word documents

Put It All Together: Design a “Facing Pages” Layout
Start the Letter Wizard When You’re Ready
Create a Flyer
Lay It Out

page layout:paper size for database reports

Customize the Appearance of Your Report

page numbers

Page Numbers, Headers, and Footers
Create a Different Design for the Second Page
Add Headers and Footers

page orientation

Lay It Out

pagination

Custom Margins

panes, freezing

What Should Your List Contain?

Paradox files

Turn Your Form into a Data-Tracking Template
View and Update Your Data in Microsoft Access
Set Up a Link to Your Database

paragraph marks

What’s on the Word Screen?
Text Spacing and Alignment

paragraphs

Select the Text You Want to Change
Change the Appearance of Text
Enter Your Own Text
Text Spacing and Alignment
Add Numbering to Headings and Paragraphs

passwords

Protect the Form from Changes
Save Your Document and Protect It from Changes
Create an Order Entry Database
Protect Your Database with a Password

Paste Function button

Enter a Formula to Calculate a Value

pasting

Move and Copy Text
Decide How You Want to Share Information
Add a Chart That Stays Up-To-Date

patterns:adding to charts

Change the Data Markers
Format the Background and Size the Chart for Printing
Formatting a 3-D Chart

patterns:adding to worksheets

Organize with Colors and Borders

Pen drawings in slide shows

Take Notes and Track Action Items on Screen

percentages, viewing numbers as

Set Up a Model

personal data, organizing

Record Your Home Assets

perspective, 3-D chart

Formatting a 3-D Chart

phone numbers

Use Outlook to Call Your Contact
Simplify Typing Phone Numbers

Picture toolbar

Add Graphics from Other Programs

pictures:adding to database records

Add a Record to Your Database

pictures:adding to Word documents

Clip Art, Graphics, and Drawings
Add the Art and Text

pictures:as chart data markers

Change the Data Markers

pictures:creating for Word documents

Clip Art, Graphics, and Drawings

pictures:cropping

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

pie charts

Find the Best Chart Type for Your Data
Change the Data Markers
Reallocate Fairly

PivotTable Wizard:using from Microsoft Access

Summarize Data by Product and Salesperson
View Sales Data by Quarter

PivotTable Wizard:using in Microsoft Excel

Who Is Selling the Most Product?

PivotTables:and page fields

How Well Are Products Selling over Time?

PivotTables:changing layout

Who Is Selling the Most Product?

PivotTables:comparing budget data

Consolidate the Combined Input

PivotTables:comparing product sales data

View Sales Data by Quarter

PivotTables:creating charts from

Is Your Data More Complex?
Compare Sales Results Graphically

PivotTables:creating from database data

Create Reports from the Database
Create a Sales Summary from a Microsoft Access Database

PivotTables:creating from worksheet data

What Information Is Buried in Your Data?
Who Is Selling the Most Product?

PivotTables:dates in

What Information Is Buried in Your Data?

PivotTables:defined

Create Reports from the Database
Create a Sales Summary

PivotTables:for sales data

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

PivotTables:grouping data with

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

PivotTables:overview

Create a Sales Summary

PivotTables:refreshing

How Well Are Products Selling over Time?

PivotTables:reusing data

How Well Are Products Selling over Time?

PivotTables:summarizing sales results

Create a Sales Summary

PivotTables:updating

How Well Are Products Selling over Time?

PivotTables:uses for

What Method Should You Use to Analyze Your Sales Data?
Create a Sales Summary
What Information Is Buried in Your Data?

PivotTables:using external data

How Well Are Products Selling over Time?

PivotTables:using from Microsoft Access

Summarize Data by Product and Salesperson

PivotTables:vs. outlines

View the Summary Without the Detail

PivotTables:when to use

What Method Should You Use to Analyze Your Sales Data?

plain text files, delimited

Can I Move My Contact Data to Another Application?

Pleading Wizard

Create a Pleading
Select Settings to Create a Custom Pleading
Write the Pleading

pleadings

Create a Pleading
Select Settings to Create a Custom Pleading
Write the Pleading
Add Footnotes
Mark Entries for a Table of Authorities
Create a Table of Authorities

plot area, chart

Format the Background and Size the Chart for Printing

policy manuals, creating

Create an Online Manual

polynomial regression

Predict Forward or Backward with a Trendline

posting documents online

Choose How You Want to Distribute Documents
Post a Document

PowerPoint Viewer

Help Your Presentation Run Smoothly

Presentation Conference Wizard

Set Up a Presentation Conference

presentation conferencing

Take Notes and Track Action Items on Screen
Give a Presentation on a Remote Computer

presentation designs

Customize the Appearance of Your Presentation
Save Time with Templates
Determine the Overall Appearance of Your Presentation

presentations:adding charts

Add a Chart to a Document or Presentation

presentations:adding comments

Add Comments to a PowerPoint Presentation

presentations:adding graphics

Get Your Point Across with Graphics

presentations:assembling quickly

Quickly Prepare a Black-and-White Presentation

presentations:black and white

Quickly Prepare a Black-and-White Presentation

presentations:blank template

Create a New Presentation

presentations:color vs. black and white

Save Time with Templates
Quickly Prepare a Black-and-White Presentation

presentations:converting to HTML

Create a Web Presentation with PowerPoint

presentations:creating for Web

Create a Web Presentation with PowerPoint

presentations:creating from Word documents

Finish by Adding a Table of Contents

presentations:creating handouts and speaker notes for

Create Audience Handouts and Speaker Notes

presentations:creating with AutoContent Wizard

Create a New Presentation
Enter Your Own Text

presentations:creating without wizard

Create a New Presentation

presentations:customizing appearance

Customize the Appearance of Your Presentation

presentations:designing look

Choose the Appearance You Want
Add Graphics

presentations:editing charts from within

Add a Chart to a Document or Presentation
Modify the Chart

presentations:editing text

Enter Your Own Text

presentations:electronic

Prepare for an Electronic Presentation
Give an Electronic Presentation

presentations:elements of

Create Your First PowerPoint Presentation

presentations:exchanging information with other applications

Transfer Information Between PowerPoint and Other Applications

presentations:exporting to Word

Create Printed Materials
Export a Presentation to Word

presentations:formatting with content templates

Customize the Appearance of Your Presentation

presentations:formatting with master slides

Customize the Appearance of Your Presentation
Apply Master Formatting

presentations:formatting with presentation designs

Customize the Appearance of Your Presentation
Determine the Overall Appearance of Your Presentation

presentations:graphics in

Add Graphics

presentations:inserting Microsoft Excel charts

Add a Chart That Stays Up-To-Date

presentations:inserting slides from other applications

Insert a Word Outline

presentations:linking Microsoft Excel charts to

Add a Chart That Stays Up-To-Date

presentations:on remote computers

Give a Presentation on a Remote Computer

presentations:overview

Create Your First PowerPoint Presentation

presentations:predesigned

Customize the Appearance of Your Presentation

presentations:previewing

Check for Errors

presentations:printed output options

Create Printed Materials
Quickly Prepare a Black-and-White Presentation
Give a Great Presentation on Paper

presentations:publishing on World Wide Web

Export a Presentation to Word

presentations:rehearsing

Check for Errors

presentations:reviewing

Add Comments to a PowerPoint Presentation

presentations:saving as templates

Save Time with Templates

presentations:saving together with Microsoft Excel workbooks

Add a Chart That Stays Up-To-Date

presentations:self-running

Create a Self-Running Presentation

presentations:sharing information between applications

Use Office Applications Together

presentations:spell checking

Check for Errors

presentations:style checking

Check for Errors

presentations:templates for

Choose the Appearance You Want
Customize the Appearance of Your Presentation
Save Time with Templates

presentations:timing

Check for Errors

presentations:transferring to Word

Other Easy Ways to Share Office Information

presentations:trying out on screen

Check for Errors

presentations:two-computer

Take Notes and Track Action Items on Screen

presentations:types of

Create Your First PowerPoint Presentation

presentations:views in

Getting Around in PowerPoint

presentations:Write-Up feature

Create Printed Materials

previewing:database reports

Type Your Contact Information
Customize the Appearance of Your Report

previewing:merged data

Merge the Mailing List with the Form Letter

previewing:Microsoft Access report layout

Adjust the Report Layout
Print One Category Per Page

previewing:presentations

Check for Errors

previewing:Word documents

Save, Preview, and Print a Document

previewing:worksheets

View and Adjust the Sheet Layout
Save, Preview, and Print a Sheet

prices:calculating discounts

Extract and Quote the Prices

prices:creating lists

Begin the Report

prices:filtering list data

Select Products that Meet Profit Requirements

prices:formatting lists as database reports

Adjust the Report Layout

prices:obtaining using VLOOKUP

Look Up Prices

prices:preparing lists

Create a Price List

prices:printing as database reports

Print One Category Per Page

prices:querying external databases for

Look Up Prices

Print Preview feature (Microsoft Access)

Print One Category Per Page
Customize the Appearance of Your Report

Print Preview feature (Microsoft Excel)

Save, Preview, and Print a Sheet

Print Preview feature (Word)

Save, Preview, and Print a Document
Custom Margins

printing:35mm slides

Create Printed Materials

printing:black and white presentations

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

printing:canceling in Word

Save, Preview, and Print a Document

printing:comments in documents

Incorporate Changes

printing:database reports

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

printing:employee data

Present Data in the Format You Need

printing:envelopes

Print an Envelope
Create a Matching Envelope
Print Addresses on Mailing Labels

printing:form letters from merged data

Merge the Mailing List with the Form Letter

printing:Genigraphics slides

Create Printed Materials

printing:gridlines in worksheets

Organize with Colors and Borders

printing:letterhead

Start with an Existing Letterhead Design

printing:mailing labels from merged data

Print Addresses on Mailing Labels

printing:Microsoft Excel worksheets

Save, Preview, and Print a Sheet

printing:orientation

Lay It Out

printing:Outlook Calendar

Print the Calendar

printing:Outlook views

Print the View

printing:partial worksheets

Save, Preview, and Print a Sheet

printing:presentation handouts

Create Printed Materials
Create Audience Handouts
Create Speaker Notes
Give a Great Presentation on Paper

printing:presentation notes

Create Printed Materials
Create Audience Handouts

printing:presentation outlines

Create Printed Materials
Create Audience Handouts

printing:price lists

Print One Category Per Page

printing:slides

Create Printed Materials
Create Audience Handouts
Give a Great Presentation on Paper

printing:subtotaled worksheet groups

Subtotal Each Region

printing:Word documents

Save, Preview, and Print a Document

printing:worksheet cell comments

Collaborate, and Watch Everyone’s Progress

procedure manuals, creating

Create an Online Manual

profit margins, calculating

Select Products that Meet Profit Requirements

projecting sales

Create a Sales Forecast

Promote button (presentation outlines)

Enter Your Own Text

proofreading documents, tools for

Check Spelling and Grammar

properties, setting

Make Your Documents and Databases Easier to Find
Make Data Entry Easy and Accurate
Create a Startup Form

protecting:databases

Create an Order Entry Database
Protect Your Database with a Password

protecting:online documents

Save Your Document and Protect It from Changes

protecting:online forms

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

protecting:Word documents

Get a Document Ready for Review

protecting:worksheets

Get Budget Projections from Each Department
Prepare Your Workbook to Be Shared

public folders

Post a Document
Use Outlook to Share Folders
Check Permissions Granted for a Public Folder
Add a Calendar to the Public Folder
Start an Online Discussion
Update a Public Folder When You’re Out of the Office

Publish to the Web Wizard

Publish Your Data