Microsoft Office 2000 9 in 1 for dummies : desk reference

Microsoft Office 2000 9 in 1 For Dummies Desk Reference contains all the great things that you need to know when using Windows 98 or any of the Microsoft Office 2000 products. You can go out and buy a different book for Windows 98 and each of the Office products, but who's going to carry them home for you? This guide doesn't pretend to be a comprehensive reference for every detail of these products. Instead, it shows you how to get up and running fast so that you have more time to do the things that you really want to do.

This book is for you if

You've never used a Windows-based computer but you want to get started in Windows 98 and all those Office 2000 products You have used a Windows-based computer before as well as some Office programs, but you never really got the hang of them You have no idea what Microsoft Office really is, but you've been told that it's the software you need You heard about all those power users who can take full advantage of the integrated products from Microsoft Office and you want to join their ranks You think that you know everything about Windows and Microsoft Office but you need a good reference for when your memory fails you

If you want to help yourself quickly and easily, this guide can help.

Each section of Microsoft Office 2000 9 in 1 For Dummies Desk Reference has handy thumb tabs so you don't get lost. The sections fall into a rough order of popularity among Office users, including:

Windows 98 Word 2000 Excel 2000 Access 2000 Outlook 2000 PowerPoint 2000 FrontPage 2000 Publisher 2000 PhotoDraw 2000

Without being cumbersome, Microsoft Office 2000 9 in 1 For Dummies Desk Reference strives to include in one book all the important details you can probably locate in individual books but would really like to have in one source. What a deal!

