Table of Contents

TABLESxvii

ACKNOWLEDGMENTSxix

INTRODUCTIONxx

     
What Makes This Book Differentxx
How I Use This Bookxxi
How This Book Is Structuredxxii
Part I: Introduction To Microsoft Officexxii
Part II: Word for Windowsxxiii
Part III: Microsoft Office Appletsxxiv
Part IV: Excelxxv
Part V: Using Microsoft Office Applications Togetherxxvi
Part VI: PowerPointxxvi
Getting The Sample Filesxxvii
Last Notesxxvii


PART I THE COMMON FEATURES
OF MICROSOFT OFFICE		 1


1     MICROSOFT OFFICE OVERVIEW 3
In The Good Old Days3
So What Is Microsoft Office?4
Versions5
What Does Microsoft Office Include?6
Some Common Features7
Common Menus9
Shortcut Menus10
Toolbars10
Summary Information (Office 4)13
Summary Information (Office 95)14
Short Cuts15
What Is New In Office 9515
Long File Names15
Enhanced File Dialog Boxes16
Schedule+16
Microsoft Binder16
Things That Have Improved In All The Programs17
Things That Have Improved In Word for Windows17
Things That Have Improved In Excel18
Things That Have Improved In PowerPoint19
Summary19


2     MICROSOFT OFFICE HELP 21
Microsoft Office 421
Microsoft Office 9528
Contents Tab28
Index Tab29
Find Tab30
Answer Wizard Tab30
Using Help Windows31
Options33
Getting Help With Dialog Boxes34
Wizards: Office 4 and Office 9535
Cue Cards: Office 4 and Office 9539
Summary39
Microsoft Office Under Windows 3.139
Microsoft Office 95 Under Windows 9540
Both Versions40


3     MICROSOFT OFFICE MANAGER 41
Using File Find42
Customizing MOM45
Larger Buttons46
More Or Different Buttons46
Short Cuts47
Summary47


4     MICROSOFT OFFICE SHORTCUT BAR 48
Shortcut Bar Components48
Switching Shortcut Bars49
Customizing The Shortcut Bar50
Customizing The View51
Customizing The Buttons51
Customizing The Toolbars51
Customizing The Settings52
Altered Windows 95 Start Menu52
Summary53


PART II     WORD FOR WINDOWS 55


5     GETTING STARTED WITH WORD FOR WINDOWS 58
A Tour Of Word59
Typing A Simple Document63
Saving Files64
Office 464
Office 9565
Save Often66
Opening A File70
Office 471
Office 9572
Formatting75
Page Formatting76
The End Of The Page76
Paragraph Formatting77
Selecting Text81
Copying Paragraph Formatting83
Other Paragraph Formatting84
Font Primer84
Text Formatting86
Highlighting (Office 95 Only)87
Undoing Formatting88
Editing88
Adding Text89
Deleting Text89
Changing Text89
Moving Text Around89
Shortcuts93
Searching For Text93
Replacing Text94
Printing95
Avoid Too Many Printouts95
Controlling Printing97
Summary98


6      EASIER FORMATTING WITH TEMPLATES, STYLES AND WIZARDS 101
Working With Multiple Documents101
Introduction To Templates102
Selecting A Template In Office 4102
Selecting A Template In Office 95102
The Normal Template103
Styles104
Formatting Several Lines At Once106
Modifying Style Sheet Entries107
Creating A New Style Entry110
Style Refreshing112
Managing All The Style Entries At Once112
Quick Changes114
Working With The Template File114
Creating Custom Documents Using Wizards116
Summary117


7     ADDITIONAL FORMATTING TECHNIQUES 119
Shortcut Menus119
Headers And Footers120
Fields122
Working With Toolbars125
Which Toolbars Do You Want To See?125
Where Do You Want Your Toolbars?126
What Do You Want On Your Toolbars?127
Working With Tabs128
Bulleted And Numbered Lists130
Excluding The Bullet Or Number131
Including The Bullet Or Number132
Office 95132
Paragraph Borders And Shading132
Footnotes And Endnotes134
Summary134


