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

Book Description

Long Description
The smart way to learn the latest version of Microsoft Office one step at a time! Updated with expanded coverage, this second edition covers Microsoft Office Publisher 2007, Office SharePoint® Server 2007, Office Groove® 2007, Office OneNote® 2007, and Office InfoPath® 2007. Plus, you still get coverage of the familiar Microsoft Office applications Office AccessTM 2007, Office Excel® 2007, Office Outlook® 2007, Office PowerPoint® 2007, and Office Word 2007. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to learn the fundamentals of working with the 2007 Microsoft Office system, including how to navigate the new user interface. You will learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. You will also discover how to get your Web site up and running, how to take notes electronically, and how to manage your e-mail communications and workday. The companion CD includes skill-building practice files, eBooks, and more! With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction building and practicing the skills you need, just when you need them!
Key Book Benefits:

Allows you to learn how to use Microsoft Office 2007 by taking just the lessons you need or by working from cover to cover you set the pace
Features easy-to-follow lessons and hands-on skill-building exercises
Includes an introduction to the new user interface and coverage of Word 2007, Excel 2007, Access 2007, PowerPoint 2007, and Outlook 2007. Expanded, this second edition also includes coverage of Publisher 2007, SharePoint Server 2007, Groove 2007, OneNote 2007, and InfoPath 2007.
Includes a companion CD with skill-building practice files, an eBook, and sample chapters from other popular books

