Special Edition Using Microsoft Office 2000

Ed Bott is an award-winning computer journalist and one of the most widely recognized voices in the computing world, with nearly two decades of experience as a writer and editor at leading magazines like PC World and PC Computing. Currently, he is Senior Contributing Editor for Smart Business (formerly PC Computing), a 1999 National Magazine Award winner with a monthly circulation of more than 1 million. On the Web, Ed is the Guide to Windows on About.com, one of the Internet's leading resources for news, information, and entertainment; he also writes a weekly column for TechRepublic.com. He is the author of a long list of Que books covering Microsoft Windows and Office; in all, Ed has reached more than 650,000 Windows and Office users through his unique combination of expert knowledge and friendly, down-to-earth style. Woody Leonhard describes himself as "a Microsoft Office victim." A contributing editor at PC Computing Magazine, Woody is known for his offbeat writing style and dead-on accurate technical content. He has earned an unprecedented six Computer Press Association awards and, with Ed Bott, two American Business Press awards. Woody is the author of Woody Leonhard Teaches Microsoft Office 2000 and Special Edition Using Microsoft Office 2000 which includes "Woody's Office POWER Pack," the award-winning Office add-on created by Woody1s software company. With 15 (or is it 16?) computer books under his belt, Woody is now the author "Woody's Office Watch" ­ a free (!) weekly electronic newsletter that holds Microsoft's feet to the fire. Woody is also a Tibetan human rights advocate and cofounder of the Tibetan Children's Fund. He lives on top of a mountain in Colorado.

Introduction.
I. COMMON TASKS.

1. An Overview of Office 2000.


What's New in Office 2000. An Overview of Office 2000 Applications. Office Applets and Utilities. Online Help for Expert Users. Advanced Support Options. Troubleshooting. Secrets of the Office Masters: Creating Shortcuts to Help Files.

2. Customizing the Office Interface.


Controlling Automatic Interface Changes. Creating a New Toolbar. Customizing Built-In Menus. Bypassing Menus with Keyboard Shortcuts. Configuring Common Office Features. Configuring Spell-Checking Options. Setting IntelliMouse Options. Saving and Restoring Personal Settings. Troubleshooting. Secrets of the Office Masters: Custom Toolbars for Quick Highlighting.

3. Office File Management for Experts.


Choosing a Default Storage Location. Creating New Files. Using and Customizing Common Dialog Boxes. Storing Document Details in the Properties Box. Searching for Office Files. Troubleshooting. Secrets of the Office Masters: Details, Details.

4. Editing and Formatting Text.


Entering Text. Selecting Text. Finding and Replacing Text. Using AutoCorrect to Automate Documents. Using and Managing Fonts. Common Formatting Options. Undoing and Redoing Changes. Troubleshooting. Secrets of the Office Masters: Using AutoCorrect to Add a Digital Signature to Your Documents.

5. Creating and Editing Professional-Quality Graphics.


Using Office Drawing Tools. Creating Graphics from Text. Using the Clip Gallery. Importing and Exporting Graphics. Using Microsoft Photo Editor to Crop and Adjust Graphics. Working with Scanned Images. Inserting Organization Charts. Creating and Editing Simple Charts. Troubleshooting. Secrets of the Office Masters: A Professional Word Flowchart.

6. Sharing Data Between Office Applications.


Using the Office Clipboard. Converting Clipboard Data into Alternative Formats. Dragging and Dropping Data. Converting and Importing Files Between Office Applications. Combining Two or More Data Types in One Document. Managing Multiple Documents with Office Binders. Troubleshooting. Secrets of the Office Masters: Unhiding the Clipboard Toolbar.

7. Sharing Documents Within a Workgroup.


Keeping Shared Documents Secure. Mailing and Routing Documents. Using NetMeeting for Online Collaboration. Troubleshooting.

II. OFFICE AND THE WEB.

8. Office on the Web for Experts.


Office and the Web. How Office Handles HTML Documents. Choosing the Right Tool for the Job. Moving Between HTML and Office Formats. Web Page Design Essentials. Working with Hyperlinks. Troubleshooting. Secrets of the Office Masters: Keys to Effective Web Page Design.

