You are previewing Office 2007 Bible.
O'Reilly logo
Office 2007 Bible

Book Description

Completely revised for Office 2007, this “best of the Bible” presents Office you with the most useful content from leading experts like John Walkenbach, Cary Prague, Faithe Wempen, and Herb Tyson. The book features valuable information to help you—no matter your level of expertise—get up to speed on the new features in Excel, Access, Outlook, Word, and PowerPoint. You’ll quickly get savvy with the most widely used business application suite worldwide.

Table of Contents

  1. Copyright
  2. About the Authors
  3. Credits
  4. Acknowledgments
  5. Introduction
  6. Common Office Features
    1. Welcome to Microsoft Office 2007
      1. Learning About Top Office Applications
      2. Taking Advantage of Other Office Applications
      3. Starting an Application
      4. Closing an Application
      5. Finding Files
      6. Getting Help
      7. Summary
    2. Navigating in the New Office
      1. Discoverability
      2. The “Results-Oriented” User Interface
      3. Ribbons and Things
      4. The Office Button (File)
      5. Options
      6. Working with Dialog Boxes
      7. Summary
    3. Mastering Fundamental Operations
      1. Working with Files
      2. Printing a File
      3. Working with Multiple Windows
      4. Moving and Copying Information
      5. Finding and Replacing
      6. Spell Checking
      7. AutoCorrect, AutoFormat, and Smart Tags
      8. Styles and Live Preview
      9. Summary
  7. Creating Documents with Word
    1. Making a Document
      1. Creating a Blank File
      2. Creating a File from a Template
      3. Saving and File Formats
      4. Compatibility with Previous Versions of Word
      5. .docx Versus .docm
      6. Understanding .docx
      7. Navigation Tips and Tricks
      8. Views
      9. Summary
    2. Formatting 101: Font/Character Formatting
      1. The Big Picture
      2. Styles and Character/Font Formatting
      3. Character Formatting
      4. Summary
    3. Paragraph Formatting
      1. Styles and Paragraph Formatting
      2. What Exactly Is a Paragraph, Anyway?
      3. Structural Formatting
      4. Paragraph Decoration
      5. Random Bonus Tip #1 — Sort Paragraphs That Aren’t in a Table
      6. Random Bonus Tip #2 — Move Paragraphs Easily
      7. Summary
    4. Styles
      1. Styles Group
      2. Styles Task Pane
      3. Summary
    5. Page Setup and Sections
      1. Page Setup Basics
      2. Page Borders
      3. The Header and Footer Layer
      4. Header and Footer Navigation and Design
      5. Adding Header and Footer Material
      6. Themes
      7. Summary
    6. Tables and Graphics
      1. Quick Start
      2. Table Basics
      3. Table Layout and Design
      4. Inserting Pictures from Files
      5. Pictures from the Clipboard and Internet
      6. Manipulation 101
      7. Inserting Clip Art
      8. SmartArt
      9. Summary
    7. Mail Merge
      1. Understanding Data Sources
      2. Choosing the Type of Data Document
      3. Attaching a Data Source
      4. Assembling a Data Document
      5. Mail Merge Task Pane/Wizard
      6. Summary
    8. Document Security
      1. Protection Types
      2. Protecting Documents for Review
      3. Summary
  8. Making the Numbers Work with Excel
    1. Using Excel Worksheets and Workbooks
      1. What Is Excel Good For?
      2. What’s New in Excel 2007?
      3. Understanding Workbooks and Worksheets
      4. Moving Around a Worksheet
      5. Creating Your First Excel Worksheet
      6. Summary
    2. Entering and Editing Worksheet Data
      1. Exploring the Types of Data You Can Use
      2. Entering Text and Values into Your Worksheets
      3. Entering Dates and Times into Your Worksheets
      4. Modifying Cell Contents
      5. Applying Number Formatting
      6. Summary
    3. Essential Worksheet and Cell Range Operations
      1. Learning the Fundamentals of Excel Worksheets
      2. Controlling the Worksheet View
      3. Working with Rows and Columns
      4. Understanding Cells and Ranges
      5. Copying or Moving Ranges
      6. Using Names to Work with Ranges
      7. Adding Comments to Cells
      8. Summary
    4. Introducing Formulas and Functions
      1. Understanding Formula Basics
      2. Entering Formulas into Your Worksheets
      3. Editing Formulas
      4. Using Cell References in Formulas
      5. Using Formulas in Tables
      6. Correcting Common Formula Errors
      7. Tips for Working with Formulas
      8. Summary
    5. Working with Dates and Times
      1. How Excel Handles Dates and Times
      2. Date-Related Functions
      3. Time-Related Functions
      4. Summary
    6. Creating Formulas That Count and Sum
      1. Counting and Summing Worksheet Cells
      2. Basic Counting Formulas
      3. Advanced Counting Formulas
      4. Summing Formulas
      5. Conditional Sums Using a Single Criterion
      6. Conditional Sums Using Multiple Criteria
      7. Summary
    7. Getting Started Making Charts
      1. What Is a Chart?
      2. Understanding How Excel Handles Charts
      3. Creating a Chart
      4. Hands On: Creating and Customizing a Chart
      5. Working with Charts
      6. Understanding Chart Types
      7. Summary
    8. Working with Database Tables in Excel
      1. Understanding Tables (Lists) and Databases
      2. Working with a Database or Table
      3. Entering and Editing Records
      4. Sorting and Filtering Data
      5. Using Excel Data in a Mail Merge
      6. Summary
  9. Persuading and Informing with PowerPoint
    1. A First Look at PowerPoint 2007
      1. What’s New in PowerPoint 2007?
      2. Starting and Exiting PowerPoint
      3. Changing the View
      4. Zooming In and Out
      5. Enabling Optional Display Elements
      6. Opening a New Display Window
      7. Summary
    2. Creating a Presentation, Slides, and Text
      1. Starting a New Presentation
      2. Saving Your Work
      3. Closing and Reopening Presentations
      4. Creating New Slides
      5. Inserting Content from External Sources
      6. Managing Slides
      7. Using Content Placeholders
      8. Creating Text Boxes Manually
      9. Working with Text Boxes
      10. Summary
    3. Working with Layouts, Themes, and Masters
      1. Understanding Layouts and Themes
      2. Changing a Slide’s Layout
      3. Applying a Theme
      4. Changing Colors, Fonts, and Effects
      5. Creating and Managing Custom Color and Font Themes
      6. Changing the Background
      7. Working with Preset Placeholders
      8. Customizing and Creating Layouts
      9. Managing Slide Masters
      10. Managing Themes
      11. Summary
    4. Working with Tables and Charts
      1. Creating a New Table
      2. Moving Around in a Table
      3. Selecting Rows, Columns, and Cells
      4. Editing a Table’s Structure
      5. Applying Table Styles
      6. Formatting Table Cells
      7. Understanding Charts
      8. Starting a New Chart
      9. Working with Chart Data
      10. Chart Types and Chart Layout Presets
      11. Working with Labels
      12. Controlling the Axes
      13. Formatting a Chart
      14. Rotating a 3-D Chart
      15. Summary
    5. Using SmartArt Diagrams, Clip Art, and Pictures
      1. Understanding SmartArt Types and Their Uses
      2. Inserting a Diagram
      3. Editing SmartArt Text
      4. Modifying SmartArt Structure
      5. Modifying a Hierarchy Diagram Structure
      6. Formatting a Diagram
      7. Choosing Appropriate Clip Art
      8. About the Clip Organizer
      9. Inserting Clip Art on a Slide
      10. Clip Art Search Methods
      11. Working with Clip Art Collections
      12. Understanding Raster Graphics
      13. Importing Image Files into PowerPoint
      14. Sizing and Cropping Photos
      15. Compressing Images
      16. Summary
    6. Building Animation Effects, Transitions, and Support Materials
      1. Understanding Animation and Transitions
      2. Assigning Transitions to Slides
      3. Using an Animation Preset
      4. The When and How of Handouts
      5. Creating Handouts
      6. Creating Speaker Notes
      7. Printing an Outline
      8. Printing Slides
      9. Summary
    7. Delivering a Live Presentation
      1. Starting and Ending a Show
      2. Using the On-screen Show Controls
      3. Using the On-screen Pen
      4. Hiding Slides for Backup Use
      5. Giving a Presentation on a Different Computer
      6. Working with Audio-visual Equipment
      7. Summary
  10. Organizing Messages, Contacts, and Time with Outlook
    1. Fundamentals of E-Mail
      1. Setting Up Your E-Mail Accounts
      2. Modifying Account Settings
      3. Using Outlook Profiles
      4. Composing and Sending Messages
      5. Reading and Replying to Messages
      6. Understanding the Inbox Display
      7. Understanding Files and Folders
      8. Outlook Data Files
      9. Working with Outlook Folders
      10. Deleting Items and Using the Deleted Items Folder
      11. Setting Options for an Individual E-Mail Message
      12. Setting Global E-Mail Options
      13. Summary
    2. Processing and Securing E-Mail
      1. Understanding Junk E-Mail Filtering
      2. Setting Junk E-Mail Options
      3. Blocking and Allowing Specific Addresses
      4. Understanding E-Mail Rule Basics
      5. Creating a New Rule
      6. Some Rule Examples
      7. Managing Rules
      8. Protecting Against Viruses
      9. Dealing with Attachments
      10. Macro Security
      11. Using Certificates and Digital Signatures
      12. HTML Message Dangers
      13. Summary
    3. Working with Contacts
      1. Understanding Outlook Contacts
      2. The Contacts Window
      3. Adding Contacts to the Address Book
      4. Working with Distribution Lists
      5. More about Contacts
      6. Performing a Mail Merge from Your Contacts
      7. Working with Multiple Address Books
      8. Setting Contact Options
      9. Summary
    4. Working with Appointments and Tasks
      1. Understanding the Outlook Calendar
      2. Using the Calendar
      3. Working with Appointments
      4. Searching the Calendar
      5. Setting Calendar Options
      6. Understanding Tasks
      7. Using the Task View
      8. Creating a New Task
      9. Working with Assigned Tasks
      10. Other Ways of Viewing Tasks
      11. Setting Task Options
      12. Summary
  11. Designing Publications with Publisher
    1. Introducing Publisher
      1. The Publisher Workspace
      2. Using a Template to Create a Publication
      3. Working with Text
      4. Working with Graphics
      5. Working with Tables
      6. Summary
    2. Design Dazzling Publications with Publisher
      1. Adding Special Effects
      2. Using the Design Gallery
      3. Updating a Publication
      4. Fine-Tuning Objects
      5. Working with Pages
      6. Checking and Printing
      7. Preparing for Outside Printing
      8. Summary
  12. Tracking Detailed Data with Access
    1. An Introduction to Database Development
      1. The Database Terminology of Access
      2. Relational Databases
      3. Access Database Objects and Views
      4. A Five-Step Design Method
      5. Summary
    2. Creating Access Tables
      1. Getting Started with Access 2007
      2. Creating a Database
      3. The Access 2007 Environment
      4. Creating a New Table
      5. Creating tblContacts
      6. Setting the Primary Key
      7. Printing a Table Design
      8. Saving the Completed Table
      9. Manipulating Tables in a Database Window
      10. Adding Records to a Database Table
      11. Navigating Records in a Datasheet
      12. Changing Values in a Datasheet
      13. Summary
    3. Creating and Entering Data with Basic Access Forms
      1. Adding Forms Using the Ribbon
      2. Adding Controls
      3. Selecting Controls
      4. Manipulating Controls
      5. Understanding Properties
      6. Using Form View
      7. Changing Values in a Form
      8. Printing a Form
      9. Summary
    4. Selecting Data with Queries
      1. Understanding Queries
      2. Creating a Query
      3. Selecting Fields
      4. Displaying the Recordset
      5. Working with Fields
      6. Changing the Sort Order
      7. Displaying Only Selected Records
      8. Printing a Query’s Recordset
      9. Saving a Query
      10. Adding More Than One Table to a Query
      11. Working with the Table/Query Pane
      12. Adding Fields from More Than One Table
      13. Understanding Multi-Table Query Limitations
      14. Summary
    5. Presenting Data with Access Reports
      1. Understanding Reports
      2. Creating a Report with Report Wizards
      3. Printing a Report
      4. Saving the Report
      5. Summary
  13. Gathering Information
    1. Keeping Information at Hand with OneNote
      1. Who Needs OneNote and Why
      2. Touring OneNote
      3. Creating a Notebook
      4. Creating a Section
      5. Creating a Page
      6. Inserting Notes
      7. Inserting an Outlook Task
      8. Inserting a Picture or File
      9. Inserting a Screen Clipping
      10. Writing on a Page
      11. Organizing, Finding, and Sharing
      12. Summary
    2. Making Data Forms with InfoPath
      1. Understanding InfoPath
      2. Designing a Form Template
      3. Publish the Template
      4. Filling Out a Form
      5. Exporting and Merging Form Data
      6. Summary
  14. Sharing and Collaboration
    1. SharePoint
      1. Accessing Your SharePoint Server
      2. Workspace Management and Options
      3. Server Tasks
      4. Summary
    2. Groove
      1. Groove versus SharePoint
      2. Using the Groove 2007 Client
      3. Summary
    3. Integration with Other Office Applications
      1. Excel
      2. PowerPoint
      3. Outlook
      4. Access Imports and Exports
      5. Summary
    4. Customizing Office
      1. Finding Program Options
      2. Using Common Options
      3. Top Word Options
      4. Top Excel Options
      5. Top PowerPoint Options
      6. Top Access Options
      7. Top Outlook Options
      8. Customizing the Quick Access Toolbar
    5. Optimizing Your Office Installation
      1. Activating Microsoft Office
      2. Getting Updates
      3. Adding or Removing Office Features
      4. Running Microsoft Office Diagnostics
      5. Repairing Your Installation
    6. International Support and Accessibility Features
      1. Understanding and Choosing Text Encoding in Word
      2. Enabling Editing Languages for Office Programs
      3. Language Translation Features
      4. Accessibility Features