You are previewing 2007 Microsoft® Office System Plain & Simple.
O'Reilly logo
2007 Microsoft® Office System Plain & Simple

Book Description

Get the fast facts that make learning the 2007 Microsoft Office system plain and simple! This no-nonsense guide uses easy numbered steps and concise, straightforward language that show the most expedient ways to learn a skill or solve a problem.

Table of Contents

  1. 2007 Microsoft® Office System Plain & Simple
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. Acknowledgments
    3. 1. About This Book
      1. No Computerspeak!
        1. Useful Tasks...
        2. ...And the Easiest Way to Do Them
      2. A Quick Overview
      3. What’s New in Office 2007?
      4. A Few Assumptions
      5. A Final Word (or Two)
    4. 2. Working in Office
      1. What’s What in Office?
        1. Microsoft Office 2007 Programs
      2. Dialog Box Decisions
      3. Using the Ribbon
        1. Explore the Ribbon
        2. Set the Ribbon Display
      4. Using Menus and Toolbars
        1. Explore the Menus
        2. Use the Toolbars
        3. Use the Shortcut Menus
      5. Using Only the Keyboard
        1. Browse the Ribbon with Your Keyboard
        2. Use Keyboard Shortcuts
          1. Common Keyboard Shortcuts
      6. Moving and Copying Content
        1. Cut or Copy Text
        2. Paste the Cut or Copied Text
        3. Copy and Paste Multiple Items
      7. Getting Help
        1. Browse for Help
        2. Search for Help
      8. Saving Your Work
        1. Save the File
      9. Office’s File Formats
        1. Other File Formats for Office Programs
        2. And There’s More
    5. 3. Common Tasks in Office
      1. Working with Old Documents
        1. Convert the Document
      2. Inserting Special Characters
        1. Insert a Character
      3. Inserting Pictures
        1. Insert a Picture
      4. Changing the Size of a Picture
        1. Trim It
        2. Size It
      5. Editing a Picture
        1. Change Its Appearance
        2. Rotate It
        3. Add an Effect
      6. Adding Shapes
        1. Draw a Shape
      7. Adding Clip Art
        1. Find and Insert Clip Art
      8. Formatting a Shape
        1. Format the Shape
      9. Inserting the Date and Time
        1. Insert the Date and/or Time
      10. Creating Stylized Text
        1. Create Some WordArt
        2. Fine-Tune the Result
      11. Inserting a Relational Diagram
        1. Create a Diagram
        2. Modify the Diagram
      12. Researching a Subject
        1. Do Some Research
    6. 4. Viewing and Editing Text in Word
      1. What’s Where in Word 2007?
      2. Creating a New Document
        1. Start Word and Enter Some Text
      3. Composing Different Types of Documents
        1. Start the Document
      4. Word’s Views
        1. Print Layout View
        2. Full Screen Reading View
        3. Web Layout View
        4. Outline View
        5. Draft View
        6. Print Preview
      5. Reading a Document
        1. Read
      6. Editing Text
        1. Select and Modify Text
      7. Finding Text
        1. Find Text One Instance at a Time
        2. Find All Instances of Text
      8. Replacing Text
        1. Replace Text
      9. Correcting Your Spelling and Grammar
        1. Correct a Spelling Error
        2. Correct a Contextual Spelling Error
        3. Correct the Grammar
        4. Automatically Correct Your Misspellings
      10. Correcting Text Automatically
        1. Add Entries
      11. Adding Page Numbers
        1. Insert Page Numbers
      12. So Many Ways to Do It
        1. Text-Selection Methods
        2. Copying and Moving Methods
      13. Marking and Reviewing Changes in a Document
        1. Review a Document
        2. Review a Review
      14. Comparing Documents Side by Side
        1. View the Documents
    7. 5. Formatting in Word
      1. Controlling the Look: Themes, Styles, and Fonts
      2. Setting the Overall Look
        1. Choose a Theme
      3. Formatting Text
        1. Apply a Quick Paragraph Style
        2. Apply Character Formatting
      4. Using Any Style
        1. Access Your Styles
      5. Changing Character Fonts
        1. Change the Font
        2. Change the Font Size
      6. Setting Paragraph Alignment
        1. Set the Alignment
      7. Adjusting Paragraph Line Spacing
        1. Set the Line Spacing Within a Paragraph
        2. Set the Line Spacing Between Paragraphs
      8. Indenting a Paragraph
        1. Indent the Paragraph
      9. Formatting with Tabs
        1. Set Your Tabs
      10. Adding Emphasis and Special Formatting
        1. Format the Text
      11. Copying Your Formatting
        1. Copy the Formatting
      12. Creating a Bulleted or Numbered List
        1. Create the List
      13. Formatting a List
        1. Change the Format
      14. Creating a Table from Scratch
        1. Create the Table
      15. Using a Predesigned Table
        1. Choose a Table
      16. Creating a Table from Text
        1. Convert the Text
      17. Adding or Deleting Rows and Columns
        1. Add to the Table
        2. Delete from the Table
      18. Formatting a Table
        1. Format the Table
      19. Improving the Layout with Hyphenation
        1. Set Automatic Hyphenation
      20. Laying Out the Page
        1. Set Up a Standard Page
        2. Set Up a Two-Sided Document
        3. Set Up a Bound Document
      21. Changing Page Orientation Within a Document
        1. Change the Page Orientation
      22. Flowing Text into Columns
        1. Change the Number of Columns
      23. Creating Chapters
        1. Start a New Chapter
        2. Change the Running Heads
      24. Wrapping Text Around a Graphic
        1. Set the Text Wrapping
      25. Creating a Running Head
        1. Create a Header and a Footer
      26. Sorting Your Information
        1. Sort a Table
        2. Sort a List
      27. Reorganizing a Document
        1. View a Document’s Outline
    8. 6. Working with Special Content in Word
      1. Inserting a Cover Page
        1. Insert the Cover Page
      2. Numbering Headings
        1. Number the Headings
      3. Adding Line Numbers
        1. Number the Lines
      4. Inserting Information with Smart Tags
        1. Insert a Character
      5. Inserting an Equation
        1. Insert the Equation
      6. Adding a Sidebar or a Pull Quote
        1. Insert a Predesigned Text Box
      7. Inserting a Watermark
        1. Create the Watermark
      8. Creating Footnotes and Endnotes
        1. Insert the Footnote or Endnote
        2. Change the Reference Mark
      9. Inserting a Citation
        1. Add Existing Citations
        2. Insert a Citation
      10. Creating a Table of Contents
        1. Set the Outline Text
      11. Printing an Envelope
        1. Add the Address
      12. Printing a Mailing Label
        1. Print the Label
      13. Mail Merge: The Power and the Pain
        1. Setting Conditional Content
        2. It’s More than Letters
      14. Creating a Form Letter
        1. Set Up Your Letter
        2. Specify the Data to Be Merged
      15. Finalizing Your Document
        1. Prepare Your Document
    9. 7. Working in Excel
      1. What’s Where in Excel?
      2. Entering the Data
        1. Enter Your Data
      3. Editing the Data
        1. Replace the Data
        2. Edit the Existing Data
      4. Excel’s Eccentricities
      5. Using a Predefined Workbook
        1. Open and Use a Template
      6. Formatting Cells
        1. Format Some Cells
      7. Changing the Overall Look
        1. Choose a Theme
      8. Formatting Numbers
        1. Format Some Numbers
      9. Moving and Copying Data
        1. Move Some Content
        2. Copy or Cut Some Content
        3. Copy Content to Adjacent Cells
      10. Adding and Deleting Columns and Rows
        1. Add a Column
        2. Add a Row
        3. Delete a Column or a Row
        4. Delete Some or All Content of Cells
      11. Creating a Series
        1. Create a Series
      12. Hiding Columns and Rows
        1. Hide Columns or Rows
        2. Reveal Hidden Columns or Rows
      13. Formatting Cell Dimensions
        1. Set the Column Width
        2. Set the Row Height
        3. Adjust the Height or Width to Fit the Content
      14. Organizing Your Worksheets
        1. Name the Worksheets
        2. Change Their Order
        3. Insert a Worksheet
        4. Delete a Worksheet
      15. Setting Up the Page
        1. Set the Dimensions
        2. Set the Header and Footer
      16. Printing a Worksheet
        1. Specify What’s to be Printed
        2. Check the Layout
      17. Adding and Viewing Comments
        1. Create a Comment
        2. Review the Comments
    10. 8. Analyzing and Presenting Data in Excel
      1. Creating a Table
        1. Create a Table
        2. Use the Table
      2. Cell References, Formulas, and Functions
      3. Doing the Arithmetic
        1. Calculate a Value
          1. Arithmetic Operators
        2. Calculate the Value of Cells
      4. Summing the Data
        1. Sum the Numbers
      5. Creating a Series of Calculations
        1. Create the Series
      6. Making Calculations with Functions
        1. Find a Function
        2. Add Your Arguments
      7. Troubleshooting Formulas
        1. Review the Errors
        2. Evaluate a Formula
      8. Sorting the Data
        1. Conduct an Alphabetic or a Numeric Sort
      9. Filtering the Data
        1. Filter the Data
      10. Separating Data into Columns
        1. Separate the Data
      11. Creating Subtotals
        1. Create the Subtotals
      12. Summarizing the Data with a PivotTable
        1. Create the PivotTable
        2. Use the PivotTable
      13. Displaying Relative Values
        1. Show the Relative Value
      14. Automatically Highlighting Certain Data
        1. Set the Conditional Formatting
      15. Customizing Conditional Formatting
        1. Create a Rule
      16. The Anatomy of a Chart
      17. Charting Your Data
        1. Create a Chart
        2. Complete the Layout
      18. Formatting a Chart
        1. Change the Chart Style
        2. Change the Theme
        3. Format an Element
      19. Customizing a Chart
        1. Change a Data-Series Chart
        2. Add an Axis
      20. Reviewing the Data
        1. Freeze the Columns and/or Rows
        2. View Multiple Sections
    11. 9. Creating a PowerPoint Presentation
      1. What’s Where in PowerPoint?
      2. Creating a Presentation
        1. Set Up the Presentation
        2. Add Your Content
      3. Inserting a Table
        1. Create the Table
      4. Converting Text into a SmartArt Graphic
        1. Create the Graphic
      5. Converting Text into WordArt
        1. Convert the Text
      6. Including a Slide from Another Presentation
        1. Include the Slide
      7. Inserting Multimedia
        1. Insert a Video
        2. Insert a Sound
      8. Formatting a Slide
        1. Format the Content
        2. Format the Background
      9. Animating Items on a Slide
        1. Animate the Text
        2. Animate a SmartArt Graphic
      10. Customizing Your Animation
        1. Customize the Animation
      11. Adding an Action to a Slide
        1. Assign an Action
      12. Editing a Presentation
        1. Change the Content of the Slides
        2. Change the Order of the Slides
      13. Repeating Content on Every Slide
        1. Add the Footer
      14. Adding Transition Effects to Slides
        1. Set the Transitions
      15. Modifying the Default Layout
        1. Modify the Layout
        2. Create a New Layout
      16. Creating a Photo Album
        1. Create the Album
    12. 10. Presenting a PowerPoint Slide Show
      1. Adding Speaker Notes
        1. Create the Notes
        2. Set Up and Print the Notes
      2. Printing Handouts
        1. Create the Handouts
      3. The Perils of Presentation
      4. Running a Slide Show
        1. Run the Presentation
        2. Modify the Presentation
      5. Running a Slide Show with Dual Monitors
        1. Control the Show
      6. Customizing the Presentation
        1. Set Up the Show
      7. Recording a Narration
        1. Narrate Your Presentation
      8. Timing a Presentation
        1. Time the Presentation
      9. Creating Different Versions of a Slide Show
        1. Create a Custom Slide Show
      10. Creating a Show for Distribution
        1. Save the Show
      11. Taking Your Show on the Road
        1. Package Your Presentation
      12. Using Navigation Buttons
        1. Add Navigation Buttons
      13. Creating Pictures of Your Slides
        1. Create the Pictures
      14. Reviewing a Presentation
        1. Review the Presentation
      15. Changing Slide-Show Settings
        1. Change the Settings
    13. 11. Working with Messages in Outlook
      1. What’s Where in Outlook Messages?
        1. Overview of New Message Window
        2. Overview of the Message Window’s Insert Tab
      2. Sending E-Mail
        1. Address an E-Mail Message
        2. Type Your Message Subject and Text
      3. Receiving and Reading E-Mail
        1. Locate New Messages
        2. Open Message Items
      4. Replying to and Forwarding a Message
        1. Reply to an E-Mail Message
        2. Forward an E-Mail Message
      5. Sending or Receiving a File
        1. Attach a File
        2. Open an Attachment
      6. Formatting E-Mail Messages
        1. Use a Rich Text or HTML Message Format
        2. Add Formatting to a Message
      7. Managing Messages
        1. Mark, Unmark, and Delete Messages
        2. Move Messages Between Folders
      8. Signing Your E-Mail
        1. Using Your Signature
      9. Setting Up RSS Subscriptions
        1. Add an RSS Feed from a Quick Link
      10. Reading RSS Items
        1. Read RSS Feed
      11. Setting Up E-Mail Accounts
        1. Add an E-Mail Account
      12. E-Mailing Your Schedule
        1. Send Your Schedule via E-Mail
      13. Understanding E-Mail Encryption
    14. 12. Organizing with Outlook
      1. What’s Where in Outlook?
        1. Calendar
        2. Contacts
      2. Keeping Track of Your Schedule
        1. Use the Date Navigator
        2. Use the Calendar View
        3. Use the To-Do Bar
      3. Sharing Calendars
        1. Forward a Calendar Item
        2. Forward an Item as an iCalendar
      4. Viewing Your Group’s Schedule
        1. Create a New Group
        2. View a Group Schedule
      5. Scheduling a Meeting
        1. Create a Meeting in a Block of Time
        2. Specify a Meeting Date and Time Manually
      6. Managing Your Contacts
        1. Use E-Mail Message Information
        2. Use the Contact Window
      7. Keeping Track of Your Tasks
        1. Set the Task Name and Due Date
        2. Open the Task Item Window
        3. Use the Task List
      8. Assigning Tasks
        1. Assign a Task
      9. Tacking Up Notes
        1. Add a Note
      10. Creating and E-Mailing Contact Business Cards
        1. Create a Contact Business Card
        2. E-Mail a Contact Business Card
      11. Customizing Outlook
        1. Add or Remove a Toolbar
    15. 13. Creating a Publication in Publisher
      1. What’s Where in Publisher?
      2. Creating a Publication from a Design
        1. Use a Design
      3. Creating a Publication from Scratch
        1. Set Up Your Publication
      4. Adding Text
        1. Add Text
      5. Flowing Text Among Text Boxes
        1. AutoFlow the Text
        2. Manually Flow the Text
      6. Tweaking Your Text
        1. Improve the Look of the Text
      7. Adding a Table
        1. Insert the Table
      8. Repeating Objects on Every Page
        1. Add the Repeating Objects
      9. Modifying a Picture
        1. Modify the Picture
      10. Formatting an Object
        1. Format the Object
      11. Adding a Design Object
        1. Insert the Design Object
      12. Arranging Objects on the Page
        1. Set Up Your Grid
        2. Position an Object at an Exact Location
      13. Stacking and Grouping Objects
        1. Arrange the Objects
      14. Flowing Text Around an Object
        1. Set the Text Wrapping
      15. Reusing Content
        1. Use the Content Library
      16. Inserting Your Business Information
        1. Use Business Information
      17. Creating a Web Site in Publisher
        1. Create the Web Site
        2. Publish It!
      18. Double-Checking Your Publication
        1. Check the Design
      19. Sending a Publication as E-Mail
        1. E-Mail Your Publication
      20. Printing Your Publication
        1. The Final Step: Print It!
    16. 14. Working in Access
      1. What’s Where in Access?
        1. Surveying the Access Window
        2. Surveying the Object Window
      2. What is a Relational Database?
        1. Storing Data on Index Cards
        2. Storing Data on the Computer
        3. Storing Data in a Database
      3. Using an Existing Database
        1. Open a Database on Startup
        2. Open a Recently Used Database
      4. Creating a Database from a Template
        1. Create a Database from a Template
        2. Find Database Templates Online
      5. Adding a Table to a Database
        1. Create a New Table by Typing
      6. Modifying a Table
        1. Change a Table
      7. Adding Data to a Table
        1. Select Text
        2. Delete Text
        3. Undoing Operations
        4. Copy and Paste Text
      8. Access File Formats
      9. Importing Data
        1. Copy a Table from Another Database
      10. Exporting Data
        1. Exporting Data to Excel
      11. Defining Relationships Among Tables
        1. Define a Relationship
      12. Creating a Form
        1. Create a Simple Form
        2. Step through the Form Wizard
      13. Creating a Report from the Data
        1. Step through the Report Wizard
      14. Extracting Information from a Database (Queries)
        1. Create a Detail Query
      15. Analyzing Data with a PivotChart
        1. Step through the PivotChart Wizard
        2. Change a PivotChart Chart Type
      16. Collecting Data Using E-Mail
        1. Send a Data Collection E-Mail Message
      17. Customizing Access
        1. Create a Macro
    17. 15. Exchanging Information Among Programs
      1. Inserting Excel Data into a Document, Publication, or Presentation
        1. Copy the Data
        2. Edit the Data
      2. Inserting an Excel Chart into a Document, Publication, or Presentation
        1. Insert the Chart
      3. Analyzing a Word Table in Excel
        1. Analyze the Table
      4. Using Word to Prepare PowerPoint Text
        1. Create the Presentation
      5. Preparing PowerPoint Handouts in Word
        1. Publish the Slides to Word
      6. Inserting a PowerPoint Slide Show into a Document, Worksheet, or Publication
        1. Insert the Presentation
      7. Using Publisher to Present a Word Document
        1. Publish Your Document
      8. Using Word to Prepare Publisher Text
        1. Create Your Story
      9. Using Word to Present Access Data
        1. Publish Your Data
      10. Analyzing Access Data in Excel
        1. Analyze Your Data
      11. Adding Excel Data to an Access Database
        1. Get the Excel Data
      12. Using Access Data in a Mail Merge
        1. Create a Mail Merge Using Access Data
      13. Using Your Contacts List in a Mail Merge
        1. Create a Mail Merge Using Your Contacts List
      14. Creating PDF or XPS Documents
        1. Create a Document in Access, Excel, PowerPoint, or Word
        2. Create a Document in Publisher
      15. Creating an Image of Your Work
        1. Create the Image
      16. Viewing and Annotating a Scanned Image or a Fax
        1. View and Annotate an Image
      17. Converting a Scanned Document into Text
        1. Convert the Image
      18. Scanning a Document
        1. Scan a Text Document
      19. Managing and Editing Your Pictures
        1. Work with Your Pictures
      20. Linking to a File or to a Web Page
        1. Link to the File or to the Web Page
      21. Managing Pictures, Videos, and Sound Files
        1. Organize Your Clips
    18. 16. Customizing and Securing Office
      1. Customizing the Quick Access Toolbar
        1. Add or Remove Items Common to the Quick Access Toolbar
        2. Control the Customization
      2. Customizing the Window
        1. Show or Hide Items on the Status Bar
        2. Change the Window’s Color Scheme
        3. Change What’s Shown
      3. Customizing Your Editing
        1. Adjust the Settings
      4. Changing Your User Information
        1. Change Your Name and Address
      5. Customizing the Spelling and Grammar Checkers
        1. Specify What’s to Be Checked
      6. Customizing Your Spelling Dictionaries
        1. Add a Dictionary
      7. Changing the Location and Type of Saved Files
        1. Change the File Locations and Formats
      8. Safeguarding a Document
        1. Set Up the Safeguards
      9. Protecting a Document, Workbook, or Presentation with a Password
        1. Encrypt the Document, Workbook, or Presentation
        2. Protect the Document, Workbook, or Presentation from Modifications
      10. Signing a Document or Workbook with a Visible Signature
        1. Set Up the Signature
        2. Sign the Document
      11. Signing a Document, Workbook, or Presentation with a Digital Certificate
        1. Attach a Digital Signature
      12. Controlling Macros, Add-Ins, and ActiveX Controls
        1. Modify the Settings
      13. Downloading Add-Ins and Other Free Software
        1. Download the Software
      14. Adding or Removing Office Components
        1. Add or Remove Components
      15. Checking the Compatibility
        1. Run the Check
      16. Fixing Office
        1. Run the Diagnostics
    19. About the Authors
    20. Choose the Right Book for You
      1. Published and Upcoming Titles
        1. Plain & Simple
        2. Step by Step
        3. Inside Out
    21. Index
    22. About the Authors
    23. SPECIAL OFFER: Upgrade this ebook with O’Reilly