You are previewing Office 2007 For Dummies®.
O'Reilly logo
Office 2007 For Dummies®

Book Description

Find and use the features you need right away

Create great documents, Excel charts, and slide shows, and organize your e-mail

What's new at the Office? A lot, and this book takes you through all the cool changes and enhancements so you can rev up and go. Find your way around the new interface, dress up your documents, create spreadsheets that actually make sense, give presentations that wow your audience, and organize your life.

Discover how to

  • Locate commands on the Ribbon

  • Use Live Preview

  • Stop spam with Outlook(r)

  • Format and enhance Word documents

  • Work with Excel(r) formulas

  • Store and find data in Access

Table of Contents

  1. Copyright
  2. About the Author
  3. Dedication
  4. Author's Acknowledgments
  5. Introduction
    1. Who Should Buy This Book
    2. How This Book Is Organized
      1. Part I: Getting to Know Microsoft Office 2007
      2. Part II: Working with Word
      3. Part III: Playing the Numbers with Excel
      4. Part IV: Making Presentations with PowerPoint
      5. Part V: Getting Organized with Outlook
      6. Part VI: Storing Stuff in Access
      7. Part VII: The Part of Tens
    3. How to Use This Book
      1. Conventions
    4. Icons Used in This Book
    5. Getting Started
  6. I. Getting to Know Microsoft Office 2007
    1. In this part . . .
    2. 1. Getting to Know Microsoft Office 2007
      1. Loading an Office 2007 Program
      2. Getting to Know the New User Interface
        1. The File menu
          1. Creating a new file
          2. Creating a new file from a template
            1. Using an Office 2007 template on your computer
            2. Downloading and using a template off Microsoft's Web site
          3. Opening an existing file
          4. Saving files
            1. Saving a file for Office 2007
            2. Saving a file for older versions of Microsoft Office
          5. Closing a file
        2. Using the Quick Access toolbar
          1. Using the Quick Access icons
          2. Adding icons
          3. Removing icons
          4. Moving the Quick Access toolbar
          5. Minimizing the Ribbon
        3. Using the Ribbon
          1. Deciphering Ribbon icons
          2. Using Live Preview
          3. Giving commands to Office 2007
      3. Customizing an Office 2007 Program
      4. Exiting Office 2007
    3. 2. Editing Data
      1. Adding Data by Pointing
      2. Selecting Data
        1. Selecting data with the mouse
        2. Selecting data with the keyboard
        3. Selecting multiple chunks of data with the mouse and keyboard
      3. Editing Data with the Pop‐up Toolbar
      4. Deleting Data
      5. Cutting and Pasting (Moving) Data
      6. Copying and Pasting Data
      7. Dragging with the Mouse to Cut, Copy, and Paste
      8. Undo and Redo
      9. Sharing Data with Other Office 2007 Programs
        1. Using the Office Clipboard
        2. Viewing and pasting items off the Office Clipboard
        3. Deleting items from the Office Clipboard
    4. 3. Getting Help from Office 2007
      1. Browsing the Help Window
      2. Searching in the Help Window
      3. Making the Help Window Easier to Read
        1. Resizing the Help window
        2. Enlarging the text in the Help window
        3. Keeping the Help window visible at all times
        4. Printing the text in the Help window
        5. Viewing the Table of Contents
  7. II. Working with Word
    1. In this part . . .
    2. 4. Typing Text in Word
      1. Moving the Cursor with the Mouse
      2. Moving the Cursor with the Keyboard
      3. Viewing a Document
        1. Switching between views
        2. Using Full Screen Reading view
        3. Using Outline view
          1. Defining a heading
          2. Promoting and demoting a heading
          3. Moving headings
          4. Creating text
          5. Collapsing and expanding headings and subheadings
      4. Navigating through a Document
        1. Navigating with the mouse
          1. Using the scroll bar
          2. Using a mouse scroll wheel
        2. Using the Go To command
      5. Finding and Replacing Text
        1. Using the Find command
        2. Using the Find and Replace command
      6. Checking Your Spelling
      7. Checking Your Grammar
      8. Proofreading Your Document
      9. Typing Symbols
    3. 5. Formatting Text
      1. Changing the Font
      2. Changing the Font Size
      3. Changing the Text Style
      4. Changing Colors
        1. Changing the color of text
        2. Highlighting text
      5. Justifying Text Alignment
      6. Adjusting Line Spacing
      7. Making Lists
        1. Indenting list items
        2. Converting list items back into text
        3. Customizing a list
        4. Renumbering numbered lists
      8. Using the Ruler
        1. Adjusting left and right paragraph margins
        2. Defining indentation with the Ruler
      9. Showing Formatting Marks
      10. Using Format Painter
      11. Using Styles
      12. Using Templates
        1. Creating a new document from a template
        2. Creating a document based on an existing document
      13. Removing Formatting from Text
    4. 6. Designing Your Pages
      1. Inserting New Pages
      2. Adding (And Deleting) a Cover Page
      3. Inserting Page Breaks
      4. Inserting Headers and Footers
        1. Creating a header (or footer)
        2. Defining which pages to display a header (or footer)
          1. Creating a unique header or footer for your first page
          2. Creating unique headers and footers for odd and even pages
        3. Deleting a header (or footer)
      5. Organizing Text in Tables
        1. Creating a table by highlighting rows and columns
        2. Creating a table with the Insert Table dialog box
        3. Creating a table with the mouse
        4. Creating a table from existing text
      6. Formatting and Coloring a Table
        1. Selecting all or part of a table
        2. Aligning text in a table cell
        3. Coloring all or part of a table
        4. Adding borders
        5. Picking a table style
        6. Resizing columns and rows
        7. Defining cell margins
        8. Defining cell spacing
        9. Splitting (and merging) cells
      7. Sorting a Table
      8. Deleting Tables
        1. Deleting an entire table
        2. Deleting rows and columns
        3. Deleting cells
        4. Deleting cell borders
      9. Making Text Look Artistic
        1. Creating drop caps
        2. Creating WordArt
      10. Dividing Text into Columns
        1. Editing columns
        2. Removing columns
      11. Previewing a Document before Printing
        1. Defining page size and orientation
        2. Using Print Preview
        3. Printing
  8. III. Playing the Numbers with Excel
    1. In this part . . .
    2. 7. The Basics of Spreadsheets: Numbers, Labels, and Formulas
      1. Understanding Spreadsheets
      2. Storing Stuff in a Spreadsheet
        1. Typing data into a single cell
        2. Typing data in multiple cells
        3. Typing in sequences with AutoFill
      3. Formatting Numbers and Labels
        1. Formatting numbers
          1. Displaying negative numbers
          2. Formatting decimal numbers
        2. Formatting cells
          1. Formatting cells with built‐in styles
          2. Formatting fonts and text styles
          3. Formatting with color
          4. Adding borders
      4. Navigating a Spreadsheet
        1. Using the mouse to move around in a spreadsheet
        2. Using the keyboard to move around a spreadsheet
        3. Naming cells
      5. Searching a Spreadsheet
        1. Searching for text
        2. Searching for formulas
      6. Editing a Spreadsheet
        1. Editing data in a cell
        2. Changing the size of rows and columns with the mouse
        3. Typing the size of rows and columns
        4. Adding and deleting rows and columns
        5. Adding sheets
        6. Renaming sheets
        7. Rearranging sheets
        8. Deleting a sheet
      7. Clearing Data
      8. Printing Workbooks
        1. Using Page Layout view
        2. Adding a header (or footer)
        3. Printing gridlines
        4. Defining a print area
        5. Inserting (and removing) page breaks
        6. Printing row and column headings
        7. Defining printing margins
        8. Defining paper orientation and size
        9. Printing in Excel
    3. 8. Playing with Formulas
      1. Creating a Formula
        1. Organizing formulas with parentheses
        2. Copying formulas
      2. Using Functions
        1. Using the AutoSum command
        2. Using recently used functions
      3. Editing a Formula
      4. Goal Seeking
      5. Creating Multiple Scenarios
        1. Creating a scenario
        2. Viewing a scenario
        3. Editing a scenario
        4. Viewing a scenario summary
      6. Auditing Your Formulas
        1. Finding where a formula gets its data
        2. Finding which formula(s) a cell can change
      7. Data Validation
    4. 9. Charting and Analyzing Data
      1. Understanding the Parts of a Chart
      2. Creating a Chart
      3. Editing a Chart
        1. Moving a chart on a worksheet
        2. Moving a chart to a new sheet
        3. Resizing a chart
      4. Using the Chart Tools
        1. Changing the chart type
        2. Changing the data source
        3. Switching rows and columns
        4. Changing the parts of a chart
        5. Designing the layout of a chart
        6. Deleting a chart
      5. Organizing Lists in Pivot Tables
        1. Creating a pivot table
        2. Rearranging labels in a pivot table
        3. Modifying a pivot table
        4. Filtering a pivot table
        5. Summing a pivot table
  9. IV. Making Presentations with PowerPoint
    1. In this part . . .
    2. 10. Creating a PowerPoint Presentation
      1. Defining the Purpose of Your Presentation
      2. Creating a PowerPoint Presentation
        1. Designing a presentation with Slide view
          1. Creating a new slide
          2. Rearranging slides
          3. Hiding and deleting a slide
        2. Designing a presentation with Outline view
          1. Creating a new slide
          2. Creating subtitles on a slide
          3. Collapsing and expanding subtitles
          4. Rearranging slides
          5. Deleting a slide
      3. Working with Text
        1. Typing text in a text box
        2. Formatting text
        3. Aligning text
        4. Adjusting line spacing
        5. Making numbered and bullet lists
        6. Making columns
        7. Moving and resizing a text box
        8. Rotating a text box
    3. 11. Adding Color and Pictures to a Presentation
      1. Applying a Theme
      2. Changing the Background
        1. Choosing a solid color background
        2. Choosing a gradient background
        3. Choosing a picture background
      3. Adding Graphics to a Slide
        1. Placing picture files on a slide
        2. Placing clip art on a slide
        3. Creating WordArt
        4. Resizing, moving, and deleting graphic images
        5. Rotating graphics
        6. Layering objects
      4. Adding Movies to a Slide
        1. Adding an animated cartoon to a slide
        2. Adding a movie to a slide
      5. Adding Sound to a Slide
        1. Adding an audio file to a presentation
        2. Adding an audio clip to a presentation
        3. Adding a CD audio track to a presentation
    4. 12. Showing Off a Presentation
      1. Spell‐Checking Your Presentation
      2. Adding Visual Transitions
        1. Adding slide transitions
        2. Text transitions
      3. Adding Hyperlinks
        1. Creating Web page hyperlinks
        2. Creating hyperlinks to external files
        3. Creating hyperlinks to different slides
        4. Running a program through a hyperlink
      4. Viewing a Presentation
        1. Creating a custom slide show
        2. Hiding a slide
        3. Organizing with Slide Sorter view
        4. Timing yourself
      5. Creating Handouts
      6. Packing Presentations to Go
  10. V. Getting Organized with Outlook
    1. In this part . . .
    2. 13. Organizing E‐Mail with Outlook
      1. Configuring E‐Mail Settings
        1. Adding an e‐mail account
        2. Deleting an e‐mail account
        3. Editing an e‐mail account
      2. Creating E‐Mail
        1. Creating a new e‐mail message
        2. Replying to an e‐mail message
        3. Using a stored e‐mail address to create a new e‐mail message
        4. Forwarding an e‐mail message
      3. Attaching Files to Messages
        1. Attaching a file to a message
        2. Attaching Outlook information to another message
      4. Formatting E‐Mail
        1. Formatting text
        2. Adding signatures to your messages
          1. Creating and using multiple signatures
          2. Editing and deleting a signature file
      5. Reading and Organizing E‐Mail
        1. Categorizing messages
          1. Color categorizing a message
          2. Clearing color categories from a message
        2. Retrieving a file attachment from a message
      6. Deleting E‐Mail Messages
    3. 14. Storing Contacts and Organizing Tasks
      1. Storing Contact Information
      2. Searching Contact Information
      3. Viewing and Printing Contact Information
      4. Categorizing Contact Information
        1. Creating categories
        2. Storing names in categories
        3. Viewing names by categories
      5. Sharing Contact Information
      6. Defining Tasks
        1. Creating a task
        2. Editing a task
        3. Organizing and viewing your tasks
        4. Finishing a task
        5. Deleting a task
    4. 15. Scheduling Your Time
      1. Setting Appointments
        1. Making a new appointment
        2. Editing an appointment
        3. Deleting an appointment
        4. Defining a recurring appointment
        5. Editing a recurring appointment
      2. Printing Your Schedule
  11. VI. Storing Stuff in Access
    1. In this part . . .
    2. 16. Using a Database
      1. Understanding the Basics of a Database
      2. Designing a Database
        1. Creating a database from scratch
        2. Creating a database from a template
      3. Editing and Modifying a Database
        1. Naming a field
        2. Adding and deleting a field
        3. Defining the type and size of a field
      4. Typing Data into a Database
        1. Using Datasheet view
        2. Using Form view
        3. Creating a form
        4. Viewing and editing data in a form
        5. Editing a form
          1. Deleting a field
          2. Adding a field
      5. Closing and Saving a Database
        1. Closing a database table
        2. Closing a database file
    3. 17. Searching, Sorting, and Querying a Database
      1. Searching a Database
        1. Searching for a specific record
        2. Filtering a database
          1. Using an exact match for a filter
          2. Filtering by form
          3. Using a filter criteria
          4. Clearing a filter
      2. Sorting a Database
      3. Querying a Database
        1. Creating a simple query
        2. Creating a crosstab query
        3. Creating a query that finds duplicate field data
        4. Creating an unmatched query
        5. Viewing and deleting queries
    4. 18. Creating a Database Report
      1. Using the Report Wizard
      2. Viewing and Printing a Report
      3. Manipulating the Data in a Report
        1. Counting records or values
        2. Sorting a field
        3. Filtering a field
      4. Editing a Report
        1. Resizing fields
        2. Deleting fields
      5. Deleting a Report
  12. VII. The Part of Tens
    1. In this part . . .
    2. 19. Ten Tips for Using Office 2007
      1. Saving Office 2007 Files
      2. Password‐Protecting Your Files
      3. Guarding Against Macro Viruses and Worms
      4. Create Your Own Word Keystroke Shortcuts
      5. Zooming In (And Out) to Avoid Eyestrain
      6. When in Doubt, Right‐Click the Mouse
      7. Freezing Row and Column Headings in Excel
      8. Displaying Slides Out of Order in PowerPoint
      9. Reduce Spam in Outlook
        1. Setting up Outlook's junk e‐mail filter
        2. Creating a Safe Senders list
        3. Creating a Blocked Senders list
      10. Using Pocket Office
    3. 20. Ten Keystroke Shortcuts for Office 2007
      1. Protecting Yourself with Undo (Ctrl+Z) and Redo (Ctrl+Y)
      2. Cut (Ctrl+X), Copy (Ctrl+C), and Paste (Ctrl+V)
        1. Using the Cut and Paste commands
        2. Using the Copy and Paste commands
        3. Using the Paste command with the Office Clipboard
      3. Saving a File (Ctrl+S)
      4. Printing a File (Ctrl+P)
      5. Checking Your Spelling (F7)
      6. Opening a File (Ctrl+O)
      7. Creating a New File (Ctrl+N)
      8. Finding Text (Ctrl+F)
      9. Finding and Replacing Text (Ctrl+H)
      10. Closing a Window (Ctrl+W)