Attention customers: online shopping is now available exclusively through our main website: http://www.manning.com. Thank you.

Microsoft Office Essentials

Manning Publications Co.
209 Bruce Park Avenue
Greenwich, CT 06830

Microsoft Office Essentials Ronny Richardson 1996 | 480 pages ISBN: 132623129
	$24.95	Softbound print book

Table of Contents

TABLES			xvii
ACKNOWLEDGMENTS			xix
INTRODUCTION			xx
		What Makes This Book Different	xx
		How I Use This Book	xxi
		How This Book Is Structured	xxii
		Part I: Introduction To Microsoft Office	xxii
		Part II: Word for Windows	xxiii
		Part III: Microsoft Office Applets	xxiv
		Part IV: Excel	xxv
		Part V: Using Microsoft Office Applications Together	xxvi
		Part VI: PowerPoint	xxvi
		Getting The Sample Files	xxvii
		Last Notes	xxvii
PART I THE COMMON FEATURES OF MICROSOFT OFFICE 1
1     MICROSOFT OFFICE OVERVIEW			3
		In The Good Old Days	3
		So What Is Microsoft Office?	4
		Versions	5
		What Does Microsoft Office Include?	6
		Some Common Features	7
		Common Menus	9
		Shortcut Menus	10
		Toolbars	10
		Summary Information (Office 4)	13
		Summary Information (Office 95)	14
		Short Cuts	15
		What Is New In Office 95	15
		Long File Names	15
		Enhanced File Dialog Boxes	16
		Schedule+	16
		Microsoft Binder	16
		Things That Have Improved In All The Programs	17
		Things That Have Improved In Word for Windows	17
		Things That Have Improved In Excel	18
		Things That Have Improved In PowerPoint	19
		Summary	19
2     MICROSOFT OFFICE HELP			21
		Microsoft Office 4	21
		Microsoft Office 95	28
		Contents Tab	28
		Index Tab	29
		Find Tab	30
		Answer Wizard Tab	30
		Using Help Windows	31
		Options	33
		Getting Help With Dialog Boxes	34
		Wizards: Office 4 and Office 95	35
		Cue Cards: Office 4 and Office 95	39
		Summary	39
		Microsoft Office Under Windows 3.1	39
		Microsoft Office 95 Under Windows 95	40
		Both Versions	40
3     MICROSOFT OFFICE MANAGER			41
		Using File Find	42
		Customizing MOM	45
		Larger Buttons	46
		More Or Different Buttons	46
		Short Cuts	47
		Summary	47
4     MICROSOFT OFFICE SHORTCUT BAR			48
		Shortcut Bar Components	48
		Switching Shortcut Bars	49
		Customizing The Shortcut Bar	50
		Customizing The View	51
		Customizing The Buttons	51
		Customizing The Toolbars	51
		Customizing The Settings	52
		Altered Windows 95 Start Menu	52
		Summary	53
PART II     WORD FOR WINDOWS 55
5     GETTING STARTED WITH WORD FOR WINDOWS			58
		A Tour Of Word	59
		Typing A Simple Document	63
		Saving Files	64
		Office 4	64
		Office 95	65
		Save Often	66
		Opening A File	70
		Office 4	71
		Office 95	72
		Formatting	75
		Page Formatting	76
		The End Of The Page	76
		Paragraph Formatting	77
		Selecting Text	81
		Copying Paragraph Formatting	83
		Other Paragraph Formatting	84
		Font Primer	84
		Text Formatting	86
		Highlighting (Office 95 Only)	87
		Undoing Formatting	88
		Editing	88
		Adding Text	89
		Deleting Text	89
		Changing Text	89
		Moving Text Around	89
		Shortcuts	93
		Searching For Text	93
		Replacing Text	94
		Printing	95
		Avoid Too Many Printouts	95
		Controlling Printing	97
		Summary	98