9. Advanced Web Page Techniques.


Browser Compatibility Issues. Creating Interactive Web Pages with Office Components. Using COM Components. Adding VBScript or JScript Code. Previewing and Testing Web Pages. Secrets of the Office Masters: The Power of Interactive Web Pages.

10. Using Office Documents on a Web Server.


Saving and Opening Pages on Web Servers. Using a Web Server for Discussions. Configuring Office for Web Discussions. Participating in Web Discussions. Troubleshooting. Secrets of the Office Masters: Tips for Managing an Intranet Server.

III. USING WORD.

11. Word Essentials.


Avoiding Compatibility Problems. Batch Conversions with the Conversion Wizard. Understanding Your Formatting Options. Choosing the Right Document View. Printing Word Documents. Customizing the Word Interface. Troubleshooting. Secrets of the Office Masters: Styles and Manually Applied Formatting.

12. Expert Text-Editing Techniques.


Navigating Through a Word Document. Finding and Replacing Text and Other Parts of a Document. Entering Text and Graphics Automatically with AutoText and AutoCorrect. Using Hyphens and Dashes. Changing Text Formatting. Changing Paragraph Formatting. Using the Ruler to Set Tab Stops and Indents. Formatting Simple Lists with Bullets and Numbers. Formatting All or Part of a Document Automatically. Checking Spelling and Grammar. Sharing Documents. Troubleshooting. Secrets of the Office Masters: Combining Revision Marks and Comments.

13. Advanced Document Formatting.


Adjusting Margins. Changing Paper Size and Orientation. Inserting and Deleting Manual Page Breaks. Formatting Documents by Section. Adding Lines, Borders, Shading, and Backgrounds. Formatting a Document with Columns. Faking Columns with Linked Text Boxes. Creating and Editing Headers and Footers. Creating and Editing Letters. Creating Envelopes and Labels. Wrapping Text Around Graphics. Summarizing a Document Automatically. Troubleshooting. Secrets of the Office Masters: Creative Newsletter Layouts.

14. Using Tables.


Using Tables to Organize Information. Adding a Table to a Document. Working with Tables. Positioning Tables on the Page. Advanced Table Formatting Options. Troubleshooting. Secrets of the Office Masters: Nested Tables for Superior Layout.

15. Using Styles, Templates, and Themes.


Formatting with Styles and Templates. Formatting Documents with Styles. Saving Formats As Named Styles. Customizing the Normal Document Template. Using Word's Built-In Templates. Changing Document Formats Globally. Managing Styles and Templates. Troubleshooting. Secrets of the Office Masters: Using a Macro to Replace Straight Quotes with Curly Quotes.

16. Creating Dynamic Documents with Fields and Forms.


Using Fields Intelligently. Inserting a Field into a Document. Formatting Field Results. Displaying Field Results Correctly. Some Useful Custom Fields. Creating a Data-Entry Form. Troubleshooting. Secrets of the Office Masters: Putting the {ListNum} Field to Work.

17. Merging Data and Documents.


Merging Data to Create Custom Reports and Letters. Using Mail Merge to Personalize Form Letters. Mass Emailing and Faxing with Outlook and Mail Merge. Creating Catalogs. Advanced Mail Merge Techniques. Troubleshooting. Secrets of the Office Masters: Professional Labels, Big Time.

18. Keeping Long Documents Under Control.


One File or Many? Using Bookmarks. Inserting Cross-References. Making Captions and Figure Numbering Work. Creating Indexes. Creating a Table of Contents. Managing Multiple Files. Troubleshooting. Secrets of the Office Masters: Combining Word's Auto Features and Cross-Referencing.

IV. USING EXCEL.

19. Excel Essentials.


Working with Worksheets and Workbooks. File Compatibility Issues. Using Ranges to Work with Multiple Cells. Hiding Rows and Columns. Using the Clipboard to Transform Data. Customizing the Worksheet Window. Using Links to Automatically Update or Consolidate Worksheet Data. Printing Worksheets. Publishing Excel Data in Web Pages. Customizing Excel. Troubleshooting. Secrets of the Office Masters: Managing Add-Ins.

