You are previewing Microsoft® Office XP Step by Step.
O'Reilly logo
Microsoft® Office XP Step by Step

Book Description

Quickly teach yourself how to use the complete suite of Office XP applications. This easy-to-follow book features step-by-step lessons in full color, plus practice files on CD-ROM. Take just the lessons you need, or work from cover to cover.

Table of Contents

  1. Microsoft® Office XP Step by Step
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. What's New in Microsoft Office XP
    4. Getting Help
      1. Getting Help with This Book and Its CD-ROM
      2. Getting Help with Microsoft Office XP
    5. Using the Book's CD-ROM
      1. Minimum System Requirements
      2. Installing the Practice Files
      3. Using the Practice Files
      4. Uninstalling the Practice Files
    6. Conventions and Features
    7. I. Microsoft Word
      1. 1. Creating a Document
        1. Getting Started with Word
        2. Creating a Document
        3. Working with an Existing Document
        4. Editing a Document
        5. Replacing Text in a Document
      2. 2. Changing the Look of Your Document
        1. Changing the Appearance of Text
        2. Changing the Appearance of a Paragraph
        3. Creating and Modifying a List
        4. Changing the Way Each Page Appears in a Document
        5. Changing the Look of a Document with Styles
      3. 3. Presenting Information in Tables and Columns
        1. Presenting Text in a Table
        2. Formatting Text in a Table
        3. Working with Data in a Table
        4. Presenting Text in Columns
      4. 4. Proofreading and Printing a Document
        1. Checking the Spelling and Grammar in a Document
        2. Previewing and Printing a Document
    8. II. Microsoft Excel
      1. 5. Getting to Know Excel
        1. Introducing Excel
        2. Working with an Existing Data List
        3. Zeroing In on Data in a List
        4. Creating a Workbook
        5. Checking and Correcting Data
      2. 6. Making Changes to Your Workbook
        1. Making Workbooks Easier to Work With
        2. Making Data Easier to Read
        3. Changing the Appearance of Data
        4. Applying an Existing Format to Data
        5. Making Numbers Easier to Read
        6. Changing Data's Appearance Based on Its Value
      3. 7. Performing Calculations on Data
        1. Naming Groups of Data
        2. Creating Formulas to Calculate Values
        3. Finding and Correcting Errors in Calculations
      4. 8. Focusing on Specific Data Using Filters
        1. Limiting the Data That Appears on the Screen
        2. Performing Calculations on Filtered Data
        3. Defining a Valid Set of Values for a Range of Cells
    9. III. Microsoft Access
      1. 9. Getting to Know Access
        1. What Is a Database?
        2. What's Special About Access?
        3. Opening an Existing Database
        4. Exploring Tables
        5. Exploring Queries
        6. Exploring Forms
        7. Exploring Reports
        8. Exploring Other Access Objects
          1. Pages
          2. Macros
          3. Modules
      2. 10. Creating a New Database
        1. Creating a Database Structure the Simple Way
        2. Checking the Work of a Wizard
        3. Creating Tables the Simple Way
        4. Refining How Data Is Displayed
        5. Manipulating Table Columns and Rows
      3. 11. Simplifying Data Entry with Forms
        1. Creating a Form Using a Wizard
        2. Refining Form Properties
        3. Refining Form Layout
        4. Adding Controls to a Form
        5. Using VBA to Enter Data in a Form
        6. Creating a Form Using AutoForm
        7. Adding a Subform to a Form
      4. 12. Locating Specific Information
        1. Sorting Information
        2. Filtering Information in a Table
        3. Filtering By Form
        4. Locating Information with the Advanced Filter/Sort Command
        5. Creating a Query in Design View
        6. Creating a Query with a Wizard
        7. Performing Calculations in a Query
    10. IV. Microsoft PowerPoint
      1. 13. Creating a Presentation
        1. Getting Started with PowerPoint
        2. Choosing the Best Method to Start a Presentation
        3. Creating a Presentation Using Suggested Content
        4. Browsing Through a Presentation
        5. Editing Text in a Presentation
        6. Viewing a Presentation
      2. 14. Working with a Presentation
        1. Creating a Presentation Using a Design Template
        2. Entering Text in a Slide
        3. Creating a New Slide
        4. Inserting Slides from Other Presentations
        5. Rearranging Slides in a Presentation
        6. Entering Speaker Notes
        7. Creating a Folder to Store a Presentation
      3. 15. Adding and Modifying Slide Text
        1. Adding and Moving Text on Slides
        2. Changing Text Alignment and Spacing
        3. Finding and Replacing Text and Fonts
        4. Correcting Text While Typing
        5. Checking Spelling and Presentation Styles
      4. 16. Printing a Presentation
        1. Working with an Existing Presentation
        2. Adding a Header and a Footer
        3. Choosing the Right Print Settings
        4. Previewing a Presentation
        5. Printing a Presentation
    11. V. Microsoft FrontPage
      1. 17. Understanding How FrontPage Works
        1. Exploring an Existing Web Site
        2. Exploring an Existing Web Page
        3. Looking at a Web Site in Various Ways
        4. Looking Around in FrontPage 2002
        5. Understanding FrontPage Concepts
      2. 18. Creating a Web Site to Promote Yourself or Your Company
        1. Creating a New Web Site Using a Template
        2. Creating a New Web Site Using a Wizard
        3. Working with the Tasks List
        4. Inserting and Editing Text
        5. Inserting Existing Text
        6. Formatting Text
        7. Inserting Hyperlinks
        8. Seeing Your Web Pages as Visitors Will
        9. Deleting a Web Site
      3. 19. Presenting Information in Lists and Tables
        1. Creating a List
        2. Creating a Table
        3. Entering and Editing Information in a Table
        4. Editing the Structure of a Table
        5. Formatting a Table
        6. Creating a Table Within a Table
      4. 20. Enhancing Your Web Site with Graphics
        1. Adding Clip Art
        2. Adding a Picture
        3. Editing and Formatting Pictures
        4. Creating and Displaying Thumbnails
        5. Adding a Line, Shape, or Drawing
        6. Creating a Photo Gallery
        7. Adding Fancy Text
      5. 21. Publishing Your Web Site
        1. Finding a Suitable Host for Your Web Site
        2. Configuring Your Own Computer to Host a Web Site
        3. Publishing a Web Site to a Local Folder
        4. Publishing a Web Site to a Web Server
    12. VI. Microsoft Publisher
      1. 22. Creating a Document
        1. Creating a Publication for the First Time
        2. Creating a Publication Using the Publication Wizard
        3. Creating a Business Card Using the Publication Design Set
        4. Saving a Publication as a Template
        5. Creating a Publication from a Template
        6. Creating a Publication from a Blank Page
      2. 23. Printing Your Documents
        1. Determining Your Printer's Nonprintable Region
        2. Printing a Document to a Standard Printer
        3. Printing a Range of Pages to a Standard Printer
        4. Printing a Single Page to a Standard Printer
        5. Canceling a Print Job on a Standard Printer
        6. Preparing a Document for a Commercial Printer
        7. Setting Up a Publication for Spot-Color Printing
        8. Changing Colors in a Spot-Color Document
        9. Setting Up a Publication for Process-Color Printing
    13. VII. Microsoft Outlook
      1. 24. Working with E-Mail
        1. Starting Outlook for the First Time
          1. Upgrading to Outlook 2002
          2. Using Outlook for the First Time
        2. Reading Messages and Opening Attachments
        3. Responding to Messages
        4. Creating New Messages
        5. Using an Address Book
        6. Attaching Files to Messages
        7. Adding Signatures to Messages
        8. Sending and Receiving Messages
        9. Printing Messages
      2. 25. Managing E-Mail Messages
        1. Customizing How You View Messages
        2. Organizing Messages in Folders
        3. Managing Messages with Color
        4. Finding Messages
        5. Storing and Archiving Messages
      3. 26. Customizing and Organizing E-Mail Messages
        1. Formatting Messages
        2. Changing Message Settings and Delivery Options
        3. Filtering Messages
        4. Using Personal Folders and Address Books
      4. 27. Managing Your Calendar
        1. Scheduling Appointments and Events
        2. Managing and Organizing Appointments
        3. Changing the Way the Calendar Looks
        4. Printing Your Calendar
      5. 28. Scheduling and Managing Meetings
        1. Scheduling Meetings
        2. Responding to Meeting Requests
        3. Updating and Canceling Meeting Requests
        4. Scheduling Online Meetings Using NetMeeting
    14. A. Quick Reference
      1. Chapter 1 Creating a Document
        1. Page 6 To start Microsoft Word
        2. 6 To use the Ask A Question box
        3. 9 To create a new blank document
        4. 9 To enter text
        5. 10 To save a new document
        6. 12 To save a file for use in another program
        7. 14 To open an existing document
        8. 19 To edit text
        9. 21 To close a document
        10. 23 To find and replace text
      2. Chapter 2 Changing the Look of Your Document
        1. Page 29 To change the appearance of text
        2. 36 To format a paragraph
        3. 42 To create a bulleted or numbered list
        4. 48 To change line and page break options
        5. 49 To add a header or footer to a document
        6. 53 To open and use the Styles and Formatting task pane to change styles
      3. Chapter 3 Presenting Information in Tables and Columns
        1. Page 62 To create a new table
        2. 64 To convert existing plain text to a table
        3. 65 To sort information in a table
        4. 67 To format text in a table
        5. 73 To calculate data in a table
        6. 73 To embed an Excel worksheet in a Word document
        7. 76 To format text into columns
      4. Chapter 4 Proofreading and Printing a Document
        1. Page 84 To check the spelling and grammar in a document
        2. 88 To preview a document
        3. 89 To print a document
        4. 90 To print an envelope or label to accompany a letter document
      5. Chapter 5 Getting to Know Excel
        1. Page 98 To open a workbook
        2. 99 To save a workbook
        3. 100 To save a workbook with a different file name and format
        4. 102 To move to a worksheet
        5. 103 To select one or more cells
        6. 105 To select one or more columns or rows
        7. 109 To create a new workbook
        8. 109 To enter data manually
        9. 111 To quickly enter a series of data
        10. 112 To enter data in multiple cells
        11. 114 To find specific data
        12. 115 To replace specific data
        13. 115 To replace cell data manually
        14. 117 To change an action
        15. 117 To check spelling
      6. Chapter 6 Making Changes to Your Workbook
        1. Page 122 To name a worksheet
        2. 123 To reposition a worksheet
        3. 123 To adjust column width
        4. 124 To adjust row height
        5. 124 To merge cells
        6. 125 To add a row or column
        7. 125 To hide a row or column
        8. 126 To unhide a row or column
        9. 129 To prevent text spillover
        10. 129 To control how text appears in a cell
        11. 130 To freeze column headings
        12. 130 To unfreeze column headings
        13. 133 To change cell formatting
        14. 134 To add cell borders
        15. 134 To add cell shading
        16. 136 To create a style
        17. 138 To copy a format
        18. 141 To format a number
        19. 141 To format a number as a dollar amount
        20. 142 To create a custom format
        21. 146 To create a conditional format
      7. Chapter 7 Performing Calculations on Data
        1. Page 153 To name a range of cells
        2. 153 To name a range of cells using adjacent cell labels
        3. 160 To write a formula
        4. 160 To copy a formula to another cell
        5. 161 To create a formula with a function
        6. 162 To create a formula with a conditional function
        7. 164 To trace precedents or dependents
        8. 165 To remove tracer arrows
      8. Chapter 8 Focusing on Specific Data Using Filters
        1. Page 169 To find the top ten values in a list
        2. 170 To find a subset of data in a list
        3. 171 To create a custom filter
        4. 171 To remove a filter
        5. 172 To filter for a specific value
        6. 172 To select a random row from a list
        7. 173 To extract a list of unique values
        8. 176 To find a total
        9. 179 To set acceptable values for a cell
        10. 182 To allow only numeric values in a cell
      9. Chapter 9 Getting to Know Access
        1. Page 190 To open an existing database
        2. 193 To view details about objects listed in the database window
        3. 194 To hide command shortcuts in the database window
        4. 198 To open a table, query, form, or report
      10. Chapter 10 Creating a New Database
        1. Page 213 To change the default storage location
        2. 220 To create an empty database structure
        3. 224 To switch views of a database object
        4. 225 To set the primary key field
        5. 225 To set a field's data type
        6. 226 To assign a caption (a column header that is different from the field name)
        7. 226 To set a text field's size
      11. Chapter 11 Simplifying Data Entry with Forms
        1. Page 239 To edit form properties
        2. 240 To rearrange form controls
        3. 246 To fine-tune the size or position of a form control
        4. 246 To create a style based on a form
        5. 248 To add a graphic to a form
        6. 248 To add a control to a form
        7. 250 To copy the formatting of one form control to another
        8. 256 To create a form using an AutoForm
        9. 259 To define a relationship between tables
        10. 260 To edit or delete a table relationship
        11. 260 To add a subform to a form
        12. 263 To adjust a subform's properties
      12. Chapter 12 Locating Specific Information
        1. Page 268 To sort information in a table
        2. 271 To filter a table based on a selection
        3. 271 To filter a table based on text you type
        4. 271 To filter a table excluding a selection
        5. 274 To filter by form to locate information
        6. 276 To save a query created in the Advanced Filter/Sort window
        7. 280 To create a select query
        8. 283 To add an expression to a query
        9. 288 To turn off the display of a field in a query
      13. Chapter 13 Creating a Presentation
        1. Page 298 To start Microsoft PowerPoint
        2. 301 To create a presentation using suggested content
        3. 304 To move from slide to slide in the Slide pane
        4. 307 To change or add text in the Slide pane
      14. Chapter 14 Working with a Presentation
        1. Page 316 To create a new presentation with a design template
        2. 320 To enter text in the Slide pane
        3. 321 To create a new slide
        4. 324 To insert slides from other presentations
        5. 326 To rearrange slides in Slide Sorter view
        6. 327 To enter text in the Notes pane
      15. Chapter 15 Adding and Modifying Slide Text
        1. Page 336 To add text to a text object
        2. 338 To move a text object
        3. 339 To create a text label
        4. 340 To create a word processing box
        5. 341 To change text alignment
        6. 344 To adjust line spacing
        7. 345 To replace text
        8. 348 To add an AutoCorrect entry
        9. 348 To use AutoCorrect to fix a misspelled word
        10. 351 To mark a word as a foreign language word
        11. 351 To select and correct a misspelled word
        12. 351 To check the spelling in a presentation
        13. 352 To set style options
        14. 353 To check the style of a presentation
      16. Chapter 16 Printing a Presentation
        1. Page 361 To open an existing presentation
        2. 361 To add a header and a footer to a presentation
        3. 365 To preview your presentation
        4. 366 To preview slides in pure black and white or grayscale
        5. 370 To print presentation slides, audience handouts, or speaker notes
      17. Chapter 17 Understanding How FrontPage Works
        1. Page 379 To stop the FrontPage task pane from appearing automatically
        2. 381 To close or open a FrontPage pane
        3. 382 To preview a Web site in a Web browser
        4. 386 To view the HTML code for a Web page
        5. 390 To switch views of a Web page
        6. 392 To change the display size of a window
        7. 394 To mark a task as complete
      18. Chapter 18 Creating a Web Site to Promote Yourself or Your Company
        1. Page 405 To create a Web site using a template
        2. 405 To open the task pane every time you start FrontPage
        3. 409 To create a Web site using a wizard
        4. 412 To use the tasks list
        5. 413 To insert a comment
        6. 413 To edit a comment
        7. 415 To insert a symbol
        8. 418 To insert an existing file
        9. 418 To delete a table
        10. 419 To customize a page banner
        11. 421 To increase the font size by one size
        12. 423 To add a border to a paragraph
        13. 423 To change paragraph formatting
        14. 425 To create an embedded cascading style sheet in FrontPage
        15. 425 To create an external cascading style sheet in FrontPage
        16. 425 To attach a style sheet in FrontPage
        17. 426 To insert a hyperlink to a file
        18. 429 To delete a Web site
      19. Chapter 19 Presenting Information in Lists and Tables
        1. Page 434 To assign a style to selected text
        2. 435 To create a list as you type
        3. 436 To create a table
        4. 437 To convert existing text to a table
        5. 437 To convert a table to text
        6. 438 To insert a table with specific formatting settings
        7. 439 To draw a table
        8. 443 To insert a row in a table
        9. 443 To delete a column in a table
        10. 443 To adjust the size of table columns so that all entries fit on one line
        11. 443 To adjust the size of table columns to the exact width of their contents
        12. 444 To change a table's properties
        13. 445 To make all columns in a table the same width
        14. 446 To change a cell's background color in a table
        15. 448 To apply an AutoFormat to a table
        16. 449 To merge cells in a table
        17. 450 To split one cell into multiple cells in a table
        18. 450 To split a table into multiple tables
        19. 450 To add a caption to a table
      20. Chapter 20 Enhancing Your Web Site with Graphics
        1. Page 454 To insert clip art in a page
        2. 458 To convert a graphic to GIF or JPG format
        3. 458 To insert a picture file on a page
        4. 462 To crop a graphic
        5. 462 To size a graphic
        6. 463 To convert a graphic to black and white
        7. 464 To create a thumbnail
        8. 467 To draw a horizontal rule
        9. 469 To insert a drawing with predefined shapes
        10. 472 To group shapes together
        11. 475 To create a photo gallery
        12. 477 To change a photo gallery's layout
        13. 479 To add fancy text with WordArt
      21. Chapter 21 Publishing Your Web Site
        1. Page 488 To install the Personal Web Server
        2. 493 To install the FrontPage Server Extensions
        3. 495 To publish a disk-based Web site to a local folder
        4. 499 To publish a single page of a Web site
        5. 499 To publish a disk-based Web site to your personal Web server
        6. 500 To publish a Web site from a personal Web server to a remote Web server
        7. 501 To publish a FrontPage Web site from a remote server to a local folder or to your personal Web server
      22. Chapter 22 Creating a Document
        1. Page 505 To start Microsoft Publisher
        2. 506 Creating a newsletter for the first time
        3. 508 To complete the Personal Information Set for your business
        4. 510 To create a newsletter using the Publication Wizard
        5. 512 To insert a picture
        6. 514 To create a business card using the Publication Design Set
        7. 517 To save a publication as a template
        8. 519 To create a publication from a template
        9. 520 To create a publication from a blank page
      23. Chapter 23 Printing Your Documents
        1. Page 527 To determine your printer's nonprintable region
        2. 530 To print a document to a standard printer
        3. 531 To select a target printer
        4. 532 To preview your document
        5. 533 To print a range of pages to a standard printer
        6. 534 To print a single page to a standard printer
        7. 535 To cancel a print job on a standard printer
        8. 537 To set up a publication for spot-color printing
        9. 538 To change colors in a spot-color document
        10. 542 To set up a publication for process-color printing
      24. Chapter 24 Working with E-Mail
        1. Page 548 To use Outlook for the first time
        2. 552 To preview a message
        3. 553 To open an attachment
        4. 554 To reply to a message
        5. 556 To forward a message
        6. 557 To create a new message
        7. 560 To add an entry to an address book
        8. 562 To create a distribution list
        9. 565 To attach a file to a message
        10. 566 To add a signature to a message
        11. 573 To print a message
      25. Chapter 25 Managing E-Mail Messages
        1. Page 578 To sort messages
        2. 581 To customize your current view
        3. 584 To create a new folder for messages
        4. 588 To manage messages with color
        5. 590 To find a message
        6. 591 To add more parameters to your message search
        7. 594 To save a message as a text file
      26. Chapter 26 Customizing and Organizing E-Mail Messages
        1. Page 609 To change message importance and sensitivity settings
        2. 612 To recall a message
        3. 620 To filter junk e-mail and adult-content messages
        4. 629 To allow Outlook to check an address using your Personal Address Book
      27. Chapter 27 Managing Your Calendar
        1. Page 637 To mark an appointment as private
        2. 643 To change the view of your Calendar
        3. 650 To change the time zone in your Calendar
        4. 652 To print your Calendar
      28. Chapter 28 Scheduling and Managing Meetings
        1. Page 666 To respond to a meeting request
        2. 670 To respond to meeting requests automatically
        3. 673 To cancel a meeting
    15. Glossary
    16. B. appendix
      1. Kristen Crupi
      2. Curtis Frye
      3. Online Training Solutions, Inc. (OTSI)
      4. Perspection, Inc.
    17. Index
    18. SPECIAL OFFER: Upgrade this ebook with O’Reilly