Microsoft Office 2003 Bible

by Willett, Edward; Wyatt, Allen; Rodgers, Bill

• ISBN13: 9780764539497
• ISBN10: 0764539493
• Edition: CD
• Format: Paperback
• Copyright: 2003-11-07
• Publisher: WILEY

Summary

Targets how to effectively and efficiently use data, text, and graphics from one Office application in another Office application. Features less emphasis on macros and programming and more focus on enhancements. Improved content and topical selection compared to previous editions.

Author Biography

About the Author<br> <b>Edward Willett</b> is the author of more than 20 books, ranging from computer books on a variety of topics to children&#8217;s nonfiction to young adult science fiction and fantasy. A former newspaper reporter and editor, he writes a science column for newspapers and radio and hosts a weekly TV phone-in show about computers and the Internet. He&#8217;s also a professional actor and singer. Ed lives in Regina, Saskatchewan, with his wife and daughter. <p> About the Contributing Authors<br> <b>Allen Wyatt</b>, an internationally recognized expert in small computer systems, has been working in the computer and publishing industries for almost two decades. He has written almost 50 books explaining many different facets of working with computers, as well as numerous magazine articles. His books have covered topics ranging from programming languages to using application software to using operating systems. Through the written word, Allen has helped millions of readers learn how to better use computers.<br> Allen is the president of Discovery Computing Inc., a computer and publishing services company located in Mesa, Arizona. Besides writing books and technical materials, he helps further the computer-book industry by providing consulting and production services. Allen also publishes a free weekly newsletter for users of Word and Excel. You can find more information at www.VitalNews.com. <p> <b>Bill Rodgers</b> is a computing consultant from Newcastle, Australia, with a passion for V8Supercars and Rugby league and Rugby Union football. Bill specializes in Office and Windows systems, collaboration, and advanced technologies. Bill has been a contributing author and technical editor on many Office books for leading international companies and has been awarded the Microsoft MVP (Most Valuable Professional) award for the past four years for his support of and expertise with Microsoft products.

Table of Contents

