More Microsoft Office for Windows 95 for dummies Book

Introduction

Who Should Buy This Book

How This Book Is Organized

Part I: Power Writing with Microsoft Word

Part II: Crunching Numbers with Microsoft Excel

Part III: The Microsoft PowerPoint Dog-and-Pony Show

Part IV: Staying Organized with Microsoft Schedule+

Part V: Storing Information in Microsoft Access

Part VI: Shortcuts and Tips Galore

How to Use This Book

How much do you need to know?

Conventions

Icons used in this book

Choosing commands in Microsoft Office 95

Your first tip

Getting Started

Chapter 1: Customizing Microsoft Word

Fiddling with the Way Word Works

Saving your files

"Where did I save that document?"

Printing stuff

Making Word act like WordPerfect 5.1 for DOS

Messing Around with Toolbars

Modifying existing toolbars

Making your own toolbars

Displaying toolbars in different ways

Making Menus Your Way

Modifying an existing menu

Making your own pull-down menus

Resetting your pull-down menus

Removing menu titles from your pull-down menus

Customizing the Keyboard

Assigning your own keystroke combinations

Removing all your keystroke combinations

Removing your keystroke combinations individually

Chapter 2: More about Macros

Recording Your Own Macros

Macros as toolbar buttons

Macros as menu commands

Macros as keystroke combinations

Editing Your Macros to Perfection

Understanding the ugly way macros look

Editing your macros

Renaming your macros

Wiping Out Macros

Recording over an existing macro

Deleting a macro from the face of the earth

Sharing Macros between Documents

Chapter 3: Formatting Text with Styles and Templates

Formatting Text with Styles

Creating a style

Using a style

Editing a style

Wiping out a style

Creating Document Templates

Using a template

Creating a template by modifying an existing one

Deleting a template

Changing the location of your templates

Chapter 4: Making Your Own Forms

Creating a Form Template

Designing Pretty Forms

Drawing tables on a form

Putting text on a form

Placing pretty graphics on a form

Adding borders and shading to your grid

Creating Online Forms with Form Fields

Making a text form field

Using a check box form field

Creating a drop-down form field

Adding Online Help

Sharing Your Online Forms

Saving and protecting your precious form templates

Creating an online form from a form template

Filling out an online form

Chapter 5: Creating an Index and Table of Contents

Making Your Very Own Index

Selecting words and individual page numbers

Marking words and page ranges for your index

Displaying your index in print

Creating an index (almost) automatically

Updating your index

Creating a Table of Contents

Using Word's built-in styles to format headings

Using your own styles to format headings

Updating your table of contents

Working with Master Documents

Creating a master document from scratch

Creating a master document from an existing document

Editing a subdocument

Collapsing and expanding subdocuments

Rearranging linked subdocuments

Adding, splitting, merging, and removing subdocuments

Chapter 6: Sharing Word Documents

Converting Files for Use with Other Word Processors

Exporting a Word file to another file format

Making Word export files flawlessly

Importing a file into Word

Hiding Comments with Annotations

Creating an annotation

Viewing annotations

Deleting an annotation

Printing a document with annotations

Marking up Text with Revision Marks

Turning revision marks on or off

Reviewing revision marks one by one

Reviewing revision marks all at one time

Using Word to Send E-mail

Installing Word as an e-mail editor

Using WordMail to write e-mail

Making Your Own Web Pages with Word and the Internet Assistant

Dissecting a Web page in Word

Making a Web page by using Word

Chapter 7: Customizing Microsoft Excel

Toying with Your Toolbars

Making a toolbar appear or disappear

Removing buttons from a toolbar

Adding buttons to a toolbar

Resetting toolbars to their original condition

Creating your own toolbars

Changing the shape of your toolbar

Deleting your custom toolbars

Changing the Way Excel Works and Looks

Saving your work

Messing around with the appearance of Excel

Changing Your Point of View

Hiding rows and columns on a worksheet

Freezing labels on a worksheet

Splitting screens on a worksheet

Zooming in for a closer look

Chapter 8: Having Fun with Formulas and Functions

Making Your Own Formulas

What the heck are references?

The magic of parentheses

Home on the cell range

Editing Formulas

Displaying formulas

Wiping out a formula

Editing a formula

Function Wizard to the Rescue!

Chapter 9: Verifying that Your Worksheets Really Work

How Excel Helps Verify Your Formulas