8     TOOLS TO IMPROVE YOUR WRITING 137
Checking Your Spelling137
Using The Spelling Checker137
Avoiding Flagging Correctly Spelled Words
Not In The Dictionary		139
Continual Spell Checking In Office 95139
Other Microsoft Office Applications140
AutoCorrect and AutoText140
AutoCorrect140
AutoText141
Thesaurus142
Grammar Checker142
Hyphenation144
Manual Hyphenation145
Automatic Hyphenation146
AutoFormat146
Envelopes And Labels146
Printing Envelopes147
Printing Labels147
Mail Merge148
Before You Start Writing149
Creating The Data Source Document150
Creating The Main Document153
Performing The Merge155
Restricting The Merge155
Envelopes and Labels156
Save Postage157
Tables157
Table Tour159
Creating A Table160
Editing A Table164
Changing Row Heights And Column Widths166
More Improvements To Tables167
Formatting Tables169
Summary169


9     OTHER WORD FOR WINDOWS FEATURES 173
Undo And Redo173
Working With Different Views174
Five Views174
Switching Views178
Zooming179
Split Screen180
Seeing More Than Two Views Of A Document181
Search And Replace182
Simple Searching182
Simple Replacing183
More Searching And Replacing Options184
Jumping Around Your Document185
Working With Different File Formats186
Summary Statistics186
Summary Statistics in Office 4186
Summary Statistics in Office 95187
Summary188


19     WORKING WITH LONG DOCUMENTS 190
Outlining190
What Is Outlining?191
Using Outlines With Long Documents192
Outline View194
Creating An Outline196
The Purpose Of Outline View196
Selecting Text In Outline View197
Editing In Outline View197
Table Of Contents198
Dividing Your Document Into Sections199
Inserting The Section Break200
Resetting The Page Numbers For Different Sections201
Adding An Index202
Marking Index Entries202
Editing The Index204
Formatting Long Documents206
Summary206


11     WRITING A NEWSLETTER 208
Multiple Columns209
Adding Multiple Columns210
Viewing Multiple Columns211
Changing Multiple Times212
Shrink To Fit213
Frames214
What Is A Frame Anyway?215
Inserting A Frame215
Removing A Frame216
Putting Something Into A Frame216
Framing Your Frame217
Positioning A Frame217
Working With Graphics217
Inserting The Image218
Resizing The Image219
Summary219


12     PRINTING FROM WORD 222
Printing Your Document224
Summary225


13     CUSTOMIZING WORD FOR WINDOWS 226
The Options Dialog Box226
Customizing Toolbars228
Adding A Button229
Deleting A Button229
Rearranging The Buttons230
Changing The Appearance Of A Button230
Resetting Your Changes230
Saving Your Changes230
Customizing Menus230
Customizing Shortcut Key Assignments231
Summary232


14     DOCUMENT DESIGN 223
Accent Marks And Other International Characters233
ALL UPPERCASE234
Dashes234
Indenting Paragraphs235
Justified Paragraphs235
Quotation Marks236
Space After A Period236
Small Capitals236
Underlining237
Use Numbers For Numbers237
Summary237


PART III     MICROSOFT OFFICE APPLETS 239


15     MICROSOFT OFFICE APPLETS 241
Understanding Embedding241
Equation Editor243
Dealing With Equations That Are Too Small244
Creating An Equation246
ClipArt Gallery249
Graph250
The Datasheet252
The Charts253
Organization Chart254
Schedule+: (Office 95 Only)255
An Introductory Tour255
Scheduling Your Time257
Scheduling Meetings258
Scheduling Events259
Tracking Your To-Do List259
Managing Contacts261
WordArt261
Summary263


16     ELECTRONIC MAIL (OFFICE 4 ONLY) 266
A Warning267
What Happened To My Mail Program?268
Starting Mail268
Sending A Message268
Sending A Document269
Attaching A File To Your Message269
Receiving A File270
Reading A Message270
Replying To A Message271
Summary271


PART IV     EXCEL 273


17     GETTING STARTED WITH EXCEL 275
A Tour Of Excel277
Moving Around In A Worksheet282
Using A Mouse282
Using The Keyboard282
Scrolling Instead Of Moving283
Entering Data284
Correcting Mistakes284
Entering Different Types Of Data285
Creating A Simple Worksheet286
Formatting The Worksheet287
Entering Formulas288
Copying Formulas289
A Copying Shortcut290
Formatting Numbers And Formulas290
Undoing Actions293
Repeating Actions293
Saving Files293
Office 4294
Office 95294
Saving Your Workspace296
Opening Files297
Office 4297
Office 95298
Workspaces300
Another Example300
Worksheets In General303
A Few Words On The General Layout
Of Your Spreadsheet		303
Summary304


