Using Microsoft Office 2000, Small Business Edition.

by Ed Bott; Woody Leonhard

• ISBN13: 9780789719690
• ISBN10: 078971969X
• Format: Paperback
• Copyright: 1999-05-01
• Publisher: Pearson P T R

Summary

Special Edition Using Microsoft Office 2000 Small Business Edition is the premier Office Suite book for intermediate and advanced users of the Small Business Edition version of the software. 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.

Table of Contents

Introduction	1	(11)
I Common Tasks
An Overview of Office 2000 Small Business Edition	11	(24)
What's New in Office 2000 Small Business Edition	12	(5)
Usability Improvements	12	(2)
Web Improvements	14	(1)
Office Setup and Configuration Tools	15	(2)
Office 2000 Small Business Edition Applications	17	(6)
Word 2000	17	(2)
Excel 2000	19	(1)
Outlook 2000	20	(1)
Publisher 2000	21	(1)
Small Business Tools	22	(1)
Office Applets and Utilities	23	(1)
Online Help for Expert Users	24	(5)
Using the Office Assistant	25	(1)
Using the Answer Wizard	26	(2)
Browsing the Help Contents	28	(1)
Using the Index to Find Keywords	29	(1)
Advanced Support Options	29	(3)
Using the Office Resource Kit	29	(1)
Using Help on the Web	30	(1)
Searching the Microsoft Knowledge Base	31	(1)
Other Resources	31	(1)
Troubleshooting	32	(1)
Secrets of the Office Masters: Creating Shorcuts to Help Files	32	(3)
Customizing the Office Interface	35	(30)
Controlling Automatic Interface Changes	36	(3)
How Personalized Toolbars and Menus Work	36	(2)
Disabling On-the-Fly Interface Change	38	(1)
Restoring Default Menus and Toolbars	38	(1)
Customizing Toolbars	39	(5)
Showing, Hiding, and Arranging Toolbars	39	(2)
Adding and Removing Buttons	41	(3)
Creating a New Toolbar	44	(6)
Adding Macros to a Toolbar	44	(1)
Customizing the Appearance of Your Toolbar Buttons	45	(1)
Putting It All Together	46	(2)
Adding a Hyperlink to a Toolbar Button	48	(2)
Customizing Built-In Menus	50	(2)
Rearranging Pull-Down Menus	50	(1)
Creating New Menus	50	(1)
Modifying Shortcut Menus	51	(1)
Bypassing Menus with Keyboard Shortcuts	52	(4)
Configuring Common Office Features	56	(1)
Configuring Spell-Checking Options	57	(3)
Setting IntelliMouse Options	60	(1)
Saving and Restoring Personal Settings	61	(1)
Troubleshooting	62	(2)
Secrets of the Office Masters: Custom Toolbars for Quick Highlighting	64	(1)
Office File Management for Experts	65	(26)
Choosing a Default Storage Location	66	(2)
Creating New Files	68	(2)
Using and Customizing Common Dialog Boxes	70	(6)
Customizing Common Dialog Boxes	72	(1)
Naming Documents	73	(1)
Protecting Documents from Changes	74	(1)
Using Alternative File Formats	75	(1)
Storing Document Details in the Properties Box	76	(5)
Default Document Properties	78	(1)
Using Custom Properties to Organize Files	79	(1)
Using Explorer to View File Properties	80	(1)
Searching for Office Files	81	(6)
Finding Files by Name, Date, or Content	83	(1)
Using Document Properties to Locate Files	83	(1)
Saving and Reusing Searches	84	(1)
Configuring the Find Fast Utility	85	(2)
Working with Multiple Files	87	(1)
Troubleshooting	88	(1)
Secrets of the Office Masters: Details, Details	89	(2)
Editing and Formatting Text	91	(24)
Entering Text	92	(6)
Inserting Symbols and Special Characters	92	(3)
Entering Accented and International Characters	95	(1)
Entering Text in Another Language	96	(2)
Selecting Text	98	(1)
Finding and Replacing Text	99	(2)
Using AutoCorrect to Automate Documents	101	(7)
How AutoCorrect Works	102	(1)
Setting AutoCorrect Options	103	(1)
Customizing the AutoCorrect Lists	104	(2)
Advanced AutoCorrect Techniques	106	(1)
AutoCorrect Do's and Don'ts	107	(1)
Using and Managing Fonts	108	(1)
Common Formatting Options	109	(3)
Changing Character Attributes	109	(2)
Using Bullets and Numbers to Set Off Lists	111	(1)
Undoing and Redoing Changes	112	(1)
Troubleshooting	113	(1)
Secrets of the Office Masters: Using AutoCorrect to Add a Digital Signature to Your Documents	113	(2)
Creating and Editing Professional-Quality Graphics	115	(22)
Using Office Drawing Tools	116	(9)
Working with the Drawing Layer	116	(2)
Drawing Simple Shapes	118	(1)
Working with AutoShapes	118	(1)
Using Lines and Arrows	119	(2)
Changing Background Colors and Line Formats	121	(1)
Adding Borders, Shadows, and 3D Effects	122	(1)
Adding Text to a Drawing	123	(1)
Aligning and Grouping Graphic Elements	124	(1)
Wrapping, Layout, and Stacking	125	(1)
Creating Graphics from Text	125	(3)
Using Text Boxes to Create Pull Quotes	126	(1)
Using WordArt for Logos	127	(1)
Using the Clip Gallery	128	(2)
Importing and Exporting Graphics	130	(3)
Choosing Embedding or Linking	130	(2)
Resizing and Cropping	132	(1)
Using Advanced Picture Effects	132	(1)
Using Microsoft Photo Editor to Crop and Adjust Graphics	133	(1)
Working with Scanned Images	134	(1)
Inserting Organization Charts	135	(1)
Creating and Editing Simple Charts	135	(1)
Troubleshooting	136	(1)
Secrets of the Office Masters: A Professional Word Flowchart	136	(1)
Sharing Data Between Office Applications	137	(22)
Using the Office Clipboard	138	(2)
Converting Clipboard Data into Alternative Formats	140	(5)
Dragging and Dropping Data	145	(2)
Converting and Importing Files Between Office Applications	147	(1)
Combining Two or More Data Types in One Document	148	(6)
Embedding Versus Linking	149	(2)
Creating and Editing Embedded Objects	151	(1)
Creating and Editing Linked Objects	152	(1)
Managing Links Between Documents and Objects	153	(1)
Managing Multiple Documents with Office Binders	154	(2)
Troubleshooting	156	(1)
Secrets of the Office Masters: Unhiding the Clipboard Toolbar	157	(2)
Sharing Documents Within a Workgroup	159	(14)
Keeping Shared Documents Secure	160	(3)
Protecting Office Documents with Passwords	160	(1)
How Office Locks Documents to Prevent Conflicts	161	(1)
Opening Documents in Read-Only Mode	162	(1)
Controlling File Access with Windows Permissions	163	(1)
Mailing and Routing Documents	163	(4)
Sending a Document As Email	164	(1)
Sending a Document As an Email Attachment	165	(1)
Adding a Routing Slip	165	(2)
Using NetMeeting for Online Collaboration	167	(2)
Troubleshooting	169	(4)
II Office and the Web
Office on the Web for Experts	173	(18)
Office and the Web	174	(1)
How Office Handles HTML Documents	174	(2)
Choosing the Right Tool for the Job	176	(7)
Word	176	(1)
Excel	177	(1)
PowerPoint	178	(1)
Access	179	(1)
Outlook	180	(1)
Publisher	181	(1)
FrontPage	181	(2)
PhotoDraw	183	(1)
Moving Between HTML and Office Formats	183	(3)
Web Page Design Essentials	186	(1)
Working with Hyperlinks	187	(1)
Troubleshooting	188	(1)
Secrets of the Office Masters: Keys to Effective Web Page Design	188	(3)
Advanced Web Page Techniques	191	(12)
Browser Compatibility Issues	192	(1)
Creating Interactive Web Pages with Office Components	192	(4)
Interactive Charts	193	(1)
Interactive Spreadsheets	194	(1)
Interactive PivotTables	195	(1)
Data Access Pages	195	(1)
Using COM Components	196	(1)
Adding VBScript or JScript Code	197	(4)
Previewing and Testing Web Pages	201	(1)
Secrets of the Office Masters: The Power of Interactive Web Pages	202	(1)
Using Office Documents on a Web Server	203	(18)
Saving and Opening Pages on Web Servers	204	(5)
Creating and Managing Web Folders	204	(3)
Opening and Saving from an FTP Site	207	(2)
Using a Web Server for Discussions	209	(2)
Configuring Office for Web Discussions	211	(2)
Participating in Web Discussions	213	(3)
Troubleshooting	216	(1)
Secrets of the Office Masters: Tips for Managing an Intranet Server	216	(5)
III Using Word
Word Essentials	221	(32)
Avoiding Compatibility Problems	222	(3)
Using Different Word File Formats	222	(1)
Strategies for Mixed Word Environments	222	(3)
Strategies for Non-Word Environments	225	(1)
Batch Conversions with the Conversion Wizard	225	(1)
Understanding Your Formatting Options	226	(9)
Character Formats	226	(3)
Paragraph Formats	229	(1)
Copying Formats with the Format Painter	230	(1)
Direct Formatting Versus Styles	230	(1)
Page/Section Setup Options	231	(2)
Floating Versus Inline Objects	233	(1)
AutoFormatting	233	(2)
Choosing the Right Document View	235	(6)
Normal View	235	(1)
Print Layout View	236	(1)
Web Layout View	236	(1)
Outline View	237	(1)
Document Map View	238	(1)
Zoom Options	239	(1)
Full Screen	239	(1)
Splitting a Document Window	240	(1)
Printing Word Documents	241	(3)
Print Preview Mode	241	(1)
Choosing What to Print	242	(1)
Printing Thumbnails	243	(1)
Collating	244	(1)
Customizing the Word Interface	244	(4)
Options Settings	244	(3)
Disabling AutoFormat Settings	247	(1)
Word Startup Switches	248	(2)
Troubleshooting	250	(1)
Secrets of the Office Masters: Styles and Manually Applied Formatting	250	(3)
Expert Text-Editing Techniques	253	(38)
Navigating Through a Word Document	254	(6)
Using the Keyboard to Move Through a Document	254	(1)
Using the Mouse to Move Through a Document	255	(1)
Navigating with the Document Map	255	(1)
Using the Keyboard and Mouse to Select Text	256	(1)
Bookmarks	257	(1)
Navigating Through Documents with the Object Browser	258	(2)
Finding and Replacing Text and Other Parts of a Document	260	(6)
Finding Text	261	(2)
Replacing Text	263	(1)
Finding and Replacing Formatting	264	(2)
Inserting Footnotes	266	(1)
Entering Text and Graphics Automatically with Auto Text AutoCorrect	266	(2)
Using Hyphens and Dashes	268	(2)
Changing Text Formatting	270	(3)
Changing Paragraph Formatting	273	(6)
Adjusting Paragraph Alignment and Outline Level	273	(2)
Indenting Paragraphs for Emphasis	275	(1)
Adjusting Line and Paragraph Spacing	275	(1)
Controlling Page Breaks	276	(1)
Using Drop Caps for Emphasis	277	(1)
Positioning Text with Tabs	278	(1)
Using the Ruler to Set Tab Stops and Indents	279	(2)
Using Tabs to Create a User Input Form	280	(1)
Formatting Simple Lists with Bullets and Numbers	281	(2)
Formatting All or Part of a Document Automatically	283	(1)
Checking Spelling and Grammar	284	(1)
Sharing Documents	285	(3)
Tracking Revisions	285	(1)
Adding Comments to Documents	286	(1)
Password Protecting Documents	287	(1)
Saving Document Versions	287	(1)
Troubleshooting	288	(1)
Secrets of the Office Masters: Combining Revision Marks and Comments	289	(2)
Advanced Document Formatting	291	(34)
Adjusting Margins	292	(2)
Changing Paper Size and Orientation	294	(1)
Inserting and Deleting Manual Page Breaks	295	(1)
Formatting Documents by Section	296	(3)
Types of Sections	296	(1)
Inserting and Deleting Section Breaks	297	(1)
Copying Formatting Between Sections	298	(1)
Adding Lines, Borders, Shading, and Backgrounds	299	(4)
Quick Ways to Create Lines	299	(1)
Borders and Boxes	300	(1)
Shading Characters, Paragraphs, and Pages	301	(2)
Formatting a Document with Columns	303	(2)
Faking Columns with Linked Text Boxes	305	(1)
Creating and Editing Headers and Footers	306	(6)
Creating Headers and Footers	306	(2)
Numbering Pages	308	(1)
Adding Dates and Document Details	309	(1)
Watermarks	309	(2)
How Section Breaks Affect Headers and Footers	311	(1)
Creating and Editing Letters	312	(6)
Using the Letter Wizard	312	(2)
Customizing Letter Templates	314	(2)
Addressing Letters with the Outlook Contacts List	316	(2)
Creating Envelopes and Lables	318	(3)
Printing Envelopes	319	(1)
Printing Labels	320	(1)
Customizing Labels	320	(1)
Wrapping Text Around Grphics	321	(1)
Summarizing Document Automatically	322	(1)
Troubleshooting	322	(1)
Secrets of the Office Masters: Creative Newsletter Layouts	323	(2)
Using Tables	325	(22)
Using Tables to Organize Information	326	(1)
Adding a Table to a Document	327	(4)
Creating Quick Tables	327	(1)
Drawing a Complex Table	328	(1)
Converting Text to a Table	329	(1)
Converting Data to a Table	330	(1)
Nesting Tables Within Tables	331	(1)
Working with Tables	331	(8)
Selecting Cells, Rows, and Columns	331	(1)
Entering and Editing Data	332	(1)
Moving and Copying Parts of a Table	332	(1)
Changing Column Widths and Row Heights	333	(2)
Adding and Deleting Rows and Columns	335	(1)
Rotating Text	335	(1)
Merging and Splitting Cells and Tables	336	(1)
Sorting Data Within Tables	337	(1)
Performing Calculations in a Table	338	(1)
Positioning Tables on the Page	339	(1)
Advanced Table Formatting Options	340	(3)
Letting Word Do the Work with AutoFormat	340	(1)
Using Borders and Shading	341	(1)
Aligning Text in Cells	341	(2)
Working with Big Tables	343	(1)
Troubleshooting	343	(2)
Secrets of the Office Masters: Nested Tables for Superior Layout	345	(2)
Using Styles, Templates, and Themes	347	(22)
Formatting with Styles and Templates	348	(1)
Formatting Documents with Styles	349	(5)
Paragraph Versus Character Styles	350	(1)
Viewing Available Styles	351	(1)
Applying Style Manually	352	(2)
Applying Styles Automatically	354	(1)
Saving Formats As Named Styles	354	(3)
Customizing the Normal Document Template	357	(2)
Using Word's Built-In Templates	359	(1)
Changing Document Formats Globally	360	(3)
Managing Styles and Templates	363	(3)
Creating a New Template from Scratch	364	(1)
Where Does Word Store Templates?	364	(1)
Customizing Word Templates	365	(1)
Copying Styles and Settings Between Templates	365	(1)
Troubleshooting	366	(1)
Secrets of the Office Masters: Using a Macro to Replace Straight Quotes with Curly Quotes	367	(2)
Creating Dynamic Documents with Fields and Forms	369	(26)
Using Fields Intelligently	370	(2)
Showing and Hiding Field Codes	371	(1)
Field Code Syntax	371	(1)
Inserting a Field into a Document	372	(1)
Formatting Field Results	372	(4)
General \* Format Switches	373	(1)
Numeric \# Picture Switches	374	(1)
Date-Time \@ Format Switches	375	(1)
Displaying Field Results Correctly	376	(1)
Some Useful Custom Fields	377	(14)
Showing Dates and Times	378	(1)
Page Numbering	379	(1)
Referring to Document Contents	380	(2)
Displaying Document Properties	382	(2)
Performing Mathematical Calculations	384	(2)
Managing Custom Numeric Sequences	386	(3)
Prompting for Input	389	(1)
Jumping in a Document	390	(1)
Table of Contents and Index Fields	390	(1)
Creating a Data-Entry Form	391	(2)
Troubleshooting	393	(1)
Secrets of the Office Masters: Putting the {ListNum} Field to Work	393	(2)
Merging Data and Documents	395	(20)
Merging Data to Create Custom Reports and Letters	396	(2)
Using Mail Merge to Personalize Form Letters	398	(7)
Creating the Form Letter	399	(1)
Specifying a Source for Names and Addresses	400	(1)
Placing Data Fields Within Your Document	401	(1)
Filtering Your Mailing List	402	(1)
Previewing Mail Merge Results	403	(2)
Mass Emailing and Faxing with Outlook and Mail Merge	405	(1)
Creating Catalogs	405	(2)
Advanced Mail Merge Techniques	407	(6)
Merge Envelopes	407	(1)
Merge Labels	408	(3)
Customizing Form Letters with Fields	411	(2)
Troubleshooting	413	(1)
Secrets of the Office Masters: Professional Labels, Big Time	414	(1)
Keeping Long Documents Under Control	415	(20)
One File or Many?	416	(1)
Using Bookmarks	417	(1)
Inserting Cross-References	418	(2)
Making Captions and Figure Numbering Work	420	(2)
Creating Your Own Caption and Figure Numbering Fields	422	(1)
Creating Indexes	422	(2)
Creating a Table of Contents	424	(3)
Managing Multiple Files	427	(2)
Using Master Documents	427	(1)
Using Binders	428	(1)
File Management Strategies	428	(1)
Troubleshooting	429	(1)
Secrets of the Office Masters: Combining Word's Auto Features and Cross-Referencing	430	(5)
IV Using Excel
Excel Essentials	435	(34)
Working with Worksheets and Workbooks	436	(8)
Working with Multiple Worksheets	436	(1)
Moving, Copying, Inserting, and Deleting Worksheets	437	(1)
Renaming a Worksheet	438	(1)
Navigating in a Workbook with Keyboard Shortcuts	439	(1)
Using Cell References and Range Names to Navigate in a Workbook	439	(2)
Selecting Ranges of Data with the Go to Dialog Box	441	(3)
File Comptibility Issues	444	(1)
Using Ranges to Work with Multiple Cells	445	(1)
Selecting Ranges	445	(1)
Moving from Cell to Cell Within a Range	446	(1)
Entering the Same Data in Multiple Cells	446	(1)
Hiding Rows and Columns	446	(1)
Using the Clipboard to Transform Data	447	(3)
Dragging and Dropping to Convert Data	447	(1)
Transforming Data with Paste Special	448	(2)
Customizing the Worksheet Window	450	(2)
Using the Zoom Controls	450	(1)
Locking Row and Column Labels for Onscreen Viewing	450	(1)
Splitting the Worksheet Window	451	(1)
Using Links to Automatically Update or Consolidate Worksheet Data	452	(1)
Printing Worksheets	453	(5)
Using Ranges to Define the Default Print Area	453	(1)
Inserting Your Own Page Breaks	454	(1)
Extra Items You Can Print	455	(1)
Labeling Printed Pages with Headers and Footers	456	(1)
Using Repeating Titles for Multiple Page Printouts	457	(1)
Forcing a Worksheet to Fit on a Specified Number of Pages	457	(1)
Publishing Excel Data in Web Pages	458	(2)
Customizing Excel	460	(5)
Customizing Undo	462	(1)
Changing Default Formatting for New Workbooks and Worksheets	463	(1)
Installing Excel Add-Ins	463	(1)
Excel Startup Switches	464	(1)
Troubleshooting	465	(1)
Secrets of the Office Masters: Managing Add-Ins	466	(3)
Advanced Worksheet Formatting	469	(32)
How Cell Formatting Works	470	(5)
Using the General Number Format	470	(1)
Controlling Automatic Number Formats	470	(2)
Avoiding Rounding Errors	472	(2)
The Limits of Precision	474	(1)
Working with Numbers in Scientific Notation	474	(1)
Entering Numbers As Text	475	(1)
Changing Formatting for a Cell or Range	475	(11)
Setting Number Formats	475	(3)
Setting Date and Time Formats	478	(1)
Excel, the Year 2000, and the Euro Currency Symbol	479	(1)
Creating Custom Cell Formats	480	(6)
Designing and Formatting a Worksheet for Maximum Readability	486	(7)
Changing Fonts and Character Attributes	486	(2)
Aligning, Wrapping, and Rotating Text and Numbers	488	(2)
Using Borders, Boxes, and Colors	490	(1)
Merging Cells	491	(1)
Changing Row Height and Column Width	492	(1)
Using Conditional Formatting to Identify Key Values	493	(1)
Copying Formats with the Format Painter	494	(1)
Saving Formats As Named Styles	495	(2)
Using AutoFormat	497	(1)
Troubleshooting	498	(1)
Secrets of the Office Masters: Redesigning a Worksheet Clarifies the Information	499	(2)
Using Formulas and Functions	501	(32)
Entering and Editing Formulas	502	(6)
Using Cell References in Formulas	502	(1)
Using 3D References to Cells on Other Worksheets	503	(1)
Controlling the Order and Timing of Calculation in Formulas	503	(2)
Absolute Versus Relative Cell References	505	(2)
Preventing Formulas from Displaying in the Formula Bar	507	(1)
Using Array Formulas	507	(1)
Using Range Names and Labels in Formulas	508	(5)
Using Natural Language Formulas	509	(1)
Limitations of Natural Language Formulas	510	(1)
Using Named Ranges in Formulas	511	(1)
Managing Range Names	512	(1)
Manipulating Data with Worksheet Functions	513	(5)
Entering Error-Free Formulas with the Formula Palette	514	(3)
Totaling Rows and Columns Automatically	517	(1)
Putting Worksheet Functions to Use	518	(9)
Calculating Financial formulas	518	(1)
Working with Date and Time Functions	519	(1)
Performing Statistical Analyses	520	(1)
Using the Lookup Wizard to Find Infromation in Lists	521	(2)
Using Database Functions	523	(1)
Performing Mathematical Operations	524	(1)
Combining and Separating Text Values	525	(1)
Using Logical and Information Functions	526	(1)
Using Goal Seek to Find Values	527	(2)
Troubleshooting Formulas	529	(2)
How Formula AutoCorrect Works	529	(1)
Understanding Common Error Messages	529	(1)
Using the Range Finder to Locate Parts of a Formula	530	(1)
Troubleshooting	531	(1)
Secrets of the Office Masters: Nesting Functions Within Functions	532	(1)
Creating and Editing Charts	533	(26)
Anatomy of an Excel Chart	534	(5)
Data Series	535	(1)
Data Markers	536	(1)
Axes and Gridlines	537	(1)
Data Labels, Legends, and Titles	537	(1)
Plot Area	537	(1)
Chart Area	538	(1)
Working with Embedded Charts	538	(1)
Using the Chart Wizard for Quick Results	539	(1)
Selecting Data to Plot	540	(2)
Selecting and Customizing a Chart Type	542	(7)
Choosing a Standard Chart Type	542	(3)
Using Combination Charts	545	(2)
Creating and Saving Custom Chart Types	547	(2)
Creating a Default Chart	549	(1)
Editing and Formatting Chart Elements	549	(8)
Adjusting Chart Options	550	(3)
Changing Number Formats	553	(1)
Changing Text Formats	553	(31)
Adding Background Colors, Textures, and Pictures	554	(1)
Changing the Scale and Spacing of Axes	554	(1)
Changing the Data Source for an Existing Chart	555	(1)
Advanced Chart Options	556	(1)
Troubleshooting	557	(1)
Secrets of the Office Masters: Creating a Custom Chart Library	557	(2)
Working with Lists and Databases	559	(32)
Creating a List on a Worksheet	560	(1)
Speeding Up Repetitive Data Entry with AutoComplete	561	(1)
Automatically Filling In a Series of Data	562	(4)
Creating Custom AutoFill Lists to Fit Your Projects	565	(1)
Sorting Lists	566	(2)
Sorting by Multiple Fields	566	(1)
Sorting by Dates or Custom Series	567	(1)
Finding and Filtering Data in a List	568	(8)
Using AutoFilter to Find Sets of Data	569	(2)
Using Comparison Criteria to Create Custom Filters	571	(1)
Filtering with Advanced Criteria	572	(4)
Summarizing, Grouping, Outlining, and Subtotaling Lists	576	(3)
Grouping and Outlining List Details	578	(1)
Removing Subtotals	579	(1)
Using Forms to Add and Edit List Data	579	(2)
Importing and Exporting Data	581	(2)
Creating Links to External Databases	583	(5)
Using the Query Wizard	584	(1)
Integrating External Data into a Worksheet	585	(1)
Using Microsoft Query to Create Custom Queries	586	(2)
Creatining and Using Web Queries	588	(1)
Troubleshooting	589	(1)
Secrets of the Office Masters: Smart Lists	590	(1)
Using Excel in a Workgroup	591	(22)
Protecting a Worksheet	592	(3)
Using Passwords to Restrict Access to a Workbook	592	(1)
Prventing Changes to a Worksheet	593	(2)
Protecting the Structure of a Workbook	595	(1)
Sharing a Workbook	595	(9)
Setting Up a Worksheet for Shared Use	596	(1)
Disabling Workbook Sharing	597	(1)
Tracking Workbook Revisions in a Workgroup	598	(1)
Viewing Changes to a Shared Workbook	599	(3)
Resolving Conflicts in Shared Workbooks	602	(1)
Incorporating Changes into a Workbook	603	(1)
Protecting a Shared Workbook	604	(1)
Storing Multiple Scenarios in a Single Workbook	604	(4)
Consolidating Data from Multiple Users into a Single Workbook	608	(2)
Creating Custom Views of Worksheet Data	610	(1)
Troubleshooting	611	(1)
Secrets of the Office Masters: Managing Scenarios	612	(1)
Using PivotTables and PivotCharts	613	(20)
How PivotTable and PivotChart Reports Work	614	(4)
When Should You Use a PivotTable?	618	(1)
Creating a PivotTable	619	(2)
Editing and Updating a PivotTable	621	(6)
Changing Sort Order and Other Display Options	622	(1)
Adding and Removing Column and Row Subtotals	623	(1)
Switching Between Table and Outline Layouts	624	(1)
Removing Blank Cells and Error Messages	625	(1)
Refreshing Data in a PivotTable	626	(1)
Creating and Editing PivotCharts	627	(2)
Formatting and printing PivotTables	629	(1)
Troubleshooting	630	(1)
Secrets of the Office Masters: Grouping Items in a PivotTable	630	(3)
Error-Proof Data-Entry Techniques	633	(18)
Restricting and Validating Data Entry for a Cell or Range	634	(4)
Defining Data Validation Rules	634	(1)
Displaying Helpful Input Messages	635	(1)
Alerting the User to Errors	636	(1)
Deleting, Moving, or Copying Data Validation Rules	637	(1)
Creating and Using Data-Entry Forms	638	(7)
Adding Controls to a Form	639	(3)
Using Forms to Fill an External Database	642	(2)
Saving a Form As a Template	644	(1)
Troubleshooting Data Errors	645	(1)
Troubleshooting	645	(1)
Secrets of the Office Masters: Creating an Online Form	646	(5)
V Using Outlook
Outlook Essentials	651	(42)
Choosing an Outlook Configuration	652	(2)
Upgrading over a Previous Version of Outlook	652	(1)
Internet Mail Only	653	(1)
Corporate/Workgroup	654	(1)
No Email	654	(1)
Changing Modes On-the-Fly	654	(1)
How Outlook Stores Your Data	654	(3)
Personal Folders Files	655	(1)
Offline Store Files	656	(1)
Mailbox Folders on an Exchange Server	657	(1)
Using and Customizing the Outlook Interface	657	(4)
Customizing the Outlook Today Page	659	(1)
Customizing the Outlook Bar	660	(1)
Customizing the Folder List	661	(1)
Creating, Editing, and Managing Outlook Items	661	(13)
Creating a New Item	662	(2)
Moving, Copying, and Deleting Intems	664	(2)
Entering Dates and Times Automatically	666	(1)
Assigning Items to Categories	667	(2)
Creating Reminders and Flagging Items for Follow-Up	669	(4)
Exchanging Items via Email	673	(1)
Viewing Personal Information in Outlook	674	(9)
Using Views to Display, Sort, and Filter Items	674	(1)
Customizing an Existing View	674	(6)
Creating a New Custom View	680	(1)
Managing Custom Views	681	(1)
Opening a Folder in a Separate Window	682	(1)
Using the Clipboard with Outlook	682	(1)
Managing Files and Folders in Outlook	683	(1)
Finding Outlook Items	684	(6)
Finding Contact Information Fast	684	(1)
Using the Find Pane for Simple Searches	685	(2)
Advanced Search Techniques	687	(3)
Saving and Reusing Outlook Searches	690	(1)
Troubleshooting	690	(1)
Secrets of the Office Masters: Building a Library of Saved Searches	691	(2)
Expert Email Management	693	(40)
Setting Up Internet Email Accounts	694	(7)
User Information	696	(1)
Server Names and Logon Information	696	(1)
Connection Options	697	(3)
Advanced Options	700	(1)
Setting a Default Email Account	700	(1)
Choosing a Message Format	701	(3)
Forcing Outlook to Use Plain Text Format	702	(1)
Advanced Message Format Options	703	(1)
Using Word As an Email Editor	704	(2)
Creating, Managing, and Using Email Addresses	706	(8)
Locating Your Outlook Addresses	706	(1)
Configuring the Outlook Address Book	707	(4)
Addressing an Email Message	711	(2)
Creating and Using Personal Distribution Lists	713	(1)
Creating and Sending Messages	714	(6)
Using Signatures	714	(2)
Using Stationery and Fonts in Formatted Messages	716	(1)
Setting Message Options	717	(2)
Setting Reply and Forward Options	719	(1)
Checking Your Mail and Reading New Messages	720	(2)
Checking Messages Automatically	720	(1)
Checking for Messages Manually	720	(1)
Setting Notifications	721	(1)
Speed-Reading New Messages with the Preview Pane	721	(1)
Organizing Your Email	722	(8)
Using the Rules Wizard to Sort and Process Mail	724	(5)
Using Outlook's Junk Mail Filters	729	(1)
Troubleshooting	730	(2)
Secrets of the Office Masters: Tasteful Stationery	732	(1)
Using Calendar	733	(16)
Managing Your Personal Calendar	734	(5)
Creating a New Appointment or Event	735	(3)
Entering a Recurring Appointment	738	(1)
Rescheduling an Appointment or Event	739	(1)
Viewing a Daily, Weekly, or Monthly Calendar	739	(6)
Using the Date Navigator	739	(1)
Switching Between Day, Week, and Month Views	740	(2)
Customizing the Calendar Display	742	(1)
Customizing Other Calendar Options	743	(2)
Printing a Calendar	745	(3)
Troubleshooting	748	(1)
Secrets of the Office Masters: Space-Saving Pocket Calendar	748	(1)
Managing a Contacts List	749	(22)
Managing Your List of Contacts	750	(1)
Creating a New Contact Item	750	(7)
Entering Names	752	(1)
Entering Addresses	753	(1)
Entering Job and Company Details	754	(1)
Entering Phone, Fax, and Other Numbers	754	(1)
Entering Email and Web Addresses	755	(1)
Entering Personal Information	755	(1)
Entering Other Details	756	(1)
Changing the Way a Contact Item Is Filed	756	(1)
Entering Several New Contact Items at Once	757	(1)
Editing One or More Contact Records	757	(1)
Merging Duplicate Contact Items	758	(2)
Mapping a Contact's Address	760	(1)
Tracking Activities for Each Contact	761	(2)
Addressing Letters and Envelopes Using Your Contacts List	763	(3)
Printing Phone Lists from Your Contacts List	766	(2)
Troubleshooting	768	(1)
Secrets of the Office Masters: Create a Contacts Folder for Web-Based Businesses	769	(2)
Sharing Schedules and Planning Meetings	771	(12)
Planning a Meeting with Outlook	772	(5)
Creating a New Meeting Request	772	(2)
Using Shared Schedules to Choose a Meeting Time	774	(2)
Checking the Status of a Meeting You've Arranged	776	(1)
Rescheduling or Canceling a Meeting	776	(1)
Responding to Meeting Requests	777	(1)
Publishing Your Schedule Information	778	(2)
Troubleshooting	780	(1)
Secrets of the Office Masters: Publishing a Calendar As a Web Page	781	(2)
Tracking Tasks and Taking Notes	783	(12)
Maintaining a Personal Task List	784	(5)
Entering Tasks	784	(1)
Entering Recurring Tasks	785	(1)
Sorting and Filtering the Task List	786	(1)
Assigning Tasks to Other People	787	(1)
Creating a Task Request	787	(1)
Responding to a Task Assignment	788	(1)
Managing a List of Assigned Tasks	789	(1)
Using the Journal to Track Activities	789	(2)
Creating and Editing Notes	791	(2)
Troubleshooting	793	(2)
Administering Outlook	795	(20)
Integrating Outlook with Exchange Server	796	(1)
Using Net Folders to Share Information	797	(2)
Managing Outlook Data Files	799	(5)
Managing Email Messages Manually	800	(1)
Deleting and Archiving Outlook Information Automatically	801	(2)
Recovering Free Space in Outlook Data Files	803	(1)
Importing and Exporting Outlook Information	804	(4)
Importing Data from External Programs	805	(3)
Exporting Outlook Data	808	(1)
Controlling Outlook with Startup Switches	808	(3)
Specifying a Startup Folder	809	(1)
Creating New Outlook Items	810	(1)
Performing Administrative Tasks	810	(1)
Troubleshooting	811	(1)
Secrets of the Office Masters: Sharing a Task List	811	(4)
VI Using Publisher
Publisher for Office Experts	815	(24)
What Does Publisher Do Best?	816	(1)
Key Components of Publisher	817	(2)
Word Versus Publisher	817	(1)
Publisher's Wizards	818	(1)
Color Print Separations	819	(1)
Designing Pages	819	(2)
Inserting and Manipulating Objects	821	(1)
Working with Graphic Objects	822	(3)
Cropping Images	823	(1)
Wrapping Text to a Frame	824	(1)
Fine-Tuning Text Wrapping	824	(1)
Editing Fills	825	(7)
Assigning Color Files	826	(1)
Mixing Up Colors in the Color Palette	827	(1)
Coordinating Colors with Color Schems	828	(2)
Tints, Patterns, and Gradients	830	(2)
Recoloring Pictures	832	(1)
Creating Borders and Shadows	833	(3)
Troubleshooting	836	(1)
Secrets of the Office Masters: Combining Rotated and Layered Objects	837	(2)
Creating and Managing Complex Publications	839	(36)
Synchronizing and Unsynchronizing Text Frames	840	(1)
Using Smart Objects	841	(1)
Updating Personal Information	842	(1)
Defining Personal Information	842	(1)
Inserting Personal Information	843	(1)
Defining Custom Logos	843	(2)
Using Templates	845	(1)
Creating a Template	845	(1)
Starting a Publication with a Template	846	(1)
Using Custom Objects from the Design Gallery	846	(1)
Defining Units of Measurement	847	(1)
Flowing Text Files Between Frames	847	(2)
Flowing Text	847	(1)
Managing Text in Many Frames	848	(1)
Using Advanced Printing Features	849	(5)
Printing Folded Publications	849	(3)
Including Printed Background Elements	852	(2)
Solving Complex Printer Challenges	854	(2)
Tiling Pages for Posters and Banners	854	(1)
Duplex Printing	855	(1)
Working with Commercial Printers	856	(13)
Spot-Color Printing	857	(2)
Process-Color Separations	859	(2)
Advanced Commercial Printing Options	861	(4)
Color Trapping	865	(3)
Printing to PostScript Files	868	(1)
Troubleshooting	869	(1)
Secrets of the Office Masters: Adding Graphics Files to the Design Gallery	870	(1)
Secrets of the Office Masters: Low-Cost Color: Adding a Single Spot Color	870	(5)
VII Automating Office with Macros and VBA
Using Macros to Automate Office Tasks	875	(20)
How Macros Work	876	(4)
What Can You Do with Macros?	876	(1)
What Shouldn't You Do with Macros?	877	(1)
How Office Applications Store Macros	878	(1)
Using Object Models	879	(1)
Recording Simple Macros	880	(3)
How the Macro Recorder Captures Actions	880	(1)
Recording a Macro	881	(1)
Testing the Macro	882	(1)
Troubleshooting Recorded Macros	883	(4)
Stepping Through and Editing Recorded Macros	883	(2)
Common Recorded Macro Mistakes	885	(1)
Testing and Bullet-Proofing Macros	886	(1)
Running Macros	887	(1)
Macro Security	887	(6)
Using Digital Signatures to Verify a Macro's Source	888	(1)
Configuring Office Security Levels	889	(3)
Protecting Your PC and Network from Viruses	892	(1)
Secrets of the Office Masters: Getting Ready to Tackle VBA	893	(2)
Working with Visual Basic for Applications	895	(20)
VBA Basics	896	(4)
Projects	898	(1)
Modules	898	(1)
Procedures: Subroutines and Functions	899	(1)
Macros	900	(1)
UserForms	900	(1)
Managing Macros	900	(2)
Using the VBA Editor	902	(6)
Managing VBA Components with Project Explorer	903	(3)
Programming in the Code Window	906	(2)
Building Interactive VBA Programs	908	(3)
Controlling an Office Appllication from VBA	911	(1)
Secrets of the Office Masters: Elements of Programming Style for the Nonprogrammer	912	(3)
Building Custom Applications with VBA	915	(28)
Controlling How VBA Applications Start	916	(11)
``How'' Linking to Macros	916	(6)
Using Auto Macros	922	(3)
Creating Toolbar Buttons, Menus, and Key Combinations	925	(1)
Substituting for Built-In Commands	926	(1)
Opening, Closing, and Creating New Documents	927	(3)
Using VBA to Open, Close, and Create Word Documents	927	(2)
Using VBA to Open, Close, and Create Excel Workbooks	929	(1)
Using VBA to Create a New Outlook Email Message or Contact	929	(1)
Using VBA to Create a New FrontPage Web File	929	(1)
Using VBA to Open, Close, and Create PowerPoint Presentations	929	(1)
Using VBA to Open, Close, and Create Access Files	930	(1)
Using VBA to Add Text	930	(2)
Adding Text to a Word Document with VBA	930	(1)
Adding Text to an Excel Workbook with VBA	931	(1)
Adding Text to an Outlook Email Message with VBA	931	(1)
Adding Text to a PowerPoint Presentation with VBA	931	(1)
Displaying Messages	932	(3)
Displaying Messages in Word with VBA	932	(2)
Displaying Messages in Excel with VBA	934	(1)
Displaying Office-Standard Dialog Boxes	935	(1)
Using Built-In Excel Dialog Boxes with VBA	935	(1)
Using Built-In Word Dialog Boxes with VBA	936	(1)
Creating Custom Dialog Boxes	936	(4)
Troubleshooting	940	(1)
Secrets of the Office Masters: Custom Dialog Boxes in VBA	940	(3)
Advanced VBA Tools and Techniques	943	(26)
Managing VBA Projects	944	(8)
Storing Projects	944	(2)
Locking VBA Projects	946	(2)
Code Signing	948	(1)
Varible Naming Conventions	949	(1)
Calling Procedures in Other Projects	950	(1)
Rejuvenating VBA	951	(1)
Code Snippets You Can Use	952	(7)
Using VBA to Navigate Office Documents	952	(1)
Use VBA to Augment Find and Replace	953	(2)
Using VBA to Apply Formatting	955	(1)
Using VBA to Loop Through Collections	956	(2)
Using VBA to Sort an Array	958	(1)
Controlling Other Applications	959	(3)
Starting Excel with a VBA/Word Macro	960	(1)
Starting Word with a VBA/Excel Macro	960	(1)
Starting PowerPoint with a VBA/Word Macro	960	(1)
Commonalities in Controlling One Application with Another	961	(1)
Using the Object Browser	962	(1)
Secrets of the Office Masters: Stuck on a Line of VBA Code?	963	(6)
VIII Using the Small Business Tools
Using Microsoft Small Business Tools	969	(48)
Who Should Use the Small Business Tools?	970	(1)
Tracking Contact Information with Small Business Customer Manager	971	(6)
Setting Up a Customer Manager Database	973	(1)
Updating Customer Information	974	(1)
Filtering a Contacts List	975	(1)
Sending Letters, Faxes, and Emails, and Other Actions	975	(1)
Tracking Activities	976	(1)
Preparing Direct Mail Campaigns	977	(7)
Preparing a Mailing List	979	(2)
Printing Your Mailing	981	(1)
Assembling a Mailing and Delivering It to the Post Office	982	(1)
Using a Mailing Service	983	(1)
Using Small Business Financial Manager	984	(4)
Using Microsoft Business Planner	988	(1)
Troubleshooting	989	(1)
Secrets of the Office Masters: Publishing Customer Information to the Web	989	(4)
XI Appendixes
A Advanced Setup Options	993	(18)
Using the Windows Installer	994	(2)
Performing a Custom Installation	996	(1)
Selecting an Installation Location	996	(1)
Saving Your Previous Office Version	997	(2)
Controlling Browser Options	999	(1)
Selecting and Configuring Office Features	1000	(2)
Fixing Setup Problems	1002	(1)
Using Setup in Maintenance Mode	1002	(1)
Repairing an Office Installation	1003	(1)
Adding and Removing Office Features	1004	(1)
Uninstalling Office 2000	1004	(1)
Installing Office from a Network	1005	(1)
Creating a Network Installation Point	1005	(1)
Running Setup from the Network	1006	(1)
Using the Custom Installation Wizard	1007	(2)
Backing Up User Settings with the Office Profile Wizard	1009	(1)
Adding Support for Other Languages	1009	(1)
Troubleshooting	1010	(1)
B What's on Que's Special Edition WOPR 2000 Pack CD	1011	(6)
WOPR 2000---Woody's Office Power Pack 2000	1012	(1)
What Does WOPR 2000 Do?	1012	(1)
Installing WOPR 2000	1013	(1)
Adding Components	1013	(1)
Uninstalling	1013	(1)
Updating WOPR 2000 to the Latest Version	1014	(1)
Tech Support	1014	(1)
Complete Electronic Copy of Special Edition Using Microsoft Office 2000	1015	(1)
Extensive Additional Electronic Book Chapters on Office 2000 Programs	1015	(1)
Third-Party Software	1015	(2)
Que's Special Edition WOPR 2000 Pack Installation	1017	(1)
Windows 95/98 Installation Instructions	1017	(1)
Windows NT 4.0 Installation Instructions	1017