MICROSOFT OFFICE 97 FOR WINDOWS FOR DUMMIES QUICK REFERENCE

Now you can have the power of Microsoft Office 97 at your fingertips whenever you sit down to work. In Microsoft Office 97 For Windows For Dummies Quick Reference, you find all the tips, shortcuts, and quick solutions you need in order to use the world's leading productivity software suite successfully. In this book, best-selling author Doug Lowe distills all the must-knows of feature-rich Office 97, so that you can easily take advantage of powerful functions without having to spend too much time looking things up.

About the Author Doug Lowe has written more than 30 computer books, including IDG Books Worldwide's PowerPoint 97 For Windows For Dummies, Word 97 SECRETS, and lnternet Explorer 3.0 For Dummies, and he knows how to present boring technostuff in a style that is both entertaining and enlightening. He lives in sunny Fresno, California, with his wife Debbie, three adorable daughters, and two female golden retrievers, and he considers himself significantly outnumbered.

Introduction.

About This Book.

How to Use This Book.

What Are All These Parts?

What All the Pretty Pictures Mean.

Other Stuff You Should Know.

PART I: Getting to Know Microsoft Office 97.

Seeing What All Those Programs Do.

Word 97.

Excel 97.

PowerPoint 97.

Access 97.

Outlook.

Looking at Those Little Applet Programs.

Graph.

Binder.

Clip Gallery.

Equation Editor.

Organization Chart.

WordArt.

Photo Editor.

PART II: Doing Common Chores.

Closing a File.

Creating a Document.

Exiting a Program.

Getting Help.

Living with the Office Assistant.

Help the old-fashioned way.

Help on the Internet.

Shortcuts That Work Everywhere.

Macros.

Recording a macro.

Running a macro.

Printing a File.

Retrieving an Existing File.

Saving a File.

Saving a File under a New Name.

Saving a File in HTML Format.

Sending a File via E-Mail.

Starting a Program.

Switching among Programs.

Using the IntelliMouse.

Working with Older Versions.

PART III: Word 97.

Borders.

Browsing.

Bulleted Lists.

Columns.

Document Map.

Envelopes.

Finding Text.

Footnotes and Endnotes.

Formatting.

Setting the character format.

Setting the paragraph format.

Formatting Web Documents.

Headers and Footers.

Hyperlinks.

Keyboard Shortcuts.

Assigning your own keyboard shortcuts.

Mail Merging.

Creating the main document.

Creating the data source.

Inserting field names in the main document.

Merging the documents.

Moving and Copying Text.

Dragging and dropping text.

Copying text via the Clipboard.

Moving text via the Clipboard.

Numbered Lists.

Replacing Text.

Selecting Text.

Selecting text by using the mouse.

Selecting text by using the keyboard.

Spell Checking.

Spell checking as you type.

Spell checking after you type.

Styles.

Applying a style.

Creating a style.

Tables of Contents.

Tables.

Tables a la the Insert Table command.

Tables via the Draw Table command.

Tabs.

Setting tabs.

Creating leader tabs.

Templates.

Web Page Wizard.

Web Toolbar.

PART IV: Excel 97.

AutoFormatting.

Centering Text over Several Columns.

Charting.

Comments.

Finding Lost Data.

Formatting a Cell or Range of Cells.

Formula AutoCorrect Functions.

ABS.

AVERAGE.

COUNT.

HLOOKUP.

IF.

LOWER.

MAXIMUM.

MEDIAN.

MINIMUM.

NOW.

PMT.

PRODUCT.

PROPER.

ROUND.

SUM.

SUMPRODUCT.

TODAY.

UPPER.

VLOOKUP.

The Function Wizard.

Hyperlinks.

Keyboard Shortcuts for Editing.

Keyboard Shortcuts for Formatting Cells.

Keyboard Shortcuts for Selecting Cells.

Moving Around.

Naming a Range of Cells.

Pivot Tables.

Printing a Worksheet.

Referencing Spreadsheet Cells.

Saving as HTML.

PART V: PowerPoint 97.

Animation.

Clip Art.

Color Scheme.

Creating a New Presentation.

Hiding Background Objects.

Keyboard Shortcuts.

Keyboard shortcuts for editing slides.

Keyboard shortcuts for formatting text.

Keyboard shortcuts for working with outlines.

Notes.

Publishing on the Web.

Rearranging Slides.

Recurring Text.

Slide Finder.

Summary Slide.

Templates.

Transitions.

Viewer.

Using the Pack and Go Wizard.

Copying a packed presentation onto another computer.

Running a slide show by using the Viewer.

Viewing Your Presentation.

PART VI: Access 97.

Adding a Field to an Existing Table.

Creating a New Database.

Creating a Query.

Creating a Report.

Entering and Editing Data.

Publishing Database Information on the Web.

Using the Form Wizard.

PART VII: Outlook.

Calendar.

Canceling an appointment.

Changing views.

Rescheduling an appointment.

Scheduling an appointment.

Scheduling an event.

Scheduling a meeting.

Scheduling a recurring appointment.

Contacts.

Adding a contact.

Deleting a contact.

Updating a contact.

E-Mail.

Reading e-mail.

Replying to e-mail.

Sending e-mail.

Tasks.

Creating a task.

PART VIII: The Microsoft Office 97 Applets.

Microsoft Clip Gallery.

Microsoft Equation Editor.

Inserting an equation.

Equation Editor buttons.

Microsoft Graph.

Microsoft Organization Chart.

Adding boxes.

Creating an organization chart.

Microsoft WordArt.

PART IX: Working Together.

The Clipboard.

Copying data.

Moving data.

Combining Documents with Microsoft Binder.

Linking.

Linking data.

Breaking a link.

OLE!

Pasting an OLE object.

Creating a new OLE object.

Inserting a file as an OLE object.

Editing an OLE object.

Deleting an OLE object.

Using Hyperlinks.

Sharing Information between Word 97 and Excel 97.

Exchanging tables between Word 97 and Excel 97.

Inserting an Excel 97 worksheet in a Word 97 document.

Using Excel 97 data in a mail merge.

Sharing Information between Word 97 and PowerPoint 97.

Using Write-Up.

Inserting a Word 97 outline in PowerPoint 97.

Creating a Word 97 table in a PowerPoint 97 presentation.

Sharing Information between PowerPoint 97 and Excel 97.

Linking a PowerPoint 97 graph to Excel 97 data.

Sharing Information between Word 97 and Access 97.

Using Access 97 data in a mail merge.

Inserting Access 97 data into a Word 97 table.

Sharing Access 97 Data with Excel 97 and Word 97.

Merge It With MSWord.

Publish It With MSWord.

Converting Access 97 data to Excel 97.

Index.

Book Registration Information.