20. Advanced Worksheet Formatting.


How Cell Formatting Works. Changing Formatting for a Cell or Range. Designing and Formatting a Worksheet for Maximum Readability. Using Conditional Formatting to Identify Key Values. Copying Formats with the Format Painter. Saving Formats As Named Styles. Using AutoFormat. Troubleshooting. Secrets of the Office Masters: Redesigning a Worksheet Clarifies the Information.

21. Using Formulas and Functions.


Entering and Editing Formulas. Using Range Names and Labels in Formulas. Manipulating Data with Worksheet Functions. Putting Worksheet Functions to Use. Using Goal Seek to Find Values. Troubleshooting Formulas. Troubleshooting. Secrets of the Office Masters: Nesting Functions Within Functions.

22. Creating and Editing Charts.


Anatomy of an Excel Chart. Using the Chart Wizard for Quick Results. Selecting Data to Plot. Selecting and Customizing a Chart Type. Editing and Formatting Chart Elements. Troubleshooting. Secrets of the Office Masters: Creating a Custom Chart Library.

23. Working with Lists and Databases.


Creating a List on a Worksheet. Speeding Up Repetitive Data Entry with AutoComplete. Automatically Filling In a Series of Data. Sorting Lists. Finding and Filtering Data in a List. Summarizing, Grouping, Outlining, and Subtotaling Lists. Using Forms to Add and Edit List Data.Importing and Exporting Data. Creating Links to External Databases. Creating and Using Web Queries. Troubleshooting. Secrets of the Office Masters: Smart Lists.

24. Using Excel in a Workgroup.


Protecting a Worksheet. Sharing a Workbook. Storing Multiple Scenarios in a Single Workbook. Consolidating Data from Multiple Users into a Single Workbook.Creating Custom Views of Worksheet Data. Troubleshooting. Secrets of the Office Masters: Managing Scenarios.

25. Using PivotTables and PivotCharts.


How PivotTable and PivotChart Reports Work. When Should You Use a PivotTable? Creating a PivotTable. Editing and Updating a PivotTable. Creating and Editing PivotCharts. Formatting and Printing PivotTables. Troubleshooting. Secrets of the Office Masters: Grouping Items in a PivotTable.

26. Error-Proof Data-Entry Techniques.


Restricting and Validating Data Entry for a Cell or Range. Creating and Using Data-Entry Forms. Troubleshooting Data Errors. Troubleshooting. Secrets of the Office Masters: Creating an Online Form.

V. USING OUTLOOK.

27. Outlook Essentials.


Choosing an Outlook Configuration. How Outlook Stores Your Data. Using and Customizing the Outlook Interface. Creating, Editing, and Managing Outlook Items. Viewing Personal Information in Outlook. Managing Files and Folders in Outlook. Finding Outlook Items. Troubleshooting. Secrets of the Office Masters: Building a Library of Saved Searches.

28. Expert Email Management.


Setting Up Internet Email Accounts. Choosing a Message Format. Using Word As an Email Editor. Creating, Managing, and Using Email Addresses. Creating and Sending Messages. Checking Your Mail and Reading New Messages. Organizing Your Email. Troubleshooting. Secrets of the Office Masters: Tasteful Stationery.

29. Using Calendar.


Managing Your Personal Calendar. Viewing a Daily, Weekly, or Monthly Calendar. Printing a Calendar. Troubleshooting. Secrets of the Office Masters: Space-Saving Pocket Calendar.

30. Managing a Contacts List.


Managing Your List of Contacts. Creating a New Contact Item. Entering Several New Contact Items at Once. Editing One or More Contact Records. Merging Duplicate Contact Items. Mapping a Contact's Address. Tracking Activities for Each Contact. Addressing Letters and Envelopes Using Your Contacts List. Printing Phone Lists from Your Contacts List. Troubleshooting. Secrets of the Office Masters: Create a Contacts Folder for Web-Based Businesses.

