Office 2008 for the Mac on Demand

Table of contents

1. Title Page
2. Copyright Page
3. Contents
4. Acknowledgements
   1. Perspection, Inc.
   2. Acknowledgements
   3. About The Author
   4. We Want To Hear From You!
5. Introduction
   1. How This Book Works
   2. What’s New
   3. Keyboard Shortcuts
   4. Step-by-Step Instructions
   5. Real World Examples
   6. Workshop
   7. Get More On The Web
6. 1. Getting Started with Office
   1. Starting an Office Program
   2. Using the Project Gallery
   3. Viewing an Office Program Window
   4. Choosing Commands
   5. Working with Toolbars
   6. Working with the Elements Gallery
   7. Creating a Blank Office Document
   8. Creating a Document Using a Template
   9. Opening an Existing Office Document
   10. Managing Windows
   11. Switching Views
   12. Using the Toolbox
   13. Checking Compatibility
   14. Saving an Office Document
   15. Saving an Office Document with Different Formats
   16. Creating a Template
   17. Recovering an Office Document
   18. Getting Updates on the Web
   19. Getting Help While You Work
   20. Closing a Document and Quitting Office
7. 2. Using Shared Office Tools
   1. Editing Text
   2. Formatting Text
   3. Copying and Moving Text
   4. Using the Scrapbook
   5. Finding and Replacing Text
   6. Correcting Text Automatically
   7. Checking Spelling
   8. Changing Spelling Options
   9. Finding the Right Words
   10. Researching Words
   11. Translating Text to Another Language
   12. Using Multiple Languages
   13. Inserting Symbols
   14. Undoing and Redoing an Action
   15. Zooming the View In and Out
   16. Using the Format Painter
   17. Adding Custom Colors
   18. Understanding Themes
   19. Viewing and Applying a Theme
   20. Applying and Creating Theme Colors
   21. Applying Theme Fonts
   22. Creating a Custom Theme
   23. Applying a Custom Theme
   24. Previewing a Document
   25. Printing a Document
   26. Protecting a Document
   27. Modifying Document Properties
8. 3. Adding Art to Office Documents
   1. Locating and Inserting Clip Art
   2. Inserting a Picture
   3. Adding a Quick Style to a Picture
   4. Applying a Shape to a Picture
   5. Applying Picture Effects
   6. Applying a Border to a Picture
   7. Modifying Picture Brightness and Contrast
   8. Recoloring a Picture
   9. Modifying Picture Size
   10. Cropping and Rotating a Picture
   11. Creating WordArt Text
   12. Formatting WordArt Text
   13. Modifying WordArt Text Position
   14. Creating SmartArt Graphics
   15. Formatting a SmartArt Graphic
   16. Modifying a SmartArt Graphic
   17. Creating an Organization Chart
   18. Modifying an Organization Chart
   19. Inserting and Creating a Chart
   20. Changing a Chart Type
   21. Changing a Chart Layout Style
   22. Changing Chart Titles
   23. Changing Chart Labels
   24. Editing Chart Data
   25. Sharing Information Between Programs
   26. Linking and Embedding Objects
   27. Flagging Documents for Follow Up
9. 4. Adding Shapes to Office Documents
   1. Drawing and Resizing Shapes
   2. Creating and Editing Freeforms
   3. Adding Text to a Shape
   4. Adding a Quick Style to a Shape
   5. Adding a Quick Style to Shape Text
   6. Adding Other Effects to a Shape
   7. Applying Color Fills
   8. Applying Picture or Texture Fills
   9. Applying Gradient Fills
   10. Aligning and Distributing Objects
   11. Aligning Objects to Grids and Guides
   12. Changing Stacking Order
   13. Rotating and Flipping Objects
   14. Grouping and Ungrouping Objects
   15. Creating a Text Box
10. 5. Creating a Document with Word
    1. Viewing the Word Window
    2. Creating a New Word Document
    3. Moving Around in a Document
    4. Navigating a Document
    5. Changing Document Views
    6. Creating a Notebook
    7. Creating a Publication
    8. Adding to a Publication
    9. Creating an Outline
    10. Setting Up the Page
    11. Setting Up the Page Margins
    12. Selecting Text
    13. Showing Characters
    14. Checking Spelling and Grammar
    15. Using Custom Dictionaries
    16. Setting Hyphenation
    17. Inserting AutoText
    18. Inserting New Pages
    19. Controlling the Way Pages Break
    20. Inserting New Sections
    21. Arranging Text in Columns
    22. Adding Headers and Footers
    23. Inserting Page Numbers and the Date and Time
    24. Inserting Symbols and Special Characters
