Download Chapter
1 TokenChapter 1. Getting Started with Office 2007

Section 1.1. An Introduction to Microsoft Office 2007

Section 1.2. Install Office 2007

Section 1.3. Add or Remove Office 2007 Features

Section 1.4. Run Office Diagnostics

Section 1.5. Start and Exit a Program

Section 1.6. Using the Office Button

Download Chapter
1 TokenChapter 2. Working with Office Documents

Section 2.1. Create a New Document

Section 2.2. Open a Document

Section 2.3. Work with Multiple Windows

Section 2.4. Save and Close a Document

Section 2.5. Save in Different Versions

Section 2.6. Using Vista Search Features

Section 2.7. Explore the Contextual Ribbon

Section 2.8. Preview Galleries and Themes

Section 2.9. Get Help

Download Chapter
1 TokenChapter 3. Getting Started with Word

Section 3.1. An Introduction to Word

Section 3.2. Explore the Contextual Ribbon

Section 3.3. Type and Select Text

Section 3.4. Insert and Delete Text

Section 3.5. Move or Copy Text

Section 3.6. Move through a Document

Section 3.7. Undo Changes

Section 3.8. Insert a Page Break

Section 3.9. Find Text

Section 3.10. Replace Text

Section 3.11. Using AutoCorrect

Section 3.12. Using Contextual Spell Check

Section 3.13. Check Grammar

Section 3.14. Using the Thesaurus

Section 3.15. Count Words

Section 3.16. Create and Insert a Quick Parts Entry

Section 3.17. Insert Date and Time

Section 3.18. Insert Symbols or Special Characters

Download Chapter
1 TokenChapter 4. Formatting Text

Section 4.1. Bold, Italicize, and Underline Text

Section 4.2. Change the Font Style

Section 4.3. Change the Font Size

Section 4.4. Highlight Text

Section 4.5. Align Text

Section 4.6. Indent Paragraphs

Section 4.7. Set Tabs

Section 4.8. Change Line and Paragraph Spacing

Section 4.9. Add Bullets

Section 4.10. Create a Numbered List

Section 4.11. Apply a Quick Style

Section 4.12. Create a Quick Style

Section 4.13. Modify a Quick Style

Section 4.14. Copy Formatting

Section 4.15. Show or Hide Formatting

Section 4.16. Change AutoFormat Options

Download Chapter
1 TokenChapter 5. Changing Document Appearance

Section 5.1. Change the Document View

Section 5.2. Using Outline View

Section 5.3. Change Margins

Section 5.4. Align Text on a Page

Section 5.5. Change Page Orientation

Section 5.6. Add Page Numbers

Section 5.7. Add a Header or Footer

Section 5.8. Add Footnotes or Endnotes

Section 5.9. Add and View Comments

Section 5.10. Create Columns

Section 5.11. Create New Documents from Templates

Section 5.12. Apply a Theme to a Document

Section 5.13. Using the Building Blocks Organizer

Download Chapter
1 TokenChapter 6. Creating Tables

Section 6.1. Create a Table

Section 6.2. Type Text in a Table

Section 6.3. Sort Text

Section 6.4. Change Column Width

Section 6.5. Erase Lines

Section 6.6. Add or Delete a Row or Column

Section 6.7. Move or Resize a Table

Section 6.8. Change Table Borders

Section 6.9. Add Shading or Color to Cells

Section 6.10. Change Text Position in Cells

Section 6.11. Using Table Styles with Galleries

Section 6.12. Using Quick Tables

Download Chapter
1 TokenChapter 7. Working with Graphics

Section 7.1. Insert a Picture

Section 7.2. Add a Clip Art Image

Section 7.3. Add Shapes

Section 7.4. Add a SmartArt Graphic

Section 7.5. Move, Copy, or Resize a Graphic

Section 7.6. Change the Position of a Graphic

Section 7.7. Change Graphic Colors and Add Effects

Download Chapter
1 TokenChapter 8. Completing Documents

Section 8.1. Work with Reviewers

Section 8.2. Compare Multiple Versions

Section 8.3. Using the Document Inspector

Section 8.4. Preview a Document

Section 8.5. Print a Document

Section 8.6. An Introduction to Mail Merge

Section 8.7. Create a Letter with Mail Merge

Section 8.8. Print Mailing Labels

Section 8.9. Print an Envelope

Section 8.10. Output to PDF and XPS Formats

Download Chapter
1 TokenChapter 9. Getting Started with Excel

Section 9.1. An Introduction to Excel

Section 9.2. Start Excel

Section 9.3. Parts of the Excel Screen

Section 9.4. Explore the Excel Ribbon