31. Sharing Schedules and Planning Meetings.


Planning a Meeting with Outlook. Responding to Meeting Requests. Publishing Your Schedule Information. Troubleshooting. Secrets of the Office Masters: Publishing a Calendar As a Web Page.

32. Tracking Tasks and Taking Notes.


Maintaining a Personal Task List. Sorting and Filtering the Task List. Using the Journal to Track Activities. Creating and Editing Notes. Troubleshooting.

33. Administering Outlook.


Integrating Outlook with Exchange Server. Using Net Folders to Share Information. Managing Outlook Data Files. Importing and Exporting Outlook Information. Controlling Outlook with Startup Switches. Troubleshooting. Secrets of the Office Masters: Sharing a Task List.

VI. USING POWERPOINT.

34. PowerPoint Essentials.


Anatomy of a PowerPoint Presentation. File Compatibility Issues. Creating a Presentation. Viewing a Presentation. Managing Slide Shows. Navigating Through a Presentation. Troubleshooting.

35. Expert Presentation-Building Techniques.


Editing the Presentation Outline. Picking the Best Slide Layout. Editing Slides. Creating a Summary Slide. Adding Comments to a Presentation. Checking for Inconsistencies and Style Errors. Troubleshooting. Secrets of the Office Masters: Advanced Tricks for Showing Graphs.

36. Advanced Formatting Options.


PowerPoint File Types. Organizing Formats with Master Slides. Applying and Modifying Designs. Using Color Schemes. Changing Paragraph and Text Formatting. Troubleshooting. Secrets of the Office Masters: Tweaking the Slide Master.

37. Adding Graphics, Multimedia, and Special Effects.


Using Transitions to Control Pacing. Animating Text and Objects on a Slide. Adding Multimedia to Your Presentation. Using Action Links to Combine Effects. Troubleshooting. Secrets of the Office Masters: Animate Charts to Emphasize Data.

38. Planning and Delivering a Presentation.


Planning Your Presentation. Delivering a Perfect Presentation. Using PowerPoint with a Projector. Taking Notes During a Slide Show. Printing Your Presentation. Troubleshooting. Secrets of the Office Masters: Anticipating Questions with Hidden Slides.

39. Creating Self-Running Presentations for Kiosks and the Web.


Creating a Self-Running Presentation. Packaging a Presentation for Use on Another Computer. Creating Presentations for the Web. Troubleshooting. Secrets of the Office Masters: Choosing the Best Screen Resolution for a Web Presentation.

VII. USING ACCESS.

40. Access Essentials.


Planning an Access Database. Working with Database Objects. Using Wizards to Create Databases and Objects. Using Sample Databases. Exporting and Importing Data. Using Expressions in Database Objects. Creating Access Applications. Troubleshooting. Secrets of the Office Masters: A Database Design Checklist.

41. Creating and Customizing Tables.


Table Essentials. Creating a New Table. Changing a Table's Structure. Restricting Data Entry. Working in Datasheet View. Troubleshooting. Secrets of the Office Masters: Input Masks Made Easy.

42. Linking Multiple Tables.


Defining Relationships Between Tables. Splitting a Table to Avoid Data Duplication. Changing Joins. Creating Links to External Databases. Troubleshooting. Secrets of the Office Masters: Sharing the (Data) Wealth.

43. Using Queries to Find and Filter Data.


Understanding Queries. Creating and Modifying Queries. Creating and Applying Filters. Troubleshooting. Secrets of the Office Masters: Using Functions to Group Dates.

44. Designing and Using Forms.


Using Forms to View and Enter Data. Creating a New Form. Displaying or Entering Data with a Form. Changing a Form's Design. Troubleshooting. Secrets of the Office Masters: Switchboard Secrets.

45. Presenting Data with Reports.


Creating Reports from Access Data. Modifying a Report. Exporting a Report to Another Data Format. Troubleshooting. Secrets of the Office Masters: Grouping Data.

VIII. USING PUBLISHER.

46. Publisher for Office Experts.


