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

Book Description

The smart way to learn the latest version of Microsoft Office for Mac one step at a time! Work at your own pace through the easy numbered steps and master the fundamental skills for working with the core programs Word 2008, Excel® 2008, PowerPoint® 2008, and Entourage® 2008 and the new user interface. With this learn-by-doing tutorial, you'll teach yourself how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. You'll also discover how to get your Web site up and running, how to take notes electronically, and how to manage your e-mail communications and workday. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction building and practicing the skills you need, just when you need them!
Key Book Benefits

Covers the fundamentals of working with Word 2008, Excel 2008, PowerPoint 2008, and Entourage 2008 for the Macintosh. Introduces the new Microsoft Office user interface Features easy-to-follow lessons and hands-on skill-building exercises.

Visit the catalog page for Microsoft® Office 2008 for Mac Step by StepVisit the errata page for Microsoft® Office 2008 for Mac Step by StepDownload the supplemental electronic content for Microsoft® Office 2008 for Mac Step by Step

Table of Contents

  1. Microsoft® Office 2008 for Mac Step by Step
  2. A Note Regarding Supplemental Files
  3. Introducing Microsoft Office 2008 for Mac
    1. Program Overview
    2. New Features
      1. New in Office 2008
      2. New in Word 2008
      3. New in Excel 2008
      4. New in PowerPoint 2008
      5. New in Entourage 2008
    3. Let’s Get Started!
  4. Features and Conventions of This Book
  5. Using the Companion Content
    1. Practice Files
      1. Using the Practice Files
      2. Removing the Practice Files
      3. Practice File List
    2. Bonus Web Content
    3. Minimum System Requirements
  6. Getting Help
    1. Getting Help with This Book and Its Companion Content
    2. Getting Help with an Office 2008 Program
  7. About the Author
    1. Online Training Solutions, Inc. (OTSI)
    2. America’s Finest Publishing Team
  8. Quick Reference
    1. Microsoft Office 2008 for Mac
    2. Office 2008 Keyboard Shortcuts
      1. Working with files, programs, and tools
      2. Dialog boxes
      3. Editing
      4. Formatting
      5. Moving around in text
      6. Basic Office 2008 Skills
        1. Closing files and programs
        2. Dialog boxes
        3. Document windows
        4. Elements Gallery
        5. Opening files
        6. Preferences dialog box
        7. Saving files
        8. Selecting text
        9. Starting and activating programs
        10. Toolbars and the toolbar area
        11. Toolbox
      7. Simple Instructions for Doing Things in Office 2008
        1. AutoCorrect
        2. Clip art
        3. Compatibility reports
        4. Diagrams
        5. Editing content
        6. Finding and replacing text and formatting
        7. Font Book
        8. Format Painter
        9. Formatting graphics
        10. Formatting Palette
        11. Formatting text manually
        12. Page setup
        13. Photos and pictures
        14. Printing files
        15. Program preferences
        16. Project Gallery
        17. Reference tools
        18. Saving files
        19. Shapes
        20. SmartArt diagrams
        21. Software Update
        22. Status bar
        23. Symbols
        24. System control
        25. Themes
        26. User information
        27. Viewing files
    3. Microsoft Word 2008 for Mac
    4. Word 2008 Keyboard Shortcuts
      1. Moving the cursor
      2. Selecting text and graphics
      3. Editing text and graphics
      4. Aligning and formatting paragraphs
      5. Inserting paragraphs and tab characters in a table
      6. Formatting characters
      7. Selecting text and graphics in a table
      8. Moving around in a table
      9. Reviewing documents
      10. Printing and previewing documents
      11. Simple Instructions for Doing Things in Word 2008
        1. Bibliography
        2. Borders and shading
        3. Charts
        4. Comments
        5. Copying and pasting content
        6. Cover pages
        7. Document formatting
        8. Document properties
        9. Document templates
        10. Finding text
        11. Formatting text by using styles
        12. Formatting text manually
        13. Formatting paragraphs
        14. Headers and footers
        15. Hiding text
        16. Index
        17. Inserting and linking to files
        18. Inserting information fields
        19. New documents
        20. Page breaks
        21. Page numbers
        22. Ruler
        23. Section breaks
        24. Spelling and Grammar
        25. Tables of contents (TOCs)
        26. Tracking changes
        27. Viewing documents
        28. Watermarks
    5. Microsoft Excel 2008 for Mac
    6. Excel 2008 Keyboard Shortcuts
      1. Moving and scrolling in a sheet or workbook
      2. Entering data on a sheet
      3. Working with a selection
      4. Formatting and editing data
      5. Working in cells or the Formula bar
      6. Selecting cells, columns, or rows
      7. Charts
      8. Toolbars
      9. Windows
      10. Simple Instructions for Doing Things in Excel 2008
        1. Charts
        2. Columns, rows, and cells
        3. Conditional formatting
        4. Editing cell data
        5. Errors
        6. Filling cells
        7. Formatting cells and cell contents
        8. Formulas
        9. Headers and footers
        10. Importing data
        11. New workbooks
        12. Number formatting
        13. Page breaks
        14. Page setup
        15. Print area
        16. Protection
        17. Range names
        18. References
        19. Restricting content
        20. Saving files
        21. Selecting cells and data
        22. Sheets
        23. Viewing worksheets
        24. Workbook templates
    7. Microsoft PowerPoint 2008 for Mac
    8. PowerPoint 2008 Keyboard Shortcuts
      1. Moving around in text
      2. Editing text and objects
      3. Working in presentations
      4. Changing views
      5. Selecting text
      6. Working in a table
      7. Presenting a slide show
      8. Simple Instructions for Doing Things in PowerPoint 2008
        1. Adding content
        2. Adding slides
        3. AutoFitting
        4. Backgrounds
        5. Bulleted and numbered lists
        6. Charts
        7. Deleting slides
        8. Color schemes
        9. Delivering a slide show
        10. Ending slide show
        11. Formatting text
        12. Headers and footers
        13. Inserting slides
        14. New presentations
        15. Moving and sizing content placeholders
        16. Moving slides
        17. Outlines
        18. Photos and pictures
        19. Presentation templates
        20. Saving files
        21. Selecting slides and text
        22. Slide layouts
        23. Themes
        24. Viewing slides
        25. Watermarks
    9. Microsoft Entourage 2008 for Mac
    10. Entourage 2008 Keyboard Shortcuts
      1. Windows and dialog boxes
      2. Modules and lists
      3. Message list
      4. Calendar
      5. Messages
      6. Flagging items
      7. Printing
      8. Search
      9. Simple Instructions for Doing Things in Entourage 2008
        1. Address Book
        2. Calendar
        3. Categories
        4. Contact groups
        5. Contact records
        6. Displaying modules
        7. E-mail accounts
        8. E-mail messages
        9. E-mail signatures
        10. Favorites Bar
        11. Flagging for follow up
        12. Folder list
        13. Mini Calendar
        14. Preview pane
        15. Scheduling Entourage events
        16. Searching items
        17. To Do list
        18. Toolbar
  9. I. Office Basics
    1. 1. Explore and Manage the Office Interface
      1. Start an Office Program
      2. Find Your Way Around File Windows
      3. Give Instructions in an Office Program
        1. Menus and the Menu Bar
        2. Toolbars
        3. The Elements Gallery
        4. The Toolbox
      4. Use and Configure Program-Specific Features and Functions
        1. Word Tools and Preferences
        2. Excel Tools and Preferences
        3. PowerPoint Tools and Preferences
      5. Personalize Program Functionality
        1. Store Your Information for Reuse
        2. Change the Gallery Color Scheme
      6. Practice Working with Windows and Commands
      7. Key Points
    2. 2. Practice Basic Office File Skills
      1. Open, Save, and Close Office Files
      2. Practice Opening, Saving, and Closing Office Files
      3. View Office Files
        1. Change the View
        2. Change the Magnification
        3. Split and Arrange Document and Workbook Windows
      4. Find and Replace Content and Formatting
        1. Word Search Options
        2. Excel Search Options
        3. PowerPoint Search Options
      5. Practice Replacing Content and Formatting
      6. Print Office Files
      7. Key Points
    3. 3. Work in Office Programs
      1. View and Move Around in Word Documents
      2. Move Around in Document Content
      3. Practice Viewing and Moving Around in Documents
      4. Practice Moving Around in Document Content
      5. View and Move Around in Excel Workbooks
      6. Practice Viewing and Moving Around in Workbooks
      7. View and Move Around in PowerPoint Presentations
      8. Practice Viewing and Moving Around in Presentations
      9. Key Points
  10. II. Create Basic Office Files
    1. 4. Create Word Documents
      1. Create a Basic Document
        1. Create a Document
        2. Enter Text
      2. Practice Creating and Populating Documents
      3. Create a Document from a Project Template
        1. The Project Gallery
        2. Project Templates
      4. Work with Word Publications
      5. Work with Word Notebooks
      6. Practice Creating Documents from Project Templates
      7. Create a Personalized Project Template
      8. Practice Creating Custom Templates
      9. Key Points
    2. 5. Create Excel Workbooks
      1. Create a Basic Workbook
      2. Enter Data on a Sheet
      3. Resize Columns and Rows
      4. Fill Cells with a Series of Data
      5. Practice Creating and Populating Workbooks
      6. Create a Workbook or Sheet from a Project Template
      7. Practice Creating Workbooks and Sheets from Templates
      8. Key Points
    3. 6. Create PowerPoint Presentations
      1. Create a Basic Presentation
      2. Add Slides to a Presentation
        1. Add Blank Slides
        2. Insert Slides from Other Presentations
      3. Practice Inserting Slides from Other Presentations
      4. Add Content to Slides
        1. Work with Layout Placeholders
        2. Insert Content in a Placeholder
        3. Modify Text
      5. Create a Presentation from the Project Gallery
        1. Create a Presentation Based on an Office Theme Template
        2. Create a Presentation Based on a Project Template
      6. Practice Creating Presentations
      7. Create a Presentation from a Word Document
      8. Practice Exporting and Importing Presentation Outlines
      9. Key Points
  11. III. Work with Office File Content
    1. 7. Work with Word Document Content
      1. Edit Document Text
        1. Insert and Delete Text
        2. Select Text
        3. Copy and Move Text
        4. Undo Changes
      2. Practice Manipulating Text
      3. Automatically Display Current Information in a Document
      4. Work with Office Themes
      5. Practice Applying Themes and Color Schemes
      6. Work with Styles
      7. Manage Document Templates
      8. Practice Applying and Modifying Styles and Document Templates
      9. Check Spelling and Grammar
      10. Key Points
    2. 8. Work with Excel Sheet Content
      1. Edit Worksheet Data
        1. Change Cell Content
        2. Change Worksheet Structure
      2. Restrict the Content Allowed in a Cell
      3. Automatically Format Cells Based on Content
      4. Create Charts in Workbooks
        1. Choose a Chart Type
        2. Modify a Chart
      5. Practice Creating Charts from Worksheet Data
      6. Create Charts in Documents and Presentations
        1. Insert or Link to an Existing Chart
        2. Create a Chart on a Page or Slide
      7. Manage Sheets
        1. Add and Remove Sheets
        2. Copy or Move Sheets
        3. Organize Sheets
        4. Assign Sheet Names
      8. Practice Working with Sheets and Data
      9. Key Points
    3. 9. Create Excel Formulas
      1. Understand Functions
        1. Numeric Functions
        2. Text Functions
        3. Generic Functions
      2. Create Simple Formulas
      3. Reference Worksheets and Workbooks
      4. Use Absolute and Relative References
      5. Reference Named Cells and Ranges
      6. Practice Creating Formulas
      7. Key Points
    4. 10. Work with PowerPoint Slide Content
      1. Format Slide Text
      2. Customize a Slide Background
      3. Add a Watermark to a Slide
      4. Practice Formatting Slide Backgrounds
      5. Change the Layout of a Slide
      6. Change Standard Slide Settings
      7. Run a Slide Show
      8. Key Points
  12. IV. Enhance Office File Content
    1. 11. Format Office File Content
      1. Control Page Setup
        1. Set the Page Size
        2. Set the Page Orientation
        3. Set the Document Margins
      2. Insert Page and Section Breaks
      3. Format Paragraphs
        1. Indent Paragraphs
        2. Align Text Horizontally
        3. Align Text Vertically
      4. Add Borders and Shading
      5. Practice Changing the Size and Appearance of Paragraphs
      6. Format Characters
      7. Practice Formatting Characters
      8. Format Worksheet Cells and Cell Contents
        1. Format Numeric Data
        2. Merge Cells
        3. Draw Borders by Hand
        4. Set Up a Sheet for Printing
      9. Key Points
    2. 12. Create and Insert Graphics
      1. Insert and Modify Shapes
      2. Insert Commercial Clip Art
      3. Insert Symbols as Text or Graphics
      4. Insert Your Own Photos
      5. Practice Inserting and Modifying Images
      6. Create Professional Diagrams
        1. Create a Diagram from Scratch
        2. Modify a Diagram
      7. Practice Creating and Modifying Diagrams
      8. Key Points
    3. 13. Review Word Documents
      1. Revise a Document
      2. Give Feedback on Document Content
      3. Practice Reviewing Documents
      4. Key Points
    4. 14. Add Finishing Document Elements
      1. Add Professional Cover Pages
      2. Practice Adding Cover Pages
      3. Add Headers and Footers
      4. Practice Adding Headers and Footers
      5. Create a Table of Contents
      6. Practice Creating Tables of Contents
      7. Create an Index
      8. Practice Creating Indexes
      9. Create a Bibliography
      10. Key Points
  13. V. Stay In Touch and On Time
    1. 15. Communicate Online
      1. Work in Entourage
      2. Personalize Entourage
      3. Connect to Your E-Mail Account
      4. Create and Send E-Mail Messages
        1. Address Messages
        2. Attach Files
        3. Save Message Drafts
        4. Send Messages
      5. Practice Creating and Sending E-Mail Messages
      6. Enhance Message Content
        1. Format Message Text
        2. Research Words and Phrases
        3. Create E-Mail Signatures
      7. Reply To and Forward Messages
      8. Practice Responding to Messages
      9. Delete Messages
      10. Practice Deleting Messages
      11. Key Points
    2. 16. Manage Contacts and Schedules
      1. Work in the Address Book
        1. View, Sort, and Filter Records in the Address Book
      2. Work with Contact Records
        1. Work in the Contact Window
        2. Create a Contact Record
      3. Work with Contact Groups
      4. Flag Items for Follow Up
      5. Assign Categories to Items
      6. Work in the Calendar
        1. Display Different Views of a Calendar
        2. Display Your To Do List
      7. Schedule a Calendar Event
      8. Practice Working with Your Calendar
      9. Search for Information
      10. Key Points
  14. Glossary
  15. A. Choose the Right Book for You
    1. Resources from Microsoft Press
      1. Plain & Simple
      2. Step by Step
      3. Inside Out
      4. Other Titles
  16. Index
  17. About the Author
  18. Copyright