You are previewing Office 2008 for the Mac on Demand.
O'Reilly logo
Office 2008 for the Mac on Demand

Book Description

Office 2008 for the Mac on Demand

Steve Johnson, Perspection Inc.

What you need, when you need it!

Need answers quickly? Office 2008 for the Mac on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. You will learn how to use all the applications in Office 2008 including Word, Excel, PowerPoint, Entourage, Project Gallery, and Messenger.

Inside the Book

• Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts

• Word: Create great-looking documents, publications, and notebooks using themes, styles, and templates

• Excel: Use organizing, processing, and presenting tools to create data, lists, and charts

• PowerPoint: Create powerful presentations faster using ready-made design templates and themes

• Entourage: Use tools for creating and managing your e-mail, calendar, contacts, and tasks

• Project Center: Gather and manage important Office and non-Office project documents in a convenient centralized place

On the Web

• Online Workshops

• Keyboard shortcuts

• Transitional tools

• Additional chapters

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