You are previewing Microsoft Office XP for Windows: Visual QuickStart Guide.
O'Reilly logo
Microsoft Office XP for Windows: Visual QuickStart Guide

Book Description

This book is a reasonably priced, unintimidating guide to the essentials of Microsoft Office. Organized and presented specifically for busy professionals who need to use the applications immediately, it guides you right to the information you need. All the most important tasks in each program are covered, using clear, step-by-step instructions, and illustrated with hundreds of helpful screenshots. Office XP promises a wealth of exciting new features, and Microsoft Office XP for Windows: Visual QuickStart Guide lets you put them to work for you in a hurry.

Table of Contents

  1. Copyright
  2. About the Authors
  3. Other Books by Steve Sagman
  4. Acknowledgments
  5. I. Common Office Techniques
    1. 1. Basic Office Techniques
      1. Creating a New Document
      2. Opening an Office Document
      3. Choosing from Menus and Toolbars
      4. Selecting Toolbars to Display
      5. Making Selections in Dialog Boxes
      6. Using the Task Panes
      7. Getting Help from the Office Assistant
      8. Getting Help Using the Ask a Question Box
      9. Controlling Office XP with Voice Commands
      10. Dictating in Office XP
      11. Using Smart Tags
    2. 2. Working in Programs
      1. Undoing a Change
      2. Selecting Text Using the Mouse
      3. Selecting and Replacing Text Using the Keyboard
      4. Dragging and Dropping Text
      5. Selecting and Formatting Objects
      6. Copying Formatting Using the Format Painter
      7. Zooming In and Out
      8. Setting Up the Page
      9. Previewing Printing
      10. Printing
      11. Saving Your Work
      12. Reopening a Saved File
      13. Quitting an Office Program
      14. Using the Office XP Clipboard
  6. II. Microsoft Word
    1. 3. Introducing Word 2002
      1. The Steps to Creating a Word Document
        1. Entering and editing the text
        2. Formatting the characters
        3. Formatting the paragraphs
        4. Formatting the pages
        5. Adding tables and graphics or objects from other applications
        6. Proofing the document
        7. Printing or e-mailing the document and publishing to the Web
        8. Other features
      2. Starting Word
      3. The Word Window
      4. Key to the Word Window
    2. 4. Entering and Editing Text
      1. Starting a New Document
      2. Starting a Document Using a Wizard or Template
      3. Entering Text
      4. Turning On Paragraph Marks
      5. Editing Text
      6. Finding Text
      7. Replacing Text
      8. Using Print Layout View
      9. Using Outline View
      10. Using Web Layout View
    3. 5. Formatting Text
      1. Changing the Font and Font Size
      2. Boldfacing, Italicizing, and Underlining
      3. Expanding and Condensing Character Spacing
      4. Changing the Case of Text
      5. Using Special Font Effects
      6. Selecting Paragraphs
      7. Using the Ruler to Indent Paragraphs
      8. Setting a Different First Line Indent
      9. Indenting Using the Paragraph Dialog Box
      10. Double-Spacing Paragraphs
      11. Centering and Justifying Paragraphs
      12. Setting Tabs
      13. Adding Bullets to Paragraphs
      14. Numbering Paragraphs
      15. Finding and Replacing Formatting
      16. Using Styles
      17. Choosing a Text Style
      18. Creating a Paragraph Style
      19. Modifying a Paragraph Style
      20. Creating a Character Style
    4. 6. Formatting Pages
      1. Changing the Page Size and Orientation
      2. Changing the Margins
      3. Setting Up Headers and Footers
      4. Creating Multiple Sections
      5. Paginating the Document
      6. Numbering Pages
      7. Setting Up Multiple Columns
      8. AutoFormatting a Document
    5. 7. Creating Tables
      1. Starting a Table
      2. Drawing a Table
      3. Drawing a More Complex Table
      4. Entering Data in a Table
      5. Aligning Data in a Table
      6. Totaling Numeric Data
      7. Deleting Data from a Table
      8. Inserting Rows and Columns
      9. Merging Cells
      10. Turning On Borders and Shading
      11. Converting Text to a Table
    6. 8. Special Word Techniques
      1. Automatically Correcting Typos
      2. Inserting Symbols from the Wingdings Font
      3. Using AutoText
      4. Printing Envelopes
      5. Envelope Printing Options
      6. Saving a Document as a Template
      7. Using Automatic Saves
      8. Creating Form Letters Using Mail Merge
    7. 9. Word and theWeb
      1. Inserting Hyperlinks
      2. Editing a Hyperlink
      3. Previewing a Document as a Web Page
      4. Saving a Document as a Web Page
      5. Using the Web Wizard to Create a Web Site
      6. Formatting a Document with a Web Theme
  7. III. Microsoft Excel
    1. 10. Introducing Excel 2002
      1. The Steps to Creating an Excel Sheet
        1. Filling the cells with row and column headings and data
        2. Entering the calculations
        3. Changing the sheet structure
        4. Formatting the sheet
        5. Annotating and auditing the sheet
        6. Printing or mailing the sheet and publishing to the Web
        7. Other features
      2. Starting Excel
      3. The Excel Window
      4. Key to the Excel Window
      5. Starting a New Workbook
    2. 11. Entering Data and Formulas
      1. Starting with a Template
      2. Moving Within a Sheet
      3. Typing Data into a Cell
      4. Editing Cells
      5. Adding a Hyperlink
      6. Filling an Entry Range
      7. AutoFilling a Range
      8. Entering Simple Calculations
      9. Building a Simple Formula
      10. Summing Columns and Rows
      11. Totaling a Column Using the Sum Function
      12. Copying Formulas to Adjacent Cells
      13. Averaging Numbers Using the Average Function
      14. Calculating Numbers in Nonadjacent Cells
      15. Building Formulas by Inserting Functions
    3. 12. Structuring the Sheet
      1. Enlarging Columns and Rows
      2. Inserting Rows and Columns
      3. Inserting and Deleting Cells
      4. Moving and Copying Data
      5. Freezing the Headings
    4. 13. Formatting the Sheet
      1. Choosing an AutoFormat
      2. Formatting Text
      3. Centering a Title Above a Range
      4. Formatting Numbers
      5. Adding Borders to a Range
      6. Adding Shading to a Range
      7. Applying Conditional Formatting
      8. Creating and Selecting a Style
      9. Designing the Layout
    5. 14. Using Excel Charts
      1. Creating a Default Chart
      2. Creating a Chart Using the Chart Wizard
      3. Modifying a Chart
      4. Modifying the Chart Type
      5. Modifying the Chart Area, Plot Area, and Gridlines
      6. Modifying the Title, Axes, and Legend
      7. Modifying a Data Series
      8. Adding Data to a Chart
      9. Adding Data Tables and Trendlines
      10. Creating a PivotTable Report
      11. Creating a PivotChart Report
    6. 15. Excel Database Techniques
      1. Setting Up the Database
      2. Creating a Form
      3. Sorting the Database
      4. Extracting Data
      5. Totaling Numeric Data in a Database
    7. 16. Special Excel Techniques
      1. Changing to Another Sheet
      2. Naming Sheets
      3. Referring to Data from Other Sheets in Formulas
      4. Consolidating to a Sheet
      5. Naming Ranges
      6. Auditing a Workbook
      7. Seeking Goals
      8. Tracking Changes
      9. Reviewing Changes
      10. Inserting Comments
      11. Including Smart Tags
      12. Protecting a Worksheet
      13. Sharing and Merging Workbooks
    8. 17. Excel and theWeb
      1. Opening a Document on the Web
      2. Running a Web Query
      3. Saving a Workbook as a Web Page
  8. IV. Microsoft PowerPoint
    1. 18. Introducing PowerPoint 2002
      1. The Steps to a PowerPoint Presentation
        1. Getting started building a presentation
        2. Creating the slides
        3. Creating charts and tables
        4. Customizing the presentation
        5. Adding special graphics
        6. Creating a slide show
      2. Starting PowerPoint
      3. The PowerPoint Window
      4. Key to the PowerPoint Window
    2. 19. Building a Presentation
      1. Starting a New Presentation
      2. Using the AutoContent Wizard
      3. Using a Design Template
      4. Using a Sample Presentation
      5. Changing Views
      6. Adding Slides
    3. 20. Outlining the Presentation
      1. Switching to the Outline Pane
      2. Entering the Text
      3. Replacing Existing Text
      4. Reorganizing the Slides
      5. Showing the Slide Titles Only
      6. Inserting and Deleting Slides
    4. 21. Creating Text Slides
      1. Creating a Text Slide
      2. Filling in Text Placeholders
      3. Selecting Text Blocks
      4. Moving and Resizing Text Blocks
      5. Formatting Text
      6. Rearranging Text in a Block
      7. Moving and Copying Text
    5. 22. Creating Chart Slides
      1. Starting a Chart
      2. Replacing the Sample Data on a Datasheet
      3. Changing the Chart Type
      4. Saving a Custom Chart Format
      5. Displaying a Legend and Gridlines
      6. Adding Chart Titles
      7. Adding Data Labels
      8. Arranging Data by Row vs. by Column
    6. 23. Formatting Charts
      1. Formatting Chart Elements
      2. Cutting a Pie Chart Slice
      3. Creating High-Low-Close Charts
      4. Switching Between 2-D and 3-D Chart Types
      5. Changing the View of 3-D Charts
      6. Moving and Resizing Charts
    7. 24. Creating Org Charts and Tables
      1. Starting an Organization Chart
      2. Entering Names and Titles
      3. Adding Members
      4. Formatting the Boxes, Text, and Lines
      5. Rearranging the Organization Chart
      6. Starting a Table
      7. Entering the Data and Formatting the Table
    8. 25. Customizing a Presentation
      1. Selecting a New Design
      2. Changing the Color Scheme
      3. Switching to Master Views
      4. Changing the Background Color and Shading
      5. Changing the Text Fonts
      6. Changing Header and Footer Information
      7. Adding a Logo to the Background
      8. Saving a Custom Design
      9. Working in Slide Sorter View
      10. Reordering Slides
      11. Changing the Design in Slide Sorter View
      12. Duplicating and Deleting Slides
    9. 26. Drawing on Slides
      1. Drawing Shapes and Lines
      2. Adding Predefined Shapes and Text Boxes
      3. Adding Shadows and 3-D Effects
      4. Making Text Conform to Shapes
      5. Grouping and Ungrouping Shapes
      6. Aligning and Rotating Shapes
      7. Using Clip Art
    10. 27. Creating Slide Shows
      1. Adding Transition Effects
      2. Adding Animation Schemes
      3. Creating Custom Animations
      4. Adding Audio and Video
      5. Adding Action Buttons
      6. Setting Up the Show
      7. Displaying the Show
    11. 28. PowerPoint and the Web
      1. Adding a Hyperlink
      2. Opening a Presentation on the Web
      3. Previewing a Presentation as a Web Page
      4. Saving a Presentation as a Web Page
  9. V. Microsoft Access
    1. 29. Introducing Access 2002
      1. The Steps to Creating an Access Database
        1. Starting a new database
        2. Setting up a table
        3. Creating a form
        4. Finding, sorting, and filtering information
        5. Creating a report
        6. Creating a data access page
        7. Other features
      2. Starting Access
      3. The Access Window
      4. Key to the Access Window
    2. 30. Creating a Database
      1. Creating a New Database
      2. Saving a New Database
      3. Starting a Database Using a Wizard
      4. Viewing the Database
    3. 31. Creating a Table
      1. Entering Data in a Table
      2. Editing Data in a Table
      3. Printing a Table
      4. Creating a Table
      5. Saving a Table
      6. Creating a Table Using the Table Wizard
      7. Adding a Field to the Table in Design View
      8. Setting the Field Size and Format
      9. Entering a Caption and Default Value for a Field
      10. Requiring and Indexing a Field
    4. 32. Creating a Form
      1. Entering Data in a Form
      2. Viewing and Editing Records Using a Form
      3. Creating and Saving a Form
      4. Creating a Form Using the Form Wizard
      5. Opening the Form in Design View
      6. Moving a Control
      7. Sizing a Control and Moving Labels Independently
      8. Adding Labels
      9. Formatting Labels
      10. Adding a Combo Box
      11. Setting the Form and Control Properties
    5. 33. Working with Records
      1. Finding a Match in a Form or a Table
      2. Sorting Records
      3. Creating a Filter
      4. Adding an Expression to a Filter
    6. 34. Using Queries
      1. Creating and Running a Select Query
      2. Saving a Query and Printing the Results
      3. Starting a Query Using the Simple Query Wizard
      4. Adding Criteria to a Query
      5. Calculating Totals in a Query
      6. Finding Duplicate or Unmatched Records
      7. Updating Table Records Using an Update Query
      8. Deleting Table Records Using a Delete Query
      9. Appending Table Records Using an Append Query
      10. Creating a Table of Query Results Using a Make-Table Query
      11. Creating a Crosstab Query
    7. 35. Creating a Report
      1. Viewing and Printing a Report
      2. Starting a Report Using an AutoReport
      3. Starting a Report Using the Report Wizard
      4. Revising a Report in Design View
      5. Sorting and Grouping Records in a Report
      6. Choosing an AutoFormat for the Report
      7. Creating Charts and Labels
    8. 36. Access and the Web
      1. Creating and Saving a Data Access Page
      2. Starting a Data Access Page Using the Page Wizard
      3. Creating a Data Acces Page Using an AutoPage
      4. Revising the Page in Design View
      5. Changing the Theme in Design View
      6. Inserting a Chart in a Data Access Page
      7. Inserting a PivotTable in a Data Access Page
      8. Inserting a Spreadsheet in a Data access Page
      9. Adding a Hyperlink Field
      10. Adding a Hyperlink
  10. VI. Microsoft Outlook
    1. 37. Introducing Outlook 2002
      1. The Steps to an Outlook Management System
        1. Setting up Outlook
        2. Organizing incoming messages
        3. Setting up your outgoing messages
        4. Building a contacts list
        5. Assigning tasks
        6. Scheduling appointments
        7. Tracking activities
      2. Starting Outlook
      3. The Outlook Inbox Window
      4. Key to the Inbox Window
      5. Going Online with Outlook
      6. Using Outlook Today
    2. 38. Reading Messages
      1. Collecting Messages
      2. Reading a Message
      3. Closing a Message
      4. Viewing the Folder List
      5. Replying to a Message
      6. Forwarding a message
      7. Printing a Message
      8. Changing a View
      9. Finding Text in a Message
      10. Deleting a Message
    3. 39. Sending Messages
      1. Setting Mail Format Options
      2. Using Stationery
      3. Creating a Signature
      4. Starting and Addressing a Message
      5. Entering and Formatting the Text
      6. Starting a Message Using a Different Format or Program
      7. Setting Message Options
      8. Attaching a File or an Item to a Message
      9. Inserting an Object in a Message
      10. Saving and Sending the Message
    4. 40. Managing Your Mailbox
      1. Moving a Message to a Folder
      2. Creating a Folder
      3. Organizing Messages
      4. Creating a Message Rule
      5. Moving or Deleting a Folder
    5. 41. Keeping a Contacts List
      1. Setting Contact Options
      2. Adding a Contact
      3. Adding a Contact from an E-mail Message
      4. Deleting a Contact
    6. 42. Scheduling Tasks and Meetings
      1. Looking at Tasks
      2. Setting Task Options
      3. Adding a Task
      4. Assigning a Task
      5. Changing the Status of a Task
      6. Viewing the Calendar
      7. Setting Calendar Options
      8. Adding an Item to the Calendar
      9. Creating a Recurring Appointment
      10. Inviting Attendees to a Meeting
      11. Adding an All-Day Event