Section 9.5. Type Text

Section 9.6. Type Numbers

Section 9.7. Edit or Delete Data

Section 9.8. Move or Copy Data

Section 9.9. Bold, Italicize, or Underline Text

Section 9.10. Apply a Number Style to Cells

Section 9.11. Format Numbers

Section 9.12. Change Font or Font Size

Section 9.13. Change Font or Fill Color

Section 9.14. Apply Special Font Effects

Section 9.15. Change Data Alignment

Section 9.16. Add Borders

Section 9.17. Copy Formatting

Section 9.18. Clear Formatting

Section 9.19. Apply Cell Styles

Section 9.20. Check Spelling

Section 9.21. Share a Workbook

Download Chapter
1 TokenChapter 10. Working with Worksheets

Section 10.1. Insert a Row or Column

Section 10.2. Delete a Row or Column

Section 10.3. Hide or Unhide a Column

Section 10.4. Change Column Width or Row Height

Section 10.5. Add or Delete a Worksheet

Section 10.6. Rename a Worksheet

Section 10.7. Move or Copy a Worksheet

Download Chapter
1 TokenChapter 11. Working with Data, Formulas, and Functions

Section 11.1. Find Data

Section 11.2. Fill a Series

Section 11.3. Enter Dates and Times

Section 11.4. Using AutoComplete

Section 11.5. Using Cell and Range Names

Section 11.6. Select a Range of Cells

Section 11.7. Protect Cells

Section 11.8. Using a Data Table

Section 11.9. Sort Data in a Table

Section 11.10. Filter Data in a Table

Section 11.11. Add Subtotals to a Range

Section 11.12. An Introduction to Formulas and Functions

Section 11.13. Sum Numbers

Section 11.14. Enter and Edit Formulas

Section 11.15. Copy a Formula

Section 11.16. Enter a Function

Section 11.17. Using the Function Library

Section 11.18. Audit Formulas

Section 11.19. Using the Watch Window

Download Chapter
1 TokenChapter 12. Creating Charts and PivotTables

Section 12.1. An Introduction to Charts

Section 12.2. Create a Chart

Section 12.3. Change the Chart Type

Section 12.4. Format Chart Elements

Section 12.5. Move or Resize a Chart

Section 12.6. Delete a Chart

Section 12.7. Add Data to a Chart

Section 12.8. Print a Chart

Section 12.9. Change Chart Shapes

Section 12.10. Apply Chart Shape Effects

Section 12.11. An Introduction to PivotTables

Section 12.12. Create and Use a PivotTable

Section 12.13. Create a PivotTable Chart

Download Chapter
1 TokenChapter 13. Working with Graphics

Section 13.1. Add Shapes

Section 13.2. Add a SmartArt Graphic

Section 13.3. Move or Resize a Graphic

Section 13.4. Add a Text Box

Section 13.5. Add a Clip Art Image

Section 13.6. Work with Graphics and Special Effects

Section 13.7. An Introduction to Conditional Formats

Section 13.8. Using Conditional Formats with Rules

Section 13.9. Using Conditional Formats with Graphics

Download Chapter
1 TokenChapter 14. Printing Worksheets

Section 14.1. Preview a Worksheet

Section 14.2. Change Margins

Section 14.3. Using Page Break Preview

Section 14.4. Fit a Worksheet to a Page or Pages

Section 14.5. Repeat Row or Column Headings

Section 14.6. Add a Header or Footer

Section 14.7. Create a Custom Header or Footer

Section 14.8. Change Page Orientation

Section 14.9. Change Print Options

Section 14.10. Print a Worksheet

Download Chapter
1 TokenChapter 15. Getting Started with PowerPoint

Section 15.1. An Introduction to PowerPoint

Section 15.2. Create a Blank Presentation

Section 15.3. Parts of the PowerPoint Screen

Section 15.4. Explore the PowerPoint Ribbon

Section 15.5. Using Online Content Presentations

Section 15.6. Add a Slide

Section 15.7. Select Text

Section 15.8. Add and Edit Text

Section 15.9. Move or Copy Text

Section 15.10. Resize, Add, or Delete Text Boxes

Section 15.11. Using Slide Layouts

Download Chapter
1 TokenChapter 16. Formatting a Presentation

Section 16.1. Change Font Style or Font Size

Section 16.2. Bold, Italicize, or Underline Text

Section 16.3. Change Text Alignment

Section 16.4. Change Text Color

Section 16.5. Copy Formatting

Section 16.6. Format Bulleted and Numbered Lists

Section 16.7. Change the Background Style

Section 16.8. Using a Design Template

Section 16.9. Format a Presentation with Themes

