Sams Teach Yourself Office Productivity All in One

Sams Teach Yourself Office® Productivity All in One......Page 2
Copyright © 2003 by Sams Publishing......Page 3
Contents at a Glance......Page 4
Contents......Page 7
Contributing Authors......Page 28
We Want to Hear from You!......Page 31
Introduction......Page 32
Conventions Used in This Book......Page 33
PART I Looking at Office from a Bird’s-eye View......Page 36
CHAPTER 1 Office: Seeing the Big Picture......Page 38
Welcome to the Microsoft Office Suite of Products......Page 39
What’s in Microsoft Office and Quicken?......Page 40
The Office Assistant......Page 47
Clip Art......Page 50
Templates......Page 51
Using Existing Templates......Page 52
Wizards......Page 53
Summary......Page 54
PART II Getting Started with Word......Page 56
What Is Word Designed to Do?......Page 58
Elements of the Word Window......Page 59
Issuing Commands......Page 60
Controlling the Word Window......Page 70
Getting Help......Page 72
Summary......Page 74
Typing Text......Page 76
Navigating Through Text......Page 82
Jumping to a Specific Page......Page 85
Summary......Page 87
Saving Documents......Page 88
Switching Among Open Documents......Page 91
The Advantages of Using a Template or Wizard......Page 93
Selecting a Template or Wizard......Page 94
Creating a Document with a Template......Page 95
Creating a Document with a Wizard......Page 96
Inserting Text......Page 99
Selecting Text......Page 101
Cutting and Pasting......Page 105
Summary......Page 109
Viewing Your Document......Page 110
Zooming Your Document......Page 114
Viewing Separate Parts of Your Document at the Same Time......Page 116
Arranging Word Documents on Your Screen......Page 117
Previewing a Document Before Printing......Page 118
Printing Your Document......Page 119
Summary......Page 123
Applying Font Formatting......Page 124
Copying Font Formatting......Page 129
Applying Paragraph Formatting......Page 130
Applying Page Formatting......Page 139
Controlling Page Breaks......Page 142
Varying the Page Formatting in Your Document......Page 143
Summary......Page 144
PART III Making Documents Look Better......Page 146
Understanding Styles......Page 148
Applying Styles......Page 149
Word Creates Styles On-the-Fly......Page 150
Creating Your Own Styles......Page 151
Modifying Existing Styles......Page 153
Basing One Style on Another......Page 155
Understanding Templates......Page 156
Personalizing Word’s Templates......Page 157
Creating Your Own Templates......Page 159
Attaching a Template to the Active Document......Page 160
Loading a Template Globally......Page 162
Summary......Page 163
Correcting Text Automatically......Page 164
Inserting Standard Blocks of Text Automatically......Page 166
Finding and Replacing Text Automatically......Page 167
Inserting Symbols and Special Characters......Page 170
Organizing Your Outline......Page 171
Working with Columns......Page 173
Working with Tables......Page 175
Summary......Page 184
Inserting Images......Page 186
Drawing Shapes......Page 194
Creating Special Effects with WordArt......Page 197
Summary......Page 198
PART IV Using Word to Manage Documents......Page 200
Understanding Mail Merges......Page 202
Starting the Main Document......Page 203
Creating and Saving the Data Source......Page 204
Entering Records into the Data Source......Page 206
Completing the Main Document......Page 207
Running the Merge......Page 208
Running Subsequent Merges......Page 210
Editing Your Data Source......Page 211
Merging Envelopes and Labels......Page 212
Summary......Page 215
Using the Highlighter......Page 216
Working with Comments......Page 217
Tracking Changes to a Document......Page 219
Protecting Documents from Being Revised......Page 223
Summary......Page 224
Inserting Data from Excel Worksheets......Page 226
Inserting PowerPoint Presentations and Slides......Page 230
Summary......Page 234
Converting Word Documents to Web Pages......Page 236
Converting Web Pages to Word Documents......Page 239
Creating Web Pages in Word......Page 240
Making Your Web Pages Available to Others......Page 242
Summary......Page 244
PART V Managing Contacts, Email, and Tasks in Outlook......Page 246
What Can Outlook Do for Me?......Page 248
Outlook’s Personalized Menus and Toolbars......Page 249
Using Shortcuts on the Outlook Bar......Page 251
Outlook Today......Page 254
Using the Inbox for Email......Page 255
Keeping a Calendar......Page 256
Working with Contacts......Page 257
Assigning and Managing Tasks......Page 258
Using Outlook Notes......Page 260
Managing Deleted Items......Page 262
Summary......Page 263
Working with Folders......Page 264
Personalizing Outlook......Page 270
Summary......Page 278
Putting Contacts into Action......Page 280
Managing Your Contacts Database......Page 281
Gaining More Control Over Your Contacts......Page 284
Details Tab: Keeping Track of the Small Stuff......Page 285
Displaying Contacts in Different Views......Page 286
Creating a Contact Database......Page 287
Adding the First Contacts......Page 288
Add a Contact from the Same Company......Page 289
Understanding Categories and Items......Page 290
Providing Additional Information About a Contact......Page 291
Manipulating the Contacts......Page 292
Dialing a Contact......Page 293
Summary......Page 294
CHAPTER 17 Emailing with Outlook......Page 296
What Is the Inbox?......Page 297
Inbox Symbols......Page 298
Customizing Your Inbox......Page 299
Composing a Mail Message......Page 300
Sending the Message......Page 304
Checking for New Mail......Page 305
Attaching a File to Your Email Message......Page 307
Summary......Page 308
Overview of Features......Page 310
Customizing Calendar......Page 312
Editing Appointments......Page 316
Deleting an Appointment......Page 318
Sending Events and Appointments to Others......Page 319
Recurring Items and Events......Page 322
Summary......Page 325
What Is a Task?......Page 326
Starting the Task Screen......Page 327
Creating a Task......Page 328
Summary......Page 333
PART VI Making Outlook Work the Way You Do......Page 334
Personalized Toolbars and Menus......Page 336
Tooling Around with Toolbars......Page 337
Adding Tools and Commands to a Toolbar......Page 340
Adding Tools and Commands to Menus......Page 343
Creating a New Menu......Page 344
Summary......Page 345
Outlook and Word......Page 346
Outlook and Excel......Page 351
Outlook and PowerPoint......Page 352
Summary......Page 353
PART VII PowerPoint Presentations for Your Audience......Page 354
What PowerPoint Is All About......Page 356
Starting the AutoContent Wizard......Page 357
What You See Onscreen......Page 360
Presentation Perspectives......Page 363
Displaying Slides......Page 365
Customizing the Sample Slides......Page 366
Spell Checking the Presentation......Page 368
Summary......Page 369
A Few Words on How a PC Stores Presentations......Page 370
Saving a Presentation......Page 371
Opening an Existing Presentation......Page 374
Starting a New Presentation......Page 376
Navigating Open Presentations......Page 378
Summary......Page 379
Using AutoLayout......Page 380
Creating a Title Slide......Page 381
Adding New Slides......Page 382
Creating and Using Bulleted or Numbered Slides......Page 383
Moving Slides......Page 384
Deleting Slides......Page 385
Text Objects Versus Text Boxes......Page 386
Rearranging Text and Text Objects......Page 387
Working with Bulleted Text......Page 388
Changing Text Object Attributes......Page 390
Summary......Page 392
PART VIII Making Your Presentations Shine......Page 394
Customizing the Color Scheme......Page 396
Customizing the Background......Page 400
Preparing Speaker’s Notes......Page 403
Preparing Audience Handouts......Page 405
Summary......Page 406
Viewing the Presentation......Page 408
Slide Sorter View......Page 411
Summary......Page 414
Text Boxes......Page 416
Formatting a Text Box......Page 418
Using WordArt......Page 421
Drawing AutoShape Objects......Page 424
Formatting Drawing Objects......Page 428
Summary......Page 431
PART IX Jazzing Up PowerPoint Presentations......Page 434
Creating a Table......Page 436
Formatting Text in a Table......Page 439
Selecting Cells, Rows, Columns, and the Entire Table......Page 440
Inserting and Deleting Columns and Rows......Page 442
Moving a Table......Page 443
Adding Impact with Custom Borders and Shading......Page 444
Summary......Page 445
What Is Multimedia?......Page 446
Inserting Sound Files......Page 447
Adding Video......Page 452
Summary......Page 454
Publishing Considerations......Page 456
Publishing a Presentation As a Web Page......Page 459
Adding Links in Presentation......Page 463
Summary......Page 469
CHAPTER 31 Automating Presentations with Macros......Page 470
Creating and Working with Macros......Page 471
Using the VBA Editor......Page 475
Summary......Page 477
PART X Designing Web Sites with FrontPage......Page 478
Acquaint Yourself with FrontPage......Page 480
Discover FrontPage’s Features......Page 481
Run the Software for the First Time......Page 482
Summary......Page 488
Discover FrontPage Templates......Page 490
Select a Web Template......Page 491
Summary......Page 497
CHAPTER 34 Applying Themes and Wizards......Page 498
Select a Web Theme......Page 499
Create Your Own Theme......Page 502
Employ a Web Wizard......Page 506
Employ a Page Wizard......Page 510
Summary......Page 512
Create and Title a Page......Page 514
Select a Background for Your Page......Page 517
Add Text to a Page......Page 519
Summary......Page 524
Create and Explore a Web......Page 526
Add a Navigation Bar to a Web......Page 529
Summary......Page 533
Create a Frame......Page 534
Create an Alternative to Frames......Page 538
Open Linked Pages into Frames......Page 539
Summary......Page 540
CHAPTER 38 Making a Point with Graphics......Page 542
Add a Graphic to a Page......Page 543
Choose Between GIF, JPEG, and PNG Graphics......Page 547
Add Page Banners and Navigation Bars......Page 551
PART XI Making FrontPage Do More Work......Page 554
Publish Your Web to a Server......Page 556
Summary......Page 561
CHAPTER 40 Communicating with Web Forms......Page 562
Call on the Wizard......Page 563
A Sample Web Form......Page 570
Manually Creating Forms......Page 571
Creating a Form by Hand......Page 572
Receive Information from a Form......Page 577
Summary......Page 579
CHAPTER 41 Seeing What HTML Is All About......Page 582
Tag a Page with HTML Commands......Page 583
Adding a Hit Counter Using HTML......Page 587
Summary......Page 589
CHAPTER 42 Introducing Cascading Style Sheets......Page 590
Define Styles on the Web......Page 591
Create a Style Sheet......Page 593
Adding a New Paragraph Style......Page 598
Summary......Page 599
PART XII Analyzing Numerical Information with Excel......Page 600
CHAPTER 43 Learning About Excel Workbooks......Page 602
Understanding Workbooks and Worksheets......Page 603
Entering Worksheet Data......Page 607
Navigating in Excel......Page 610
Automating Your Work......Page 611
Creating a Simple Spreadsheet......Page 613
Entering Values......Page 615
Working with a Worksheet......Page 617
Copying from Cell to Cell......Page 618
Making Changes to the Worksheet......Page 621
Inserting and Deleting Cells......Page 622
Working with Rows and Columns......Page 623
Summary......Page 625
Why Use Formulas?......Page 626
How Formulas Work......Page 627
Creating a Simple Formula......Page 629
Referencing Cells......Page 631
Using Ranges......Page 633
Workbook and Worksheet Navigation Tools......Page 635
Using Relative and Absolute Addressing......Page 638
Working with Formulas That Reference Other Workbooks and Worksheets......Page 640
Copying Formulas......Page 644
Summary......Page 646
What Is a Template?......Page 648
Exploring Excel Templates......Page 649
Creating Your Own Template......Page 655
Saving a Worksheet As a Template......Page 656
Summary......Page 658
Checking Your Spelling Before You Print......Page 660
Choosing What to Print......Page 662
Controlling Where Pages Break......Page 664
Formatting Your Text......Page 665
Formatting Characters......Page 666
Changing Cell Alignment......Page 667
Rotating Cell Entries......Page 669
Centering a Heading......Page 670
Controlling the Flow of Text......Page 671
Copying Formatting with the Format Painter......Page 672
Adjusting Column Width......Page 673
Altering Row Height......Page 674
What Formats Are Available?......Page 675
Choosing a Number Style......Page 677
Hiding Zeros......Page 679
Working with Dates......Page 680
Summary......Page 681
CHAPTER 47 Adding Eye-Catching Borders, Colors, Fills, and Graphics......Page 682
Adding Borders to Cells and Ranges......Page 683
Working with Fills, Shading, and Color......Page 686
Formatting with AutoFormat......Page 687
Why Use Graphics?......Page 689
Using the Drawing Toolbar......Page 690
Adding Clip Art......Page 693
Chart Elements......Page 695
Types of Charts......Page 697
Creating Charts with the Chart Wizard......Page 698
Working with Charts......Page 701
Chart Formatting Techniques......Page 705
Summary......Page 706
PART XIII Integrating Excel into Your Work......Page 708
Using Objects in Excel......Page 710
Inserting Objects......Page 715
Using Hyperlinks with Other Office Documents......Page 718
Sending Your Document Via Email with Outlook......Page 720
Summary......Page 721
What Is a Macro?......Page 722
Creating a Macro......Page 724
Running the Macro......Page 727
Fixing Macro Errors......Page 729
Attaching a Macro to a Toolbar......Page 731
Using a Macro in Other Workbooks......Page 732
Understanding Macro Viruses......Page 733
Summary......Page 734
Basic Database Concepts......Page 736
Creating a Database......Page 738
Entering and Adding Data......Page 739
Searching for Data......Page 743
Summary......Page 748
Using the Web Toolbar......Page 750
Adding a Hyperlink to a Worksheet......Page 751
Saving Excel Documents to the Web......Page 753
Summary......Page 755
INDEX......Page 756