18     ADVANCED WORKSHEET EDITING 307
Formatting307
Word Wrap307
Page Formatting308
Advanced Text Formatting309
Page Breaks312
Making Your Worksheet Functional And Attractive313
Automatic Formatting315
Selecting Cells And Ranges316
Copying The Selected Range317
Moving The Selected Range317
Copying Formatting From One Range To Another318
Using Styles318
AutoCalculate (Office 95 Only)319
Filling A Range With Values319
AutoFill320
Creating A Custom AutoFill List321
AutoComplete322
Clearing A Cell Or Range Of Cells323
Deleting And Inserting Rows And Columns323
Searching For Text323
Replacing Text324
Summary325


19     PERFORMING MORE COMPLEX CALCULATIONS USING EXCEL 327
Functions327
Syntax328
A Shortcut For Lotus Users329
Summing A Range Of Values329
The Function Wizard330
Common Functions332
Editing A Function334
Getting Help On The Different Functions334
Giving Names To Ranges335
What Is A Range Name?335
Creating A Range Name335
Using A Range Name336
Working With More Than One Sheet337
Renaming A Sheet337
Switching Between Sheets338
Adding, Deleting, And Moving Sheets338
A Shortcut339
Using Data From Other Sheets
and Workbooks In A Formula		340
Summary341


20     ADVANCED ANALYTICAL TOOLS 344
What-If Analysis344
A Little Background345
What-If Analysis And Buying A House346
Using Scenarios To Perform What-If Analysis348
Spelling352
The Spelling Checker352
AutoCorrect (Office 95 Only)354
Auditing Your Worksheet354
Precedent Cells355
Dependent Cells357
Errors357
Notes358
Finding "The" Answer359
Goal Seeker359
Finding A More Complex Solution Using Solver360
Summary364


21     ADVANCED DATA MANIPULATION TOOLS 366
Database Terms366
Creating A List367
Adding More Data By Filling Out A Form368
Using Pick From List To Speed Data Entry (Office 95)369
Keeping Your Database In Order369
Finding Records370
Using Forms370
Using Filters371
Summarizing Data372
Summary374


22     DISPLAYING YOUR DATA WITH CHARTS 376
The Data376
Chart Wizard377
Chart Adjustments379
Data Map (Office 95)380
Creating The Map381
Customizing The Map382
Printing Your Chart384
Summary385


23     PRINTING FROM EXCEL 386
A Final Check Before You Print386
Printing Your Worksheet389
Summary390


24     CUSTOMIZING EXCEL 391
The Options Dialog Box391
Customizing Toolbars395
Moving Toolbars396
Adding A Button396
Deleting A Button397
Rearranging The Buttons397
Changing The Appearance Of A Button397
Resetting Your Changes397
Saving Your Changes398
Summary398


PART V USING MICROSOFT OFFICE
APPLICATIONS TOGETHER		 399


25     USING MICROSOFT OFFICE APPLICATIONS TOGETHER 401
Object Linking And Embedding402
When To Use Copy And Paste,
When To Use Linking, And When To Use Embedding		403
A Warning Regarding Linking And Embedding403
Windows 3.1404
Windows 95404
Copy And Paste404
Embedding405
Linking408
Summary409


26     MICROSOFT BINDER (OFFICE 95 ONLY) 410
An Example410
Adding Sections410
Rearranging Sections412
Hiding The Section Name Window413
Printing413
Sharing Files413
Summary414


PART VI     POWER POINT 415


27     A SIMPLE POWERPOINT PRESENTATION 417
Developing A Simple Presentation417
Outlining419
Adding Graphics420
Fine Tuning Your Presentation422
Making Your Presentation423
A Few Notes On Writing An Effective Presentation424
Summary425


28     EXPANDING ON YOUR POWERPOINT PRESENTATION 427
Adding Charts427
Using Excel427
Using Microsoft Graph427
Adding Tables428
Changing The Format429
The Background429
The Colors430
Displaying Your Presentation On The Screen431
Transitions431
Builds432
Timed Display432
Showing On Other Computers433
Summary434


APPENDIX     TIME MANAGEMENT FOR THE HOME-BASED OFFICE 435
Microsoft Office Index447
Excel Index459