2007 Microsoft® Office System Step by Step, 2nd Edition

Larger Cover

By Joyce Cox, Curtis D. Frye, M. Dow Lambert III, Steve Lambert, John Pierce, Joan Lambert

Publisher: Microsoft Press

Released: March 2008

Pages: 960

The smart way to learn Microsoft Office—one step at a time! The second edition of this popular book features new and expanded content. In addition to covering familiar Microsoft Office applications such as Microsoft Office Access™ 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Word 2007—you now also get coverage of Microsoft Office Publisher 2007, SharePoint® Server 2007, Groove® 2007, OneNote® 2007, and InfoPath® 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. Learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. And discover how to get your Web site up and running, take notes electronically, and 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!

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Microsoft Office Word 2007
1. Chapter 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. Chapter 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. Chapter 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. Chapter 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
Microsoft Office Excel 2007
1. Chapter 5 Setting Up a Workbook
  1. Creating Workbooks
  2. Modifying Workbooks
  3. Modifying Worksheets
  4. Customizing the Excel 2007 Program Window
  5. Key Points
2. Chapter 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. Chapter 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. Chapter 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
Microsoft Office Access 2007
1. Chapter 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. Chapter 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. Chapter 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. Chapter 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
Microsoft Office PowerPoint 2007
1. Chapter 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. Chapter 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. Chapter 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. Chapter 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
Microsoft Office Outlook 2007
1. Chapter 17 Sending E-Mail Messages
  1. Working in the Message Window
  2. Creating and Sending Messages
  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. Chapter 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. Chapter 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. Chapter 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
Microsoft Office Publisher 2007
1. Chapter 21 Creating Colorful Cards and Calendars
  1. Storing Personal and Company Information
  2. Creating Folded Cards
  3. Creating Postcards
  4. Creating Calendars
  5. Packaging Publications for Printing
  6. Key Points
2. Chapter 22 Creating Text-Based Publications
  1. Planning Longer Publications
  2. Creating Newsletters
  3. Organizing Content
  4. Editing and Proofing Content
  5. Key Points
Microsoft Office OneNote 2007
1. Chapter 23 Collecting Information in a Notebook
  1. Understanding Notebooks
  2. Understanding Note Containers
  3. Entering Content Directly onto a Page
  4. Sending Content to OneNote
  5. Capturing Audio and Video Notes
  6. Quickly Capturing Notes
  7. Key Points
2. Chapter 24 Organizing and Locating Information
  1. Moving and Removing Information
  2. Tagging Notes
  3. Searching for Information
  4. Key Points
Microsoft Office Groove 2007
1. Chapter 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. Chapter 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
  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
Collaboration
1. Chapter 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

Glossary

Title:

2007 Microsoft® Office System Step by Step, 2nd Edition

By:

Joyce Cox, Curtis D. Frye, M. Dow Lambert III, Steve Lambert, John Pierce, Joan Lambert

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

March 2008

Ebook:

February 2010

Pages:

960

Print ISBN:

978-0-7356-2531-0

| ISBN 10:

0-7356-2531-X

Ebook ISBN:

978-0-7356-3910-2

| ISBN 10:

0-7356-3910-8

Joyce Cox

Joyce Cox has 20+ years of experience developing training materials on technical subjects for non-technical audiences, specializing in Office and Windows® technologies.

View Joyce Cox's full profile page.
Curtis D. Frye

Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

View Curtis D. Frye's full profile page.
John Pierce

John Pierce is a writer with Microsoft's Information Worker New Markets group and a former editor and writer at Microsoft Press®. He is the author of Microsoft Office Access® 2003 Inside Track.

View John Pierce's full profile page.
Joan Lambert

Joan Lambert is the author of more than a dozen books on Windows® and Office, including several popular STEP BY STEP titles from Microsoft Press®.

View Joan Lambert's full profile page.