About the Book
Special Edition Using
Microsoft Office 2000 is the premier Office Suite book for intermediate
and advanced users. Focusing on intermediate and advanced skills and uses
this book features additional coverage of undocumented features, workarounds,
and practical (and unapologetic) advice for avoiding features that don't
work well. You'll also see a writing style that crams in more information
by not wasting step-by-step coverage on simpler tasks
Related Books
Special Edition Using Books (Special
Edition Using Books)
Table ofContents
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. |
