You are previewing Microsoft® Office 2007 Simplified®.
O'Reilly logo
Microsoft® Office 2007 Simplified®

Book Description

Are you new to computers? Does new technology make you nervous? Relax! You're holding in your hands the easiest guide ever to Office 2007 -- a book that skips the long-winded explanations and shows you how things work. All you have to do is open the book, follow Chip, your friendly guide -- and discover just how easy it is to get up to speed.

The Simplified series is very accessible to beginners and provides useful information for more experienced users. For visual learners (like myself), the illustrations are a great help. It's challenging to take a complex subject and express it simply, clearly, concisely, and comprehensively. This book meets the challenge.

--John Kelly (Anchorage, AK)

  • Simplify It" sidebars offer real-world advice

  • A friendly character called Chip introduces each task

  • Full-color screen shots walk you through step by step

  • Self-contained, two-page lessons make learning a snap

Table of Contents

  1. Copyright
  2. Praise for Visual Books
  3. Credits
  4. About the Author
  5. Author's Acknowledgments
  6. I. Office Features
    1. 1. Office Basics
      1. 1.1. Start and Exit Office Applications
      2. 1.2. Navigate the Program Windows
      3. 1.3. Work with the Ribbon
      4. 1.4. Customize the Quick Access Toolbar
      5. 1.5. Find Customizing Options
      6. 1.6. Turn Off Live Preview
      7. 1.7. Find Help with Office
      8. 1.8. Diagnose Office Programs
    2. 2. Working with Files
      1. 2.1. Start a New File
      2. 2.2. Save a File
      3. 2.3. Open an Existing File
      4. 2.4. Close a File
      5. 2.5. Print a File
      6. 2.6. Cut, Copy, and Paste Data
      7. 2.7. View Multiple Files
    3. 3. Office Internet and Graphics Tools
      1. 3.1. Create an HTML File
      2. 3.2. Add a Hyperlink
      3. 3.3. Draw AutoShapes
      4. 3.4. Insert Clip Art
      5. 3.5. View Clip Art with the Clip Organizer
      6. 3.6. Insert a Picture
      7. 3.7. Insert a WordArt Object
      8. 3.8. Move and Resize an Object
      9. 3.9. Rotate and Flip Objects
      10. 3.10. Crop a Picture
      11. 3.11. Arrange Objects
      12. 3.12. Control Text Wrapping
      13. 3.13. Recolor a Picture
      14. 3.14. Add SmartArt
  7. II. Word
    1. 4. Adding Text
      1. 4.1. Change Word's Views
      2. 4.2. Type and Edit Text
      3. 4.3. Select Text
      4. 4.4. Move and Copy Text
      5. 4.5. Insert Quick Parts
      6. 4.6. Apply a Template
      7. 4.7. Insert Symbols
    2. 5. Formatting Text
      1. 5.1. Add Basic Formatting
      2. 5.2. Use the Mini Toolbar
      3. 5.3. Changethe Font
      4. 5.4. Change the Font Size
      5. 5.5. Add Color to Text
      6. 5.6. AlignText
      7. 5.7. Set Line Spacing
      8. 5.8. Set Character Spacing
      9. 5.9. Apply Color Shading
      10. 5.10. Highlight Text
      11. 5.11. Copy Formatting
      12. 5.12. Clear Formatting
      13. 5.13. Indent Text
      14. 5.14. Set Tabs
      15. 5.15. Create Bulleted or Numbered Lists
      16. 5.16. Set Margins
      17. 5.17. Format with Styles
    3. 6. Working with Tables
      1. 6.1. Insert a Table
      2. 6.2. Insert a Quick Table
      3. 6.3. Draw a Table
      4. 6.4. Insert an Excel Spreadsheet
      5. 6.5. Select Table Cells
      6. 6.6. Adjust the Column Width or Row Height
      7. 6.7. Add Columns and Rows
      8. 6.8. Delete Columns or Rows
      9. 6.9. Merge Table Cells
      10. 6.10. Split Table Cells
      11. 6.11. Apply Table Styles
      12. 6.12. Change Cell Alignment
      13. 6.13. Reposition a Table
      14. 6.14. Resize a Table
    4. 7. Adding Extra Touches
      1. 7.1. Assign a Theme
      2. 7.2. Add Borders
      3. 7.3. Create Columns
      4. 7.4. Add Headers and Footers
      5. 7.5. Insert Comments
      6. 7.6. Insert Footnotes and Endnotes
      7. 7.7. Insert Page Numbers and Page Breaks
    5. 8. Reviewing and Printing Documents
      1. 8.1. Find and Replace Text
      2. 8.2. Check Spelling and Grammar
      3. 8.3. Work with AutoCorrect
      4. 8.4. Use the Thesaurus
      5. 8.5. Check Your Document for Hidden or Personal Data
      6. 8.6. Track and Review Document Changes
      7. 8.7. E-mail a Document
      8. 8.8. Change Paper Size
      9. 8.9. Print an Envelope
  8. III. Excel
    1. 9. Building Spreadsheets
      1. 9.1. Enter Cell Data
      2. 9.2. Select Cells
      3. 9.3. Faster Data Entry with AutoFill
      4. 9.4. Add Columns and Rows
      5. 9.5. Delete Columns and Rows
      6. 9.6. Resize Columns and Rows
      7. 9.7. Turn On Text Wrapping
      8. 9.8. Center Data Across Columns
      9. 9.9. Freeze a Column or Row
      10. 9.10. Remove Data or Cells
    2. 10. Worksheet Basics
      1. 10.1. Assign Worksheet Names
      2. 10.2. Delete a Worksheet
      3. 10.3. Add a Worksheet
      4. 10.4. Move a Worksheet
      5. 10.5. Copy a Worksheet
      6. 10.6. Format the Worksheet Tab Color
      7. 10.7. Find and Replace Data
      8. 10.8. Sort Data
      9. 10.9. Filter Data with AutoFilter
      10. 10.10. Insert a Comment
      11. 10.11. Track and Review Workbook Changes
      12. 10.12. Change Page Setup Options
    3. 11. working with formulas and functions
      1. 11.1. Understanding Formulas
      2. 11.2. Create Formulas
      3. 11.3. Define a Range Name
      4. 11.4. Reference Ranges in Formulas
      5. 11.5. Reference Cells from Other Worksheets
      6. 11.6. Apply Absolute and Relative Cell References
      7. 11.7. Understanding Functions
      8. 11.8. Apply a Function
      9. 11.9. Total Cells with AutoSum
      10. 11.10. Audit a Worksheet for Errors
    4. 12. Formatting Worksheets
      1. 12.1. Change Number Formats
      2. 12.2. Change the Font and Size
      3. 12.3. Increase or Decrease Decimals
      4. 12.4. Change Data Color
      5. 12.5. Adjust the Cell Alignment
      6. 12.6. Control Data Orientation
      7. 12.7. Copy Cell Formatting
      8. 12.8. Add Borders
      9. 12.9. Format Data with Styles
      10. 12.10. Assign Conditional Formatting
    5. 13. working with charts
      1. 13.1. Create a Chart
      2. 13.2. Move and Resize Charts
      3. 13.3. Change the Chart Type
      4. 13.4. Change the Chart Style
      5. 13.5. Change the Chart Layout
      6. 13.6. Add Axis Titles
      7. 13.7. Format Chart Objects
      8. 13.8. Add Gridlines
      9. 13.9. Change the Chart Data
  9. IV. PowerPoint
    1. 14. Presentation Basics
      1. 14.1. Create a Presentation with a Template
      2. 14.2. Build a Blank Presentation
      3. 14.3. Change PowerPoint Views
    2. 15. Creating Slides
      1. 15.1. Add and Edit Slide Text
      2. 15.2. Change the Font and Size
      3. 15.3. Change the Text Color
      4. 15.4. Change the Text Style
      5. 15.5. Change the Text Alignment
      6. 15.6. Set Line Spacing
      7. 15.7. Assign a Theme
      8. 15.8. Change the Slide Layout
      9. 15.9. Add a New Text Object
      10. 15.10. Add Clip Art to a Slide
      11. 15.11. Add a Chart to a Slide
      12. 15.12. Add a Table to a Slide
      13. 15.13. Move a Slide Object
      14. 15.14. Resize a Slide Object
    3. 16. Assembling a Slide Show
      1. 16.1. Insert and Delete Slides
      2. 16.2. Reorganize Slides
      3. 16.3. Define Slide Transitions
      4. 16.4. Add Animation Effects
      5. 16.5. Insert a Media Clip
      6. 16.6. Record Narration
      7. 16.7. Set Up a Slide Show
    4. 17. Presenting a Slide Show
      1. 17.1. Rehearse a Slide Show
      2. 17.2. Run a Slide Show
      3. 17.3. Create Speaker Notes
      4. 17.4. Package Your Presentation on a CD
  10. V. Access
    1. 18. Database Basics
      1. 18.1. Understanding Database Basics
      2. 18.2. Create a Blank Database
      3. 18.3. Create a Database Based on a Template
    2. 19. Adding Data Using Tables
      1. 19.1. Create a New Table
      2. 19.2. Create a Table with a Table Template
      3. 19.3. Change Table Views
      4. 19.4. Add a Field
      5. 19.5. Delete a Field
      6. 19.6. Hide a Field
      7. 19.7. Move a Field
      8. 19.8. Add a Record
      9. 19.9. Delete a Record
    3. 20. Adding Data Using Forms
      1. 20.1. Create a Form Using a Wizard
      2. 20.2. Create a Quick Form
      3. 20.3. Add a Record
      4. 20.4. Navigate Records
      5. 20.5. Delete a Record
      6. 20.6. Change Form Views
      7. 20.7. Move a Field
      8. 20.8. Delete a Field
      9. 20.9. Add a Field
      10. 20.10. Change the Field Formatting
      11. 20.11. Apply a Quick Format
    4. 21. Finding and Querying Data
      1. 21.1. Sort Records
      2. 21.2. Filter Records
      3. 21.3. Perform a Simple Query
      4. 21.4. Create a Report
  11. VI. Outlook
    1. 22. Organizing with Outlook
      1. 22.1. View Outlook Components
      2. 22.2. Schedule an Appointment
      3. 22.3. Schedule a Recurring Appointment
      4. 22.4. Schedule an Event
      5. 22.5. Plan a Meeting
      6. 22.6. Create a New Contact
      7. 22.7. Create a New Task
      8. 22.8. Add a Note
      9. 22.9. Organize Outlook Items
      10. 22.10. Perform an Instant Search
      11. 22.11. Customize the To-Do Bar
    2. 23. Emailing with Outlook
      1. 23.1. Compose and Send a Message
      2. 23.2. Read an Incoming Message
      3. 23.3. Control the Reading Pane
      4. 23.4. Reply to or Forward a Message
      5. 23.5. Add a Sender to Your Address Book
      6. 23.6. Delete a Message
      7. 23.7. Attach a File to a Message
      8. 23.8. Clean Up the Mailbox
      9. 23.9. Screen Junk E-mail
      10. 23.10. Create a Message Rule
  12. VII. Publisher
    1. 24. Publisher Basics
      1. 24.1. Create a Publication
      2. 24.2. Create a Blank Publication
      3. 24.3. Zoom In and Out
      4. 24.4. Add Text
      5. 24.5. Add a New Text Box
      6. 24.6. Add a Picture to a Publication
      7. 24.7. Add Clip Art to a Publication
      8. 24.8. Change the Text Font and Size
    2. 25. Organizing with Outlook
      1. 25.1. Change the Text Style
      2. 25.2. Change Text Alignment
      3. 25.3. Change Text Color
      4. 25.4. Control Text Wrap
      5. 25.5. Add a Border
      6. 25.6. Move a Publication Object
      7. 25.7. Resize a Publication Object
      8. 25.8. Connect Text Boxes
      9. 25.9. Edit the Background Page
      10. 25.10. Add a Design Gallery Object
      11. 25.11. Use the Content Library