You are previewing Microsoft® Office System Step by Step -- 2003 Edition.
O'Reilly logo
Microsoft® Office System Step by Step -- 2003 Edition

Book Description

Build exactly the skills you need to succeed with Microsoft Office 2003—one step at a time! Self-paced lessons and exercises teach you to easily create great documents, spreadsheets, e-mail messages, slide presentations, databases, Web sites, and more.

Table of Contents

  1. Microsoft® Office System: Step by Step, 2003 Edition
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. What’s New in The Microsoft Office System 2003
      1. Other New Features in The Microsoft Office System 2003
        1. Microsoft OneNote
        2. Microsoft InfoPath
        3. Collaboration with The Microsoft Office System 2003
    4. Getting Help
      1. Getting Help with This Book and Its CD-ROM
      2. Getting Help with The Microsoft Office System 2003
      3. More Information
    5. Using the Book’s CD-ROM
      1. What’s on the CD-ROM?
      2. Minimum System Requirements
      3. Installing the Practice Files
      4. Opening the Practice Data Files in Outlook
      5. Using the Practice Files
      6. Uninstalling the Practice Files
    6. Conventions and Features
    7. About the Authors
      1. Online Training Solutions, Inc. (OTSI)
      2. Kristen Crupi
      3. Perspection, Inc.
    8. Quick Reference
      1. Chapter 1 Working with Documents
      2. Chapter 2 Editing and Proofreading a Document
      3. Chapter 3 Changing the Look of Text
      4. Chapter 4 Presenting Information in Tables and Columns
      5. Chapter 5 Setting Up a Workbook
      6. Chapter 6 Performing Calculations on Data
      7. Chapter 7 Changing Document Appearance
      8. Chapter 8 Focusing on Specific Data Using Filters
      9. Chapter 9 Creating a New Database
      10. Chapter 10 Simplifying Data Entry with Forms
      11. Chapter 11 Locating Specific Information
      12. Chapter 12 Keeping Your Information Accurate
      13. Chapter 13 Creating Presentations
      14. Chapter 14 Working with Slides
      15. Chapter 15 Working with Slide Text
      16. Chapter 16 Setting Up and Delivering Slide Shows
      17. Chapter 17 Working with Outlook
      18. Chapter 18 Managing E-mail Messages
      19. Chapter 19 Finding and Organizing E-mail Messages
      20. Chapter 20 Managing Your Calendar
      21. Chapter 21 Scheduling and Managing Meetings
      22. Chapter 22 Understanding How FrontPage Works
      23. Chapter 23 Creating a Web Site to Promote Yourself or Your Company
      24. Chapter 24 Presenting Information in Lists and Tables
      25. Chapter 25 Enhancing Your Web Site with Graphics
      26. Chapter 26 Creating and Printing Publications
      27. Chapter 27 Creating Web Sites and E-mail Messages
      28. Chapter 28 Taking Notes
      29. Chapter 29 Working with Notes
      30. Chapter 30 Working with InfoPath Forms
      31. Chapter 31 Designing InfoPath Forms
      32. Chapter 32 Working in a Document Workspace
      33. Chapter 33 Teaming Up in a Meeting Workspace
    9. I. Microsoft Office Word 2003
      1. 1. Working with Documents
        1. Getting Started with Word
        2. Creating, Saving, and Closing Documents
        3. Opening and Viewing Existing Documents
        4. Deciding Which View to Use When
        5. Key Points
      2. 2. Editing and Proofreading Documents
        1. Editing a Document
        2. Using Text Entry Shortcuts
        3. Finding the Best Word
        4. Using an Outline to Rearrange Paragraphs
        5. Finding and Replacing Text
        6. Checking Spelling and Grammar
        7. Key Points
      3. 3. Changing the Appearance of Text
        1. Changing the Look of Characters
        2. Changing the Look of Paragraphs
        3. Creating and Modifying Lists
        4. Formatting Text as You Type
        5. Changing the Look of Characters and Paragraphs with Styles
        6. Key Points
      4. 4. Presenting Information in Tables and Columns
        1. Presenting Information in a Table
        2. Formatting Table Information
        3. Working with Table Data
        4. Presenting Text in Columns
        5. Key Points
    10. II. Microsoft Office Excel 2003
      1. 5. Setting Up a Workbook
        1. Making Workbooks Easier to Work With
        2. Making Data Easier to Read
        3. Adding a Graphic to a Document
        4. Key Points
      2. 6. Performing Calculations on Data
        1. Naming Groups of Data
        2. Creating Formulas to Calculate Values
        3. Finding and Correcting Errors in Calculations
        4. Key Points
      3. 7. Changing Document Appearance
        1. Changing the Appearance of Data
        2. Applying an Existing Format to Data
        3. Making Numbers Easier to Read
        4. Changing Data’s Appearance Based on Its Value
        5. Making Printouts Easier to Follow
        6. Positioning Data on a Printout
        7. Key Points
      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
        4. Key Points
    11. III. Microsoft Office Access 2003
      1. 9. 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
        6. Key Points
      2. 10. Simplifying Data Entry with Forms
        1. Creating a Form by Using a Wizard
        2. Refining Form Properties
        3. Refining Form Layout
        4. Adding Controls to a Form
        5. Using Visual Basic for Applications to Enter Data in a Form
        6. Creating a Form by Using an AutoForm
        7. Adding a Subform to a Form
        8. Key Points
      3. 11. Locating Specific Information
        1. Sorting Information
        2. Filtering Information in a Table
        3. Filtering By Form
        4. Locating Information That Matches Multiple Criteria
        5. Creating a Query in Design View
        6. Creating a Query with a Wizard
        7. Performing Calculations in a Query
        8. Key Points
      4. 12. Keeping Your Information Accurate
        1. Using Data Type Settings to Restrict Data
        2. Using Field Size Properties to Restrict Data
        3. Using Input Masks to Restrict Data
        4. Using Validation Rules to Restrict Data
        5. Using Lookup Lists to Restrict Data
        6. Updating Information in a Table
        7. Deleting Information from a Table
        8. Key Points
    12. IV. Microsoft Office PowerPoint 2003
      1. 13. Creating Presentations
        1. Getting Started with PowerPoint
        2. Opening, Saving, and Closing a Presentation
        3. Viewing a Presentation
        4. Creating a Presentation Based on Content
        5. Creating a Presentation Based on Design
        6. Creating a New Blank Presentation
        7. Key Points
      2. 14. Working with Slides
        1. Creating Slides and Entering Text
        2. Changing the Layout of a Slide
        3. Inserting Slides from Another Presentation
        4. Rearranging a Presentation
        5. Entering Speaker Notes
        6. Key Points
      3. 15. Working with Slide Text
        1. Adding and Manipulating Text
        2. Changing Size, Alignment, and Spacing
        3. Finding and Replacing Text and Fonts
        4. Correcting Text While Typing
        5. Checking Spelling and Presentation Styles
        6. Choosing the Best Word
        7. Key Points
      4. 16. Setting Up and Delivering Slide Shows
        1. Taking a Presentation on the Road
        2. Delivering a Slide Show
        3. Customizing a Slide Show
        4. Adding Slide Timings
        5. Using Microsoft Producer to Set Up an Online Broadcast
        6. Key Points
    13. V. Microsoft Office Outlook 2003
      1. 17. Working with Outlook
        1. Starting Outlook for the First Time
        2. Reading Messages and Opening Attachments
        3. Responding to Messages
        4. Creating New Messages
        5. Using Address Books
        6. Attaching Files to Messages
        7. Sending and Receiving Messages
        8. Printing Messages
        9. Creating and Sending Instant Messages
        10. Key Points
      2. 18. Managing E-Mail Messages
        1. Formatting Messages
        2. Changing Message Settings and Delivery Options
        3. Customizing How You View Messages
        4. Managing Messages with Color
        5. Adding Signatures to Messages
        6. Flagging Messages for Follow-Up
        7. Key Points
      3. 19. Finding and Organizing E-Mail Messages
        1. Finding and Categorizing Messages
        2. Using Search Folders
        3. Filtering Messages
        4. Managing Messages through Rules
        5. Organizing Messages in Folders
        6. Sharing Folders with Others
        7. Saving Messages in Other Formats
        8. Archiving Messages
        9. Key Points
      4. 20. Managing Your Calendar
        1. Looking at Calendars in Different Ways
        2. Scheduling Appointments and Events
        3. Managing and Organizing Appointments
        4. Working with Multiple Calendars
        5. Defining Your Available Time
        6. Labeling Appointments with Color
        7. Printing Calendars
        8. Key Points
      5. 21. Scheduling and Managing Meetings
        1. Scheduling Meetings
        2. Responding to Meeting Requests
        3. Updating and Canceling Meetings
        4. Viewing Other Users’ Calendars
        5. Saving a Calendar as a Web Page
        6. Key Points
    14. VI. Microsoft Office FrontPage 2003
      1. 22. Understanding How FrontPage Works
        1. Looking Around in FrontPage
        2. Exploring an Existing Web Site
        3. Looking at a Web Site in Various Ways
        4. Exploring an Existing Web Page
        5. Understanding FrontPage Web Site Concepts
        6. Key Points
      2. 23. Creating a Web Site to Promote Yourself or Your Company
        1. Creating a New Web Site by Using a Template
        2. Creating a New Web Site by Using a Wizard
        3. Inserting and Editing Text
        4. Reusing Existing Text
        5. Formatting Text
        6. Inserting Hyperlinks
        7. Seeing Your Web Site as Visitors Will
        8. Deleting a Web Site
        9. Key Points
      3. 24. Presenting Information in Lists and Tables
        1. Creating Bulleted and Numbered Lists
        2. Creating Tables
        3. Entering Information in a Table
        4. Editing the Structure of a Table
        5. Formatting a Table
        6. Splitting a Table into Separate Tables
        7. Key Points
      4. 25. Enhancing Your Web Site with Graphics
        1. Adding Pictures to a Web Page
        2. Editing and Formatting Pictures
        3. Creating and Displaying Thumbnails
        4. Adding a Line, Shape, or Drawing to a Web Page
        5. Creating a Photo Gallery
        6. Adding Fancy Text to a Web Page
        7. Key Points
    15. VII. Microsoft Office Publisher 2003
      1. 26. Creating and Printing Publications
        1. Creating a Publication for the First Time
        2. Creating a Print Publication by Using a Design Set
        3. Creating a Publication from a Blank Page
        4. Creating and Using a Template
        5. Printing a Publication
        6. Preparing a Document for a Commercial Printing Service
        7. Key Points
      2. 27. Creating Web Sites and E-mail Messages
        1. Creating an E-mail Message by Using a Wizard
        2. Sending a Publication as an E-mail Message
        3. Creating a Web Site from Scratch
        4. Publishing a Web Site
        5. Creating a Web Site from an Existing Publication
        6. Updating a Web Site
        7. Converting a Web Publication to a Print Publication
        8. Key Points
    16. VIII. Microsoft Office OneNote 2003
      1. 28. Taking Notes
        1. Using OneNote for the First Time
        2. Adding Drawings and Images
        3. Finding and Inserting Web Clippings
        4. Adding Pages and Sub Pages
        5. Moving Notes on Pages
        6. Organizing Notes into Sections and Folders
        7. Key Points
      2. 29. Working with Notes
        1. Using Quick Notes
        2. Marking Notes with Note Flags
        3. Searching Notes
        4. Sending Notes in E-mail
        5. Creating Outlook Tasks from Notes
        6. Key Points
    17. IX. Microsoft Office InfoPath 2003
      1. 30. Working with InfoPath Forms
        1. Completing InfoPath Forms
        2. Updating Form Data
        3. Viewing and Sorting Form Data
        4. Importing and Exporting Form Data
        5. Sharing and Publishing Forms
        6. Key Points
      2. 31. Designing InfoPath Forms
        1. Modifying an Existing Form
        2. Designing a New Form
        3. Creating Form Views
        4. Validating Form Data
        5. Key Points
    18. X. Collaborating with The Microsoft Office System
      1. 32. Working in a Document Workspace
        1. Creating a Document Workspace and Managing Workspace Members
        2. Creating and Assigning Document Tasks
        3. Updating a Document in a Workspace
        4. Receiving Alerts When Information in a Workspace Changes
        5. Starting a Discussion in a Workspace
        6. Customizing a Document Workspace
        7. Key Points
      2. 33. Teaming Up in a Meeting Workspace
        1. Creating a Meeting Workspace
        2. Documenting Meeting Objectives and Agenda Items in a Workspace
        3. Posting Meeting Materials to a Workspace
        4. Creating and Assigning Meeting Tasks
        5. Customizing a Meeting Workspace
        6. Key Points
    19. Glossary
    20. Index
    21. SPECIAL OFFER: Upgrade this ebook with O’Reilly