Using Microsoft Word and Excel in Office 2000
Home > Computing and Information Technology > Business applications > Spreadsheet software > Using Microsoft Word and Excel in Office 2000: (Special Editions)
Using Microsoft Word and Excel in Office 2000: (Special Editions)

Using Microsoft Word and Excel in Office 2000: (Special Editions)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Table of Contents:
Introduction. I. BUILDING SLICKER DOCUMENTS FASTER. 1. Templates, Wizards, and Add-Ins. Selecting a Template for a New Document. Using Words Built-In Template Library. The Normal Template: Crucial to All Documents. Creating a New Template. Understanding the Relationship Between Styles and Templates. Understanding Global Templates. Attaching a New Template to an Existing Document. Using Themes to Change the Styles in Your Template. Previewing New Templates with Style Gallery. Moving Elements Among Templates. Managing Templates to Minimize Your Work. Using Workgroup Templates. Using Word Wizards. Understanding Word Add-Ins. Troubleshooting. 2. Streamlining Your Formatting with Styles. Why Styles Are So Valuable. What Styles Are and How They Work. Understanding Words Default Styles. Applying an Existing Style. Creating and Changing Styles. Changing Styles. Managing Styles. Troubleshooting. 3. Making the Most of Words Proofing Tools. Using Automatic Spelling and Grammar Checking. Disabling or Hiding Automatic Spelling and Grammar Checking. Checking Spelling Through the Spelling and Grammar Dialog Box. Reproofing a Document Youve Already Checked. Controlling Spelling Settings. Custom Dictionaries for Custom Needs. A Closer Look at the Grammar Checker. Using the Word Thesaurus. Counting a Documents Words, Pages, Lines, and Characters. Displaying Readability Statistics. Troubleshooting. 4. Automating Your Documents: AutoCorrect, AutoFormat, AutoText, and AutoSummarize. AutoCorrect: Smarter than Ever. AutoText: The Complete Boilerplate Resource. AutoFormatting: The Fastest Way to Format. Working with AutoSummarize. Troubleshooting. 5. Tables: Organizing Your Pages. Tables: Words All-Purpose Solution for Structuring Information. Words Multiple Approaches to Creating a Table. Creating Side-by-Side Tables. Creating Nested Tables. Editing in a Table. Changing a Tables Structure or Formatting. Formatting Within a Table. Adding Table Borders and Shading. Controlling Table Breaks and Table Headers. Working with Table Properties. Converting Text to Tables. Converting Tables to Text. Calculating with Tables. Quick and Easy Sorting. Troubleshooting. II. INDUSTRIAL STRENGTH DOCUMENT PRODUCTION TECHNIQUES. 6. Using Mail Merge Effectively An Overview of Words Mail Merge. Using the Mail Merge Helper. Creating a Main Document. Creating and Using Data Sources. Opening an Existing Word Data Source. Using an Outlook Address Book as a Data Source. Using an Access Database as a Data Source. Creating a Separate Header Source. Specifying Fields to Merge into Your Main Document. Preparing to Merge. Printing Accompanying Envelopes and Labels. Troubleshooting. 7. Outlining: The Best Way to Organize a Document. The Benefits of Outlining. The Role of Heading Styles in Outlining. Creating a New Outline. Understanding Outline View. Controlling Your Outline View. Hiding Character Formatting. Expanding/Collapsing Headings. Navigating an Outline Document with Document Map and Browse Object. Applying Outline Levels to Specific Text. Printing Your Outline. Using Words Automatic Outline Numbering. Troubleshooting. 8. Master Documents: Control and Share Even the Largest Documents. The Advantages of Master Documents. Choosing How to Create a New Master Document. Creating a New Master Document and Subdocuments. Taking a Closer Look at Subdocuments. Transforming an Existing Document into a Master Document. Adding an Existing Document to a Master Document. Saving a Master Document. Saving Master Documents as Web Pages. Opening a Master Document. Editing a Subdocument from Within the Master Document. Editing Subdocuments Outside the Master Document. Style Behavior in Master Documents and Subdocuments. Reorganizing a Master Document. Removing a Subdocument. Creating a Table of Contents, Index, or Cross-References for a Master Document. Printing Master Documents and Subdocuments. Working with Others on the Same Master Document. Inserting Files Rather than Using Master Documents. Using Insert File to Insert Part of a Document. Troubleshooting. 9. Tables of Contents, Figures, Authorities, and Captioning. Tables of Contents. Introducing Tables of Figures and Captions. Introducing Citations. Troubleshooting. 10. Building More Effective Indexes. How Word Indexes Work. Creating a New Index Entry. Compiling Your Index. Building Indexes from Multiple Documents. Automating Indexing with Index AutoMark Files. Placing More Than One Index in a Document. Troubleshooting. 11. Footnotes, Bookmarks, and Cross-References. Using Footnotes and Endnotes. Using Bookmarks. Working with Cross-References. Troubleshooting. III. THE VISUAL WORD: MAKING DOCUMENTS AND WEB PAGES LOOK GREAT. 12. Getting Images into Your Documents. Opportunities to Use Graphics Effectively. Managing Clip Art Through Clip Gallery 5.0. Inserting Pictures Directly, Without Clip Gallery. Editing Clip Art to Serve Your Needs. Minimizing Graphics File Size. Adding Alternative Text to Your Image. Introducing WordArt. Troubleshooting. 13. Drawing in Word. When to Use Words Drawing Tools-And When Not To. Using Word 2000s Drawing Toolbar. Understanding How Word Drawings Work. Drawing Lines and Other Basic Shapes. AutoShapes: Words Library of Predrawn Shapes. Controlling Colors. Adding Depth to Your Graphics. Editing Objects in a Word Drawing. Troubleshooting. 14. Word Desktop Publishing. Word 2000: Almost a Full-Fledged Desktop Publishing Program. When to Use Word-And When Not To. Planning Your Document. Quick and Easy Brochures with the Brochure Template. Working with Multiple Columns. Using Drop Caps. Inserting Symbols and Special Characters. Working with Special Characters. Using Text Boxes. Linking Text Boxes. Troubleshooting. 15. Using Graphs to Make Sense of Your Data-Visually. Understanding Graphs and Charts. A High-Level Look at Charting in Word. Creating Data to Be Graphed. Tips for Selecting Which Data to Include. Making Yourself at Home in Microsoft Graph. Choosing Among Words Extensive Selection of Charts. Working with Chart Options. Formatting Chart Elements. Creating a Custom Chart Type. Creating a Chart from Scratch. Using Trendlines. Using Error Bars. Revising Charts Automatically. Troubleshooting. IV. THE CORPORATE WORD. 16. Managing Revisions An Overview of Words Team Writing Tools. Working with Comments. Working with Track Changes. Merging Revisions. Resolving Proposed Changes. Using Words Versioning Feature. Streamlining the Review Process with Microsoft Outlook. Assigning a Review Task to Someone Else. Troubleshooting. 17. Creating Forms. Words Forms Capabilities: An Overview. When to Use Word, When to Use Another Tool. Applications for Words Forms Feature. Building the Skeleton of Your Form. Adding Interactivity with Form Fields. Advanced Form Field Features. Setting Tab Order for Your Form Fields. Converting Electronic Forms to Printed Forms. Working with Prompting Forms. Protecting an Entire Form. Filling in Online Forms. Saving Only the Data in a Form. Printing Only the Data in Forms. Troubleshooting. 18. Automating Your Documents with Field Codes. Understanding Fields. Fields That Might Already Be in Your Document. Viewing Fields. Inserting a Field Using the Field Dialog Box. Inserting a Field Using Field Characters. Updating Your Fields. Locking Fields to Prevent Them from Updating. Shortcuts for Working with Fields. Finding and Replacing Field Contents. Moving Among Fields. A Closer Look at Field Instructions. A Closer Look at Field Formatting. Nesting Fields. Troubleshooting. V. FORMATTING AND PRINTING EXCEL WORKSHEETS. 19. Formatting Worksheets Why Change the Formatting? Using the Formatting Toolbar. Using the Format Cells Dialog Box. Changing the Font, Point Size, and Font Styles. Working with Styles. Keeping Worksheets Legible. Applying Borders and Shading. Copying Formats with the Format Painter. Using AutoFormat to Enhance Your Worksheets. Troubleshooting. 20. Modifying Numbers and Dates. Applying Common Numeric Formats from the Toolbar. Applying Built-In Formats. Creating Custom Formats. Conditional Formatting. Troubleshooting. 21. Using Excels Drawing Tools. Introducing the Drawing Toolbar. Creating Drawn Shapes and Lines. Working with AutoShapes. Ordering, Grouping, Moving, and Resizing Drawn Objects. Formatting Drawn Objects. Creating Text Boxes. Using WordArt to Create Artistic Text. Inserting Clip Art Images Troubleshooting. 22. Professional Formatting Techniques. Combining Excels Tools for Innovative Formatting. Combining Drawing Tools with Charts and Worksheets. Professional Tables. Creating Visual Effects and Professional Pointing Devices. Troubleshooting. 23. Printing Excel Worksheets. Printing a Worksheet. Previewing the Print Job. Using Page Break Preview. Working with Page Setup Options. Troubleshooting. VI. USING FORMULAS AND FUNCTIONS. 24. Constructing Excel Formulas. Understanding Basic Formula Concepts. Using AutoSum to Total Columns and Rows of Data. Editing Formulas. Writing Multiple Copies of a Formula. Using AutoCalculate for Quick Totals. Understanding Formula Construction. Using Relative, Absolute, and Mixed Cell References in Formulas. Referencing Values in Other Worksheets and Workbooks. Troubleshooting. 25. Using Excels Built-In Functions. Understanding Functions. Building Functions with the Paste Function Dialog Box. Working with Excels Most Useful Functions. Converting Formula Results to Values. Troubleshooting. 26. Working with Named Ranges. Managing Named Ranges. Using Range Names in Formulas. Pasting a List of Named Ranges. Using Range Names to Speed Formatting. Troubleshooting. VII. CREATING AND MODIFYING CHARTS. 27. Building Charts with Excel. An Overview of Excel Charts. Creating Charts with the Chart Wizard. Excel Chart Types. Printing Charts. Troubleshooting. 28. Modifying Excel Charts. Options for Improving Your Charts. Changing the Chart Type. Changing a Data Series. Adding a Secondary Axis to the Chart. Value Axis Scaling. Category Axis Scaling. Changing the Series Order. Adding a Trendline to a Data Series. Troubleshooting. 29. Formatting Charts. An Overview of Formatting Charts. Formatting Lines: Axes, Tick Marks, High/Low Lines, and Error Bars. Formatting Text: Data Labels, Titles, Legends, and Text Boxes. Enhancing Charts with Drawing Objects. Formatting Data Series. Changing the Border, Color, or Fill of a Chart Item. Formatting 3D Charts. Troubleshooting. 30. Professional Charting Techniques. Formatting Charts for a Professional Look. Creating Column Depth. Pie Chart Techniques. Using Fill Effects to Show Variance in 3D Charts. Using Form Controls with Charts. Stacking Multiple Charts. Creating Cost and Production Curves with Charts for Variance. Linking Chart Text to Worksheet Cells. Charting Hidden Data. Creating Effective Multiple-Combination Charts. Troubleshooting. VIII. ANALYZING AND MANAGING YOUR DATA. 31. Setting Up a List or Database in Excel. Using Excel As a Database Program. Building an Effective List. Working with the Data Form. Viewing and Printing the List. 32. Using Excels Data-Management Features. Data Management in Excel. Using Conditional Formatting with Lists. Sorting a List. Filtering a List. Protecting Your Data. Troubleshooting. 33. Outlining, Subtotaling, and Auditing Worksheet Data. Organizing and Auditing Your Data. Grouping and Outlining Data. Consolidating Data. Creating Automatic Subtotals. Validating and Auditing Data Entry. Troubleshooting. 34. Using PivotTables and PivotCharts. Understanding PivotTables. Using the PivotTable and PivotChart Wizard. Laying Out the PivotTable. Setting PivotTable Options. Creating PivotCharts. Modifying PivotTables and PivotCharts. Working with Dates in PivotTables. Creating a PivotTable from Multiple Ranges. Managing Employee Hours and Costs with PivotTables. Analyzing Costs with PivotCharts. Saving and Editing PivotTables in HTML Format. Troubleshooting. 35. Managing Data with Formulas and Form Controls. Combining Excel Features to Manage Your Data. Extracting Date-Based Totals from Lists. Using the Conditional Sum Wizard and Lookup Wizard. Using Functions with Tables. Adding Form Controls to Your Worksheets. Troubleshooting. 36. Using Excels Analysis Tools. Using Excel to Analyze Your Data. Using Goal Seek. Using Solver. Creating Amortization Tables to Calculate Mortgage Payments. Using the Analysis ToolPak Add-In. IX. INTEGRATION. 37. Integrating with Microsoft Office. Word and Office: More Tightly Integrated Than Ever. Integrating Excel and Word. Working with Access and Word. Using PowerPoint with Word. Integrating with Microsoft Publisher 2000. Using Outlook with Word. Using Binders to Combine Multiple Documents. Using the Microsoft Office Shortcut Bar. Using Microsoft Photo Editor 3.01. Using Microsoft Organization Chart 2.0. Using Equation Editor 3.0. Troubleshooting. 38. Using Excel with Word and PowerPoint. Using Excel with Other Microsoft Office Programs. Copying Excel Data to a Word Document. Copying Excel Data to a PowerPoint Presentation. Copying Word and PowerPoint Data to an Excel Worksheet. Combining Word, Excel, and PowerPoint Files with Hyperlinks. Troubleshooting. Fixing Invalid Hyperlinks. X. WEB PUBLISHING AND DOCUMENT CREATION. 39. Using Word to Develop Web Content. Web Page Development: Words Strengths and Weaknesses. Creating a Single Web Page in Word. The Web Toolbar. Creating a Web Site with Words Web Page Wizard. Creating Your Own Web Page Templates. Web Publishing in Word 2000. The New Technologies Used in Word 2000 Web Pages. Advanced Web Options. Troubleshooting. 40. Using Excel on the Web. Exploring Excels Web Capabilities. Publishing Your Worksheet As a Web Page. Copying Tabular Web Data to an Excel Worksheet. Collaborating Online with Excel. Sending Your Excel Workbook via Email. Index.