Introduction	p. 1
About This Book	p. 2
Who Are You?	p. 2
How to Use This Book	p. 3
How This Book is Organized	p. 4
Icons Used in This Book	p. 6
Book 1 Windows 98	p. 7
Chapter 1 Getting to Know the Windows 98 Desktop	p. 9
Windows Desktop	p. 9
Icons	p. 11
Selecting and Opening Icons	p. 12
Selecting More Than One Icon at a Time	p. 13
Standard Desktop Icons	p. 15
Chapter 2 Getting Started (And Stopped) in Windows 98	p. 17
Taskbar Basics	p. 17
Starting Your Programs	p. 21
Switching between Programs	p. 21
Shutting Down Windows 98	p. 22
Chapter 3 Working with Windows (Within Windows)	p. 23
Windows (The On-Screen Type)	p. 23
Moving and Resizing Windows	p. 25
Arranging and Sizing Icons in a Window	p. 26
Windows Explorer	p. 27
Explorer Bars	p. 29
Chapter 4 Dealing with Toolbars	p. 31
Toolbars	p. 31
Standing up to the Standard Buttons Toolbar	p. 32
Displaying Toolbars on Your Taskbar	p. 33
Customizing the Appearance of a Toolbar	p. 36
Chapter 5 Dialog Boxes and Menus	p. 39
Dialog Boxes	p. 39
Menu Management	p. 42
Chapter 6 The Lowdown on Files and Folders	p. 47
Files	p. 47
Folders	p. 48
Opening Files and Folders	p. 49
Shortcuts	p. 50
Chapter 7 File and Folder Management	p. 53
Creating New Files and Folders	p. 53
Selecting Files and Folders	p. 54
Copying (And Moving) Files and Folders	p. 54
Finding Files and Folders	p. 57
Renaming Files and Folders	p. 59
Deleting Junk	p. 59
Chapter 8 Getting Involved with the Active Desktop	p. 61
The Active Desktop	p. 61
Turning the Desktop Web Page View On and Off	p. 62
Browsing Folders on a Local Disk	p. 63
Changing the Folder Options for Windows 98	p. 65
Windows 98 Index	p. 69
Book 2 Word 2000	p. 73
Chapter 1 Word 101	p. 75
What All That Stuff On-Screen Is	p. 75
What Is a Document?	p. 76
Opening a Document	p. 77
Opening a New Document	p. 79
Moving Around in Documents	p. 79
Understanding How Paragraphs Work	p. 80
Working on Many Documents at Once	p. 80
Working in Two Places in the Same Document	p. 81
Zooming In, Zooming Out	p. 82
Chapter 2 Saving, Naming, Deleting, and Exiting	p. 85
Saving a Document for the First Time	p. 85
Saving a Document under a New Name	p. 86
Saving a Document You've Been Working On	p. 87
Saving Versions of Documents	p. 87
Closing a Document	p. 89
Deleting a Word Document	p. 89
Exiting Word 2000	p. 90
Chapter 3 Changing the Look of Your Document	p. 91
Changing the Look of the Screen	p. 91
Putting Headers and Footers on Pages	p. 92
Numbering the Pages	p. 94
Breaking a Line	p. 96
Breaking a Page	p. 96
Dashes	p. 96
Hyphenating a Document	p. 97
Spacing Lines	p. 99
Symbols and Special Characters	p. 100
Decorating a Page with a Border	p. 101
Chapter 4 Editing Made Easy	p. 103
Selecting Text in Speedy Ways	p. 103
Deleting Text	p. 104
Undoing a Mistake	p. 104
Finding and Replacing Text and Formats	p. 105
Finding Text and More	p. 106
The Thesaurus's Role in Finding the Right Word	p. 108
Spell-Checking (And Grammar-Checking) a Document	p. 108
Changing lowercase to UPPERCASE, UPPERCASE to lowercase	p. 111
Chapter 5 Basic Formating	p. 113
Adding Bold, Italic, Underline, and Other Effects	p. 114
Centering, Justifying, and Aligning Text	p. 115
Changing the Font of Text	p. 115
Coloring Text	p. 116
Fast Formatting with the Format Painter	p. 117
Creating Numbered and Bulleted Lists	p. 117
Indenting Paragraphs and First Lines	p. 119
Setting Up and Changing the Margins	p. 120
Working with Tabs	p. 122
Chapter 6 Advanced Formatting	p. 125
Applying Styles for Consistent Formatting	p. 125
Dropping In a Drop Cap	p. 129
Dividing a Document into Sections	p. 130
Putting Newspaper-Style Columns in a Document	p. 132
Chapter 7 Envelopes, Labels, and Form Letters	p. 135
Printing Addresses on Envelopes	p. 135
Printing Labels	p. 137
Churning Our Form Letters	p. 140
Chapter 8 Making Your Work Go Faster	p. 143
Customizing Word 2000	p. 143
Rearranging the Toolbars	p. 146
Correcting Typos on the Fly	p. 151
Repeating an Action -- and Quicker This Time	p. 153
Going Here, Going There in Documents	p. 153
Entering Graphics and Text Quickly	p. 155
Chapter 9 Getting Really Organized	p. 157
Outlines for Organizing Your Work	p. 157
Linking Documents to Make Your Work Easier	p. 158
Chapter 10 Constructing the Perfect Table	p. 163
Constructing the Perfect Table	p. 163
Modifying Different Parts of a Table	p. 166
Sorting, or Reordering, a Table	p. 168
Dressing Up Your Table	p. 169
Merging and Splitting Cells and Tables	p. 171
Using Math Formulas in Tables	p. 172
Chapter 11 Drawing and Inserting Things into Your Document	p. 175
Drawing Lines and Shapes	p. 175
Inserting Pictures and Graphics into Documents	p. 177
Chapter 12 Doing Some Desktop Publishing	p. 181
Handling Objects on Pages	p. 181
Working with Text Boxes	p. 185
WordArt for Embellishing Documents	p. 188
Borders and Color Shades for Graphics and Text Boxes	p. 189
Chapter 13 Web Publishing	p. 191
Creating Your Own Web Pages and Sites	p. 191
Choosing Backgrounds and Themes for Web Pages	p. 195
Hyperlinking Your Web Page to Other Pages	p. 196
Word 2000 Index	p. 199
Book 3 Excel 2000	p. 203
Chapter 1 Getting to Know Excel 2000	p. 205
Acquainting Yourself with the Excel Screen	p. 205
Excel behind the Scenes	p. 205
Chapter 2 Working with Workbook Files	p. 209
Creating a Empty Workbook File	p. 209
Opening a Workbook File	p. 210
Saving a Workbook File	p. 210
Closing a Workbook	p. 212
Using a Workbook Template	p. 212
Finding a Workbook File	p. 213
Deleting a Workbook File	p. 214
Creating Multiple Windows (Views) for a Workbook	p. 214
Chapter 3 Working with the Worksheets in Your Workbook	p. 215
Working with Worksheets	p. 215
Manipulating Your Worksheets	p. 217
Moving Around in a Worksheet	p. 219
Moving a Sheet	p. 220
Deleting a Worksheet	p. 221
Chapter 4 Entering Worksheet Data	p. 223
Entering Data into a Worksheet	p. 223
Entering Formulas	p. 226
Entering Fractions	p. 227
Chapter 5 Editing the Data You Enter	p. 229
Basic Cell Editing	p. 229
Undoing Changes and Mistakes	p. 232
Using AutoComplete	p. 233
Using AutoFill	p. 233
Using Automatic Decimal Points	p. 235
Using Cell Comments	p. 236
Seaching for Data	p. 237
Searching and Replacing Data	p. 238
Spell Checking	p. 238
Chapter 6 Making Your Work Look Good	p. 239
Using AutoFormats	p. 239
Formatting Cells and Ranges to Your Liking	p. 240
Copying Formats	p. 246
Formatting Numbers	p. 246
Chapter 7 Selecting, Copying, and Moving Your Data	p. 249
Selecting Cells and Ranges	p. 249
Copying Cells and Ranges	p. 251
Moving Cells and Ranges	p. 253
Chapter 8 Using Formulas and Functions	p. 255
Using Formulas	p. 255
Identifying Formula Errors	p. 257
Using Absolute, Relative, and Mixed References	p. 258
Using Functions in Your Formulas	p. 258
Using the Formula Palette	p. 260
Chapter 9 Managing and Analyzing Your Data	p. 263
Filtering and Sorting Lists	p. 263
Performing Advanced Filtering	p. 267
Good Seeking: Making a Formula Return a Desired Value	p. 270
Performing What-If Analysis (Scenarios)	p. 270
Chapter 10 Taking Advantage of Pivot Tables	p. 273
Pivot Tables	p. 273
Chapter 11 Charting the Excel Way	p. 283
Using the Chart Wizard	p. 283
Charting Basics	p. 286
Changing the Chart Type	p. 290
Dealing with Chart Elements	p. 290
Chapter 12 Getting Your Work on the Web	p. 293
Web Publishing with Excel	p. 293
Customizing the Way Excel Saves a File for Publishing	p. 294
Publishing Your Worksheet Data to a Web Page	p. 296
Excel 2000 Index	p. 299
Book 4 Access 2000	p. 303
Chapter 1 Access Basics	p. 305
About Databases	p. 305
Access Database Objects	p. 307
Opening a Database File	p. 307
Saving a Database File	p. 308
Closing a Database File	p. 309
Working with Wizards	p. 309
Quitting Access 2000	p. 310
Chapter 2 Creating and Navigating a Database	p. 311
Creating a Database	p. 311
Finding Your Way around a Database	p. 314
The Database Window Toolbar	p. 315
Chapter 3 Tables: A Home for Your Data	p. 319
About Tables	p. 319
Adding a New Table to Your Database	p. 320
Moving Around in a Datasheet	p. 325
Adding Data to Your Database	p. 326
Editing Data in a Datasheet	p. 326
Changing Data Types	p. 327
Relating (Linking) Tables	p. 328
Identifying Records with a Primary Key Field	p. 330
Chapter 4 Getting Your Tables Just Right	p. 333
Changing Column Width	p. 333
Changing Row Height	p. 334
Inserting a Column/Adding a Field	p. 335
Moving a Column in a Datasheet	p. 335
Formatting Datasheets	p. 336
Deleting Records	p. 337
Saving a Table	p. 337
Chapter 5 Working with Fields	p. 339
Field Management	p. 339
Formatting Fields	p. 342
Creating a Lookup Field	p. 344
Chapter 6 Manipulating Your Data	p. 347
Finding Data in a Table	p. 347
Filtering Your Data	p. 348
Sorting a Table	p. 353
Blocking Unwanted Data with an Input Mask	p. 353
Chapter 7 Queries: Getting Answers from Your Data	p. 355
About Queries	p. 355
Using a Query Wizard	p. 356
About Query Design View	p. 361
Adding a Select Query to the Database	p. 363
Saving a Query	p. 365
Chapter 8 More Fun with Queries	p. 367
Sorting a Query	p. 367
Inserting Fields in a Query Grid	p. 368
Editing a Query	p. 368
Attaching a Table to a Query	p. 369
Limiting Records with Criteria Expressions	p. 370
Chapter 9 Using Aggregate Calculations and Building Expressions	p. 375
Calculating Summary Data for a Group of Data	p. 375
Calculating Fields (Building Expressions)	p. 379
Chapter 10 Reporting Results	p. 383
About Reports	p. 383
Adding a Report with AutoReport	p. 383
Adding a Report with the Report Wizard	p. 385
Adding a Report Created in Design View	p. 388
Editing Objects in a Report	p. 393
Chapter 11 Changing the Look of Your Report	p. 395
Inserting Page Breaks in a Report	p. 395
Playing with Borders	p. 396
Adding Color to a Report	p. 396
Adding Dates and Page Numbers	p. 397
Aligning Report Objects	p. 398
Changing Date or Number Formats	p. 399
Changing Font and Font Size	p. 399
Changing Page Layout	p. 399
Changing the Size of an Object	p. 400
Moving a Control	p. 401
Formatting Reports with AutoFormat	p. 402
Chapter 12 Forms for Displaying and Entering Data	p. 403
About Forms	p. 403
Adding a Form to your Database	p. 404
Adding a Form with the Form Wizard	p. 405
Entering Data through a Form	p. 407
Editing and Formatting Forms	p. 408
AutoFormatting Your Form	p. 408
Viewing Your Form in Design View	p. 409
Access 2000 Index	p. 411
Book 5 Outlook 2000	p. 415
Chapter 1 All About Outlook	p. 417
Recognizing What You See in Outlook	p. 417
Adding an Icon to the Outlook Bar	p. 419
Adding Specialized Applications	p. 420
Archiving Your Work	p. 422
Chapter 2 Getting Going with E-Mail	p. 423
The Outlook Inbox	p. 423
Creating and Sending Messages	p. 423
Spell Checking	p. 427
Creating Personal Distribution Lists and Groups	p. 429
Chapter 3 Reading and Replying to Your Mail	p. 431
Handling Incoming Messages	p. 431
Replying to or Forwarding Messages	p. 435
Chapter 4 Making Your E-Mail Life Easier	p. 437
Managing Your E-Mail with Folders	p. 437
Using the Rules Wizard	p. 439
Using and Choosing E-Mail Views	p. 441
Chapter 5 Using the Calendar	p. 443
Reviewing the Calendar	p. 443
Scheduling an Appointment	p. 446
Scheduling a Recurring Appointment	p. 447
Changing an Appointment	p. 448
Deleting an Item from Your Calendar	p. 450
Chapter 6 Tasks for Everyone	p. 451
Creating a New Task	p. 451
Deleting a Task	p. 454
Modifying an Existing Task	p. 454
Creating a Recurring Task	p. 454
Creating a Regenerating Task	p. 455
Attaching a File to a Task Item	p. 456
Changing the Appearance of Your Task List	p. 456
Marking a Task as Complete	p. 458
Chapter 7 Working with Your Contacts	p. 459
Entering a New Contact	p. 459
Finding a Name, Address, or Phone Number	p. 461
Changing Information about a Contact	p. 463
Customizing the Appearance of the Contact List	p. 463
Calling Someone from Outlook	p. 468
Chapter 8 Tracking Activities with Journals	p. 469
Viewing the Journal	p. 469
Viewing a Specific Date in Your Journal	p. 470
Creating Journal Entries Manually with Drag-and-Drop	p. 471
Creating Journal Entries with the New Journal Item Button	p. 472
Finding a Journal Entry	p. 473
Activating the Automatic Recording Feature	p. 473
Chapter 9 Managing Outlook Notes	p. 475
Creating Notes	p. 475
Reading (Or Changing) a Note	p. 476
Finding a Note	p. 476
Viewing Notes	p. 477
Forwarding a Note to Someone Else	p. 479
Deleting a Note	p. 480
Using Notes to Your Advantage	p. 480
Outlook 2000 Index	p. 483
Book 6 PowerPoint 2000	p. 487
Chapter 1 Getting Started with a PowerPoint Presentation	p. 489
Opening a Presentation	p. 489
Beginning a New Presentation	p. 493
Changing Your View	p. 493
Saving Your Work	p. 494
Exiting PowerPoint	p. 494
Chapter 2 Sliding into Your Presentation	p. 495
Creating and Working with Slides	p. 495
Working in Outline View	p. 500
Chapter 3 Laying the Groundwork with Templates	p. 503
Applying and Creating Templates	p. 503
Chapter 4 Using and Abusing Masters	p. 507
Editing the Slide Master	p. 507
Editing the Title Master	p. 511
Editing the Handout Master	p. 512
Editing the Notes Master	p. 514
Overriding the Master Style on a Single Slide	p. 514
Chapter 5 Adding Text to Your Presentation	p. 515
About Text Boxes	p. 515
Aligning Paragraphs of Text	p. 517
Finding and Replacing Text	p. 518
Spell-Checking	p. 519
Chapter 6 Making Your Text Look Presentable	p. 521
Formatting Text	p. 521
Numbering Lists	p. 524
Bulleting Text	p. 524
Chapter 7 Getting Visual	p. 525
About the Drawing Toolbar	p. 525
Drawing Lines	p. 526
Drawing with AutoShapes	p. 527
Adding WordArt	p. 528
About Clips	p. 530
Chapter 8 Manipulating Your Multimedia	p. 533
Adding Pictures: Clip Art and Photos	p. 533
Adding Polygons and Freeform Shapes	p. 534
Adding Rectangles, Squares, Ovals, and Circles	p. 534
Adding Movies and Motion Clips	p. 535
Adding Sound	p. 537
Chapter 9 Making a Graph(ical) Presentation	p. 539
Starting with the Datasheet	p. 539
Creating Graphs	p. 540
Using Tables	p. 543
Chapter 10 Planning the Presentation	p. 547
Adding Action Buttons	p. 547
Adding Slide Transitions	p. 550
Chapter 11 Showing Off Your Work	p. 553
Showing Your Slides via Computer	p. 553
Chapter 12 Publishing Your Presentation	p. 557
Printing Audience Handouts	p. 557
Publishing on the Web	p. 558
PowerPoint 2000 Index	p. 561
Book 7 FrontPage 2000	p. 565
Chapter 1 Getting to Know FrontPage 2000	p. 567
What Is FrontPage 2000, and What Can I Do with It?	p. 567
What's New with FrontPage 2000?	p. 567
How FrontPage Is Organized	p. 568
Why Does This Look Like Microsoft Word?	p. 569
The Views Bar	p. 569
Introducing the FrontPage Editor	p. 574
Chapter 2 Starting Your Webbing	p. 575
Creating a New Web	p. 575
Creating a Web Site from a Template	p. 576
Creating Web Pages	p. 577
Naming Your Web	p. 580
Changing a Filename	p. 580
Opening Files	p. 581
Saving Your Web Pages	p. 582
Chapter 3 Getting Organized Before It's Too Late	p. 583
A Quick Guide to the Three Views of the FrontPage Editor	p. 583
Using FrontPage Toolbars	p. 584
Creating Folders	p. 586
Deleting Files and Folders	p. 587
Importing Webs and Web Pages	p. 588
Chapter 4 Laying the Groundwork for Your Web Pages	p. 591
Applying a Theme to a Web	p. 591
Editing a Theme	p. 592
Editing Page Properties	p. 593
Chapter 5 Getting the Basics on Your Page	p. 597
Changing Text Attributes	p. 597
Working with Tables	p. 602
Creating and Using Hyperlinks	p. 604
Chapter 6 Giving Your Pages Something to Look At	p. 609
Inserting Some Extra Effects	p. 609
Inserting a Page Banner	p. 613
Adding Graphics to Web Pages	p. 613
Adding Clip Art to a Web Page	p. 615
Chapter 7 Image Editing for Everyone	p. 617
Activating the Picture Toolbar	p. 617
Image Manipulation Made Easy	p. 618
Creating Image Maps	p. 623
Chapter 8 Publishing Your Web Pages	p. 625
Publishing a Web by Using HTTP	p. 625
Publishing a Web by Using FTP	p. 627
Connecting to a FrontPage Server	p. 628
FrontPage 2000 Index	p. 629
Book 8 Publisher 2000	p. 633
Chapter 1 Publisher 101	p. 635
Creating a Publication	p. 635
Saving Your Files	p. 639
Chapter 2 Working with Pages	p. 641
Moving from Page to Page	p. 641
Changing What You See On-Screen	p. 642
Lining Things Up	p. 643
Creating Background Pages	p. 645
Adding Background Objects	p. 647
Creating Headers and Footers	p. 647
Adding and Deleting Pages	p. 648
Modifying the Page Layout	p. 650
Chapter 3 Objects and Frames	p. 651
Working with Frames	p. 651
Working with Drawn Objects	p. 655
Aligning and Positioning Objects	p. 656
Creating Regular Text Wraps	p. 657
Chapter 4 Getting the Word	p. 659
Using Text Frames	p. 659
Table Frames	p. 660
Working with Table Text	p. 662
Chapter 5 You Ought to Be in Pictures	p. 665
Understanding More about Picture Frames	p. 665
Getting Yours	p. 666
Modifying Pictures	p. 668
Applying Borders and BorderArt	p. 670
Chapter 6 Spinning a Web Site	p. 671
Using the Web Sites Wizard	p. 671
Adding Text or Picture Objects	p. 674
Adding and Removing Hyperlinks	p. 676
Adding Color and Texture to the Background	p. 677
Publisher 2000 Index	p. 679
Book 9 PhotoDraw 2000	p. 681
Chapter 1 Your Personal Tour	p. 683
Interface Roadmap	p. 683
The Visual Menu Toolbar	p. 685
The Formatting Toolbar	p. 686
The Picture List	p. 686
The Drawing Area	p. 687
From Window Panes to Workpanes	p. 688
Feedback from the Status Bar	p. 688
Chapter 2 Getting Pictures into PhotoDraw	p. 689
Getting Images Already on Your System	p. 689
Clipping Art from the CD	p. 690
Scanning Your Way Through	p. 691
Using a Digital Camera	p. 693
Images through Imagination	p. 694
Chapter 3 Fixing Photos	p. 697
Coloring Using Slider Controls	p. 697
Touching Up	p. 701
Cropping, Cutting, and Erasing	p. 708
Chapter 4 Adding Text and Dressing Up Photos	p. 713
Adding Text Effects	p. 713
Templates	p. 716
Drawing and Painting	p. 719
Filling Objects	p. 722
Outline	p. 727
Effects	p. 727
Chapter 5 Dressed Up and Someplace to Go	p. 731
The Wizard that Saves	p. 731
Saving the Old-Fashioned Way	p. 734
PhotoDraw Printing Options	p. 735
PhotoDraw 2000 Index	p. 737
Appendixes	p. 739
Appendix A Starting, Surviving, and Getting Help	p. 741
Starting an Office 2000 Application	p. 741
Using the Mouse	p. 742
Cursors and Pointers	p. 742
Shortcut Keys for Doing It Quickly	p. 743
Cutting, Copying, and Pasting	p. 743
Undoing Errors	p. 744
Getting the Help You Need in Office 2000	p. 744
Appendix B Printing an Office 2000 Document	p. 749
Previewing What You Print	p. 749
Choosing Some Page Options	p. 751
Printing a Document	p. 753
Canceling a Print Job	p. 756
Appendix C Binding Office 2000 Documents Together	p. 757
Creating a New Binder	p. 757
Putting Documents into a Binder	p. 759
Switching between Sections in Your Binder	p. 761
Opening an Existing Binder	p. 761
Deleting a Binder Section	p. 762
Index	p. 763
Book Registration Information

可借阅:*

链接这些题名

已订购

摘要

摘要

目录