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

Book Description

The smart way to learn the latest version of Microsoft Office—one step at a time! Build exactly the skills you need by working at your own pace through easy-to-follow lessons and hands-on practice files on CD.

Table of Contents

  1. 2007 Microsoft® Office System Step by Step
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. A Note Regarding Supplemental Files
    3. A Tour of the Office 2007 User Interface
      1. Using the "Ribbon"
        1. Command Tabs
        2. Command Sets
        3. Contextual Tools
        4. Dialog Launchers
        5. Galleries
      2. The New File Menu
      3. Quick Access Toolbar
      4. New View Controls
      5. Key Points
    4. Information for Readers Running Windows XP
      1. Managing the Practice Files
      2. Using the Start Menu
      3. Navigating Dialog Boxes
    5. Getting Help
      1. Getting Help with This Book and Its Companion CD
      2. Getting Help with an Office Program
      3. More Information
    6. Using the Book’s CD
      1. What’s on the CD?
      2. Minimum System Requirements
        1. Step-by-Step Exercises
      3. Installing the Practice Files
      4. Using the Practice Files
      5. Removing and Uninstalling the Practice Files
    7. Features and Conventions of This Book
    8. About the Authors
      1. Joyce Cox
      2. Curtis Frye
      3. Steve Lambert
      4. M. Dow Lambert III
      5. Katherine Murray
      6. Joan Lambert Preppernau
      7. Online Training Solutions, Inc. (OTSI)
    9. Quick Reference
      1. 1. Exploring Word 2007
      2. 2. Editing and Proofreading Documents
      3. 3. Changing the Look of Text
      4. 4. Presenting Information in Columns and Tables
      5. 5. Setting Up a Workbook
      6. 6. Working with Data and Data Tables
      7. 7. Performing Calculations on Data
      8. 8. Changing Document Appearance
      9. 9. Creating a Database
      10. 10. Simplifying Data Entry by Using Forms
      11. 11. Locating Specific Information
      12. 12. Keeping Your Information Accurate
      13. 13. Starting a New Presentation
      14. 14. Working with Slide Text
      15. 15. Adjusting the Layout, Order, and Look of Slides
      16. 16. Delivering a Presentation Electronically
      17. 17. Getting Started with Outlook 2007
      18. 18. Sending E-Mail Messages
      19. 19. Managing Your Inbox
      20. 20. Managing Appointments, Events, and Meetings
      21. 21. Managing Your Calendar
    10. I. Microsoft Office Word 2007
      1. 1. Exploring Word 2007
        1. Working in the Word Environment
        2. Opening, Moving Around in, and Closing a Document
        3. Displaying Different Views of a Document
        4. Creating and Saving a Document
        5. Previewing and Printing a Document
        6. Key Points
      2. 2. Editing and Proofreading Documents
        1. Making Changes to a Document
        2. Inserting Saved Text
        3. Finding the Most Appropriate Word
        4. Reorganizing a Document Outline
        5. Finding and Replacing Text
        6. Correcting Spelling and Grammatical Errors
        7. Finalizing a Document
        8. Key Points
      3. 3. Changing the Look of Text
        1. Quickly Formatting Text and Paragraphs
        2. Manually Changing the Look of Characters
        3. Manually Changing the Look of Paragraphs
        4. Creating and Modifying Lists
        5. Key Points
      4. 4. Presenting Information in Columns and Tables
        1. Presenting Information in Columns
        2. Creating a Tabular List
        3. Presenting Information in a Table
        4. Formatting Table Information
        5. Performing Calculations in a Table
        6. Using a Table to Control Page Layout
        7. Key Points
    11. II. Microsoft Office Excel 2007
      1. 5. Setting Up a Workbook
        1. Creating Workbooks
        2. Modifying Workbooks
        3. Modifying Worksheets
        4. Customizing the Excel 2007 Program Window
          1. Zooming In on a Worksheet
          2. Arranging Multiple Workbook Windows
          3. Adding Buttons to the Quick Access Toolbar
        5. Key Points
      2. 6. Working with Data and Data Tables
        1. Entering and Revising Data
        2. Moving Data Within a Workbook
        3. Finding and Replacing Data
        4. Correcting and Expanding Upon Worksheet Data
        5. Defining a Table
        6. Key Points
      3. 7. Performing Calculations on Data
        1. Naming Groups of Data
        2. Creating Formulas to Calculate Values
        3. Summarizing Data That Meets Specific Conditions
        4. Finding and Correcting Errors in Calculations
        5. Key Points
      4. 8. Changing Document Appearance
        1. Formatting Cells
        2. Defining Styles
        3. Applying Workbook Themes and Table Styles
        4. Making Numbers Easier to Read
        5. Changing the Appearance of Data Based on Its Value
        6. Adding Images to a Document
        7. Key Points
    12. III. Microsoft Office Access 2007
      1. 9. Creating a Database
        1. Creating a Database from a Template
        2. Creating a Table Manually
        3. Creating a Table by Using a Template
        4. Manipulating Table Columns and Rows
        5. Key Points
      2. 10. Simplifying Data Entry by Using Forms
        1. Creating a Form by Using the Form Tool
        2. Refining Form Properties
        3. Changing the Arrangement of a Form
        4. Adding Controls to a Form
        5. Entering Data in a Form by Using VBA
        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 in a Table
        2. Filtering Information in a Table
        3. Filtering Information by Using a Form
        4. Locating Information That Matches Multiple Criteria
        5. Creating a Query Manually
        6. Creating a Query by Using a Wizard
        7. Performing Calculations by Using a Query
        8. Key Points
      4. 12. Keeping Your Information Accurate
        1. Restricting the Type of Data in a Field
        2. Restricting the Amount of Data in a Field
        3. Specifying the Format of Data in a Field
        4. Restricting Data by Using Validation Rules
        5. Creating a Simple Lookup List
        6. Creating a Multi-Column Lookup List
        7. Updating Information in a Table
        8. Deleting Information from a Table
        9. Preventing Database Problems
        10. Key Points
    13. IV. Microsoft Office PowerPoint 2007
      1. 13. Starting a New Presentation
        1. Quickly Creating a Presentation
        2. Creating a Presentation Based on a Ready-Made Design
        3. Converting an Outline to a Presentation
        4. Reusing Existing Slides
        5. Key Points
      2. 14. Working with Slide Text
        1. Entering Text
        2. Editing Text
        3. Adding and Manipulating Text Boxes
        4. Correcting and Sizing Text While Typing
        5. Checking Spelling and Choosing the Best Words
        6. Finding and Replacing Text and Fonts
        7. Changing the Size, Alignment, Spacing, and Look of Text
        8. Key Points
      3. 15. Adjusting the Slide Layout, Order, and Look
        1. Changing the Layout of a Slide
        2. Rearranging Slides in a Presentation
        3. Applying a Theme
        4. Switching to a Different Color Scheme
        5. Using Colors That Are Not Part of the Scheme
        6. Adding Shading and Texture to the Background of a Slide
        7. Key Points
      4. 16. Delivering a Presentation Electronically
        1. Adapting a Presentation for Different Audiences
        2. Rehearsing a Presentation
        3. Preparing Speaker Notes and Handouts
        4. Preparing a Presentation for Travel
        5. Showing a Presentation
        6. Key Points
    14. V. Microsoft Office Outlook 2007
      1. 17. Getting Started with Outlook 2007
        1. Connecting to Your Primary E-Mail Account
        2. Troubleshooting the Startup Wizard
        3. Connecting to Additional E-Mail Accounts
        4. Creating Additional Outlook Profiles
        5. Personalizing Your Outlook Workspace
        6. Exploring the Advanced Toolbar
        7. Key Points
      2. 18. Sending E-Mail Messages
        1. Working in the Message Window
        2. Creating and Sending Messages
          1. Addressing Messages
          2. Sending Courtesy Copies
          3. Saving Message Drafts
        3. Attaching Files to Messages
        4. Creating and Formatting Business Graphics
        5. Personalizing the Appearance of Messages
        6. Adding Signatures to Messages Automatically
        7. Key Points
      3. 19. Managing Your Inbox
        1. Quickly Locating Messages
        2. Arranging Messages in Different Ways
        3. Organizing Messages by Using Color Categories
        4. Organizing Messages in Folders
        5. Archiving Messages
        6. Key Points
      4. 20. Managing Appointments, Events, and Meetings
        1. Working in the Calendar Item Windows
        2. Scheduling and Changing Appointments
        3. Scheduling and Changing Events
        4. Scheduling, Updating, and Canceling Meetings
        5. Responding to Meeting Requests
        6. Key Points
      5. 21. Managing Your Calendar
        1. Displaying Different Views of a Calendar
        2. Defining Your Available Time
        3. Printing a Calendar
        4. Sending Calendar Information in an E-Mail Message
        5. Linking to an Internet Calendar
        6. Working with Multiple Calendars
        7. Key Points
    15. Glossary
    16. Choose the Right Book for You
      1. Published and Upcoming Titles
        1. Plain & Simple
        2. Step by Step
        3. Inside Out
        4. Other Titles
    17. Index
    18. SPECIAL OFFER: Upgrade this ebook with O’Reilly