6      EASIER FORMATTING WITH TEMPLATES, STYLES AND WIZARDS			101
		Working With Multiple Documents	101
		Introduction To Templates	102
		Selecting A Template In Office 4	102
		Selecting A Template In Office 95	102
		The Normal Template	103
		Styles	104
		Formatting Several Lines At Once	106
		Modifying Style Sheet Entries	107
		Creating A New Style Entry	110
		Style Refreshing	112
		Managing All The Style Entries At Once	112
		Quick Changes	114
		Working With The Template File	114
		Creating Custom Documents Using Wizards	116
		Summary	117
7     ADDITIONAL FORMATTING TECHNIQUES			119
		Shortcut Menus	119
		Headers And Footers	120
		Fields	122
		Working With Toolbars	125
		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 Tabs	128
		Bulleted And Numbered Lists	130
		Excluding The Bullet Or Number	131
		Including The Bullet Or Number	132
		Office 95	132
		Paragraph Borders And Shading	132
		Footnotes And Endnotes	134
		Summary	134
8     TOOLS TO IMPROVE YOUR WRITING			137
		Checking Your Spelling	137
		Using The Spelling Checker	137
		Avoiding Flagging Correctly Spelled Words Not In The Dictionary	139
		Continual Spell Checking In Office 95	139
		Other Microsoft Office Applications	140
		AutoCorrect and AutoText	140
		AutoCorrect	140
		AutoText	141
		Thesaurus	142
		Grammar Checker	142
		Hyphenation	144
		Manual Hyphenation	145
		Automatic Hyphenation	146
		AutoFormat	146
		Envelopes And Labels	146
		Printing Envelopes	147
		Printing Labels	147
		Mail Merge	148
		Before You Start Writing	149
		Creating The Data Source Document	150
		Creating The Main Document	153
		Performing The Merge	155
		Restricting The Merge	155
		Envelopes and Labels	156
		Save Postage	157
		Tables	157
		Table Tour	159
		Creating A Table	160
		Editing A Table	164
		Changing Row Heights And Column Widths	166
		More Improvements To Tables	167
		Formatting Tables	169
		Summary	169
9     OTHER WORD FOR WINDOWS FEATURES			173
		Undo And Redo	173
		Working With Different Views	174
		Five Views	174
		Switching Views	178
		Zooming	179
		Split Screen	180
		Seeing More Than Two Views Of A Document	181
		Search And Replace	182
		Simple Searching	182
		Simple Replacing	183
		More Searching And Replacing Options	184
		Jumping Around Your Document	185
		Working With Different File Formats	186
		Summary Statistics	186
		Summary Statistics in Office 4	186
		Summary Statistics in Office 95	187
		Summary	188
19     WORKING WITH LONG DOCUMENTS			190
		Outlining	190
		What Is Outlining?	191
		Using Outlines With Long Documents	192
		Outline View	194
		Creating An Outline	196
		The Purpose Of Outline View	196
		Selecting Text In Outline View	197
		Editing In Outline View	197
		Table Of Contents	198
		Dividing Your Document Into Sections	199
		Inserting The Section Break	200
		Resetting The Page Numbers For Different Sections	201
		Adding An Index	202
		Marking Index Entries	202
		Editing The Index	204
		Formatting Long Documents	206
		Summary	206
11     WRITING A NEWSLETTER			208
		Multiple Columns	209
		Adding Multiple Columns	210
		Viewing Multiple Columns	211
		Changing Multiple Times	212
		Shrink To Fit	213
		Frames	214
		What Is A Frame Anyway?	215
		Inserting A Frame	215
		Removing A Frame	216
		Putting Something Into A Frame	216
		Framing Your Frame	217
		Positioning A Frame	217
		Working With Graphics	217
		Inserting The Image	218
		Resizing The Image	219
		Summary	219
12     PRINTING FROM WORD			222
		Printing Your Document	224
		Summary	225
13     CUSTOMIZING WORD FOR WINDOWS			226
		The Options Dialog Box	226
		Customizing Toolbars	228
		Adding A Button	229
		Deleting A Button	229
		Rearranging The Buttons	230
		Changing The Appearance Of A Button	230
		Resetting Your Changes	230
		Saving Your Changes	230
		Customizing Menus	230
		Customizing Shortcut Key Assignments	231
		Summary	232