Preface	p. ix
Acknowledgments	p. xiii
Getting Started	p. 1
Welcome to Your New Office	p. 3
Introducing Office Applications: What Do They Do?	p. 3
Starting Office Applications	p. 4
Creating, Saving, and Closing Documents	p. 4
Working with Smart Tags and Task Panes	p. 8
Using Office Search Effectively	p. 9
Getting Help in Office Applications	p. 12
Summary	p. 16
Using Office's Menus and Toolbars	p. 17
Creating Customized Menus and Toolbars	p. 18
Will That Be Hidden, Docked, or Floating?	p. 29
Summary	p. 31
Using Word	p. 33
Creating and Working with Documents	p. 35
Creating New Documents	p. 35
Navigating in Word	p. 37
Word's Views	p. 44
Word's Wizards	p. 51
Using Word's AutoCorrect Features	p. 54
Using Simple Macros	p. 60
Saving: Format Options	p. 62
Summary	p. 63
Working with Text	p. 65
Entering, Selecting, and Editing Text	p. 65
Formatting Text	p. 68
Headers, Footers, and Page Numbers	p. 86
Creating Footnotes	p. 90
Printing	p. 93
Summary	p. 96
Working with Tables	p. 97
Creating Tables	p. 97
Editing and Formatting Tables	p. 100
Using Sort and Formulas	p. 113
The Tables and Borders Toolbar	p. 116
Summary	p. 117
Forms, Fields, and Merging	p. 119
Using Fields	p. 119
Creating and Using Forms	p. 126
Using Mail Merge	p. 133
Summary	p. 142
Outlines, Tables of Contents, and Indexes	p. 143
What Is an Outline?	p. 143
Using Outline View	p. 144
Creating and Modifying Outlines	p. 145
Building a Table of Contents	p. 148
Building a Table of Figures	p. 150
Building a Table of Authorities	p. 151
Creating an Index	p. 153
Summary	p. 156
Styles and Templates	p. 159
What Are Styles?	p. 159
What Are Templates?	p. 161
Applying Word's Built-in Styles	p. 162
Creating Styles	p. 168
Modifying Styles	p. 170
Using the Style Gallery	p. 173
Attaching a Template	p. 174
Creating and Modifying Templates	p. 176
Modifying the Normal Template	p. 177
Summary	p. 178
Getting Graphical	p. 181
Using Bulleted and Numbered Lists	p. 181
Using Columns	p. 186
Adding Borders and Shading	p. 188
Inserting Pictures	p. 192
Summary	p. 199
Working with Others on Word Documents	p. 201
Collaborating with Many Users on a Single Document	p. 201
Tracking Changes in a Document	p. 206
Using Versions	p. 210
Protecting Your Document	p. 211
Using Master Documents	p. 214
Summary	p. 217
Using XML in Word	p. 219
What Is XML?	p. 219
Saving a Word Document in XML Format	p. 221
Creating an XML File with a Schema	p. 222
About Smart Documents	p. 228
Summary	p. 228
Using Excel	p. 231
Worksheets and Workbooks	p. 233
Understanding Workbooks	p. 233
Working with Worksheets	p. 237
Selecting and Using Ranges	p. 245
Using Absolute and Relative References	p. 246
Saving and Closing a Workbook	p. 248
Finding Workbooks	p. 252
Setting Workbook Properties	p. 254
Summary	p. 255
Entering and Formatting Information	p. 257
Entering Data	p. 257
Editing Data	p. 263
Copying, Moving, and Merging Cells	p. 264
Adding Comments to Cells	p. 268
Adding and Deleting Cells, Rows, and Columns	p. 270
Changing Column Widths and Row Heights	p. 272
Hiding and Unhiding Columns, Rows, and Gridlines	p. 275
Using AutoFormat	p. 276
Applying Fonts and Styles	p. 278
Applying Borders, Patterns, and Colors	p. 286
Using Number, Date, and Time Formats	p. 291
Custom Formats	p. 294
Summary	p. 297
Charts	p. 299
Creating Charts with Chart Wizard	p. 299
Understanding Chart Types	p. 304
Modifying Charts	p. 305
Formatting Charts	p. 315
Handling 3-D Chart Views	p. 316
Enhancing Charts	p. 318
Saving Custom Chart Formats	p. 322
Summary	p. 323
Formulas and Functions	p. 325
Working with Formulas	p. 325
Copying and Moving Formulas	p. 329
Using Range Names in Formulas	p. 332
Using Arrays in Formulas	p. 333
Understanding Functions	p. 335
Inserting Functions	p. 335
Using AutoSum	p. 337
Using Other Automatic Functions	p. 338
Using Links	p. 340
Summary	p. 342
Lists and Databases	p. 343
Understanding Lists and Databases	p. 343
Working with Databases	p. 345
Entering and Editing Records	p. 347
Sorting and Filtering Data	p. 356
Using Excel Data in a Mail Merge	p. 363
Summary	p. 364
Templates, Forms, and Graphics	p. 365
Using Excel's Templates	p. 365
Creating a Template	p. 367
Creating Forms	p. 371
Protecting Worksheets and Workbooks	p. 377
Adding Graphics to Excel Worksheets	p. 382
Summary	p. 393
PivotTable and PivotChart Reports	p. 395
Working with PivotTable Reports	p. 395
Working with PivotChart Reports	p. 406
Summary	p. 408
Using Excel to Analyze Data	p. 411
Creating and Using Data Tables	p. 411
Using Goal Seek	p. 414
Using Solver	p. 416
Circular References and Iteration	p. 420
Summary	p. 422
Using XML in Excel	p. 425
What Is XML?	p. 425
Using XML Data Sources in Excel	p. 427
Saving XML Data in Excel	p. 430
Excel and Smart Documents	p. 434
Summary	p. 434
Using Outlook	p. 437
Outlook Overview	p. 439
Working with Outlook Folders	p. 439
Using the Navigation Pane	p. 442
Working with and Customizing Views	p. 443
Using Outlook Today	p. 451
Configuring and Using Multiple Mail Accounts	p. 452
Reading Messages	p. 455
Addressing and Sending Messages	p. 455
Saving Messages	p. 459
Printing Messages	p. 460
Deleting Messages	p. 462
Summary	p. 463
Advanced Message Management	p. 465
Organizing Messages with Search Folders	p. 465
Quick-flagging Messages	p. 469
Creating Mail-Filtering Rules	p. 470
Archiving Messages	p. 472
Exporting and Importing Messages	p. 474
Sending Business Cards	p. 476
Using Signatures and Receipts	p. 477
Attaching Files to Messages	p. 480
Finding the Message You Want	p. 481
Summary	p. 483
Outlook Security	p. 485
Dealing with Junk E-mail	p. 485
Turning Off Web Beacons	p. 488
Outlook's Security Settings	p. 489
Why Can't I Open That?	p. 493
Digital Signatures and Encryption	p. 496
Permissions	p. 497
E-mail Safety Tips	p. 498
Summary	p. 499
Creating and Maintaining a Contact List	p. 501
Adding a Contact	p. 502
Importing Contacts	p. 507
Opening and Editing a Contact	p. 508
Viewing Your Contacts	p. 509
Creating Groups	p. 509
Creating Distribution Lists	p. 510
Associating Contacts with Other Outlook Items	p. 511
Mail-merging Outlook Contacts with Word	p. 512
Introduction to Business Contact Manager	p. 514
Summary	p. 516
Managing Your Time with Calendar	p. 517
The Outlook Today View	p. 517
Adding and Editing Your Own Tasks	p. 520
Assigning a Task to Someone Else	p. 521
Using Calendar	p. 522
Creating and Managing Appointments and Events	p. 524
Importing Appointments and Events	p. 527
Sending Calendar Information to Other Users	p. 528
Summary	p. 529
Using PowerPoint	p. 531
Beginning a Presentation	p. 533
Planning Great Presentations	p. 533
Working with the PowerPoint User Interface	p. 534
Choosing a Slide Layout	p. 535
Using Outlines to Plan and Organize	p. 537
Navigating Through a Presentation	p. 543
Summary	p. 544
Entering and Formatting Text	p. 545
Entering and Editing Text	p. 545
Importing Text from Other Applications	p. 549
Formatting Text	p. 551
Summary	p. 558
Using Templates and Wizards	p. 559
Using the AutoContent Wizard	p. 559
Using the Slide Layout Task Pane	p. 561
Using Masters	p. 565
Using Design Templates	p. 571
Creating and Saving Your Own Templates	p. 573
Summary	p. 574
Creating Charts and Tables	p. 575
Exploring Chart Types	p. 575
Creating and Editing Charts	p. 577
Formatting Charts	p. 583
Creating an Organization Chart or Diagram	p. 588
Creating and Editing Tables	p. 593
Inserting Excel Worksheets and Word Tables	p. 595
Summary	p. 598
Adding Graphics and Special Effects	p. 599
Adding Pictures and Multimedia	p. 599
Using Slide Transitions	p. 608
Using Animation Schemes	p. 609
Creating Actions	p. 612
Summary	p. 615
Finalizing Your Slide Show	p. 617
Creating a Slide Show	p. 617
Playing the Slide Show	p. 624
Using Recorded Narration	p. 630
Packaging Your Presentation for a CD	p. 632
Options for Saving Your Presentation	p. 634
Printing	p. 638
Broadcasting over the Internet or an Intranet	p. 641
Summary	p. 643
Fine-Tuning Your Presentation	p. 645
Practice Makes Perfect	p. 645
Troubleshooting Your Slide Show	p. 647
Ten Top PowerPoint Tips	p. 648
Summary	p. 655
Using Access	p. 657
Fundamentals of Access	p. 659
Basic Database Concepts	p. 659
Planning a Database	p. 664
Summary	p. 666
Creating a Database	p. 667
Creating a New Database	p. 667
Creating a Table by Importing or Linking	p. 676
Adding and Editing Data	p. 677
Changing the Appearance of a Table	p. 678
Sorting Data	p. 683
Adding an Index	p. 683
Printing a Table	p. 685
Exporting Table Data	p. 685
Summary	p. 687
Working with Forms	p. 689
Using AutoForm	p. 689
Using the Form Wizard	p. 691
Designing a Form	p. 695
Modifying a Form	p. 697
Adding Controls to a Form	p. 697
Summary	p. 704
Using Queries	p. 705
How Queries Work	p. 705
Creating and Editing Queries	p. 706
Using Queries to Modify Records	p. 712
Using the Query Wizards	p. 716
Summary	p. 728
Generating Reports	p. 729
Types of Reports	p. 729
Using AutoReport	p. 731
Using the Report Wizard	p. 732
Creating Mailing Labels	p. 737
Designing Custom Reports	p. 742
Placing Controls in Reports	p. 744
Creating Relational Reports	p. 747
Summary	p. 750
Access and XML	p. 751
What Is XML?	p. 751
Importing XML Data	p. 754
Exporting Access Data as XML	p. 756
Summary	p. 758
Office and the Web	p. 761
Designing Web Sites with FrontPage	p. 763
What Is FrontPage?	p. 763
Navigating Through FrontPage Views	p. 764
Creating a Web Site	p. 766
Adding and Formatting Text	p. 773
Using Tables for Layout Purposes	p. 776
Adding Graphics	p. 783
Hyperlinks and Image Maps	p. 789
Inserting Special FrontPage Components	p. 793
Experimenting with HTML	p. 795
Summary	p. 798
Managing Your Web Site with FrontPage	p. 799
Themes, Shared Borders, and Link Bars	p. 799
Customizing Themes	p. 805
Organizing Office Documents into a Web Site	p. 809
Generating Usage and Other Reports	p. 810
Global Site Editing	p. 812
Publishing Your Site	p. 816
Getting More Information	p. 819
Summary	p. 820
Creating Web Pages in Other Office Applications	p. 821
Saving Documents as Web Pages	p. 821
Working with Hyperlinks	p. 825
About Graphics in Office-created Web Pages	p. 832
Editing HTML Code in Office	p. 833
Web Page Authoring with Word	p. 834
Web Presentations with PowerPoint	p. 842
Creating Interactive Pages in Office	p. 844
Publishing Spreadsheets on the Web	p. 845
Database Publishing on the Net with Access	p. 849
Publishing Your Web Pages	p. 856
Summary	p. 856
Collaborating in Office	p. 859
Building Integrated Documents	p. 861
Inserting Objects from Other Applications	p. 862
Working with Embedded Objects	p. 865
Working with Linked Objects	p. 866
Other Methods of Sharing Data	p. 868
Sharing Data with XML	p. 872
Summary	p. 873
Universal Drawing and Graphics Features	p. 875
Inserting and Editing Pictures	p. 875
Drawing Your Own Art	p. 883
Formatting Objects: The Master Control Center	p. 904
Using WordArt	p. 906
Using Microsoft Equation Editor	p. 910
Summary	p. 911
Using Microsoft Office Document Imaging and Scanning	p. 913
Scanning Documents	p. 913
Viewing Documents	p. 918
Using Optical Character Recognition (OCR)	p. 920
Annotating Documents	p. 921
Customizing Microsoft Office Document Imaging	p. 922
Distributing Documents	p. 924
Summary	p. 924
Using Microsoft Office Picture Manager	p. 925
Adding Picture Shortcuts	p. 925
Editing Pictures	p. 929
Touching Up Pictures	p. 933
Compressing Pictures	p. 936
Sharing Pictures	p. 938
Exporting Pictures	p. 940
Saving Your Edited Pictures	p. 943
Printing	p. 943
Summary	p. 944
Collaborating on a Network	p. 945
Resource Sharing and Security	p. 945
Sharing Excel Workbooks	p. 954
Collaborating in PowerPoint	p. 957
Sharing Access Databases	p. 959
Distributing Office Documents	p. 963
Summary	p. 966
Windows SharePoint Services with Office System	p. 969
Working with SharePoint Sites and SharePoint Lists	p. 970
Collaborative Document Authoring	p. 984
SharePoint as a Central Contacts and Calendar Server	p. 998
Conducting an Online Meeting with the Meeting Workspace	p. 1002
Summary	p. 1004
Customizing and Automating Office	p. 1007
Customizing Office Applications	p. 1009
Customizing Tips for Word	p. 1009
Customizing Outlook	p. 1014
Customizing Excel	p. 1020
Customizing PowerPoint	p. 1024
Customizing Access	p. 1026
Summary	p. 1027
Working with Macros	p. 1029
Recording Macros	p. 1029
Assigning Macros to Keyboard Combinations, Toolbars, and Menus	p. 1033
Using Macros in Access	p. 1037
Introduction to Visual Basic for Applications	p. 1041
Summary	p. 1042
What's on the CD-ROM	p. 1045
Optimizing Your Office Installation	p. 1055
International Support and Accessibility Features	p. 1059
Finding Office Information on the Web	p. 1067
Index	p. 1071
Table of Contents provided by Ingram. All Rights Reserved.