Tracing Your Formulas

Understanding where a formula gets its data

Knowing which formulas a cell affects

Getting rid of those precedent and dependent arrows

Knowing What to Do When a Formula Displays an Error Message

Digging into the Guts of Your Cells

Finding the Oddball Formula

Checking Your Spelling

Chapter 10: Printing Pretty Pages

Squeezing (or Blowing Up) Your Work

Setting Page Margins

Adjusting page margins the fast way

Adjusting page margins the slower, more precise way

Playing with Headers and Footers

Choosing a header and footer

Making your own headers and footers

Changing the Paper Size and Orientation

Changing the page orientation

Choosing the size of your paper

Printing Gridlines, Headings, and Page Orders

Chapter 11: Sharing Your Excel Files

Converting Files from or for Other Spreadsheets

Exporting an Excel file

Importing a file into Excel

Tacking on Notes to the Cells in Your Worksheet

Attaching notes

Finding your notes again

Printing notes

Deleting notes

Playing with Scenarios

Creating a scenario

Viewing a scenario

Editing a scenario

Deleting a scenario

Protecting Your Worksheets from the Harm Others May Do

Protecting your work

Unprotecting your work

Excel at Converting Worksheets into Web Page Tables

Chapter 12: Customizing PowerPoint

Changing PowerPoint Toolbars

Making your own toolbars

Playing with Pretty Colors

Changing the background colors

Altering your background patterns

Picking your own background colors

Changing the color scheme

Take Me to Your Slide Master

Defining the formatting of titles and text

Putting in pictures to appear on all your slides

Making text appear on all your slides

Chapter 13: Making Notes and Handouts

Making a Generic Notes Page

Jotting Down Notes for Posterity

Creating notes for yourself

Writing notes during a presentation

Printing your notes pages

Providing Distracting Handouts to Your Audience

Chapter 14: Showing Off Your PowerPoint Presentations

Making Neat Transitions

Creating your slide's visual transition

Creating your slide's text transition

Sorting Your Slides

Hiding and Inserting Slides

Hiding an existing slide

Inserting a new slide

Packing Up Your Presentation for the Road

Testing your slide show

Copying your presentation to floppy disks

Making Great Web Pages From PowerPoint Presentations

Chapter 15: Customizing Schedule+

Playing with Different Days and Times

Changing the Way Your Reminders and Tasks Work

Modifying the Way Schedule+ Displays Your Data

Changing Time Zones

Adding and Removing Tabs

Removing a tab

Adding a tab

Moving a tab

Renaming a tab

Chapter 16: The Seven Habits of Successful People

Learning the Seven Habits of Success

Choosing Your Mission

Role-Playing Your Way to Success

Aiming For Your Goals

Gaining Wisdom from Others

Chapter 17: Customizing Microsoft Access

Modifying Your Toolbars

Modifying existing toolbars

Making your own toolbars

Displaying toolbars in different ways

Making Access Work with Your Keyboard

Changing the Way Access Prints

Chapter 18: Automating Microsoft Access

Making Macros

Creating a macro

Running a macro

Deleting a macro

Using Command Buttons

Creating a command button

Deleting a command button

Real Programming with Visual Basic

Creating a command button(for Visual Basic)

Writing an event procedure

Putting Access Databases on the Web

Chapter 19: Sharing Your Microsoft Access Databases

Converting Databases to (And from) Access

Turning foreign files into an Access database

Linking foreign files to Access

Converting Access databases into another file format

Creating a Startup Form

Designing your startup form

Adding a button to close your startup form

Making your startup form appear

Password-Protecting Your Valuable Work

Creating a password

Opening a password-protected database

Removing a password

Chapter 20: Online Resources for Microsoft Office

Visiting the Microsoft Network

Getting Help from CompuServe

Microsoft Office on the Internet

Chapter 21: Making Microsoft Office Easier to Use

Starting up Microsoft Office Quickly

Click the Start button (and choose New/Open Office Document)

Click the Start button and use the Programs menu

Click the Microsoft Office Shortcut Bar

Click the right mouse button

Use the Windows Explorer

Click the Start button (and choose an individual program)

Using Microsoft Bookshelf

Looking up definitions

Finding alternatives in the thesaurus

Finding a neat quote

Finding fun stuff in the encyclopedia

Finding your country with an atlas

Somewhere in time

Using an almanac