Table of Contents

  1. 2007 Microsoft® Office System Step by Step, Second Edition
  2. A Note Regarding Supplemental Files
  3. Your All-in-One Resource
  4. Introducing the 2007 Microsoft Office System
    1. The Microsoft Office Fluent User Interface
    2. Certification
  5. Information for Readers Running Windows XP
    1. Managing the Practice Files
    2. Using the Start Menu
    3. Navigating Dialog Boxes
  6. Features and Conventions of This Book
  7. Using the Companion CD
    1. What’s on the CD?
    2. Minimum System Requirements
    3. Installing the Practice Files
    4. Using the Practice Files
    5. Removing and Uninstalling the Practice Files
  8. Getting Help
    1. Getting Help with This Book and Its Companion CD
    2. Getting Help with an Office Program
    3. More Information
  9. About the Authors
    1. Joyce Cox
    2. Curtis Frye
    3. M. Dow Lambert III
    4. Steve Lambert
    5. John Pierce
    6. Joan Preppernau
    7. Online Training Solutions, Inc. (OTSI)
  10. Quick Reference
    1. Part I Microsoft Office Word 2007
      1. Exploring Word 2007
      2. Editing and Proofreading Documents
      3. Changing the Look of Text
      4. Presenting Information in Columns and Tables
    2. Part II Microsoft Office Excel 2007
      1. Setting Up a Workbook
      2. Working with Data and Data Tables
      3. Performing Calculations on Data
      4. Changing Workbook Appearance
    3. Part III Microsoft Office Access 2007
      1. Creating a Database
      2. Simplifying Data Entry by Using Forms
      3. Locating Specific Information
      4. Keeping Your Information Accurate
    4. Part IV Microsoft Office PowerPoint 2007
      1. Starting a New Presentation
      2. Working with Slide Text
      3. Adjusting the Layout, Order, and Look of Slides
      4. Delivering a Presentation Electronically
    5. Part V Microsoft Office Outlook 2007
      1. Sending E-Mail Messages
      2. Managing Your Inbox
      3. Managing Appointments, Events, and Meetings
      4. Managing Your Calendar
    6. Part VI Microsoft Office Publisher 2007
      1. Creating Colorful Cards and Calendars
      2. Creating Text-Based Publications
    7. Part VII Microsoft Office OneNote 2007
      1. Collecting Information in a Notebook
      2. Organizing and Locating Information
    8. Part VIII Microsoft Office Groove 2007
      1. Setting Up a Standard Workspace
      2. Managing and Sharing Files
    9. Part IX Collaboration
      1. Enabling Collaboration by Using SharePoint
  11. 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
  12. 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 Workbook 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 Documents
      7. Key Points
  13. 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 from 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
  14. 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 Layout, Order, and Look of Slides
      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
  15. V. Microsoft Office Outlook 2007
    1. 17. 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
    2. 18. 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
    3. 19. 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
    4. 20. Managing Your Calendar
      1. Displaying Different Views of a Calendar
      2. Defining Your Available Time
      3. Configuring Outlook for Multiple Time Zones
      4. Printing a Calendar
      5. Sending Calendar Information in an E-Mail Message
      6. Linking to an Internet Calendar
      7. Working with Multiple Calendars
      8. Key Points
  16. VI. Microsoft Office Publisher 2007
    1. 21. Creating Colorful Cards and Calendars
      1. Storing Personal and Company Information
      2. Creating Folded Cards
        1. Choosing a Design or Layout
        2. Changing the Color Scheme
        3. Using Non-Color-Scheme Colors
        4. Choosing Text
      3. Creating Postcards
        1. Printing Both Sides of Thick Paper
        2. Using Mail Merge
      4. Creating Calendars
        1. Adding Captions, Credits, and Copyrights
        2. Changing the Background
        3. Working with the Master Page
      5. Packaging Publications for Printing
      6. Key Points
    2. 22. Creating Text-Based Publications
      1. Planning Longer Publications
      2. Creating Newsletters
        1. Copyfitting Text
        2. Inserting Pages
      3. Organizing Content
        1. Working with a Table of Contents
        2. Creating Sections
        3. Moving Content
        4. Solving Organization Problems
      4. Editing and Proofing Content
        1. Editing Content in Word
        2. Correcting Spelling Errors
        3. Controlling Hyphenation
      5. Key Points
  17. VII. Microsoft Office OneNote 2007
    1. 23. Collecting Information in a Notebook
      1. Understanding Notebooks
      2. Understanding Note Containers
      3. Entering Content Directly onto a Page
        1. Referencing External Files
        2. Creating Handwritten Notes
      4. Sending Content to OneNote
        1. Collecting Screen Clippings
        2. Collecting Web Notes
      5. Capturing Audio and Video Notes
        1. Recording Audio
        2. Recording Video
        3. Playing Back a Recording
      6. Quickly Capturing Notes
      7. Key Points
    2. 24. Organizing and Locating Information
      1. Moving and Removing Information
        1. Manipulating Objects on a Page
        2. Moving Pages, Sections, and Notebooks
        3. Accessing Information from Multiple Locations
      2. Tagging Notes
      3. Searching for Information
      4. Key Points
  18. VIII. Microsoft Office Groove 2007
    1. 25. Setting Up a Standard Workspace
      1. Creating a Standard Workspace
      2. Sending and Accepting Workspace Invitations
      3. Working in the Workspace Members Pane
      4. Changing the Role of a Workspace Member
      5. Changing Permissions Assigned to a Workspace Role
      6. Exploring a Groove Workspace
      7. Adding Files to the Files Tool
      8. Adding a Tool to a Standard Workspace
      9. Key Points
    2. 26. Managing and Sharing Files
      1. Adding Folders and Files to the Files Tool
      2. Working with Files in the Files Tool
      3. Opening, Editing, and Saving a File in the Files Tool
      4. Specifying Download Settings for a Folder
      5. Setting Permissions in the Files Tool
      6. Specifying Alert Settings for Folders and Files
      7. Creating a File Sharing Workspace
        1. Creating a File Sharing Workspace in Windows
        2. Creating a File Sharing Workspace from the Launchbar
      8. Downloading Files in a File Sharing Workspace
      9. Changing Roles and Permissions for a File Sharing Workspace
      10. Setting Properties for a File Sharing Workspace
      11. Key Points
  19. IX. Collaboration
    1. 27. Enabling Collaboration by Using SharePoint
      1. Creating a SharePoint Team Site
      2. Creating a Document Library
      3. Managing Files in a Document Library
      4. Checking Files Into and Out of a Document Library
      5. Creating a Custom List from an Excel Workbook
      6. Working with SharePoint List Data in Access
      7. Creating a Document Workspace from an Office Document
      8. Creating a Document Workspace from Outlook
      9. Working Offline with Document Library Contents
      10. Linking a SharePoint Calendar to Outlook
      11. Key Points
  20. Glossary
  21. Index
  22. About the Authors
  23. Copyright