11. 6. Formatting a Document with Word
    1. Formatting Text for Emphasis
    2. Using Automatic Formatting
    3. Finding and Replacing Formatting
    4. Changing Paragraph Alignment
    5. Changing Line Spacing
    6. Displaying Rulers
    7. Setting Paragraph Tabs
    8. Setting Paragraph Indents
    9. Creating Bulleted and Numbered Lists
    10. Changing Character Spacing
    11. Changing Text Direction
    12. Applying a Style
    13. Revealing Formatting Styles
    14. Creating and Modifying Styles
    15. Hiding Text
12. 7. Enhancing a Document with Word
    1. Adding a Drop Cap
    2. Adding a Watermark
    3. Adding Page Backgrounds
    4. Wrapping Text Around an Object
    5. Working with Text Boxes
    6. Creating a Table
    7. Entering Text in a Table
    8. Modifying a Table
    9. Adjusting Table Cells
    10. Formatting a Table
    11. Adding a Quick Style to a Table
    12. Calculating a Value in a Table
    13. Creating a Form Letter
    14. Creating Labels
    15. Inserting a Table of Contents
    16. Creating an Index
    17. Creating Captions
    18. Creating Footnotes or Endnotes
    19. Creating a Bookmark
    20. Comparing Documents
    21. Using Track Changes
    22. Addressing Envelopes and Labels
    23. Using Print Preview
    24. Adding a Cover Page
13. 8. Creating a Worksheet with Excel
    1. Viewing the Excel Window
    2. Selecting Cells
    3. Moving Around the Workbook
    4. Entering Labels on a Worksheet
    5. Entering Values on a Worksheet
    6. Entering Values Quickly with AutoFill
    7. Editing Cell Contents
    8. Clearing Cell Contents
    9. Inserting and Deleting Cell Contents
    10. Selecting Rows, Columns, and Special Ranges
    11. Selecting and Naming a Worksheet
    12. Inserting and Deleting a Worksheet
    13. Inserting a Worksheet from the Elements Gallery
    14. Moving and Copying a Worksheet
    15. Hiding or Unhiding a Worksheet
    16. Hiding and Unhiding a Column or Row
    17. Inserting a Column or Row
    18. Deleting a Column or Row
    19. Adjusting Column Width and Row Height
    20. Splitting a Worksheet into Panes
    21. Freezing and Unfreezing a Column or Row
    22. Showing and Hiding Workbook Elements
14. 9. Building a Worksheet with Excel
    1. Understanding Formulas
    2. Understanding Cell Referencing
    3. Creating a Simple Formula
    4. Creating a Formula Using Formula AutoComplete
    5. Editing a Formula
    6. Naming Cells and Ranges
    7. Entering Named Cells and Ranges
    8. Simplifying a Formula with Ranges
    9. Using the Calculator
    10. Using the Formula Builder
    11. Using Nested Functions
    12. Calculating Multiple Results
    13. Using Lookup and Reference Functions
    14. Using Text Functions
    15. Summarizing Data Using Subtotals
    16. Summarizing Data Using Functions
    17. Calculating Totals with AutoSum
    18. Calculating a Conditional Sum
    19. Auditing a Worksheet
    20. Correcting Calculation Errors
    21. Correcting Formulas
    22. Creating a List
    23. Entering and Editing Data in a List
    24. Formatting a List
    25. Working with Lists
    26. Sorting Data in a List
    27. Displaying Parts of a List with AutoFilter
    28. Creating Custom Searches
    29. Creating Calculations in a List
    30. Converting Text to Columns
    31. Creating Groups and Outlines
    32. Adding Data Validation to a Worksheet
    33. Creating a Drop-Down List
15. 10. Designing a Worksheet with Excel
    1. Formatting Numbers
    2. Designing Conditional Formatting
    3. Controlling Text Flow
    4. Changing Data Alignment
    5. Changing Data Color
    6. Adding Color and Patterns to Cells
    7. Adding Borders to Cells
    8. Formatting Data with AutoFormat
    9. Creating and Applying Styles
    10. Formatting a Background
    11. Inserting Page Breaks
    12. Setting Up the Page
    13. Adding Headers and Footers
    14. Setting the Print Area
    15. Customizing Worksheet Printing
16. 11. Sharing a Worksheet with Excel
    1. Locking or Unlocking Worksheet Cells
    2. Protecting Worksheets and Workbooks
    3. Sharing Workbooks
    4. Creating and Reading a Cell Comment
    5. Editing and Deleting a Cell Comment
    6. Tracking Changes
    7. Comparing and Merging Workbooks
    8. Asking “What If” with Goal Seek
    9. Creating Scenarios
    10. Exporting Data
    11. Analyzing Data Using a PivotTable
    12. Consolidating Data
    13. Linking Data
    14. Getting Query Data from a Database
    15. Getting Query Data from the Web
    16. Getting Data from a FileMaker Pro Database
    17. Getting Text Data