What Does Publisher Do Best? Key Components of Publisher. Designing Pages. Inserting and Manipulating Objects. Working with Graphic Objects. Editing Fills. Recoloring Pictures. Creating Borders and Shadows. Troubleshooting. Secrets of the Office Masters: Combining Rotated and Layered Objects.

47. Creating and Managing Complex Publications.


Synchronizing and Unsynchronizing Text Frames. Using Smart Objects. Updating Personal Information. Defining Custom Logos. Using Templates. Creating a Template. Using Custom Objects from the Design Gallery. Defining Units of Measurement. Flowing Text Files Between Frames. Using Advanced Printing Features. Printing Folded Publications. Solving Complex Printer Challenges. Working with Commercial Printers. Troubleshooting. Secrets of the Office Masters: Adding Graphics Files to the Design Gallery. Secrets of the Office Masters: Low-Cost Color: Adding a Single Spot Color.

IX. USING FRONTPAGE AND PHOTODRAW.

48. FrontPage Essentials.


How FrontPage 2000 Fits into Office. Using the Integrated Environment. Creating and Managing Web Sites. Understanding the Office Server Extensions. Understanding HTTP. Troubleshooting. Secrets of the Office Masters: Using HTTP-EQUIV and Meta Data.

49. Developing Web Sites.


Creating Web Sites. Creating Web Pages. Introduction to HTML. Creating Hyperlinks. Using Tables. Working with Images and Videos. Troubleshooting. Secrets of the Office Masters: Elements of Effective Page Layout Design.

50. Creating Advanced Web Pages.


Going Beyond Simple Pages. Using Cascading Style Sheets. Applying Themes. Laying Out Your Pages. Planning the Navigation Structure of Your Web Site. Using Forms. Using FrontPage Components. Serving Live Pages from a Database. Troubleshooting. Secrets of the Office Masters: Understanding Cookies.

51. Publishing and Managing Web Sites.


Publishing Web Sites. Managing Web Sites. Collaborating with FrontPage. Troubleshooting. Secrets of the Office Masters: Understanding Site Statistics.

52. PhotoDraw Essentials.


Getting Started with PhotoDraw. Using Design Templates. Creating and Editing Images. Importing and Outputting Images. Photo Retouching. Secrets of the Office Masters: 3D Extrusion and Rotation.

X. AUTOMATING OFFICE WITH MACROS AND VBA.

53. Using Macros to Automate Office Tasks.


How Macros Work. Recording Simple Macros. Troubleshooting Recorded Macros. Running Macros. Macro Security. Secrets of the Office Masters: Getting Ready to Tackle VBA.

54. Working with Visual Basic for Applications.


VBA Basics. Managing Macros. Using the VBA Editor. Building Interactive VBA Programs. Controlling an Office Application from VBA. Secrets of the Office Masters: Elements of Programming Style for the Nonprogrammer.

55. Building Custom Applications with VBA.


Controlling How VBA Applications Start. Opening, Closing, and Creating New Documents. Using VBA to Add Text. Displaying Messages. Displaying Office-Standard Dialog Boxes. Creating Custom Dialog Boxes. Troubleshooting. Secrets of the Office Masters: Custom Dialog Boxes in VBA.

56. Advanced VBA Tools and Techniques.


Managing VBA Projects. Code Snippets You Can Use. Controlling Other Applications. Using the Object Browser. Secrets of the Office Masters: Stuck on a Line of VBA Code? Que's Special Edition WOPR 2000 Pack Installation.

XI. APPENDIXES.

Appendix A. Advanced Setup Options.


Using the Windows Installer. Performing a Custom Installation. Fixing Setup Problems. Using Setup in Maintenance Mode. Installing Office from a Network. Backing Up User Settings with the Office Profile Wizard. Adding Support for Other Languages. Troubleshooting.

Appendix B. What's on Que's Special Edition WOPR 2000 Pack CD.


WOPR 2000--Woody's Office POWER Pack 2000. Complete Electronic Copy of Special Edition Using Microsoft Office 2000. Extensive Additional Electronic Book Chapters on Office 2000 Programs. Third-Party Software. Que's Special Edition WOPR 2000 Pack Installation.