Mastering Microsoft® Office XP Premium Edition

Contents......Page 13
Introduction......Page 30
Part I Harenessing the Power of Office XP......Page 40
1 Presenting Office XP: What You Need to Know......Page 42
Exploring the Office XP User Interface......Page 44
New Ways to Let Office Know What You Really Want to Do......Page 63
New and Improved Collaboration Tools......Page 67
Moving beyond the Keyboard......Page 69
Minimizing the Impact of Crashes......Page 70
2 Inputting Text with Speech and Handwriting Recognition Tools......Page 74
Preparing to Use Office XP's Speech Recognition Tools......Page 75
Using the Speech Recognition System......Page 79
Handwriting Recognition......Page 89
Finding Help for Speech and Handwriting Recognition......Page 95
Part II Creating Quality Text Documents Using Word......Page 96
3 Working with Text and Formats in Word......Page 98
Getting a Different Perspective......Page 100
Using Word Views......Page 101
Editing Quickly and Easily......Page 105
Printing Your Documents......Page 110
Making Fonts Work for You......Page 122
Aligning and Formatting Paragraphs......Page 126
Creating Lists, Numbers, and Symbols......Page 133
Updating Date and Time Automatically......Page 142
4 Putting Text and Language Tools to Work for You......Page 144
Creating and Applying Frequently Used Text......Page 145
Finding and Replacing Text......Page 151
Checking It Twice with Spelling and Grammar......Page 154
Keeping a Running Word Count......Page 167
¡Que Bueno! Translating Text......Page 168
Making Smart Tags Work for You......Page 170
5 Designing Pages with Columns and Tables......Page 174
Understanding Sections......Page 175
Creating and Modifying Page Numbers......Page 177
Creating Headers and Footers......Page 180
Taking Care of Loose Ends......Page 183
Working with Columns......Page 188
Creating Parallel Columns with Tables......Page 191
6 Beyond Text: Making the Most of Graphics......Page 214
Organizing Your Clips with Microsoft Clip Organizer......Page 215
Inserting Pictures into Documents......Page 228
Inserting Pictures from Other Sources......Page 235
7 Getting Creative with the Office XP Graphics Tools......Page 238
Using Microsoft Draw......Page 239
Creating Charts with Microsoft Graph......Page 263
8 Simplifying with Styles, Outlines, and Templates......Page 270
Creating an Outline......Page 271
Working with Styles......Page 278
Using Templates......Page 287
9 Creating Merge Documents in Word......Page 296
Understanding Mail Merge......Page 297
Creating or Specifying the Main Document......Page 298
Selecting Recipients......Page 300
Adding Merge Fields to a Main Document......Page 317
Previewing the Merged Document......Page 324
Creating Directories......Page 325
Creating Envelopes and Labels......Page 328
Merging Documents......Page 333
Using the Mail Merge Toolbar......Page 335
10 Creating and Distributing Word Forms......Page 340
Designing a Form......Page 341
Protecting and Using the Form......Page 352
11 Making Large Documents Easy to Use......Page 354
Adding Footnotes and Endnotes......Page 355
Using Bookmarks......Page 359
Creating Cross-References......Page 361
Adding Hyperlinks to Make Navigation Easy......Page 369
Generating a Table of Contents......Page 372
Managing Large Documents......Page 376
12 Working Collaboratively with Word......Page 380
Saving Multiple Versions of a Document......Page 381
Tracking Changes to a Document......Page 383
Highlighting Text......Page 392
Adding Comments Using Document Summary Information......Page 393
Protecting Documents......Page 397
Routing Documents......Page 403
Part III Crunching Data with Excel......Page 410
13 Creating and Printing Excel Worksheets......Page 412
Entering and Editing Cell Entries......Page 413
Working with Numbers......Page 421
Formatting Text......Page 435
Applying Borders and Color......Page 438
Adjusting Worksheet Layout......Page 440
Applying AutoFormats and Styles......Page 445
Previewing and Printing......Page 446
Checking Worksheet Spelling......Page 455
14 Using References, Names, and Functions......Page 456
Working with Worksheets......Page 457
Naming Ranges......Page 460
Using Functions and References......Page 466
Linking Workbooks......Page 503
15 Creating Easy-to-Understand Charts......Page 508
A Quick Overview of Chart Types......Page 509
Creating a Chart......Page 513
Editing and Formatting Charts......Page 520
16 Managing Information with Excel......Page 530
Basic Database Concepts......Page 531
Sorting an Excel Database......Page 535
Filtering a Database......Page 537
Creating Subtotals......Page 544
Importing Data from Other Applications......Page 547
Using Data Forms......Page 551
Using Dfunctions to Summarize a Database......Page 553
Applying Conditional Formatting......Page 555
Using the Conditional Sum Wizard......Page 560
17 Solving Business Problems with the Analysis Tools......Page 564
Forecasting and Modeling......Page 565
Using Goal Seek......Page 569
Using Solver......Page 572
Using Scenarios......Page 578
Creating Views......Page 580
Auditing Worksheets......Page 581
18 Automating Excel with Macros......Page 588
Creating Macros in Excel......Page 589
Working in the Visual Basic IDE......Page 597
19 Using Excel to Present Information......Page 606
Grouping and Outlining......Page 607
Creating Pivot Tables and PivotCharts......Page 611
Mapping Geographic Data in Excel......Page 629
20 Importing and Exporting Data in Excel......Page 630
Working with Access and Excel......Page 631
Importing Data......Page 632
Retrieving External Data with Microsoft Query......Page 637
3-D Pivot Analysis with OLAP......Page 653
21 Using Excel's Workgroup Tools......Page 664
Using and Creating Templates......Page 665
Using Lookup Functions......Page 669
Protecting Workbooks, Worksheets, and Ranges......Page 673
Working with Workgroups......Page 676
Part IV And Now, Presenting with PowerPoint!......Page 686
22 Creating a Presentation......Page 688
Steps to a Quality Presentation......Page 689
Creating a Presentation Using the AutoContent Wizard......Page 691
Other Ways to Create Presentations......Page 706
23 Formatting and Designing a Presentation......Page 720
Changing the Color Scheme......Page 721
Modifying the Slide Master......Page 723
Customizing the Background......Page 726
Formatting and Checking Text......Page 732
24 Objects, Transitions, and Animation......Page 740
Adding Objects......Page 741
Customizing Bullets......Page 749
Modifying and Adding Transitions......Page 752
Adding Animation......Page 755
Using Charts in Presentations......Page 772
Hiding Slides......Page 776
Orchestrating the Soundtrack......Page 779
25 Taking Your Show on the Road......Page 786
Getting Feedback on Your Presentation from Your Workgroup......Page 787
Incorporating Feedback......Page 788
Preparing Handouts and Notes......Page 795
Printing in PowerPoint......Page 797
Creating Handouts in Word......Page 801
Preparing 35mm Slides and Overhead Transparencies......Page 802
Setting Slide Timings......Page 803
Customizing Shows for Different Audiences......Page 806
Setting Up the Slide Show......Page 808
Displaying the Slide Show......Page 811
Drawing on Slides......Page 813
Generating Meeting Notes......Page 814
Saving a Presentation for Use on Another Computer......Page 815
Part V Integration and Collaboration for Power Users......Page 818
26 Breaking the Application Barrier......Page 820
Converting, Linking, and Embedding......Page 821
Using Application-Specific Tools to Exchange Data......Page 833
27 Collaborating in Office XP......Page 840
Writing, Revising, and Working Together on Documents......Page 841
Scheduling Meetings and Managing Tasks......Page 846
Communicating with Others across the Web......Page 851
Managing Team Contact Data in Outlook and Exchange......Page 856
Part VI Making the Web Come Alive with Office XP......Page 866
28 Exploring Office XP's Web Creation Tools......Page 868
Filling Your Web Design Toolbox......Page 869
Setting Web Publishing Options......Page 871
Saving Documents As Web Pages......Page 876
29 Creating Web Pages in Word and Excel......Page 880
Creating Web Pages Using the Web Page Wizard......Page 881
Adding Content to a Web Page......Page 890
Creating Web-Based Forms......Page 898
Working with Frames......Page 902
Making a Web Available for Others to View......Page 906
Creating Web Pages with Excel......Page 907
30 Creating Online Presentations with PowerPoint......Page 914
Preparing Presentations for the Web......Page 915
Broadcasting Presentations......Page 919
Part VII Getting Organized with Outlook......Page 930
31 Understanding Outlook Basics......Page 932
Outlook Uses and Outlook Users......Page 933
Exploring the Application Window......Page 935
Outlook Today......Page 939
Working in the Outlook Folders......Page 941
Printing in Outlook......Page 946
32 Using Outlook As a Communications Tool......Page 950
Understanding Outlook E-mail Accounts......Page 951
Creating and Addressing E-Mail......Page 952
Formatting Messages......Page 963
Inserting Files and Items into Messages......Page 978
Sending Your Message......Page 983
Reviewing Mail Messages......Page 989
Opening Mail Messages......Page 991
Replying to Mail......Page 997
Forwarding Messages......Page 998
Flagging Messages for Further Action......Page 999
Organizing E-mail Messages......Page 1000
33 Tracking and Documenting Contacts with Outlook......Page 1006
Creating a Contact......Page 1007
Finding Contact Information When You Need It......Page 1030
Documenting Your Communications in the Journal......Page 1039
Making Notes......Page 1044
34 Managing Your Time and Tasks......Page 1048
Creating a Task......Page 1049
Setting Up Recurring Tasks......Page 1055
Delegating Tasks......Page 1058
Creating Tasks from Other Outlook Items......Page 1061
Completing a Task......Page 1062
Scheduling Your Time in Calendar......Page 1063
35 Working behind the Scenes in Outlook......Page 1084
Managing Data and Files in Outlook......Page 1085
Using Rules to Manage Mail......Page 1091
Importing and Exporting Outlook Data......Page 1094
Customizing the Outlook Environment......Page 1101
Setting Up Outlook Profiles and E-mail Accounts......Page 1106
Modifying the Default Profile......Page 1108
Properties and Other Options......Page 1115
Customizing the Outlook Bar......Page 1116
Creating Custom Views......Page 1117
Outlook 2002 and Microsoft Exchange Server......Page 1121
Part VIII Creating and Using an Access Database......Page 1130
36 Planning a Database......Page 1132
Creating a Database with the Database Wizard......Page 1134
Understanding Access Database Objects......Page 1140
Designing Your Own Database......Page 1144
37 Creating the Database Structure......Page 1154
Creating a New Database......Page 1155
Creating Tables......Page 1156
Setting Field Properties......Page 1177
Relating the Tables......Page 1186
Entering Data in a Table......Page 1191
38 Creating and Using Forms......Page 1200
Selecting a Form Layout......Page 1201
Creating Forms for Multiple Tables......Page 1210
Modifying Form Design......Page 1214
39 Creating Reports and Queries......Page 1232
Creating Reports......Page 1233
Creating Queries......Page 1250
40 Creating Web Pages with Access......Page 1278
Creating Web Pages......Page 1279
Appendices......Page 1294
A Customizing the Office Environment......Page 1296
Customizing the Office XP Shortcut Bar......Page 1297
Customizing Application Menus and Toolbars......Page 1303
Setting Application Options......Page 1311
A Troubleshooting Office XP......Page 1314
All Office XP Applications......Page 1315
Access 2002......Page 1317
Excel 2002......Page 1320
FrontPage 2002......Page 1321
Outlook 2002......Page 1322
PowerPoint 2002......Page 1325
Publisher 2002......Page 1327
Word 2002......Page 1328
A......Page 1330
B......Page 1333
C......Page 1334
D......Page 1339
E......Page 1343
F......Page 1347
G......Page 1351
H......Page 1352
I......Page 1353
L......Page 1356
M......Page 1357
N......Page 1361
O......Page 1362
P......Page 1365
R......Page 1370
S......Page 1372
T......Page 1377
V......Page 1382
W......Page 1384
Z......Page 1388