Section 16.10. Save a Custom Theme

Section 16.11. Move Slides between Presentations

Download Chapter
1 TokenChapter 17. Adding Objects to Slides

Section 17.1. Add a Table with Text

Section 17.2. Format a Table

Section 17.3. Add a Chart

Section 17.4. Edit or Format a Chart

Section 17.5. Add a Clip Art Image

Section 17.6. Add a Picture

Section 17.7. Add a Shape

Section 17.8. Add WordArt Styles

Section 17.9. Add or Edit a Header or Footer

Section 17.10. Convert Bullets to SmartArt Graphics

Section 17.11. Add Special Effects to Graphics

Section 17.12. Animate Slide Objects

Section 17.13. Using Custom Animation

Download Chapter
1 TokenChapter 18. Fine-Tuning a Presentation

Section 18.1. Change Views

Section 18.2. Browse a Presentation

Section 18.3. Using the Slide Master

Section 18.4. Rearrange Slides

Section 18.5. Delete a Slide

Section 18.6. Hide a Slide

Section 18.7. Using the Selection Pane

Section 18.8. Add Slide Transitions

Section 18.9. Rehearse a Slide Show

Section 18.10. Set Up a Slide Show

Section 18.11. Preview a Slide Show

Section 18.12. Create Speaker Notes

Section 18.13. Check Spelling

Section 18.14. Set Up a Presentation for Printing

Section 18.15. Print a Presentation

Section 18.16. Present with a Projector

Download Chapter
1 TokenChapter 19. Getting Started with Access

Section 19.1. An Introduction to Access

Section 19.2. Parts of a Database

Section 19.3. Plan a Database

Section 19.4. Start Access

Section 19.5. Create a Blank Database

Section 19.6. Create a Database Using a Template

Section 19.7. Explore the Contextual Ribbon

Section 19.8. Using the Navigation Pane

Section 19.9. Parts of the Database Window

Section 19.10. Rename or Delete an Object

Section 19.11. Open and Save a Database

Download Chapter
1 TokenChapter 20. Creating and Editing Data

Section 20.1. Create a Table

Section 20.2. Create a Table Using Templates

Section 20.3. Add Fields from Templates

Section 20.4. Enter Data in a Table

Section 20.5. Understanding Data Types

Section 20.6. Open a Table

Section 20.7. Add or Delete Records

Section 20.8. Move through Records

Section 20.9. Select Data

Section 20.10. Edit Data

Section 20.11. Zoom Into a Cell

Section 20.12. Change Column Width

Section 20.13. Hide a Field

Section 20.14. Freeze a Field

Section 20.15. Embed Attachment Files in Fields

Download Chapter
1 TokenChapter 21. Changing Table Design

Section 21.1. Switch between Datasheet and Design Views

Section 21.2. Rearrange Fields

Section 21.3. Display Field Properties

Section 21.4. Add a Field Description

Section 21.5. Change the Data Type

Section 21.6. Rename a Field

Section 21.7. Change the Field Size

Section 21.8. Select a Data Format

Section 21.9. Change the Number of Decimal Places

Section 21.10. Add or Delete a Field

Section 21.11. Add a Caption

Section 21.12. Add a Default Value

Section 21.13. Require an Entry

Section 21.14. Add a Validation Rule

Section 21.15. Create a Yes/No Field

Section 21.16. Create a Lookup Column

Section 21.17. Using a Lookup Column to Enter Data

Section 21.18. Create an Index

Section 21.19. Set the Primary Key

Section 21.20. Display a Subdatasheet

Section 21.21. Define Relationships between Tables

Download Chapter
1 TokenChapter 22. Creating Forms

Section 22.1. Create a Form Using a Wizard

Section 22.2. Open a Form

Section 22.3. Move through Records with a Form

Section 22.4. Edit Data Using a Form

Section 22.5. Add a Record

Section 22.6. Add a Field to a Form

Section 22.7. AutoFormat a Form

Section 22.8. Change a Form Control

Section 22.9. Change the Appearance of Form Controls

Section 22.10. Change Form Control Colors and Gridlines

Section 22.11. Using Conditional Formats

Download Chapter
1 TokenChapter 23. Finding and Querying Data

Section 23.1. Find Data

Section 23.2. Sort Records

Section 23.3. Filter Data

Section 23.4. Filter Data by Form

Section 23.5. Create a Query Using the Simple Query Wizard

Section 23.6. Create a Query in Design View

Section 23.7. Open a Query

Section 23.8. Change the Query View

Section 23.9. Set Criteria

Section 23.10. Examples of Criteria

Section 23.11. Sort Query Results

Section 23.12. Perform Calculations

Section 23.13. Summarize Data

