You are previewing Microsoft® Office System Plain & Simple -- 2003 Edition.
O'Reilly logo
Microsoft® Office System Plain & Simple -- 2003 Edition

Book Description

Get the fast facts that make learning Microsoft Office 2003 plain and simple! This colorful, no-nonsense guide delivers fast answers for using Microsoft Office Access, Excel, FrontPage®, InfoPath™, OneNote™, Outlook®, PowerPoint®, Publisher, and Word.

Table of Contents

  1. Microsoft® Office System Plain & Simple 2003 Edition
  2. Acknowledgments
  3. 1. About This Book
    1. No Computerese!
      1. Useful Tasks. . .
      2. . . .And the Easiest Way to Do Them
    2. A Quick Overview
    3. What’s New in Office 2003?
    4. A Few Assumptions
    5. A Final Word (or Two)
  4. 2. Office Basics
    1. What’s Where in Office?
      1. Microsoft Office Programs
    2. Creating a New File
      1. Start an Office Program
      2. Save the File
    3. Working with an Existing File
      1. Open a File
    4. Finding a File
      1. Search for a File
    5. Using Menus and Toolbars
      1. Explore the Menus
      2. Use Toolbars
      3. Use Shortcut Menus
    6. Working with Task Panes
      1. View the Task Panes
    7. Using Smart Tags
      1. Manage the Tags
      2. Use the Tags
    8. Formatting Your Text
      1. Change the Font or Font Size
      2. Apply Emphasis
    9. Moving and Copying Content
      1. Cut or Copy Content
      2. Paste the Cut or Copied Content
      3. Copy and Paste Multiple Items
    10. Researching a Subject
      1. Do Some Research
    11. Getting Help
      1. Interrogate Office
      2. Get More Help
    12. Printing
      1. Select a Printer
      2. Preview the Printing
      3. Print a File
    13. Correcting Your Spelling
      1. Correct a Spelling Error
  5. 3. Working in Word
    1. What’s Where in Word?
    2. Editing Text
      1. Select and Modify Text
    3. Formatting Text
      1. Apply a Style
    4. Formatting Your Document
      1. Apply Preset Formatting
      2. Reapply Custom Formatting
    5. Custom-Formatting a Paragraph
      1. Modify a Paragraph
    6. Creating a Bulleted or Numbered List
      1. Create a List
    7. So Many Ways to View It
      1. Normal View
      2. Web Layout View
      3. Print Layout View
      4. Outline View
      5. Reading Layout View
    8. Setting Up the Page
      1. Set Up a Standard Page
      2. Set Up for a Two-Sided Document
      3. Set Up for a Bound Document
    9. Formatting as You Compose
      1. Format Your Text
      2. Set the Automatic Changes
      3. Control the Changes
    10. So Many Ways to Do It
    11. Finding Text
      1. Find Text One Instance at a Time
      2. Find All Instances of Text
      3. Modify the Search
    12. Replacing Text
      1. Replace Text
  6. 4. Creating Different Types of Documents
    1. Using Word’s Templates
      1. Start the Document
      2. Complete the Document
    2. Templates, Styles, Wizards, and Direct Formatting
      1. Templates
      2. Styles
      3. Wizards
      4. Direct Formatting
    3. Creating a Letter
      1. Start the Letter
      2. Complete the Letter
    4. Printing an Envelope
      1. Add the Address
    5. Printing a Mailing Label
      1. Print a Label
    6. Creating Your Own Styles
      1. Create a Style
      2. Modify a Style in a Document
      3. Specify Style Changes
    7. Customizing a Template
      1. Open the Template
      2. Modify the Template
    8. Designing a Template
      1. Create the Design
      2. Customize the Content
    9. Mail Merge: The Power and the Pain
      1. Managing the Data
      2. Setting Conditional Content
      3. It’s More than Letters
      4. The Pain of Mail Merge
    10. Creating a Form Letter
      1. Set Up Your Letter
      2. Specify the Data to Be Merged
    11. Printing a Word Document
      1. Print a Document
  7. 5. Enhancing a Document
    1. Creating a Table
      1. Create a Table
      2. Add to the Table
      3. Delete from the Table
    2. Formatting a Table
      1. Apply Table Formatting
      2. Customize the Formatting
    3. The Anatomy of a Table
    4. Organizing Your Information
      1. Sort a Table
      2. Sort a List
    5. Inserting Frequently Used Information
      1. Store the Information
      2. Insert the Information
      3. Find and Insert an AutoText Entry
      4. Insert Multiple Entries
    6. Organizing with Styles
      1. Create a Heading Hierarchy
      2. Define a Style as a Heading
    7. Numbering Headings
      1. Number the Headings
    8. Numbering Pages and Creating Running Heads
      1. Create a Header
      2. Create a Footer
    9. Creating Chapters
      1. Start a New Chapter
      2. Change the Running Heads
    10. Creating a Table of Contents
      1. Create and Format Your TOC
    11. Creating a Drawing
      1. Draw a Shape
      2. Combine Drawings
    12. Reorganizing a Document
      1. View a Document’s Outline
      2. Move a Paragraph
      3. Move a Section
    13. Positioning a Picture
      1. Set the Text Wrapping
      2. Rotate the Picture
    14. Creating Footnotes
      1. Insert a Footnote
  8. 6. Working in Excel
    1. What’s Where in Excel?
    2. Entering Data
      1. Enter Your Data
    3. Using a Predefined Workbook
      1. Open and Use a Template
    4. Excel’s Eccentricities
    5. Formatting Cells
      1. Format Some Cells
    6. Formatting Numbers
      1. Format Some Numbers
      2. Select a Formatting Style
    7. Adding and Viewing Comments
      1. Create a Comment
      2. Read a Comment
    8. Editing the Data
      1. Replace the Data
      2. Edit the Existing Data
    9. Moving and Copying Data
      1. Move Some Content
      2. Copy or Cut Some Content
      3. Copy Content to Adjacent Cells
    10. Adding and Deleting Columns and Rows
      1. Add a Column
      2. Add a Row
      3. Delete a Column or a Row
      4. Delete the Contents of a Column or a Row
    11. Creating a Series
      1. Create a Series
    12. Hiding Columns and Rows
      1. Hide Columns or Rows
      2. Reveal Hidden Columns or Rows
    13. Formatting a Worksheet
      1. Format a Table
      2. Set the Column Width
      3. Set the Row Height
    14. Organizing Your Worksheets
      1. Name the Worksheets
      2. Change Their Order
      3. Insert a Worksheet
      4. Delete a Worksheet
    15. Setting Up the Page
      1. Set the Dimensions
      2. Set the Header and Footer
      3. Set What’s Printed
    16. Printing a Worksheet
      1. Check the Layout
    17. Reviewing Your Data
      1. Freeze It
      2. View Multiple Workbooks
    18. Working with Multiple Workbooks
      1. Create a Workspace
  9. 7. Analyzing Your Data
    1. Making Lists
      1. Create a List
      2. Use the List
    2. Cell References, Formulas, and Functions
    3. Doing the Arithmetic
      1. Calculate a Value
      2. Calculate the Value of Cells
    4. Summing the Data
      1. Sum the Numbers
    5. Creating a Series of Calculations
      1. Create a Series
      2. Include a Constant
    6. Making Calculations with Functions
      1. Find a Function
      2. Add Your Arguments
    7. Troubleshooting Formulas
      1. Review the Errors
      2. Evaluate a Formula
    8. Sorting Your Data
      1. Specify the Sort
    9. Filtering Your Data
      1. Filter the Data
    10. Creating Worksheet Subtotals
      1. Create Subtotals
    11. Naming Cells and Ranges
      1. Define and Use a Name
    12. Summarizing Data with a PivotTable
      1. Create a PivotTable
      2. Use the PivotTable
    13. Automatically Highlighting Certain Data
      1. Set the Conditional Formatting
    14. Importing Data from a Web Page
      1. Import the Web Data
    15. Importing Data from a Service
      1. Import the Data
  10. 8. Presenting Your Data
    1. Charting Your Data
      1. Choose a Chart
      2. Complete the Chart
    2. Formatting a Chart
      1. Format an Element
      2. Change the Chart Type
    3. Customizing a Chart
      1. Change a Data Series Chart
      2. Add an Axis
    4. Changing the Order of a Series
      1. Change the Order
    5. Adding or Removing Data
      1. Add or Remove Data
    6. Adding a Trendline to a Data Series
      1. Add a Trendline
    7. Adding Error Bars
      1. Add Error Bars to a Series
    8. Working with a 3-D Chart
      1. Modify Your Chart
    9. Moving a Chart
      1. Change the Location
    10. Saving a Custom Chart Design
      1. Save the Design
  11. 9. Communicating Using Outlook
    1. What’s Where in Outlook Mail?
    2. Setting Up an E-Mail Account
      1. Set Up a New Account
    3. Sending E-Mail
      1. Create a Message
      2. Customize and Send Your Message
    4. Receiving and Reading E-Mail
      1. Read Your Messages
    5. Replying to or Forwarding a Message
      1. Answer or Forward a Message
    6. Sending or Receiving a File
      1. Send a File by E-Mail
      2. Receive an Attachment
    7. Using Word for E-Mail Messages
      1. Configure Outlook
    8. Sending a File as E-Mail
      1. Send the Text of a File
    9. Setting the Default Formatting for E-Mail Messages
      1. Format the Message
      2. Add Your Signature
    10. Sending a File as a Fax
      1. Send an Internet Fax
  12. 10. Managing with Outlook
    1. What’s Where in Outlook?
    2. Keeping Track of Your Schedule
      1. Record an Appointment
      2. Schedule a Recurring Appointment
    3. Sharing Calendars
      1. Share Your Calendar
      2. View a Shared Calendar
    4. Creating an Internet Calendar
      1. Set Up an Internet Calendar
    5. Viewing Your Group’s Schedule
      1. Set Up Your Group
    6. Scheduling a Meeting
      1. Set Up a Meeting
      2. Finalize the Meeting
    7. Managing Your Contacts
      1. Create a New Contact
      2. Create a Distribution List
    8. Keeping Track of Your Tasks
      1. Record a Task
      2. Track Your Tasks
    9. Assigning Tasks
      1. Assign a Task to Someone
    10. Taking Notes
      1. Create a Note
    11. Reviewing Your Actions
      1. Set Up Your Record
      2. Create a Journal Entry
    12. Using Public Folders
      1. Create a Folder
  13. 11. Working with a Database
    1. What’s Where in Access?
    2. What Is a Relational Database?
    3. Using an Existing Database
      1. Use a Form
    4. Creating a Database from a Template
      1. Select a Database Template
      2. Customize the Database
    5. Adding a Table to a Database
      1. Create a Table
    6. Modifying a Table
      1. Make Changes to a Table
    7. Adding Data to a Table
      1. Add Data Directly
      2. Add Data by Using a Form
    8. Creating a Form
      1. Create a Form for a Table
      2. Modify a Form
    9. Creating a Report from the Data
      1. Create a Report
      2. Modify a Report
    10. Extracting Information from a Database
      1. Create a Query
      2. Define the Questions
    11. Analyzing Data with a PivotChart
      1. Create a PivotChart
      2. Use the PivotChart
    12. Defining Relationships Among Tables
      1. Define the Relationship
  14. 12. Creating a PowerPoint Presentation
    1. What’s Where in PowerPoint?
    2. Creating a Presentation
      1. Start the Presentation
      2. Add Slides
    3. Using a Predesigned Presentation
      1. Customize the Presentation
    4. Creating a Photo Album
      1. Create an Album
    5. Editing a Presentation
      1. Change the Content of Slides
      2. Change the Order of Slides
    6. Adding Text Animation Effects
      1. Animate the Text
      2. Customize the Animation
    7. Adding Transition Effects
      1. Set the Transitions
    8. Adding Special Content
      1. Add the Content
    9. Adding Notes and Handouts
      1. Create Notes and Handouts
    10. Including a Slide from Another Presentation
      1. Include a Slide
    11. Running a Slide Show Automatically
      1. Narrate and Time Your Presentation
    12. Customizing a Slide Show
      1. Set Up the Show
    13. Running a Slide Show Using a Single Monitor
      1. Give a Presentation
    14. Running a Slide Show Using Dual Monitors
      1. Control the Show
    15. Taking a Slide Show on the Road
      1. Package Your Presentation
  15. 13. Creating a Publication in Publisher
    1. What’s Where in Publisher?
    2. Creating a Publication from Scratch
      1. Set Up Your Publication
    3. Creating a Publication from a Design
      1. Use a Design
    4. Repeating Objects on Every Page
      1. Add the Repeating Objects
    5. Adding Text
      1. Add a Text Box
      2. Add Text
    6. Flowing Text Among Text Boxes
      1. AutoFlow the Text
      2. Manually Flow the Text
    7. Tweaking Your Text
      1. Improve the Look of the Text
    8. Adding a Table
      1. Insert a Table
    9. Adding a Picture
      1. Insert a Picture
    10. Adding a Design Object
      1. Insert a Design Object
    11. Arranging Objects on the Page
      1. Set Up Your Grid
      2. Position an Object at an Exact Location
    12. Stacking and Grouping Objects
      1. Arrange the Objects
    13. Flowing Text Around an Object
      1. Set the Text Wrapping
    14. Double-Checking Your Publication
      1. Check the Design
    15. Sending a Publication as E-Mail
      1. E-Mail Your Publication
    16. Printing Your Publication
      1. The Final Step: Print It!
  16. 14. Creating Web Pages and Web Sites
    1. What’s Where in FrontPage?
    2. Creating a Web Site
      1. Start Creating Your Web Site
      2. Review the Web Site
    3. Editing a Web Page
      1. Change the Properties
      2. Change the Content Directly
    4. Customizing Your Web Site
      1. Modify the Settings
    5. Customizing a Web Page
      1. Make Your Settings
    6. Creating Hyperlinks
      1. Create a Hyperlink
    7. Creating Hotspot Hyperlinks
      1. Create a Hotspot
    8. Adding Pictures
      1. Add a Picture
      2. Create a Photo Gallery
    9. Adding a Page to a Web Site
      1. Add an Existing Page
    10. Adding Web Components
      1. Insert a Web Component
    11. Using Tables for Web-Page Layout
      1. Insert a Layout Table
    12. Creating a SharePoint Web Site
      1. Create a Custom SharePoint Web Site
    13. Creating a Web Page in Word
      1. Convert a Word Document into a Web Page
    14. Creating a Web Page in Excel
      1. Create an Excel Web Page
    15. Creating a Web Page in PowerPoint
      1. Create a PowerPoint Web Page
    16. Creating a Data-Access Page
      1. Create an Access Web Page
    17. Creating a Web Site in Publisher
      1. Create a Web Site
      2. Publish It!
    18. Creating a Calendar Web Page
      1. Publish Your Calendar
    19. Working with HTML Code
      1. Review the Tags
    20. Double-Checking Your Web Site
      1. Check the Site
      2. Review the Structure
    21. Publishing Your Web Site
      1. Publish Your Files
  17. 15. Using Forms with InfoPath
    1. What’s Where in InfoPath?
    2. Filling Out a Form
      1. Enter the Information
      2. Review and Save the Form
    3. Creating a Form
      1. Start a Form
      2. Modify the Form
    4. Using InfoPath Data
      1. Merge Data from Different Forms
      2. Review the Data in Excel
    5. What Is XML?
      1. Fear Not the Schema
      2. XML and InfoPath
      3. Putting XML to Work
  18. 16. Taking Notes with OneNote
    1. What’s Where in OneNote?
    2. Typing a Note
      1. Create a Note
    3. Using a Side Note
      1. Use the Side Notes Window
    4. Drawing a Note
      1. Draw a Note
    5. Recording a Note
      1. Record a Note
      2. Play Back Your Note
    6. Formatting a Note
      1. Format Your Note
    7. Classifying Your Notes
      1. Flag Your Notes
    8. Transferring Information
      1. Drag Your Material to Another Location
    9. Distributing Notes
      1. E-Mail Your Notes
  19. 17. Exchanging Information Among Programs
    1. Inserting Excel Data into a Document, Publication, or Presentation
      1. Copy the Data
      2. Edit the Data
    2. Inserting an Excel Chart into a Document, Publication, or Presentation
      1. Insert a Chart
    3. Analyzing a Word Table in Excel
      1. Analyze a Table
    4. Using Word to Prepare PowerPoint Text
      1. Create the Presentation
    5. Inserting a PowerPoint Slide Show into a Document, Worksheet, or Publication
      1. Insert the Presentation
    6. Using Publisher to Present a Word Document
      1. Publish Your Document
    7. Using Word to Prepare Publisher Text
      1. Create Your Story
    8. Using Word to Present Access Data
      1. Publish Your Data
    9. Analyzing Access Data in Excel
      1. Analyze Your Data
    10. Using Access Data in a Mail Merge
      1. Create a Mail Merge
    11. Using Access Data to Create a Catalog in Publisher
      1. Create a Catalog
    12. Adding Excel Data to an Access Database
      1. Get the Excel Data
  20. 18. Working with Graphics and Objects
    1. Creating Stylized Text with WordArt
      1. Create Some WordArt
      2. Fine-Tune the Result
    2. Inserting Clip Art
      1. Find and Insert Clip Art
    3. Drawing on a Canvas
      1. Create a Drawing
    4. Drawing AutoShapes
      1. Draw an AutoShape
      2. Format the AutoShape
    5. Inserting a Diagram
      1. Create a Diagram
    6. Creating an Equation
      1. Create an Equation
    7. Inserting a Picture
      1. Add a Picture
    8. Wrapping Text Around a Picture
      1. Set the Text Wrapping
    9. Editing a Picture
      1. Modify the Color
      2. Resize the Picture
      3. Crop the Picture
    10. Reducing the File Size of a Picture
      1. Reduce the File Size
    11. Formatting an Object
      1. Add Formatting
    12. Managing Pictures, Videos, and Sound Files
      1. Organize Your Clips
  21. 19. Alternative Ways to Add Content
    1. Correcting Text Automatically
      1. Add Your Own Misspellings
      2. Add Other Entries
      3. Control the Corrections
    2. Translating Foreign-Language Text
      1. Translate a Word or Phrase
    3. Scanning Text
      1. Scan a Text Document
    4. Editing a Fax Document
      1. Convert the Fax
    5. Inserting Special Characters
      1. Insert a Character
    6. Dictating Your Text
      1. Dictate Your Text
      2. Correct an Error Manually
      3. Choose a Correction
    7. Dictating Custom Text
      1. Add an Unusual Word
      2. Correct the Pronunciation
    8. Telling Your Program What to Do
      1. Dictate Your Commands
    9. Writing Text by Hand
      1. Write Some Text
      2. Insert Your Handwriting into a Word Document
    10. Drawing Pictures in Word
      1. Do Some Drawing
  22. 20. Working with Others
    1. What’s Where in SharePoint?
    2. Sharing a File on a SharePoint Site
      1. Save a File to a Shared Documents Library
    3. Accessing a Shared File
      1. Find and Open a File
    4. Sharing Information with Your Group
      1. Review and Add Items
    5. Working in a Shared Workspace
      1. Use the Shared Workspace
      2. Work with a Workspace File
    6. Managing Your SharePoint Site
      1. Administer the Site
    7. Working Simultaneously on a File
      1. Work on an Open File
    8. Comparing Documents and Presentations
      1. Compare Two Documents
    9. Working Simultaneously on a Shared Excel Workbook
      1. Share Your Excel Workbook
    10. Controlling Changes in Word
      1. Set the Access in Word
    11. Controlling Changes in Excel
      1. Protect the Data
    12. Discussing a File On Line
      1. Discuss a File
      2. Review the Discussions
    13. Sending Out a File for Review
      1. Send the File to All the Reviewers
      2. Assemble the Reviews
      3. Route a File for Sequential Reviews
    14. Reviewing a Document in Word
      1. Review a Document
    15. Reviewing a File in Excel or PowerPoint
      1. Review a File
    16. Reviewing a Review in Word
      1. Review the Document
    17. Reviewing a Review in Excel
      1. Review the Changes to the Data
    18. Reviewing a Review in PowerPoint
      1. Review the Changes to the Presentation
    19. Combining Reviews in Word or PowerPoint
      1. Merge the Documents
    20. Working with Business Manager
      1. Gather Your Data
      2. Use Your Information
    21. Reviewing Your Business Information
      1. Create a Report
  23. 21. Fine-Tuning Your Work
    1. Proofreading in Another Language
      1. Turn On Office’s Language Tools
      2. Work in Different Languages
    2. Controlling What’s Checked
      1. Specify What Isn’t to Be Checked
    3. Improving the Layout with Hyphenation
      1. Set Automatic Hyphenation
    4. Reviewing Your Grammar in Word
      1. Check Your Grammar
      2. Set the Grammar Rules
    5. Fine-Tuning the Text Flow
      1. Control Widows and Orphans
      2. Break Lines
    6. Getting the Results You Want
      1. Use the Tools
      2. Know Your Printer
      3. Know Your Fonts
      4. Know What’s in Your File
      5. Print What You Want
    7. Finding Alternative Wording
      1. Choose an Alternative Word
  24. 22. Customizing Office
    1. Adding or Removing Office Components
      1. Add or Remove Components
    2. Changing the Location of Saved Files
      1. Change the File Location
    3. Managing Toolbars and Menus
      1. Set the Options
    4. Rearranging Toolbars
      1. Move a Toolbar
    5. Rearranging Toolbar Buttons and Menus
      1. Move Toolbar Buttons
      2. Move Menu Commands
      3. Move Shortcut Menu Commands
    6. Customizing Toolbars and Menus
      1. Add or Remove Toolbar Buttons
      2. Add Different Items to Toolbars or Menus
    7. Creating Your Own Commands
      1. Set Up a Macro
    8. Controlling Your Services
      1. Set the Service Options
    9. Controlling the Office Assistant
      1. Design Your Assistant
  25. 23. Keeping Your Files Secure
    1. Protecting Your Files
      1. Protect a File
    2. Verifying a File by Using a Signature
      1. Digitally Sign a File
    3. Protecting Your System from Malicious Macros
      1. Set the Macro Security
    4. What Is Information Rights Management?
    5. Restricting File Access
      1. Restrict Access to a File
      2. Use a Restricted File
    6. Limiting E-Mail Snooping
      1. Set Your Download Options
      2. Name Your Trusted Contacts
    7. Encrypting Your E-Mail
      1. Install and Use the Digital ID
  26. A. About the Authors
  27. Index
  28. About the Authors
  29. Copyright