Acknowledgments
|
xxviii
|
Introduction
|
xxix
|
How This Book Is Organized
|
xxx
|
Who This Book Is For
|
xxxii
|
Conventions Used in This Book
|
xxxii
|
Visiting Our Web Site
|
xxxiii
|
Using the Book's Sample Files
|
xxxiii
|
Office 2000 and the Y2K Problem
|
xxxiv
|
The Nature of the Y2K Problem
|
xxxv
|
Planning for the Year 2000
|
xxxvi
|
Resources for the Y2K Problem
|
xxxvii
|
Microsoft Office 2000 Support
|
xxxviii
|
Contacting the Authors
|
xxxviii
|
Part I Getting Started with Microsoft Office
|
1
|
Chapter 1 A Quick Tour of Microsoft Office
|
3
|
Introducing Microsoft Office
|
4
|
What's New in the Software?
|
5
|
Microsoft Office 2000
|
5
|
Microsoft Word
|
7
|
Microsoft Excel
|
8
|
Microsoft PowerPoint
|
8
|
Microsoft Access
|
9
|
Microsoft Outlook
|
9
|
Choosing an Office Application
|
10
|
Running Office Applications
|
11
|
Clicking the Start Button
|
11
|
Clicking a Program Icon on the Office Shortcut Bar
|
12
|
Creating Files Using a Document Template
|
13
|
Opening Documents Using Microsoft Outlook
|
16
|
Switching Between Office Applications
|
17
|
Using the Help System
|
19
|
The Microsoft Help Command
|
20
|
The Office Assistant Feature
|
22
|
The What's This? Feature
|
24
|
Fixing Problems Using Detect And Repair
|
24
|
Exiting Office Applications
|
25
|
Chapter 2 Learning the Basics: Windows, Toolbars, and Printing
|
27
|
Working with Application Windows
|
28
|
Understanding the Workplace
|
29
|
Navigating Document Windows
|
31
|
Using Menus and Dialog Boxes
|
35
|
Menu Conventions
|
35
|
Dialog Box Options
|
36
|
Using Toolbars
|
39
|
What If I See Something Different?
|
40
|
Moving Toolbars
|
41
|
Adding and Removing Toolbars
|
43
|
Customizing Toolbars
|
44
|
Customizing Menus
|
50
|
Printing Documents
|
52
|
Using Print Preview
|
52
|
Using the Print Command
|
52
|
Troubleshooting Your Printer
|
57
|
Chapter 3 Managing Documents: From Your Hard Disk to the Internet
|
59
|
Opening an Existing Document
|
60
|
Browsing Through Folders
|
62
|
Previewing Files Using the Open Dialog Box
|
63
|
Performing an Automated Search for a File
|
64
|
Using the Find Command
|
66
|
Deleting Files, Renaming Files,and Creating New Folders
|
68
|
Saving Documents and Web Pages
|
69
|
Using the Save Command
|
70
|
Using the Save As Command
|
70
|
Saving Documents as Web Pages
|
75
|
Creating a New Document
|
77
|
Closing a Document
|
78
|
Working with Property Sheets
|
79
|
Sharing Documents in a Workgroup
|
82
|
Saving and Retrieving Files on a Network
|
82
|
Routing Files Using Microsoft Exchange
|
83
|
Sending Files by Electronic Mail
|
84
|
Using Online Collaboration
|
86
|
Browsing Documents on the Web
|
89
|
Linking Up with the World Wide Web
|
90
|
Using the Web Toolbar
|
91
|
Using Internet Explorer 5
|
93
|
Part II Microsoft Word
|
97
|
Chapter 4 Getting Started Using Word
|
99
|
Touring the Word Workplace
|
100
|
Creating and Printing a Document from Start to Finish
|
105
|
Changing the Way Documents Are Displayed
|
114
|
Chapter 5 Entering and Editing Text in a Word Document
|
117
|
Entering Text
|
118
|
Inserting Special Characters
|
119
|
Automatic Writing
|
120
|
Moving the Insertion Point
|
130
|
Editing Text
|
132
|
Selecting Text
|
133
|
Editing the Selection
|
138
|
Finding and Replacing Text
|
143
|
Navigating Through a Document Using Other Methods
|
148
|
Marking and Retrieving Text Using Bookmarks
|
149
|
Using the Go To Command
|
150
|
Using the Browse Buttons
|
154
|
Inserting and Navigating Using Hyperlinks
|
155
|
Chapter 6 Formatting a Word Document
|
159
|
Formatting Documents Automatically
|
160
|
Using the AutoFormat As You Type Feature
|
165
|
Applying a Theme
|
168
|
Using the Style Gallery
|
169
|
Using Click and Type
|
171
|
Applying Styles
|
172
|
Applying Paragraph Styles
|
173
|
Applying Character Styles
|
177
|
Applying Character Formatting Directly
|
178
|
Using the Font Dialog Box
|
181
|
Using Shortcut Keys to Apply Character Formatting
|
184
|
Using the Formatting Toolbar to Apply Character Formatting
|
186
|
Applying Paragraph Formatting Directly
|
187
|
Using the Paragraph Dialog Box
|
189
|
Using Shortcut Keys to Apply Paragraph Formatting
|
191
|
Using the Formatting Toolbar and Ruler to Apply Paragraph Formatting
|
193
|
Copying Formatting
|
194
|
Chapter 7 Customizing Styles and Templates
|
197
|
Modifying Styles
|
198
|
Modifying Styles by Example
|
200
|
Modifying Styles Using the Style Dialog Box
|
201
|
Creating New Styles
|
209
|
Creating Paragraph Styles by Example
|
209
|
Creating Styles Using the Style Dialog Box
|
210
|
Copying Styles
|
212
|
Copying Styles from a Template to a Document
|
212
|
Copying Styles from a Document to a Template
|
213
|
Modifying and Creating Document Templates
|
214
|
Modifying Templates
|
217
|
Creating New Templates
|
219
|
Changing the Template Attached to a Document and Loading Global Templates
|
220
|
Chapter 8 Arranging Text in Columns and Lists
|
223
|
Using Tabs
|
224
|
Defining Custom Tab Stops Using the Ruler
|
226
|
Defining Custom Tab Stops Using the Tabs Dialog Box
|
228
|
Using Tables
|
229
|
Inserting a Table
|
229
|
Entering Text into a Table
|
230
|
Inserting and Deleting Rows, Columns, and Cells
|
231
|
Adjusting the Size of Table Cells
|
234
|
Moving and Copying Rows, Columns, and Cells
|
237
|
Using the Table Menu Commands
|
239
|
Drawing Tables
|
241
|
Creating Newspaper-Style Columns
|
243
|
Setting Up Columns Using the Columns Button
|
244
|
Setting up Columns Using the Columns Dialog Box
|
245
|
Adjusting Columns
|
247
|
Creating Bulleted and Numbered Lists
|
248
|
Adding Bullets and Numbering Using the Formatting Toolbar
|
249
|
Adding Bullets and Numbering Using the Bullets And Numbering Dialog Box
|
250
|
Sorting Lists and Tables
|
253
|
Using Borders and Shading
|
256
|
Adding Borders and Shading Using the Tables And Borders Toolbar
|
257
|
Adding Borders and Shading Using the Borders And Shading Dialog Box
|
260
|
Adding Page Borders
|
264
|
Inserting Horizontal Dividing Lines
|
265
|
Chapter 9 Using Word's Proofing Tools
|
269
|
Marking the Language
|
270
|
Using Automatic Language Detection
|
271
|
Checking Your Spelling
|
273
|
Checking Your Spelling Automatically as You Type
|
273
|
Running the Spelling Checker Manually
|
275
|
Customizing the Spelling Checker
|
278
|
Using Custom Dictionaries
|
279
|
Checking Your Grammar
|
282
|
Checking Your Grammar Automatically as You Type
|
283
|
Running the Grammar Checker Manually
|
284
|
Customizing the Grammar Checker
|
287
|
Using the Thesaurus to Find Synonyms
|
288
|
Hyphenating Your Documents
|
291
|
Hyphenating Your Document Automatically
|
291
|
Hyphenating Your Document Using Confirmation
|
292
|
Inserting Hyphen Characters Manually
|
294
|
Chapter 10 Designing Pages
|
295
|
Adding Page Numbering
|
296
|
Adding Headers and Footers
|
299
|
Sizing and Moving Headers or Footers
|
302
|
Varying Headers or Footers Within the Document
|
304
|
Adjusting the Page Setup
|
306
|
Adjusting the Margins
|
308
|
Adjusting the Paper Size and Orientation
|
312
|
Adjusting the Paper Source
|
313
|
Adjusting the Page Layout
|
314
|
Using Text Boxes to Position Text on the Page
|
316
|
Adding Graphics
|
320
|
Importing Pictures
|
320
|
Creating Drawings in Word
|
323
|
Formatting Text Boxes, Pictures, and Drawing Objects
|
331
|
Using the Format Dialog Box
|
331
|
Using the Picture Toolbar
|
333
|
Adding Movie Clips, Scrolling Text, and Backgrounds
|
335
|
Previewing and Printing Documents
|
337
|
Chapter 11 Working with Word in Workgroups
|
341
|
Adding Comments to Your Documents
|
342
|
Tracking Document Changes
|
346
|
Reviewing Changes
|
349
|
Customizing Revision Marking
|
350
|
Working with Different Document Versions
|
351
|
Using Other Workgroup Techniques
|
353
|
Protecting Documents
|
353
|
Merging Tracked Changes
|
357
|
Highlighting Text
|
358
|
Sharing Fonts
|
359
|
Online Collaboration
|
360
|
Chapter 12 Writing Long Documents
|
361
|
Using Outline View
|
362
|
Switching to Outline View
|
362
|
Changing Heading Levels
|
364
|
Moving Blocks of Text
|
367
|
Collapsing and Expanding Text
|
368
|
Browsing Through Outline Headings
|
371
|
Printing an Outline
|
373
|
Adding Footnotes and Endnotes
|
374
|
Creating Indexes and Tables of Contents
|
378
|
Creating an Index
|
378
|
Creating a Table of Contents
|
382
|
Chapter 13 Using Word to Automate Mailing
|
385
|
Printing Individual Envelopes and Labels
|
386
|
Printing Individual Envelopes
|
386
|
Printing Individual Labels
|
389
|
Using Mail Merge for Large Mailings
|
392
|
Printing Form Letters
|
392
|
Printing Sets of Envelopes
|
399
|
Printing Sets of Mailing Labels
|
402
|
Chapter 14 Automating Word Using Macros
|
405
|
Recording Macros
|
406
|
Managing Macros
|
408
|
Running Macros
|
409
|
Macro Examples
|
410
|
Part III Microsoft Excel
|
413
|
Chapter 15 Building a Worksheet
|
415
|
Starting Excel and Getting Comfortable
|
416
|
Navigating a Worksheet
|
418
|
Entering Information
|
421
|
Entering Numeric Values
|
421
|
Entering Text Values
|
423
|
Entering Dates and Times
|
424
|
Entering Comments
|
426
|
Entering Formulas
|
427
|
Adding Artwork
|
430
|
Inserting Hyperlinks
|
433
|
Creating a Hyperlink in Your Worksheet
|
433
|
Activating a Hyperlink
|
435
|
Editing and Removing Hyperlinks
|
437
|
Saving the Workbook
|
437
|
Exiting Excel (A Few Points to Remember)
|
438
|
Chapter 16 Editing a Worksheet
|
441
|
Essential Editing Techniques
|
442
|
Selecting Cells and Ranges
|
442
|
Clearing Cells and Deleting Cells
|
444
|
Undoing Commands
|
445
|
Using Cut and Paste to Move Data
|
448
|
Using the New Office Clipboard Toolbar
|
449
|
Using Copy and Paste to Duplicate Data
|
450
|
Moving Cells by Dragging
|
451
|
Adding Rows and Columns to the Worksheet
|
452
|
Entering a Series of Labels, Numbers, and Dates
|
453
|
Using AutoFill to Create a Series
|
454
|
Using the Fill Commands
|
455
|
Chapter 17 Formatting a Worksheet
|
457
|
Formatting Cells
|
458
|
Changing Alignment
|
458
|
Changing Number Formats
|
462
|
Changing Text Font and Text Color
|
466
|
Adding Borders to Cells
|
468
|
Adding Shading to Cells
|
470
|
Copying Formatting Using the Format Painter Button
|
471
|
Changing Column Widths and Row Heights
|
472
|
Adjusting the Height or Width Manually
|
473
|
Using the AutoFit Command
|
475
|
Applying a Combination of Effects Using AutoFormat
|
476
|
Creating Conditional Formatting
|
477
|
Using Styles
|
480
|
Creating Your Own Styles
|
480
|
Applying Existing Styles
|
482
|
Merging Styles from Other Workbooks
|
483
|
Creating Templates
|
484
|
Opening and Modifying an Existing Template File
|
485
|
Creating a New Template File
|
487
|
Changing Page Breaks
|
487
|
Using Page Break Preview
|
488
|
Chapter 18 Using Workbooks to Organize Information
|
491
|
Managing Worksheets
|
492
|
Switching Between Worksheets
|
492
|
Naming Worksheets
|
493
|
Deleting Worksheets
|
493
|
Inserting Worksheets
|
495
|
Moving Worksheets
|
496
|
Linking Information Between Worksheets
|
497
|
Using More Than One Workbook
|
499
|
Switching Between Workbooks
|
500
|
Linking Information Between Workbooks
|
501
|
Managing Shared Workbooks
|
504
|
Creating a Shared Workbook
|
505
|
Monitoring a Shared Workbook
|
506
|
Accepting or Rejecting Revisions
|
507
|
Merging Workbooks
|
510
|
Protecting Worksheets and Workbooks
|
511
|
Protecting Worksheets
|
511
|
Protecting Workbook Structure
|
513
|
Requiring a Password for File Access
|
514
|
Chapter 19 Customizing Excel to Work the Way You Do
|
517
|
Adjusting Views
|
518
|
Using the Zoom Command
|
518
|
Saving Views Using the Custom Views Command
|
520
|
Setting Printing Options
|
521
|
Controlling Page Orientation
|
522
|
Adjusting the Margins
|
523
|
Adding Headers and Footers
|
523
|
Adding Gridlines and Other Options
|
527
|
Setting AutoCorrect Options
|
529
|
Customizing Excel Using the Options Dialog Box
|
531
|
Controlling Calculation
|
531
|
Customizing Worksheet Appearance
|
533
|
Customizing Editing Options
|
534
|
Installing Add-in Commands and Wizards
|
535
|
Chapter 20 Using Formulas and Functions to Crunch Numbers
|
537
|
Building a Formula
|
538
|
Multiplying Numbers
|
538
|
Replicating a Formula
|
540
|
Using Arithmetic Operators
|
542
|
Parentheses and Order of Evaluation
|
542
|
Using Built-in Functions
|
544
|
The Versatile SUM Function
|
545
|
The Insert Function Command
|
546
|
Using Functions to Analyze Finances
|
548
|
Using PMT to Determine Loan Payments
|
549
|
Using FV to Compute Future Value
|
550
|
Using RATE to Evaluate Rate of Return
|
551
|
Using Function Error Values
|
553
|
Using Range Names in Functions
|
554
|
Creating Range Names
|
554
|
Putting Range Names to Work
|
555
|
Modifying Ranges
|
556
|
Deleting Range Names
|
557
|
Chapter 21 Creating Worksheet Charts
|
559
|
Planning a Chart
|
560
|
Creating a Chart
|
562
|
Creating an Embedded Chart
|
565
|
Formatting a Chart
|
569
|
Exploring the Chart Menu
|
569
|
Using the Charting Toolbar
|
570
|
Changing the Chart Type
|
570
|
Changing Titles and Labels
|
571
|
Adjusting Gridlines
|
574
|
Modifying the Chart Legend
|
575
|
Adding Labels and Arrows
|
577
|
Printing a Chart
|
579
|
Chapter 22 Working with Lists, Databases, and Pivot Tables
|
581
|
Using a List of Cells as a Database
|
582
|
Using a Form for Data Entry
|
583
|
Validating Data as You Enter It
|
584
|
Sorting Rows and Columns
|
587
|
Sorting on More Than One Column
|
588
|
Creating Your Own Custom Sort Order
|
590
|
Using a Custom Sort Order
|
590
|
Using AutoFilter to Find Records
|
592
|
Creating a Custom AutoFilter
|
593
|
Using the Subtotals Command to Organize a List
|
594
|
Working in Outline View
|
597
|
Converting an Excel List into an Access Database
|
598
|
Creating Pivot Tables and Pivot Charts
|
599
|
Using the PivotTable And PivotChart Wizard
|
599
|
Evaluating a Pivot Table
|
603
|
Rearranging Fields in a Pivot Table
|
604
|
Changing the Function in a Pivot Table
|
605
|
Adjusting the Formatting in a Pivot Table
|
606
|
Displaying Pivot Charts
|
607
|
Using External Data Sources in Pivot Tables
|
609
|
Chapter 23 Analyzing Business Data
|
611
|
Using the Goal Seek Command to Forecast
|
612
|
Using the Solver to Set Quantity and Pricing
|
615
|
Setting Up the Problem
|
616
|
Running the Solver
|
617
|
Editing Your Solver Forecast
|
621
|
Using the Scenario Manager to Evaluate What-If Questions
|
623
|
Creating a Scenario
|
623
|
Viewing a Scenario
|
626
|
Creating Scenario Reports
|
628
|
Chapter 24 Using Excel to Publish to the Web
|
631
|
Designing a Web Page
|
632
|
Static Pages vs. Interactive Pages
|
633
|
Setting Web Publication Options
|
633
|
Running Excel Web Pages on the Internet
|
637
|
Using Office Web Toolbars
|
639
|
Chapter 25 Using Macros to Increase Productivity
|
643
|
Carpe Datum: Knowing When to Build a Macro
|
644
|
Recording a Macro
|
644
|
Running a Macro
|
646
|
Starting a Macro with the Macro Dialog Box
|
647
|
Assigning a Shortcut Key to a Macro
|
648
|
Editing a Macro
|
649
|
Using the Personal Macro Workbook
|
652
|
Adding a Macro to a Toolbar
|
655
|
Protecting Yourself Against Rogue Macros
|
658
|