Section 23.14. Connect an InfoPath Web Form

Download Chapter
1 TokenChapter 24. Creating Reports

Section 24.1. Create a Report Using the Report Wizard

Section 24.2. Open a Report

Section 24.3. Change the Report View

Section 24.4. Preview a Report

Section 24.5. Print Data from a Database

Section 24.6. An Introduction to Interactive Design Modes

Section 24.7. Create Mailing Labels Using the Label Wizard

Download Chapter
1 TokenChapter 25. Getting Started with Outlook

Section 25.1. An Introduction to Outlook

Section 25.2. Start Outlook

Section 25.3. Using the Outlook To-Do Bar

Section 25.4. Using the Navigation Pane

Section 25.5. Read Messages

Section 25.6. Create a New Message

Section 25.7. Select a Name from the Address Book

Section 25.8. Attach a File to a Message

Section 25.9. Open and Save Attachments

Section 25.10. Reply to or Forward a Message

Section 25.11. Preview Messages and Attachments

Download Chapter
1 TokenChapter 26. Organizing E-Mail

Section 26.1. Open E-mail Folders

Section 26.2. Print a Previewed Message

Section 26.3. Delete a Message

Section 26.4. Create a New Mail Folder

Section 26.5. Move a Message

Section 26.6. Archive Messages

Section 26.7. Format a Message

Section 26.8. Sort or Find Messages

Section 26.9. Sort Messages Using Rules

Section 26.10. Using the Spam Filter

Section 26.11. Using RSS Feeds in Outlook

Download Chapter
1 TokenChapter 27. Managing Personal Information

Section 27.1. View the Calendar

Section 27.2. Create New Appointments

Section 27.3. Print a Calendar

Section 27.4. Share a Calendar

Section 27.5. Add Contacts

Section 27.6. Organize Contacts with Categories

Section 27.7. Create a Task List

Section 27.8. Manage a Task List

Section 27.9. Keep Personal Notes

Download Chapter
1 TokenChapter 28. Getting Started with OneNote

Section 28.1. An Introduction to OneNote

Section 28.2. Start OneNote

Section 28.3. Create a New Section

Section 28.4. Add a New Page

Section 28.5. Work with Pages

Section 28.6. Note a Web Page

Section 28.7. Find Text

Section 28.8. Change Font Style or Font Size

Section 28.9. Bold, Italicize, or Underline Text

Section 28.10. Change Text Color

Section 28.11. Indent Text

Section 28.12. Add Numbers or Bullets

Section 28.13. Using Tags for Organization

Section 28.14. Add an Outlook Task

Section 28.15. Add a Picture

Section 28.16. Using the All Notebooks Window

Section 28.17. Protect and Back Up Your Notebook

Section 28.18. Share Notes

Section 28.19. Start a OneNote Shared Session

Download Chapter
1 TokenChapter 29. Collaborating with Office System 2007

Section 29.1. An Introduction to Live Meeting

Section 29.2. Start a Live Meeting Conference

Section 29.3. Present PowerPoint in Live Meeting

Section 29.4. Poll in Live Meeting

Section 29.5. An Introduction to SharePoint Workspaces

Section 29.6. Using Files in SharePoint

Section 29.7. Using a PowerPoint Slide Library

Section 29.8. Using a Team Discussion

Section 29.9. An Introduction to Groove Workspaces

Section 29.10. Explore Vista Meeting Space

Download Chapter
1 TokenAppendix A. What's on the CD-ROM

Download Chapter
1 TokenChapter Bonus Chapter 1. Getting Started with Publisher

Section BC1.1. Start Publisher

Section BC1.2. Parts of the Publisher Screen

Section BC1.3. Create a New Publication

Section BC1.4. Insert a New Page

Section BC1.5. Move through a Publication

Section BC1.6. Insert Text in a Text Box

Section BC1.7. Using the Zoom Tools

Section BC1.8. Insert or Delete Text

Section BC1.9. Arrange Text Using AutoFlow

Download Chapter
1 TokenChapter Bonus Chapter 2. Working with Graphics

Section BC2.1. Add a Clip Art Image

Section BC2.2. Insert a Picture

Section BC2.3. Move or Resize a Graphic

Section BC2.4. Wrap Text Around a Graphic

Section BC2.5. Create a Table

Section BC2.6. Using the Design Gallery

Section BC2.7. Using the Content Library

Download Chapter
1 TokenChapter Bonus Chapter 3. Reviewing and Printing Your Publication

Section BC3.1. Using the Design Checker

Section BC3.2. Add a Header or Footer

Section BC3.3. Preview a Publication

Section BC3.4. Print a Publication