About the Author :
Bill Camarda is the author of Special Edition Using Microsoft Word 97 Best Seller Edition and Special Edition Using Microsoft Office 2000 in addition to several other popular books published by Que and New Riders. He has more than 15 years experience writing about technology for users of all levels of expertise, and for corporate clients such as, IBM, AT&T, MCI, and Bell Atlantic. Laurie Ulrich is a co-author of Ques Special Edition Using Microsoft Word 2000 as well as the author of several other Que books. Laurie teaches computer classes and writes training materials for universities and corporate training centers in the PA, NJ, and NY area. Patrick Blattner has been an Excel professional for the past 8 years and is presently with the Walt Disney Company in southern California where he focuses on scheduling and production issues using Excel. Previously, he spent 15 years defining and solving production and process problems as a consultant.


Best Sellers


Product Details
  • ISBN-13: 9780789719294
  • Publisher: Macmillan Computer Publishing (a Pearson Education company)
  • Publisher Imprint: Que
  • Edition: Special edition
  • Language: English
  • Series Title: Special Editions
  • Width: 189 mm
  • ISBN-10: 0789719290
  • Publisher Date: 01 Jun 1999
  • Binding: Paperback
  • Height: 232 mm
  • Returnable: N
  • Weight: 700 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Using Microsoft Word and Excel in Office 2000: (Special Editions)
Macmillan Computer Publishing (a Pearson Education company) -
Using Microsoft Word and Excel in Office 2000: (Special Editions)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Using Microsoft Word and Excel in Office 2000: (Special Editions)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!