17. 12. Creating a Presentation with PowerPoint
    1. Viewing the PowerPoint Window
    2. Browsing a Presentation
    3. Understanding PowerPoint Views
    4. Creating New and Consistent Slides
    5. Working with Objects
    6. Entering and Editing Text
    7. Resizing Text While Typing
    8. Changing Character Direction
    9. Inserting and Developing an Outline
    10. Moving and Indenting Text
    11. Modifying a Bulleted and Numbered List
    12. Creating Text Columns
    13. Changing Text Spacing
    14. Rearranging Slides
    15. Using Slides from Other Presentations
    16. Making Your Presentation Look Consistent
    17. Controlling Slide Appearance with Masters
    18. Controlling a Slide Layout with Masters
    19. Modifying Placeholders
    20. Controlling a Slide Background with Masters
    21. Adding a Background Style
    22. Inserting a Table
    23. Adding a Quick Style to a Table
    24. Modifying a Table
    25. Formatting a Table
    26. Inserting Special Characters
    27. Creating a Text Box
18. 13. Delivering a Presentation with PowerPoint
    1. Changing Page Setup Options
    2. Adding Animation
    3. Using Specialized Animations
    4. Coordinating Multiple Animations
    5. Adding Slide Timings
    6. Creating Slide Transitions
    7. Recording a Narration
    8. Inserting Movies and Sounds
    9. Setting Movie and Sound Play Options
    10. Setting Up a Slide Show
    11. Creating a Custom Slide Show
    12. Starting and Navigating a Slide Show
    13. Annotating a Slide Show
    14. Using Presenter Tools
    15. Saving a Presentation as a Movie
    16. Saving a Presentation as a Slide Show
    17. Preparing Handouts
    18. Preparing Speaker Notes
    19. Adding Comments to a Presentation
    20. Adding a Header and Footer
    21. Inserting the Date and Time
    22. Inserting Slide Numbers
    23. Printing a Presentation
19. 14. Communicating with Entourage
    1. Viewing the Entourage Window
    2. Preparing for Entourage
    3. Setting Up an Account
    4. Changing Views
    5. Viewing Items and Folders
    6. Creating a Contact
    7. Sorting Contacts
    8. Creating a Contact Group
    9. Creating and Addressing an E-Mail Message
    10. Formatting Message Text
    11. Attaching a File to a Message
    12. Creating a Signature
    13. Setting Message Delivery Priorities
    14. Sending Messages
    15. Receiving and Reading Messages
    16. Flagging Messages
    17. Categorizing Messages By Color
    18. Replying To and Forwarding a Message
    19. Organizing Messages in Folders
    20. Managing Messages with Rules
    21. Searching with Spotlight
    22. Finding and Filtering Messages
    23. Using Search Folders
    24. Creating a Mailing List
    25. Deleting Messages
    26. Reducing Junk E-Mail
    27. Archiving Messages
    28. Sending and Receiving Instant Messages
    29. Creating a News Server Account
    30. Reading and Posting a News Message
    31. Customizing Toolbars in Entourage
20. 15. Managing Information with Entourage
    1. Viewing the Calendar
    2. Customizing the Calendar
    3. Scheduling an Appointment and Event
    4. Modifying or Deleting an Event
    5. Responding to Reminders
    6. Inviting Others to an Event
    7. Responding to Event Requests
    8. Updating and Canceling Event Requests
    9. Creating and Updating Tasks
    10. Creating a To Do List Item
    11. Viewing Tasks and To Do List Items
    12. Managing Tasks and To Do List Items
    13. Creating and Modifying Notes
    14. Using My Day
    15. Viewing the My Day Window
    16. Synchronizing Entourage with an iPod
    17. Printing Items from Entourage
21. 16. Publishing Office Documents on the Web
    1. Opening a Web Page
    2. Previewing a Web Page
    3. Creating a Hyperlink
    4. Adding Hyperlinks to Slide Objects
    5. Changing Web Page Options
    6. Saving a Web Page
    7. Saving Slides as Web Graphics
    8. Creating a PDF Document
    9. Sending a Document Using E-Mail
22. 17. Customizing and Expanding Office
    1. Customizing Toolbars
    2. Changing Menus
    3. Changing Shortcut Keys
    4. Working with Macros
    5. Opening a Document with Macros
    6. Saving a Document with Macros
    7. Installing and Running Office Scripts
    8. Working with an Automator Workflow
    9. Using Ready-Made AppleScripts
    10. Writing and Recording AppleScripts
    11. Removing Office
23. 18. Using the Project Center
    1. Creating a Project
    2. Using the Project Center
    3. Adding and Removing Project Contacts
    4. Adding and Removing E-mail Messages
    5. Adding Notes, Tasks, Events, or Clippings
    6. Adding Document Files
    7. Working with Projects in Office
    8. Backing Up a Project
24. New! Features
    1. Microsoft Office 2008
25. On Demand Online Workshop
    1. Here are Some of the Workshops You’ll Find
26. Index