9780789719690

Using Microsoft Office 2000, Small Business Edition.

by ;
  • ISBN13:

    9780789719690

  • ISBN10:

    078971969X

  • Format: Paperback
  • Copyright: 1999-05-01
  • Publisher: Pearson P T R
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $46.65

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

Rewards Program

Reviews for Using Microsoft Office 2000, Small Business Edition. (9780789719690)