You are previewing Microsoft® Office 2008 for Mac® Bible.
O'Reilly logo
Microsoft® Office 2008 for Mac® Bible

Book Description

  • Written by an expert in the field of technology training and author of nearly two dozen titles, this complete guide offers readers thorough yet clear instruction on using the Microsoft Office suite: Word, Excel, PowerPoint, and Entourage

  • Apple has welcomed Microsoft Office into its world and this reference is the ultimate resource for learning how to best capitalize on each application of Office

  • Reviews creating, editing, formatting, and sharing digital documents with Word; gathering and analyzing information with Excel; creating dynamic presentations with PowerPoint; and using the e-mail and calendar of Entourage

Table of Contents

  1. Copyright
  2. About the Authors
  3. Credits
  4. Preface
    1. What's in This Book?
    2. Who Should Read This Book?
    3. How to Use This Book
  5. Acknowledgments
  6. I. Getting to Know Office 2008
    1. 1. Introducing the New Office
      1. 1.1. What Is Office 2008?
        1. 1.1.1. Word 2008
        2. 1.1.2. Excel 2008
        3. 1.1.3. PowerPoint 2008
        4. 1.1.4. Entourage 2008
      2. 1.2. Learning a Little Office History
      3. 1.3. Discovering What's New and Improved in Office
        1. 1.3.1. Word
        2. 1.3.2. Excel
        3. 1.3.3. PowerPoint
        4. 1.3.4. Entourage
      4. 1.4. Summary
    2. 2. Installing Office 2008
      1. 2.1. System Requirements
      2. 2.2. Using the Installer
        1. 2.2.1. Running the Installer
        2. 2.2.2. Using the Microsoft Office Setup Assistant
        3. 2.2.3. Uninstalling Office
      3. 2.3. Checking for Updates
      4. 2.4. Troubleshooting
      5. 2.5. Summary
    3. 3. Office 2008 Program Basics
      1. 3.1. Starting and Exiting Programs
      2. 3.2. Working with Program Windows
        1. 3.2.1. Closing, minimizing, and zooming windows
        2. 3.2.2. Moving and resizing windows
        3. 3.2.3. Scrolling around windows
        4. 3.2.4. Hiding windows
      3. 3.3. Opening Files
      4. 3.4. Using Multiple Windows
      5. 3.5. Using Menus, Toolbars, and the Toolbox
        1. 3.5.1. Using menus
        2. 3.5.2. Using toolbars
        3. 3.5.3. Using the Toolbox
      6. 3.6. Summary
    4. 4. Finding Help with Office 2008
      1. 4.1. Accessing Help
        1. 4.1.1. Opening the Help files
        2. 4.1.2. Getting around the Help window
      2. 4.2. Searching for Help
      3. 4.3. Using the Office Reference Tools
        1. 4.3.1. Using the Thesaurus
        2. 4.3.2. Using the Dictionary
        3. 4.3.3. Using the Encarta Encyclopedia
        4. 4.3.4. Translating text
        5. 4.3.5. Using the Bilingual Dictionary
        6. 4.3.6. Performing a Web search
      4. 4.4. Summary
  7. II. Working with Word
    1. 5. Word Basics
      1. 5.1. Navigating the Word Window
        1. 5.1.1. Viewing window parts
          1. 5.1.1.1. Title bar and menu bar
          2. 5.1.1.2. Standard toolbar
          3. 5.1.1.3. Elements Gallery
          4. 5.1.1.4. Ruler
          5. 5.1.1.5. Toolbox
          6. 5.1.1.6. Scroll bars
          7. 5.1.1.7. Status bar
        2. 5.1.2. Using the Navigation Pane
        3. 5.1.3. Using the Toolbox
      2. 5.2. Creating, Opening, and Saving Documents
        1. 5.2.1. Creating new files
        2. 5.2.2. Saving files
          1. 5.2.2.1. Saving for the first time
          2. 5.2.2.2. Making subsequent saves
          3. 5.2.2.3. Saving an existing file under a new filename
          4. 5.2.2.4. Creating a backup file
          5. 5.2.2.5. Using AutoRecover
        3. 5.2.3. Using the Compatibility Report feature
        4. 5.2.4. Opening files
          1. 5.2.4.1. Opening a document with the Open command
          2. 5.2.4.2. Opening a document with the Recent Documents menu
          3. 5.2.4.3. Opening a document with the Project Gallery
          4. 5.2.4.4. Opening a document based on a template
          5. 5.2.4.5. Searching for a file
      3. 5.3. Changing Views
        1. 5.3.1. Using the view modes
          1. 5.3.1.1. Draft view
          2. 5.3.1.2. Outline view
          3. 5.3.1.3. Publishing Layout view
          4. 5.3.1.4. Print Layout view
          5. 5.3.1.5. Notebook Layout view
          6. 5.3.1.6. Web Layout view
        2. 5.3.2. Using the Zoom feature
          1. 5.3.2.1. Using the Zoom tool
          2. 5.3.2.2. Using the Zoom dialog box
      4. 5.4. Setting Document Properties
      5. 5.5. Protecting Documents
        1. 5.5.1. Assigning read-only status
        2. 5.5.2. Assigning passwords
      6. 5.6. Summary
    2. 6. Building Word Documents
      1. 6.1. Typing Text
        1. 6.1.1. Typing with AutoCorrect
          1. 6.1.1.1. Adding a word to AutoCorrect
          2. 6.1.1.2. Removing a word from AutoCorrect
          3. 6.1.1.3. Turning off AutoCorrect
        2. 6.1.2. Using AutoText
          1. 6.1.2.1. Adding a word to AutoText
      2. 6.2. Editing Text
        1. 6.2.1. Selecting text
          1. 6.2.1.1. Selecting text with the mouse
          2. 6.2.1.2. Selecting text with the keyboard
          3. 6.2.1.3. Selecting text with the mouse and the keyboard combined
        2. 6.2.2. Using Undo and Redo
        3. 6.2.3. Moving and copying text
          1. 6.2.3.1. Moving text via drag-and-drop
          2. 6.2.3.2. Moving and copying with the Edit menu
          3. 6.2.3.3. Moving and copying with the context menu
          4. 6.2.3.4. Moving and copying with shortcut keys
          5. 6.2.3.5. Using the Paste Special command
          6. 6.2.3.6. Using the Paste Options button
        4. 6.2.4. Removing text
        5. 6.2.5. Finding and replacing text
          1. 6.2.5.1. Finding text
          2. 6.2.5.2. Replacing text
          3. 6.2.5.3. Using Advanced Find options
          4. 6.2.5.4. Using the Go To tab
      3. 6.3. Adding Text in Columnar Layouts
        1. 6.3.1. Tabbing text
          1. 6.3.1.1. Setting tab stops using the ruler
          2. 6.3.1.2. Setting tab stops using the Tabs dialog box
        2. 6.3.2. Creating columns
          1. 6.3.2.1. Creating easy columns
          2. 6.3.2.2. Creating columns with the Columns dialog box
          3. 6.3.2.3. Editing columns
      4. 6.4. Adding Special Text
        1. 6.4.1. Adding drop caps
        2. 6.4.2. Adding symbols and special characters
        3. 6.4.3. Changing text case
        4. 6.4.4. Adding text boxes
      5. 6.5. Building Documents Using Outlines
        1. 6.5.1. Assigning headings
        2. 6.5.2. Changing the outline view
        3. 6.5.3. Adding outline numbers
      6. 6.6. Building Documents Using Notebook Layout View
        1. 6.6.1. Adding note text
        2. 6.6.2. Organizing notes with text levels
        3. 6.6.3. Sorting and flagging notes
        4. 6.6.4. Using the Scribble tool
        5. 6.6.5. Using audio notes
      7. 6.7. Building Documents Using Publishing Layout View
      8. 6.8. Summary
    3. 7. Formatting Word Text
      1. 7.1. Understanding Formatting
      2. 7.2. Using the Formatting Palette
      3. 7.3. Changing Fonts and Sizes
        1. 7.3.1. Changing fonts with the Formatting Palette
        2. 7.3.2. Changing font sizes
        3. 7.3.3. Adding color
      4. 7.4. Modifying Fonts with the Font Dialog Box
        1. 7.4.1. Using font effects
        2. 7.4.2. Using ligatures
        3. 7.4.3. Character spacing
      5. 7.5. Adding Bullets and Numbers
        1. 7.5.1. Changing bullet or number styles
        2. 7.5.2. Customizing bullets
        3. 7.5.3. Creating an outline-numbered list
          1. 7.5.3.1. Customizing an outline-numbered list
          2. 7.5.3.2. Using list styles
      6. 7.6. Changing Alignment and Spacing
        1. 7.6.1. Setting horizontal spacing
        2. 7.6.2. Specifying line spacing
        3. 7.6.3. Changing text orientation
        4. 7.6.4. Setting paragraph spacing
        5. 7.6.5. Setting indents
        6. 7.6.6. Caring for widows and orphans
      7. 7.7. Adding Borders and Shading
        1. 7.7.1. Creating borders
        2. 7.7.2. Adding shading
        3. 7.7.3. Applying page borders
      8. 7.8. Changing Document Margins
        1. 7.8.1. Setting gutters and mirrors
        2. 7.8.2. Changing margins and orientation for a section
      9. 7.9. Changing Document Themes
      10. 7.10. Copying Formatting
      11. 7.11. Understanding AutoFormatting
      12. 7.12. Using the Formatting Toolbar
      13. 7.13. Summary
    4. 8. Adding Tables
      1. 8.1. Creating Tables
        1. 8.1.1. Inserting Quick Tables
        2. 8.1.2. Inserting tables on the fly
        3. 8.1.3. Inserting tables with the Insert Table dialog box
        4. 8.1.4. Drawing your own tables
        5. 8.1.5. Converting text into tables
      2. 8.2. Editing Tables
        1. 8.2.1. Entering table text
        2. 8.2.2. Selecting table elements
        3. 8.2.3. Using the Table pane
        4. 8.2.4. Resizing columns and rows
        5. 8.2.5. Inserting and deleting table elements
          1. 8.2.5.1. Inserting columns and rows
          2. 8.2.5.2. Deleting columns and rows
          3. 8.2.5.3. Inserting and deleting cells
          4. 8.2.5.4. Deleting entire tables
          5. 8.2.5.5. Creating nesting tables
        6. 8.2.6. Merging and splitting cells
      3. 8.3. Formatting Tables
        1. 8.3.1. Using table formatting attributes
        2. 8.3.2. AutoFormat a table
        3. 8.3.3. Adding repeating headings
        4. 8.3.4. Controlling cell margins and spacing
      4. 8.4. Performing Table Actions
        1. 8.4.1. Sorting a table
        2. 8.4.2. Summing table data
      5. 8.5. Summary
    5. 9. Editing Lengthy Documents
      1. 9.1. Using the Navigation Pane
        1. 9.1.1. Switching to the Document Map
        2. 9.1.2. Customizing the Document Map
      2. 9.2. Using Styles
        1. 9.2.1. Applying styles
        2. 9.2.2. Creating styles
          1. 9.2.2.1. Naming styles
          2. 9.2.2.2. Using the New Style dialog box
        3. 9.2.3. Modifying and deleting styles
        4. 9.2.4. Organizing styles
      3. 9.3. Using and Creating Templates
        1. 9.3.1. Attaching a template
          1. 9.3.1.1. Opening a template from the Project Gallery
          2. 9.3.1.2. Attaching a template through the Templates and Add-Ins tool
          3. 9.3.1.3. Loading global templates
        2. 9.3.2. Modifying templates
        3. 9.3.3. Creating new templates
      4. 9.4. Adding Line and Page Breaks
      5. 9.5. Turning On Hyphenation
        1. 9.5.1. Manually hyphenating
        2. 9.5.2. Using optional and nonbreaking hyphens
        3. 9.5.3. Removing hyphens
      6. 9.6. Adding Headers and Footers
        1. 9.6.1. Formatting page numbers
        2. 9.6.2. Creating section-based headers and footers
      7. 9.7. Inserting Fields
        1. 9.7.1. Building and modifying fields
          1. 9.7.1.1. Locking fields
          2. 9.7.1.2. Unlinking fields
      8. 9.8. Creating Citations and Bibliographies
        1. 9.8.1. Editing citation data
        2. 9.8.2. Managing citations
        3. 9.8.3. Using citations
          1. 9.8.3.1. Generating a bibliography
          2. 9.8.3.2. Formatting bibliographies and works cited
        4. 9.8.4. Deleting a citation
      9. 9.9. Inserting Footnotes and Endnotes
        1. 9.9.1. Converting footnotes to endnotes
        2. 9.9.2. Deleting footnotes and endnotes
      10. 9.10. Adding Captions
        1. 9.10.1. Editing captions
        2. 9.10.2. Using the AutoCaption feature
      11. 9.11. Navigating with Bookmarks
        1. 9.11.1. Adding and deleting bookmarks
        2. 9.11.2. Using bookmarks
      12. 9.12. Using Cross-References
      13. 9.13. Creating a Table of Contents
        1. 9.13.1. Using the table of contents document element
        2. 9.13.2. Creating a table of contents through the dialog box
          1. 9.13.2.1. Using non-heading styles for a table of contents
          2. 9.13.2.2. Changing TOC styles
        3. 9.13.3. Adding other tables
      14. 9.14. Creating an Index
        1. 9.14.1. Creating index entries
        2. 9.14.2. Generating an index
        3. 9.14.3. AutoMarking an index
      15. 9.15. Adding Line Numbers
      16. 9.16. Using Master Documents
      17. 9.17. Summary
    6. 10. Collaborating on Documents
      1. 10.1. Adding Comments
        1. 10.1.1. Adding comments
        2. 10.1.2. Adding comments with the Reviewing pane
      2. 10.2. Tracking Changes
      3. 10.3. Reviewing Changes
      4. 10.4. Merging and Comparing Documents
        1. 10.4.1. Merging documents
        2. 10.4.2. Comparing documents
      5. 10.5. Summary
    7. 11. Proofing and Printing Documents
      1. 11.1. Proofreading a Document
        1. 11.1.1. Setting spelling and grammar options
          1. 11.1.1.1. Using Custom and Foreign Dictionaries
          2. 11.1.1.2. Creating an exclusion dictionary
        2. 11.1.2. Checking spelling and grammar as you type
        3. 11.1.3. Checking spelling and grammar on demand
      2. 11.2. Counting Words and Lines
      3. 11.3. Inserting a Watermark
      4. 11.4. Printing Documents
        1. 11.4.1. Printing to PDF
        2. 11.4.2. Previewing documents
        3. 11.4.3. Setting page setup options
        4. 11.4.4. Printing envelopes and labels
          1. 11.4.4.1. Creating envelopes
          2. 11.4.4.2. Printing labels
      5. 11.5. Creating Mass Mailings
        1. 11.5.1. Creating a form letter
        2. 11.5.2. Using data source files
          1. 11.5.2.1. Creating a new data source
          2. 11.5.2.2. Using existing data sources
        3. 11.5.3. Adding fields to the form letter
        4. 11.5.4. Creating labels and envelopes in the Mail Merge Manager
      6. 11.6. Summary
  8. III. Using Excel
    1. 12. Excel Basics
      1. 12.1. Navigating the Excel Window
        1. 12.1.1. Title and menu bar
        2. 12.1.2. Formula bar
        3. 12.1.3. Rulers
        4. 12.1.4. Scroll box and scroll bars
        5. 12.1.5. Standard toolbar
        6. 12.1.6. Toolbox
        7. 12.1.7. Status bar and view buttons
      2. 12.2. Creating and Opening Workbooks and Worksheets
        1. 12.2.1. Starting a new workbook
        2. 12.2.2. Adding and deleting sheets
        3. 12.2.3. Opening an existing workbook
          1. 12.2.3.1. Opening a workbook with the Open command
          2. 12.2.3.2. Opening a document with the Open Recent menu
          3. 12.2.3.3. Opening a document with the Project Gallery
          4. 12.2.3.4. Searching for a file
        4. 12.2.4. Using the Project Gallery
        5. 12.2.5. Elements Gallery
      3. 12.3. Changing Views
        1. 12.3.1. Working with view modes
          1. 12.3.1.1. Normal view
          2. 12.3.1.2. Page Layout view
          3. 12.3.1.3. Using the Zoom tool
          4. 12.3.1.4. Using the Zoom dialog box
        2. 12.3.2. Creating custom views
      4. 12.4. Saving Excel Workbooks
        1. 12.4.1. Saving for the first time
          1. 12.4.1.1. Subsequent saves
          2. 12.4.1.2. Saving workspaces
        2. 12.4.2. Checking compatibility
      5. 12.5. Setting Workbook Properties
      6. 12.6. Protecting Workbooks and Data
        1. 12.6.1. Assigning read-only status
        2. 12.6.2. Assigning passwords
      7. 12.7. Summary
    2. 13. Entering and Editing Data
      1. 13.1. Typing Data
        1. 13.1.1. Moving around
        2. 13.1.2. Entering data
        3. 13.1.3. Using AutoComplete
        4. 13.1.4. Using AutoFill
          1. 13.1.4.1. Filling cells with repeating data
          2. 13.1.4.2. Continuing a sequence of data values
          3. 13.1.4.3. Automatically entering a series of date and time values
        5. 13.1.5. Importing Data
          1. 13.1.5.1. Importing from text files
          2. 13.1.5.2. Importing from CSV files
          3. 13.1.5.3. Importing from HTML files
          4. 13.1.5.4. Importing from FileMaker Pro
      2. 13.2. Selecting Cells
        1. 13.2.1. Selecting a range of cells
        2. 13.2.2. Selecting multiple cells
      3. 13.3. Adding and Deleting Cells
        1. 13.3.1. Adding cells
        2. 13.3.2. Deleting cells
        3. 13.3.3. Deleting content
      4. 13.4. Working with Rows and Columns
        1. 13.4.1. Adding and deleting rows and columns
        2. 13.4.2. Resizing rows and columns
        3. 13.4.3. Hiding rows and columns
        4. 13.4.4. Moving rows and columns
        5. 13.4.5. Freezing and splitting panes
          1. 13.4.5.1. Freezing panes
          2. 13.4.5.2. Splitting panes
      5. 13.5. Working with Sheets
        1. 13.5.1. Renaming sheets
        2. 13.5.2. Moving and copying sheets
        3. 13.5.3. Hiding sheets
        4. 13.5.4. Changing sheet backgrounds
      6. 13.6. Working with Named Ranges
        1. 13.6.1. Naming ranges
        2. 13.6.2. Reviewing named ranges
      7. 13.7. Moving and Copying Cells
      8. 13.8. Creating Lists
        1. 13.8.1. Exploring the List Wizard
          1. 13.8.1.1. Getting started with the List Wizard
          2. 13.8.1.2. Defining columns
          3. 13.8.1.3. Setting list options
        2. 13.8.2. Working with lists
          1. 13.8.2.1. Using the List toolbar
          2. 13.8.2.2. Using the List Manager
            1. 13.8.2.2.1. Entering data
            2. 13.8.2.2.2. Using AutoFilter
          3. 13.8.2.3. Reactivating the List Wizard
      9. 13.9. Sorting and Filtering Data
        1. 13.9.1. Sorting data
        2. 13.9.2. Filtering
          1. 13.9.2.1. Using AutoFilter
          2. 13.9.2.2. Using advanced filtering
      10. 13.10. Finding and Replacing Data
        1. 13.10.1. Using the Find dialog box
        2. 13.10.2. Using the Replace dialog box
      11. 13.11. Using Undo and Redo
      12. 13.12. Summary
    3. 14. Formatting Data and Worksheets
      1. 14.1. Formatting Cells
        1. 14.1.1. Choosing a number format
          1. 14.1.1.1. Formatting general
          2. 14.1.1.2. Formatting numbers
          3. 14.1.1.3. Formatting currency
          4. 14.1.1.4. Formatting for accounting
          5. 14.1.1.5. Formatting dates and time
          6. 14.1.1.6. Formatting percentages
          7. 14.1.1.7. Formatting fractions
          8. 14.1.1.8. Formatting scientific values
          9. 14.1.1.9. Formatting text
          10. 14.1.1.10. Special formatting
          11. 14.1.1.11. Creating a custom format
        2. 14.1.2. Changing alignment and spacing
          1. 14.1.2.1. Setting text alignment
            1. 14.1.2.1.1. Horizontal alignment
            2. 14.1.2.1.2. Vertical alignment
          2. 14.1.2.2. Setting text control
          3. 14.1.2.3. Changing the orientation
        3. 14.1.3. Changing fonts
          1. 14.1.3.1. Choosing a font
          2. 14.1.3.2. Applying character formatting
            1. 14.1.3.2.1. Underline options
            2. 14.1.3.2.2. Effect options
            3. 14.1.3.2.3. Normal Font
          3. 14.1.3.3. Changing text color
        4. 14.1.4. Adding and modifying borders
        5. 14.1.5. Setting a background pattern
      2. 14.2. Using the Format Toolbar
      3. 14.3. Using the Formatting Palette
      4. 14.4. Copying Formatting
      5. 14.5. Using AutoFormat
      6. 14.6. Applying Conditional Formatting
      7. 14.7. Using Styles
        1. 14.7.1. Creating styles
        2. 14.7.2. Applying styles
        3. 14.7.3. Copy and merge styles
      8. 14.8. Applying Document Themes
      9. 14.9. Summary
    4. 15. Using Formulas and Functions
      1. 15.1. Working with Formulas
        1. 15.1.1. Understanding formulas
          1. 15.1.1.1. Understanding operands
          2. 15.1.1.2. Understanding formula operators
            1. 15.1.1.2.1. Arithmetic operators
            2. 15.1.1.2.2. Comparison operators
            3. 15.1.1.2.3. Text operators
            4. 15.1.1.2.4. Cell reference operators
          3. 15.1.1.3. Explaining precedence
        2. 15.1.2. Writing formulas
          1. 15.1.2.1. Using the Formula Bar
          2. 15.1.2.2. Using the Formula Builder
      2. 15.2. Exploring Absolute and Relative Cell References
        1. 15.2.1. Using absolute references
        2. 15.2.2. Using named ranges
        3. 15.2.3. Naming formulas
      3. 15.3. Working with Functions
        1. 15.3.1. Understanding functions
        2. 15.3.2. Exploring function categories
          1. 15.3.2.1. Using database functions
          2. 15.3.2.2. Using date and time functions
          3. 15.3.2.3. Using engineering functions
          4. 15.3.2.4. Using financial functions
          5. 15.3.2.5. Using information functions
          6. 15.3.2.6. Using logical functions
          7. 15.3.2.7. Using lookup and reference functions
          8. 15.3.2.8. Using math and trigonometry functions
          9. 15.3.2.9. Using statistical functions
          10. 15.3.2.10. Using text functions
        3. 15.3.3. Using AutoComplete
        4. 15.3.4. Using AutoSum functions
      4. 15.4. Fixing Formula Errors
        1. 15.4.1. Checking for errors
        2. 15.4.2. Showing formulas in the worksheet
        3. 15.4.3. Using the Formula Auditing toolbar
          1. 15.4.3.1. Tracing precedents
          2. 15.4.3.2. Tracing dependents
          3. 15.4.3.3. Tracing errors
          4. 15.4.3.4. Adding comments
          5. 15.4.3.5. Highlighting invalid data
      5. 15.5. Controlling Automatic Recalculation
      6. 15.6. Summary
    5. 16. Creating Charts
      1. 16.1. Adding Charts
        1. 16.1.1. Understanding chart parts
          1. 16.1.1.1. Data points
          2. 16.1.1.2. Data series
          3. 16.1.1.3. Data categories
          4. 16.1.1.4. Axes
          5. 16.1.1.5. Axis labels
          6. 16.1.1.6. Plot area
          7. 16.1.1.7. Legend
          8. 16.1.1.8. Chart area
          9. 16.1.1.9. Gridlines
          10. 16.1.1.10. Chart text
        2. 16.1.2. Choosing a chart type
          1. 16.1.2.1. Area chart
          2. 16.1.2.2. Bar chart
          3. 16.1.2.3. Bubble chart
          4. 16.1.2.4. Column chart
          5. 16.1.2.5. Doughnut chart
          6. 16.1.2.6. Line chart
          7. 16.1.2.7. Pie chart
          8. 16.1.2.8. Radar chart
          9. 16.1.2.9. Stock chart
          10. 16.1.2.10. Surface chart
          11. 16.1.2.11. XY (Scatter) chart
        3. 16.1.3. Inserting a chart
      2. 16.2. Editing Chart Data
      3. 16.3. Formatting Charts
        1. 16.3.1. Formatting with the chart tools
        2. 16.3.2. Formatting individual chart elements
          1. 16.3.2.1. Format the chart area
            1. 16.3.2.1.1. Formatting with Fill options
            2. 16.3.2.1.2. Formatting with Line options
            3. 16.3.2.1.3. Formatting with Shadow options
            4. 16.3.2.1.4. Formatting with 3-D options
            5. 16.3.2.1.5. Formatting chart properties
            6. 16.3.2.1.6. Formatting with Font options
          2. 16.3.2.2. Format the plot area
          3. 16.3.2.3. Format a data series
            1. 16.3.2.3.1. Formatting the axis
            2. 16.3.2.3.2. Formatting labels
            3. 16.3.2.3.3. Formatting options
          4. 16.3.2.4. Format a single axis
          5. 16.3.2.5. Format a legend
          6. 16.3.2.6. Format a chart title
          7. 16.3.2.7. Format gridlines
          8. 16.3.2.8. Moving and deleting chart elements
      4. 16.4. Using Advanced Charting Techniques
        1. 16.4.1. Adding error bars
        2. 16.4.2. Adding trend lines
      5. 16.5. Summary
    6. 17. Using the Excel Database Tools
      1. 17.1. Retrieving External Data
        1. 17.1.1. Connecting to your database
        2. 17.1.2. Importing data using ODBC
          1. 17.1.2.1. Opening the connection
          2. 17.1.2.2. Creating the query
          3. 17.1.2.3. Removing tables and fields
          4. 17.1.2.4. Refining queries
            1. 17.1.2.4.1. Specifying criteria
            2. 17.1.2.4.2. Choosing a sort order
            3. 17.1.2.4.3. Joining tables
        3. 17.1.3. Returning results to Excel
      2. 17.2. Updating the Data
        1. 17.2.1. Refreshing data
        2. 17.2.2. Editing a query
        3. 17.2.3. Using parameters
          1. 17.2.3.1. Defining parameters
          2. 17.2.3.2. Setting parameter options
      3. 17.3. Analyzing Data with PivotTables
        1. 17.3.1. Creating PivotTables
        2. 17.3.2. Analyzing PivotTable data
        3. 17.3.3. Using advanced PivotTable settings
      4. 17.4. Using Goal Seek
      5. 17.5. Using Scenarios
        1. 17.5.1. Adding scenarios
        2. 17.5.2. Merging scenarios
        3. 17.5.3. Generating a scenario summary
        4. 17.5.4. Flagging for follow-up
      6. 17.6. Using Data Forms
      7. 17.7. Summary
    7. 18. Proofing, Printing, and Collaborating in Excel
      1. 18.1. Proofreading Workbooks
        1. 18.1.1. Checking spelling
        2. 18.1.2. Looking up words
        3. 18.1.3. Enabling AutoCorrect
      2. 18.2. Printing Worksheets and Workbooks
        1. 18.2.1. Defining a print area
        2. 18.2.2. Changing page setup
          1. 18.2.2.1. Setting page orientation and scaling
          2. 18.2.2.2. Setting margins
          3. 18.2.2.3. Setting headers and footers
          4. 18.2.2.4. Setting sheet options
          5. 18.2.2.5. Setting more page setup options
        3. 18.2.3. Printing data
        4. 18.2.4. Previewing your work
      3. 18.3. Using Collaboration Features
        1. 18.3.1. Sharing workbooks
          1. 18.3.1.1. Enabling worksheet sharing
          2. 18.3.1.2. Saving and resolving conflicts
          3. 18.3.1.3. Merging documents later
        2. 18.3.2. Tracking changes
          1. 18.3.2.1. Highlighting changes
          2. 18.3.2.2. Accepting and rejecting changes
        3. 18.3.3. Using the Reviewing toolbar
      4. 18.4. Summary
  9. IV. Presenting with PowerPoint
    1. 19. PowerPoint Basics
      1. 19.1. Navigating the PowerPoint Window
        1. 19.1.1. Viewing window parts
          1. 19.1.1.1. Title bar and menu bar
          2. 19.1.1.2. Standard toolbar
          3. 19.1.1.3. Elements Gallery
          4. 19.1.1.4. Toolbox
          5. 19.1.1.5. Slide pane
          6. 19.1.1.6. Slides/Outline view pane
          7. 19.1.1.7. Notes pane
          8. 19.1.1.8. View buttons
      2. 19.2. Creating, Opening, and Saving Presentations
        1. 19.2.1. Creating new files
        2. 19.2.2. Saving files
          1. 19.2.2.1. Saving for the first time
          2. 19.2.2.2. Subsequent saves
          3. 19.2.2.3. Saving an existing file under a new filename
          4. 19.2.2.4. Using AutoRecover
        3. 19.2.3. Using the Compatibility Report feature
        4. 19.2.4. Opening files
          1. 19.2.4.1. Open a presentation with the Open command
          2. 19.2.4.2. Open a presentation with the Open Recent menu
          3. 19.2.4.3. Open a document with the Project Gallery
          4. 19.2.4.4. Search for a file
      3. 19.3. Changing Views
        1. 19.3.1. Using the view modes
        2. 19.3.2. Using the Zoom feature
          1. 19.3.2.1. Using the Zoom tool
          2. 19.3.2.2. Using the Zoom dialog box
      4. 19.4. Setting Presentation Properties
      5. 19.5. Summary
    2. 20. Building Presentations
      1. 20.1. Planning a Presentation
      2. 20.2. Using Outlines
        1. 20.2.1. Creating an outline
        2. 20.2.2. Importing a Word outline
      3. 20.3. Adding Slide Content
        1. 20.3.1. Working with layouts
        2. 20.3.2. Adding text
        3. 20.3.3. Adding clip art
        4. 20.3.4. Adding a picture
        5. 20.3.5. Adding a table
        6. 20.3.6. Adding a chart
        7. 20.3.7. Adding a SmartArt graphic
        8. 20.3.8. Adding a movie or sound clip
      4. 20.4. Assigning Themes
      5. 20.5. Navigating and Working with Slides
        1. 20.5.1. Navigating slides
        2. 20.5.2. Adding and deleting slides
        3. 20.5.3. Moving slides
        4. 20.5.4. Hiding slides
        5. 20.5.5. Inserting slides from other presentations
      6. 20.6. Working with Slide Masters
      7. 20.7. Summary
    3. 21. Formatting Slides
      1. 21.1. Formatting Text
        1. 21.1.1. Using the Formatting Palette
        2. 21.1.2. Applying bold, italics, and underline
        3. 21.1.3. Formatting with fonts and sizes
        4. 21.1.4. Formatting bullets and numbering
        5. 21.1.5. Formatting with alignment and spacing
        6. 21.1.6. Formatting with color
        7. 21.1.7. Applying Quick Styles and Effects for text
        8. 21.1.8. Copying formatting
      2. 21.2. Easy Formatting for Slide Elements
        1. 21.2.1. Applying Quick Styles and Effects
        2. 21.2.2. Formatting with shadows and reflections
        3. 21.2.3. Formatting with colors, weights, and fills
        4. 21.2.4. Formatting for size, rotation, and slide order
        5. 21.2.5. Customizing themes
      3. 21.3. Working with Backgrounds
      4. 21.4. Summary
    4. 22. Fine-tuning a Presentation
      1. 22.1. Rearranging Slides
      2. 22.2. Adding Transition Effects
        1. 22.2.1. Assigning transitions from the Elements Gallery
        2. 22.2.2. Setting transition options
      3. 22.3. Adding Animation Effects
        1. 22.3.1. Customize animation settings
        2. 22.3.2. Assigning more effect options
        3. 22.3.3. Setting animation timings
        4. 22.3.4. Applying text animation settings
        5. 22.3.5. Applying chart animation settings
      4. 22.4. Adding Slide Controls and Action Buttons
      5. 22.5. Adding Sound and Narration
        1. 22.5.1. Play a CD during a presentation
        2. 22.5.2. Play a soundtrack throughout a presentation
        3. 22.5.3. Recording narration
      6. 22.6. Rehearsing Timings
      7. 22.7. Summary
    5. 23. Preparing and Presenting a Slide Show
      1. 23.1. Setting Up a Slide Show
        1. 23.1.1. Choosing a show type
        2. 23.1.2. Creating a custom show
      2. 23.2. Ways to Present a Slide Show
        1. 23.2.1. Presentation scenarios
        2. 23.2.2. Presentation tips
      3. 23.3. Running a Slide Show
        1. 23.3.1. Starting and navigating a slide show
        2. 23.3.2. Using pointer tools
        3. 23.3.3. Using Presenter Tools
      4. 23.4. Printing Presentations
        1. 23.4.1. Making changes to Page Setup
          1. 23.4.1.1. Adding headers and footers
        2. 23.4.2. Printing slides, handouts, and notes
      5. 23.5. Saving Slides as Other Objects
        1. 23.5.1. Saving a presentation as a QuickTime movie
        2. 23.5.2. Saving slides as graphics files
          1. 23.5.2.1. Save as pictures
          2. 23.5.2.2. Send to iPhoto
        3. 23.5.3. Saving a presentation as a Web page
      6. 23.6. Summary
  10. V. Working with Entourage
    1. 24. Entourage Basics
      1. 24.1. Using the Setup Assistant
      2. 24.2. Navigating the Entourage Window
        1. 24.2.1. Viewing the main Entourage features
          1. 24.2.1.1. Mail
          2. 24.2.1.2. Address Book
          3. 24.2.1.3. Calendar
          4. 24.2.1.4. Notes
          5. 24.2.1.5. Tasks
          6. 24.2.1.6. Project Center
        2. 24.2.2. Viewing window elements
          1. 24.2.2.1. Title and menu bar
          2. 24.2.2.2. Toolbar
          3. 24.2.2.3. Panes
      3. 24.3. Summary
    2. 25. E-mailing with Entourage
      1. 25.1. Setting Up an E-mail Account
      2. 25.2. Working with the Mail Tool
        1. 25.2.1. Introducing Mail
        2. 25.2.2. Using Mail Views in the Folders List
        3. 25.2.3. Inbox columns and icons
      3. 25.3. Receiving and Sending E-mail
        1. 25.3.1. Checking for e-mail
        2. 25.3.2. Reading e-mail messages
        3. 25.3.3. Creating and sending an e-mail
          1. 25.3.3.1. Assigning flags, priorities, and categories
          2. 25.3.3.2. Inserting pictures, backgrounds, sounds, or movie clips
        4. 25.3.4. Replying to an e-mail
        5. 25.3.5. Forwarding an e-mail
        6. 25.3.6. Adding a signature
        7. 25.3.7. Scheduling message checking
        8. 25.3.8. Sending an automatic response
      4. 25.4. Managing Messages
        1. 25.4.1. Deleting messages
        2. 25.4.2. Printing messages
        3. 25.4.3. Filing messages
        4. 25.4.4. Getting rid of junk e-mail
        5. 25.4.5. Marking messages
        6. 25.4.6. Setting message rules
        7. 25.4.7. Linking messages
        8. 25.4.8. Working with attachments
          1. 25.4.8.1. Receiving attachments
          2. 25.4.8.2. Sending attachments
      5. 25.5. Using the Address Book
        1. 25.5.1. Introducing the Address Book
        2. 25.5.2. Adding a contact
        3. 25.5.3. Working with contacts
        4. 25.5.4. Creating groups
        5. 25.5.5. Importing and exporting contacts
      6. 25.6. Viewing Newsgroups
        1. 25.6.1. Setting up a news account
        2. 25.6.2. Accessing newsgroups
      7. 25.7. Summary
    3. 26. Organizing Your Calendar
      1. 26.1. Working with the Calendar
        1. 26.1.1. Using Calendar views
          1. 26.1.1.1. Day view
          2. 26.1.1.2. Work Week view
          3. 26.1.1.3. Week view
          4. 26.1.1.4. Month view
          5. 26.1.1.5. List view
          6. 26.1.1.6. Calendar views in the Folders List
      2. 26.2. Recording Appointments and All-day Events
        1. 26.2.1. Recording a time-slot appointment
        2. 26.2.2. Recording an all-day event
        3. 26.2.3. Recording a recurring event
      3. 26.3. Editing Calendar Items
        1. 26.3.1. Editing events
          1. 26.3.1.1. Edit an appointment's timeframe
          2. 26.3.1.2. Move an appointment
          3. 26.3.1.3. Using the Event window to edit
        2. 26.3.2. Deleting events
      4. 26.4. Working with Categories
      5. 26.5. Working with Reminders
      6. 26.6. Adding Holidays
      7. 26.7. Working with Invitations
        1. 26.7.1. Creating an invite
        2. 26.7.2. Receiving an invite
        3. 26.7.3. Tracking an invite
      8. 26.8. Printing Calendar Items
      9. 26.9. Summary
    4. 27. Tracking Tasks, Notes, and Projects
      1. 27.1. Organizing Tasks
        1. 27.1.1. Creating tasks
        2. 27.1.2. Editing tasks
        3. 27.1.3. Sorting and filtering tasks
        4. 27.1.4. Handling reminders
        5. 27.1.5. Working with the To Do List
      2. 27.2. Making Notes
      3. 27.3. Printing Tasks and Notes
      4. 27.4. Working with Projects
        1. 27.4.1. Starting a new project
        2. 27.4.2. Viewing projects in the Project Center
          1. 27.4.2.1. Overview tab
          2. 27.4.2.2. Schedule tab
          3. 27.4.2.3. Mail tab
          4. 27.4.2.4. Files tab
          5. 27.4.2.5. Contacts tab
          6. 27.4.2.6. Clippings tab
          7. 27.4.2.7. Notes tab
        3. 27.4.3. Sharing projects
        4. 27.4.4. Backing up projects
      5. 27.5. Using My Day
      6. 27.6. Summary
  11. VI. Organizing Digital Media with Expression Media
    1. 28. Introducing Expression Media
      1. 28.1. Navigating the Expression Media Window
        1. 28.1.1. Viewing the window parts
          1. 28.1.1.1. Title and menu bar
          2. 28.1.1.2. Toolbar
          3. 28.1.1.3. View modes
            1. 28.1.1.3.1. List view
            2. 28.1.1.3.2. Thumbnail view
            3. 28.1.1.3.3. Media view
          4. 28.1.1.4. Annotation panels
          5. 28.1.1.5. Info panel
          6. 28.1.1.6. Organize panel
            1. 28.1.1.6.1. Catalog Fields panel
            2. 28.1.1.6.2. Hierarchical Keywords panel
            3. 28.1.1.6.3. Catalog Folders panel
          7. 28.1.1.7. Status bar
        2. 28.1.2. Importing digital media
          1. 28.1.2.1. Importing from files or folders
          2. 28.1.2.2. Importing catalogs
          3. 28.1.2.3. Importing from the Spotlight feature
          4. 28.1.2.4. Downloading and importing from cameras, removable disks, or memory cards
          5. 28.1.2.5. Importing from the Web
      2. 28.2. Summary
    2. 29. Working with Catalogs
      1. 29.1. Understanding Catalogs
        1. 29.1.1. Saving a catalog
        2. 29.1.2. Finding catalogs
      2. 29.2. Viewing Catalogs
        1. 29.2.1. Marking media
          1. 29.2.1.1. Assigning a star rating
          2. 29.2.1.2. Assigning a color label
        2. 29.2.2. Using the Light Table
      3. 29.3. Organizing Catalogs
        1. 29.3.1. Moving media
        2. 29.3.2. File renaming
        3. 29.3.3. Batch renaming
        4. 29.3.4. Searching through catalogs
        5. 29.3.5. Filtering catalogs
      4. 29.4. Viewing Slide Shows
      5. 29.5. Basic Image Editing Techniques
      6. 29.6. Printing Catalogs
      7. 29.7. Summary
  12. VII. Working with Office Graphics and Web Features
    1. 30. Adding Graphics
      1. 30.1. Working with Clip Art
        1. 30.1.1. Using the Clip Gallery
        2. 30.1.2. Downloading more clip art
        3. 30.1.3. Using the Object Palette
      2. 30.2. Adding Pictures
        1. 30.2.1. Choosing a picture
        2. 30.2.2. Using the Object Palette
      3. 30.3. Adding SmartArt Graphics
      4. 30.4. Adding WordArt
      5. 30.5. Adding AutoShapes
      6. 30.6. Adding Text Boxes
      7. 30.7. Using the Drawing Toolbar
      8. 30.8. Formatting Graphics
        1. 30.8.1. Using the Formatting Palette
          1. 30.8.1.1. Size, Rotation, and Ordering
          2. 30.8.1.2. Wrapping
          3. 30.8.1.3. Colors, Weights, and Fills
          4. 30.8.1.4. Shadow
          5. 30.8.1.5. Picture
          6. 30.8.1.6. Quick Styles and Effects
          7. 30.8.1.7. Reflection
        2. 30.8.2. Using the Format dialog box
          1. 30.8.2.1. Formatting options for pictures and clip art
          2. 30.8.2.2. Formatting options for shapes, text boxes, and WordArt objects
      9. 30.9. Summary
    2. 31. Creating Web Content
      1. 31.1. Turning Office Files into Web Pages
      2. 31.2. Previewing a Web Page
      3. 31.3. Saving Content as a Web Page
      4. 31.4. Adding Hyperlinks
      5. 31.5. Summary
    3. 32. Using Microsoft Messenger
      1. 32.1. Setting Up Messenger
      2. 32.2. Signing On and Out with Messenger
      3. 32.3. Working with the Personal Contacts Window
        1. 32.3.1. Adding and deleting contacts
        2. 32.3.2. Change your display picture
        3. 32.3.3. Change your status and privacy settings
      4. 32.4. Sending Instant Messages
      5. 32.5. Sending a File
      6. 32.6. E-mailing from Messenger
      7. 32.7. Summary
  13. VIII. Coordinating and Customizing Your Office
    1. 33. Coordinating Projects
      1. 33.1. Using the Projects Gallery
        1. 33.1.1. Creating a new project
        2. 33.1.2. Opening recent projects
        3. 33.1.3. Using the Project Center
        4. 33.1.4. Customizing your settings
      2. 33.2. Using the Office Scrapbook Tool
        1. 33.2.1. Adding items to the Scrapbook
        2. 33.2.2. Inserting items from the Scrapbook
        3. 33.2.3. Organizing the Scrapbook
        4. 33.2.4. Deleting clippings
      3. 33.3. Summary
    2. 34. Customizing Office
      1. 34.1. Setting Program Preferences
        1. 34.1.1. Setting Word preferences
          1. 34.1.1.1. General
          2. 34.1.1.2. View
          3. 34.1.1.3. Edit
          4. 34.1.1.4. Spelling and Grammar
          5. 34.1.1.5. AutoCorrect
          6. 34.1.1.6. Save
          7. 34.1.1.7. Print
          8. 34.1.1.8. Compatibility
          9. 34.1.1.9. Track Changes
          10. 34.1.1.10. Audio Notes
          11. 34.1.1.11. User Information
          12. 34.1.1.12. Security
          13. 34.1.1.13. Feedback
          14. 34.1.1.14. File Locations
          15. 34.1.1.15. Gallery
        2. 34.1.2. Setting Excel preferences
          1. 34.1.2.1. General
          2. 34.1.2.2. View
          3. 34.1.2.3. Edit
          4. 34.1.2.4. AutoCorrect
          5. 34.1.2.5. Chart
          6. 34.1.2.6. Color
          7. 34.1.2.7. Calculation
          8. 34.1.2.8. Error Checking
          9. 34.1.2.9. Custom Lists
          10. 34.1.2.10. AutoComplete
          11. 34.1.2.11. Save
          12. 34.1.2.12. Compatibility
          13. 34.1.2.13. Security
          14. 34.1.2.14. Feedback
          15. 34.1.2.15. Gallery
        3. 34.1.3. Setting PowerPoint preferences
          1. 34.1.3.1. General
          2. 34.1.3.2. View
          3. 34.1.3.3. Edit
          4. 34.1.3.4. Save
          5. 34.1.3.5. Spelling
          6. 34.1.3.6. Gallery
          7. 34.1.3.7. AutoCorrect
          8. 34.1.3.8. Compatibility
          9. 34.1.3.9. Advanced
          10. 34.1.3.10. Feedback
        4. 34.1.4. Setting Entourage preferences
          1. 34.1.4.1. General
          2. 34.1.4.2. Address Book
          3. 34.1.4.3. To Do List
          4. 34.1.4.4. Calendar
          5. 34.1.4.5. Fonts
          6. 34.1.4.6. Spelling
          7. 34.1.4.7. Notification
          8. 34.1.4.8. Security
          9. 34.1.4.9. Sync Services
          10. 34.1.4.10. Spotlight Services
          11. 34.1.4.11. Feedback
          12. 34.1.4.12. Read
          13. 34.1.4.13. Compose
          14. 34.1.4.14. Reply & Forward
          15. 34.1.4.15. View
      2. 34.2. Customizing Toolbars and Menus
        1. 34.2.1. Customizing toolbars
          1. 34.2.1.1. Moving or deleting buttons
          2. 34.2.1.2. Adding buttons
          3. 34.2.1.3. Creating a new toolbar
        2. 34.2.2. Customizing menus
          1. 34.2.2.1. Removing menu commands
          2. 34.2.2.2. Adding menu commands
          3. 34.2.2.3. Creating a new menu
      3. 34.3. Customizing Keyboard Shortcut Keys
      4. 34.4. Summary
    3. 35. Working with AppleScript
      1. 35.1. What Is AppleScript?
        1. 35.1.1. Viewing the Script Editor
        2. 35.1.2. Writing a script
        3. 35.1.3. Compile a script
        4. 35.1.4. Saving a script
      2. 35.2. Using Scripts in Office
        1. 35.2.1. Running scripts with keyboard shortcuts
        2. 35.2.2. Running an Entourage script
        3. 35.2.3. Using Automator workflows
          1. 35.2.3.1. Viewing the Automator window
          2. 35.2.3.2. Using Office Automator workflows
      3. 35.3. Summary
    4. Glossary