14     DOCUMENT DESIGN			223
		Accent Marks And Other International Characters	233
		ALL UPPERCASE	234
		Dashes	234
		Indenting Paragraphs	235
		Justified Paragraphs	235
		Quotation Marks	236
		Space After A Period	236
		Small Capitals	236
		Underlining	237
		Use Numbers For Numbers	237
		Summary	237
PART III     MICROSOFT OFFICE APPLETS 239
15     MICROSOFT OFFICE APPLETS			241
		Understanding Embedding	241
		Equation Editor	243
		Dealing With Equations That Are Too Small	244
		Creating An Equation	246
		ClipArt Gallery	249
		Graph	250
		The Datasheet	252
		The Charts	253
		Organization Chart	254
		Schedule+: (Office 95 Only)	255
		An Introductory Tour	255
		Scheduling Your Time	257
		Scheduling Meetings	258
		Scheduling Events	259
		Tracking Your To-Do List	259
		Managing Contacts	261
		WordArt	261
		Summary	263
16     ELECTRONIC MAIL (OFFICE 4 ONLY)			266
		A Warning	267
		What Happened To My Mail Program?	268
		Starting Mail	268
		Sending A Message	268
		Sending A Document	269
		Attaching A File To Your Message	269
		Receiving A File	270
		Reading A Message	270
		Replying To A Message	271
		Summary	271
PART IV     EXCEL 273
17     GETTING STARTED WITH EXCEL			275
		A Tour Of Excel	277
		Moving Around In A Worksheet	282
		Using A Mouse	282
		Using The Keyboard	282
		Scrolling Instead Of Moving	283
		Entering Data	284
		Correcting Mistakes	284
		Entering Different Types Of Data	285
		Creating A Simple Worksheet	286
		Formatting The Worksheet	287
		Entering Formulas	288
		Copying Formulas	289
		A Copying Shortcut	290
		Formatting Numbers And Formulas	290
		Undoing Actions	293
		Repeating Actions	293
		Saving Files	293
		Office 4	294
		Office 95	294
		Saving Your Workspace	296
		Opening Files	297
		Office 4	297
		Office 95	298
		Workspaces	300
		Another Example	300
		Worksheets In General	303
		A Few Words On The General Layout Of Your Spreadsheet	303
		Summary	304
18     ADVANCED WORKSHEET EDITING			307
		Formatting	307
		Word Wrap	307
		Page Formatting	308
		Advanced Text Formatting	309
		Page Breaks	312
		Making Your Worksheet Functional And Attractive	313
		Automatic Formatting	315
		Selecting Cells And Ranges	316
		Copying The Selected Range	317
		Moving The Selected Range	317
		Copying Formatting From One Range To Another	318
		Using Styles	318
		AutoCalculate (Office 95 Only)	319
		Filling A Range With Values	319
		AutoFill	320
		Creating A Custom AutoFill List	321
		AutoComplete	322
		Clearing A Cell Or Range Of Cells	323
		Deleting And Inserting Rows And Columns	323
		Searching For Text	323
		Replacing Text	324
		Summary	325
19     PERFORMING MORE COMPLEX CALCULATIONS USING EXCEL			327
		Functions	327
		Syntax	328
		A Shortcut For Lotus Users	329
		Summing A Range Of Values	329
		The Function Wizard	330
		Common Functions	332
		Editing A Function	334
		Getting Help On The Different Functions	334
		Giving Names To Ranges	335
		What Is A Range Name?	335
		Creating A Range Name	335
		Using A Range Name	336
		Working With More Than One Sheet	337
		Renaming A Sheet	337
		Switching Between Sheets	338
		Adding, Deleting, And Moving Sheets	338
		A Shortcut	339
		Using Data From Other Sheets and Workbooks In A Formula	340
		Summary	341
20     ADVANCED ANALYTICAL TOOLS			344
		What-If Analysis	344
		A Little Background	345
		What-If Analysis And Buying A House	346
		Using Scenarios To Perform What-If Analysis	348
		Spelling	352
		The Spelling Checker	352
		AutoCorrect (Office 95 Only)	354
		Auditing Your Worksheet	354
		Precedent Cells	355
		Dependent Cells	357
		Errors	357
		Notes	358
		Finding "The" Answer	359
		Goal Seeker	359
		Finding A More Complex Solution Using Solver	360
		Summary	364
21     ADVANCED DATA MANIPULATION TOOLS			366
		Database Terms	366
		Creating A List	367
		Adding More Data By Filling Out A Form	368
		Using Pick From List To Speed Data Entry (Office 95)	369
		Keeping Your Database In Order	369
		Finding Records	370
		Using Forms	370
		Using Filters	371
		Summarizing Data	372
		Summary	374
22     DISPLAYING YOUR DATA WITH CHARTS			376
		The Data	376
		Chart Wizard	377
		Chart Adjustments	379
		Data Map (Office 95)	380
		Creating The Map	381
		Customizing The Map	382
		Printing Your Chart	384
		Summary	385
23     PRINTING FROM EXCEL			386
		A Final Check Before You Print	386
		Printing Your Worksheet	389
		Summary	390
24     CUSTOMIZING EXCEL			391
		The Options Dialog Box	391
		Customizing Toolbars	395
		Moving Toolbars	396
		Adding A Button	396
		Deleting A Button	397
		Rearranging The Buttons	397
		Changing The Appearance Of A Button	397
		Resetting Your Changes	397
		Saving Your Changes	398
		Summary	398
PART V USING MICROSOFT OFFICE APPLICATIONS TOGETHER 399
25     USING MICROSOFT OFFICE APPLICATIONS TOGETHER			401
		Object Linking And Embedding	402
		When To Use Copy And Paste, When To Use Linking, And When To Use Embedding	403
		A Warning Regarding Linking And Embedding	403
		Windows 3.1	404
		Windows 95	404
		Copy And Paste	404
		Embedding	405
		Linking	408
		Summary	409
26     MICROSOFT BINDER (OFFICE 95 ONLY)			410
		An Example	410
		Adding Sections	410
		Rearranging Sections	412
		Hiding The Section Name Window	413
		Printing	413
		Sharing Files	413
		Summary	414
PART VI     POWER POINT 415
27     A SIMPLE POWERPOINT PRESENTATION			417
		Developing A Simple Presentation	417
		Outlining	419
		Adding Graphics	420
		Fine Tuning Your Presentation	422
		Making Your Presentation	423
		A Few Notes On Writing An Effective Presentation	424
		Summary	425
28     EXPANDING ON YOUR POWERPOINT PRESENTATION			427
		Adding Charts	427
		Using Excel	427
		Using Microsoft Graph	427
		Adding Tables	428
		Changing The Format	429
		The Background	429
		The Colors	430
		Displaying Your Presentation On The Screen	431
		Transitions	431
		Builds	432
		Timed Display	432
		Showing On Other Computers	433
		Summary	434
APPENDIX     TIME MANAGEMENT FOR THE HOME-BASED OFFICE			435
		Microsoft Office Index	447
		Excel Index	459

DESCRIPTION

Many books on Microsoft Office try to cover every feature of the software. You don't use every feature, though. Microsoft Office Essentials simply covers the things you really want to know and skips over all those esoteric features that 99 out of 100 readers never use.

You will learn, among other things, how to use:

• Microsoft Office Manager and Shortcut Bar
• Word's formatting tools -- templates, styles, and wizards
• Word to create newsletters, reports, etc.
• Word and Excel together, capitalizing on the strengths of both
• Excel to create simple workbooks for such tasks as balancing your checkbook or preparing a budget
• Excel to display your data with charts
• Powerpoint to develop a presentation that combines words and clip-art images

Once you get to know Microsoft Office Essentials you'll want to keep it within easy reach of you computer...

ABOUT THE AUTHOR...

Ronny Richardson, now a faculty member at Southern Polytechnic State University, was formerly a financial analyst at a Fortune 100 company where he developed and maintained thousands of spreadsheets, large and small. He has written 20 computer books, including several best sellers.

Home | Catalog | Privacy Policy | About Manning

© 2003-2006 Manning Publications Co.