Office 2008 for Mac All-in-One For Dummies®

Book description

The perfect companion for taking the Microsoft Office suite to the Mac!

So you finally got a Mac, but you’re not looking forward to figuring out how Office works in a different environment? No worries! All you need is Microsoft Office 2008 For Mac All-in-One For Dummies to learn the fundamentals of Office 2008. With six books in one, it shows you how to use every Office 2008 for Mac application, so you can start getting things done right away.

Written by Microsoft MVPs, Microsoft Office 2008 For Mac All-in-One For Dummies provides a user-friendly guide on how to master all the programs: Excel, Word, PowerPoint, and Entourage. This book explores ways to:

  • Use the new galleries to find features, formats, wizards, templates, and recently used files

  • Create your own templates on Excel and open Web pages in HTML format

  • Take advantage of PowerPoint by adding animation to your slides, inserting music from your iTunes library, and fine-tuning the timing

  • Organize your schedule on My Day, handle contacts and e-mail, and manage a database—all through Entourage

  • Manage projects of all sizes on the Project Center

  • Use all the applications together, and to their full potential

With this all-in-one reference, you’ll become an expert on sharing files with Windows users, integrating Office 2008 with iLife and other Mac applications, and working with Office and Web 2.0, as well as other common business tasks. This book makes it that easy!

Table of contents

  1. Copyright
  2. About the Authors
  3. Authors' Acknowledgments
  4. Publisher's Acknowledgments
  5. Introduction
    1. About This Book
    2. How to Use This Book
    3. How This Book Is Organized
      1. Book I: Introducing Office 2008
      2. Book II: Word 2008
      3. Book III: Excel 2008
      4. Book IV: PowerPoint 2008
      5. Book V: Entourage 2008
      6. Book VI: Entourage's Project Center
      7. Bonus Chapters
    4. Conventions Used in This Book
      1. Stuff you type
      2. Menu commands
      3. Key combinations
      4. Right-click versus Control-click
      5. Display messages
    5. Icons Used in This Book
    6. Where to Go from Here
  6. I. Introducing Office 2008
    1. I.1. Oscillating in the Office 2008 World
      1. I.1.1. Getting Familiar with Office 2008
        1. I.1.1.1. Getting started in Project Gallery
          1. I. The New tab
          2. I. The Recent tab
          3. I. The Project Center tab
          4. I. The Settings tab
        2. I.1.1.2. Helping Word veterans make the transition
        3. I.1.1.3. Looking for Visual Basic for Applications (VBA)
        4. I.1.1.4. De-mystifying Excel
        5. I.1.1.5. Slide shows with PowerPoint
        6. I.1.1.6. Making your day with Entourage
        7. I.1.1.7. Mingling instantly with Messenger
        8. I.1.1.8. Lighting the future with Silverlight
      2. I.1.2. What's New Office-Wide for 2008?
        1. I.1.2.1. Elation from Elements Gallery
        2. I.1.2.2. Getting smart with SmartArt Graphics
        3. I.1.2.3. Discovering new Office-wide themes
      3. I.1.3. Comparing Office 2008 for Mac with Office for Windows
        1. I.1.3.1. Picking the products
          1. I. Both Mac and PC platforms
          2. I. Just on Windows
          3. I. Just on Macintosh
          4. I. Comparing Office 2008 for Mac package bundles
        2. I.1.3.2. Understanding file format compatibility
        3. I.1.3.3. Navigating the interface
          1. I. Launching applications
          2. I. Opening Spaces
          3. I. Switching from one document to another
          4. I. Switching from one application to another
        4. I.1.3.4. Coping with Office automation incompatibility
        5. I.1.3.5. Co-existing with Office 2004 and earlier
          1. I. Saving from 2008 to the old format
          2. I. Choosing a default save format
          3. I. Saving from 2004 to the new XML format
          4. I. Using Open XML Converter
    2. I.2. Project Gallery — The Natural Starting Point
      1. I.2.1. Launching Project Gallery
      2. I.2.2. Opening Blank Documents from Project Gallery
        1. I.2.2.1. Opening blank new documents
        2. I.2.2.2. Opening other blank documents
          1. I. Starting an Excel list
          2. I. Start taking notes in Word Notebook Layout View
          3. I. Creating a new Word Publishing Layout View document
          4. I. Writing a new e-mail message
          5. I. Creating a new Calendar event
      3. I.2.3. Exploring More Project Gallery Categories
        1. I.2.3.1. Using My Templates to open new documents
          1. I. Saving a document as a template for My Templates
          2. I. Digging deeper into templates
        2. I.2.3.2. Opening new documents based on My Themes
        3. I.2.3.3. Starting with the right template, theme, or wizard
        4. I.2.3.4. Filtering results by application
      4. I.2.4. Finding the Fab Four (Wizards, That Is)
        1. I.2.4.1. Making lists with the List Wizard
        2. I.2.4.2. Making labels and name badges
        3. I.2.4.3. Designing with the Envelope Wizard
        4. I.2.4.4. Making perfect business letters
      5. I.2.5. Viewing What's in the Galleries
      6. I.2.6. Finding Your Things in Project Gallery
        1. I.2.6.1. Searching fast within Project Gallery
        2. I.2.6.2. Finding things with Open Other
        3. I.2.6.3. Finding recently used files
        4. I.2.6.4. Remembering misplaced filenames
        5. I.2.6.5. Getting another chance to find a file
      7. I.2.7. Prospecting the Project Center Tab
      8. I.2.8. Customizing Project Gallery
        1. I.2.8.1. General settings
        2. I.2.8.2. Documents and wizards settings
        3. I.2.8.3. File location default settings
        4. I.2.8.4. Changing file location settings for templates
          1. I. Local templates
          2. I. Workgroup templates
    3. I.3. Menus and Toolbars
      1. I.3.1. Cruising Elements Gallery
      2. I.3.2. Summoning Pop-Up Menus
      3. I.3.3. Traversing the Menus and Toolbars
        1. I.3.3.1. Customizing Word, Excel, and PowerPoint toolbars and menus
          1. I. Adding a jewel of a command
          2. I. Ditching a dud command
          3. I. Rolling your own
            1. I. Changing the command button icon
            2. I. Assigning keyboard shortcuts to new command buttons
        2. I.3.3.2. Resetting, renaming, or trashing toolbars and menus
        3. I.3.3.3. Sharing toolbars and menus
      4. I.3.4. Customizing Entourage and Project Center Toolbars
    4. I.4. Busting Out Your Toolbox
      1. I.4.1. Taking a Look Inside the Toolbox
        1. I.4.1.1. Introducing the Toolbox palettes
        2. I.4.1.2. Using palettes in the Toolbox
      2. I.4.2. No Objections to the Object Palette
        1. I.4.2.1. Squeezing shapes
        2. I.4.2.2. Clamoring for clip art
        3. I.4.2.3. Showing the way with symbols
        4. I.4.2.4. Picking the perfect photo
        5. I.4.2.5. Perfecting your pictures
      3. I.4.3. Scrapbook: The Clipboard Evolves
      4. I.4.4. Getting Serious with Reference Tools
      5. I.4.5. Making Compatibility Checking a Snap
      6. I.4.6. Peeking at Your Projects in the Project Palette
    5. I.5. Graphing, Drawing, and Making Art
      1. I.5.1. Getting the Nitty-Gritty on Graphs and Charts
        1. I.5.1.1. Graphing an equation with Grapher
        2. I.5.1.2. Graphing data using Elements Gallery
          1. I. Graphing in Word or PowerPoint
          2. I. Graphing in Excel
        3. I.5.1.3. Formatting charts in Word, Excel, and PowerPoint
          1. I. Changing chart types with Elements Gallery
          2. I. Formatting chart elements with the Formatting Palette
        4. I.5.1.4. Applying multiple formatting options
        5. I.5.1.5. Discovering even more chart-formatting options
        6. I.5.1.6. Graphing the old-fashioned way in Microsoft Graph
      2. I.5.2. Making an Organization Chart with SmartArt Graphics
        1. I.5.2.1. Organizing the organization chart
        2. I.5.2.2. Working in the Text pane
        3. I.5.2.3. Working with Organization Chart
        4. I.5.2.4. Formatting your organization chart
      3. I.5.3. Creating Your Own Shapes
        1. I.5.3.1. Making a curvy line
        2. I.5.3.2. Drawing a solid shape
        3. I.5.3.3. Formatting your lines and shapes
        4. I.5.3.4. Editing points on a line or shape
      4. I.5.4. Making an Impression with WordArt
        1. I.5.4.1. Creating WordArt
        2. I.5.4.2. Formatting WordArt
      5. I.5.5. Working in Layers
        1. I.5.5.1. Starting at the back
        2. I.5.5.2. Moving on to the layers on top
    6. I.6. Common Tools That Make Your Life Easier
      1. I.6.1. Proofing Your Spelling and Grammar
        1. I.6.1.1. Running spelling and grammar checks
        2. I.6.1.2. Controlling the AutoCorrect feature
        3. I.6.1.3. Configuring spelling and grammar preferences
      2. I.6.2. Understanding Themes and Templates
        1. I.6.2.1. Applying a theme
        2. I.6.2.2. Saving your own theme
        3. I.6.2.3. Getting to know more about themes
      3. I.6.3. Saving Everything as a Template
      4. I.6.4. Sharing Files in Other Formats
        1. I.6.4.1. Saving as an Adobe PDF
        2. I.6.4.2. Saving as a Web page
        3. I.6.4.3. Saving as a 97 to 2004 document
      5. I.6.5. Getting Mathematical with Equation Editor
      6. I.6.6. Programming and Automation Options
        1. I.6.6.1. Coping without VBA
        2. I.6.6.2. Being savvy with AppleScript
        3. I.6.6.3. Automating with Automator
    7. I.7. Getting Help!
      1. I.7.1. Helping You with New Help
        1. I.7.1.1. Sending feedback to Microsoft
        2. I.7.1.2. Asking someone for help
        3. I.7.1.3. Getting online training for free
      2. I.7.2. Utilizing Newsgroups and Community Resources
      3. I.7.3. Checking for Updates
      4. I.7.4. Getting Help from Office Web Sites
        1. I.7.4.1. Getting freebies from Mactopia
        2. I.7.4.2. Getting freebies from the Microsoft Office Web site
      5. I.7.5. Making the Most of MVP Sites
        1. I.7.5.1. Welcome to Word:mac
        2. I.7.5.2. Excelling with Excel MVPs
        3. I.7.5.3. PowerPointing MVPs
        4. I.7.5.4. Connecting with Entourage MVPs
      6. I.7.6. Join the Club!
        1. I.7.6.1. Joining a user group
        2. I.7.6.2. Joining the Customer Experience Improvement Program
      7. I.7.7. Getting Help for Legal and Medical Professionals
  7. II. Word 2008
    1. II.1. Getting to Know Word's Interface
      1. II.1.1. Opening Blank Word Documents
      2. II.1.2. Looking at Word's Views
        1. II.1.2.1. Working in Print Layout View
        2. II.1.2.2. Taking notes in Notebook Layout View
        3. II.1.2.3. Designing in Publishing Layout View
      3. II.1.3. Making the Most of Toolbars
      4. II.1.4. Making Word Behave the Way You Want It To
        1. II.1.4.1. Finding Word's new Preferences pane
        2. II.1.4.2. Turning AutoCorrect on and off
        3. II.1.4.3. Setting compatibility preferences
        4. II.1.4.4. Customizing Word's keyboard shortcuts
    2. II.2. An Open and Shut Case
      1. II.2.1. Opening the World in Word
        1. II.2.1.1. Trying out templates
        2. II.2.1.2. Being normal with Normal.dotx
        3. II.2.1.3. Becoming a whiz with wizards
        4. II.2.1.4. Opening Web pages
          1. II. Copying and pasting
          2. II. Saving and opening a Web page
        5. II.2.1.5. Saving a document as a Web page
        6. II.2.1.6. Extracting text from any file
        7. II.2.1.7. Finding files in Finder
        8. II.2.1.8. Comparing two Word documents
        9. II.2.1.9. Recovering AutoRecover files
      2. II.2.2. Saving Word Documents
        1. II.2.2.1. Just close me
        2. II.2.2.2. Giving a document a new name, a new location
        3. II.2.2.3. Securing Word documents
          1. II. Security Options for "Document Name"
          2. II. Privacy Options
        4. II.2.2.4. Turning your document into a template
        5. II.2.2.5. Being compatible with others
        6. II.2.2.6. Sending copies everywhere — fast!
    3. II.3. Working with Text, Words, and Paragraphs
      1. II.3.1. Triumphing Over Text
        1. II.3.1.1. Formatting deftly with the Formatting Palette
        2. II.3.1.2. Dropping a cap
        3. II.3.1.3. Spacing sweetly
          1. II. Kicking in kerning
          2. II. Spacing the characters
        4. II.3.1.4. Making friends with subscript and superscript
        5. II.3.1.5. Using special characters for special occasions
        6. II.3.1.6. Shooting bullets and numbing numbers
          1. II. Creating a list with the Formatting Palette
          2. II. Starting a numbered list automatically
          3. II. Telling Word to stop adding bullets or numbers
          4. II. Starting over in the middle of a list
          5. II. Making special bullets and numbers
          6. II. Loving legal beagles and authors of long documents
        7. II.3.1.7. Painless paragraph formatting
          1. II. Dealing with widows and orphans
            1. II. Pagination
            2. II. Other options
        8. II.3.1.8. Tinkering with tabs
          1. II. Working with the Tabs menu
          2. II. Setting a tab stop
          3. II. The five kinds of tab stops
          4. II. Precision tab placement
          5. II. Clearing tab stops
      2. II.3.2. Formatting an Entire Document
        1. II.3.2.1. Ruling margins by the Ruler
        2. II.3.2.2. Breaking up things
          1. II. Page breaks
          2. II. Section breaks
        3. II.3.2.3. Making columns
        4. II.3.2.4. Tickling footers and watching your header
        5. II.3.2.5. Getting around with bookmarks
      3. II.3.3. Writing with Style
        1. II.3.3.1. Applying slick styles
        2. II.3.3.2. Applying document themes to styles
        3. II.3.3.3. Making a homemade style
          1. II. Create a new style from formatted text
          2. II. Working with the Style dialog
          3. II. Copying styles
      4. II.3.4. Using Organizer
        1. II.3.4.1. Opening Organizer
        2. II.3.4.2. Copying styles, AutoText, and toolbars
        3. II.3.4.3. Renaming or deleting items
      5. II.3.5. AutoFormat as You Type
      6. II.3.6. Automatically Numbering Lines
    4. II.4. Reviewing and Proofing with Word
      1. II.4.1. Keeping Track of Changes
        1. II.4.1.1. Setting up tracking changes
        2. II.4.1.2. Working with a changed document
          1. II. Merging changed versions into the original
          2. II. Accepting and rejecting changes
        3. II.4.1.3. Finishing up
      2. II.4.2. Casting a Spell Check
        1. II.4.2.1. Knowing how to spell is still important!
          1. II. Running a spelling and grammar check
          2. II. Adding a custom dictionary
          3. II. Editing a custom dictionary
          4. II. Setting a new default language for proofing
          5. II. Using a different language for proofing a selection
          6. II. Enabling Japanese for proofing
        2. II.4.2.2. Cleaning up your grammar
        3. II.4.2.3. Choosing a writing style
        4. II.4.2.4. Creating a custom writing style
    5. II.5. Making Great Tables and Charts
      1. II.5.1. Deciding Which Table Tools to Use
      2. II.5.2. Inserting Quick Tables in a Flash
      3. II.5.3. Creating Your Own Tables
        1. II.5.3.1. Using the Tables button
        2. II.5.3.2. Using the mouse
        3. II.5.3.3. Using the Insert Table dialog
      4. II.5.4. Formatting Tables
        1. II.5.4.1. Using the Tables and Borders toolbar
        2. II.5.4.2. Using the Formatting Palette
        3. II.5.4.3. Applying a document theme
          1. II. Using the Tables Properties dialog
        4. II.5.4.4. Using styles
          1. II. Styling with Table AutoFormat
          2. II. Styling with the Style dialog
            1. II. Applying styles
            2. II. Modifying styles
          3. II. Creating a new table style
      5. II.5.5. Working with Tables
        1. II.5.5.1. Basic table tips
        2. II.5.5.2. Handling tables from the Web
      6. II.5.6. Working with Charts
        1. II.5.6.1. Whoa! It's way too big!
        2. II.5.6.2. Getting unstuck
        3. II.5.6.3. This is a frame-up!
        4. II.5.6.4. Changing a chart into a picture
    6. II.6. Saving Time in Word
      1. II.6.1. Automating with AutoText
        1. II.6.1.1. Teaching Word a lesson
        2. II.6.1.2. Using AutoText on a daily basis
        3. II.6.1.3. Teaching Word even more
        4. II.6.1.4. Taming AutoText
      2. II.6.2. Making Magic with Mail Merge
        1. II.6.2.1. Getting started: Making a mail merge form letter
        2. II.6.2.2. Merging to envelopes
        3. II.6.2.3. Making labels
          1. II. Making a sheet of identical labels
          2. II. Making labels from a database
          3. II. Merging to a catalog
        4. II.6.2.4. Using different data sources
          1. II. New Data Source
          2. II. Open Data Source
          3. II. Office Address Book
          4. II. FileMaker Pro
        5. II.6.2.5. Previewing merge results
        6. II.6.2.6. Completing the merge
          1. II. Performing a test run
          2. II. Doing the merge
            1. II. Merge to Printer
            2. II. Merge to a New Document
            3. II. Merge to E-Mail
      3. II.6.3. Automating Long Document Chores
        1. II.6.3.1. Making an instant Table of Contents
        2. II.6.3.2. Long Document Wizard
        3. II.6.3.3. Creating an index
        4. II.6.3.4. Creating a Table of Figures
        5. II.6.3.5. Creating a Table of Authorities
          1. II. Marking text to include in the table
          2. II. Building the Table of Authorities
        6. II.6.3.6. Creating an executive summary or an abstract
      4. II.6.4. Formatting the Background
      5. II.6.5. Inserting a Citation
    7. II.7. Advanced Word Stuff
      1. II.7.1. Wrapping Text around Objects
      2. II.7.2. Flowing Text from One Text Box into Another
        1. II.7.2.1. More fun with text boxes
        2. II.7.2.2. Text boxes in Publishing Layout View
      3. II.7.3. Publishing Newspapers, Newsletters, and Periodicals
        1. II.7.3.1. Discovering new tools
        2. II.7.3.2. Customizing a template
        3. II.7.3.3. Font formatting controls
        4. II.7.3.4. Mastering master pages
        5. II.7.3.5. Working with static guides
      4. II.7.4. Having a Field Day
      5. II.7.5. Creating an Electronic Form
        1. II.7.5.1. Using tables and frames in forms
        2. II.7.5.2. Inserting a text form field
        3. II.7.5.3. Inserting a check box on a form
        4. II.7.5.4. Upgrading to a combo
        5. II.7.5.5. Doing the math in Word forms
        6. II.7.5.6. Grabbing just the form field data
      6. II.7.6. Working Word with the Web
        1. II.7.6.1. Opening Web pages in Word
          1. II. Saving a Web page
          2. II. Opening a Web page in Word
        2. II.7.6.2. Sending Word to the Web
      7. II.7.7. Managing Multiple Open Documents
      8. II.7.8. Embedding All Kinds of Things
    8. II.8. Printing for Posterity
      1. II.8.1. Sizing Up Things with Page Setup
        1. II.8.1.1. Configuring your settings
        2. II.8.1.2. Formatting for a particular printer
        3. II.8.1.3. Choosing a paper size
      2. II.8.2. Previewing Your Document
        1. II.8.2.1. Displaying a document preview
        2. II.8.2.2. Previewing multiple pages
        3. II.8.2.3. Other preview controls
      3. II.8.3. Printing like a Pro!
        1. II.8.3.1. Make it fast!
        2. II.8.3.2. Getting a few more options
          1. II. Picking a printer
          2. II. Picking a set of preset printing options
          3. II. Printing to PDF
          4. II. Previewing in Mac OS X Preview
          5. II. Activating advanced printing options
        3. II.8.3.3. Seeing all the possible print options
          1. II. Using Copies & Pages
          2. II. Using special Microsoft Word printing options
          3. II. Using special printer features
  8. III. Excel 2008
    1. III.1. Working Every Day in Excel
      1. III.1.1. Introducing Ledger Sheets
        1. III.1.1.1. Opening a ledger sheet
        2. III.1.1.2. Entering text and data
      2. III.1.2. Working with Other File Formats
        1. III.1.2.1. Default format
        2. III.1.2.2. Common formats
        3. III.1.2.3. Specialty formats
          1. III. XML
          2. III. Binary
          3. III. Delimited
          4. III. Old formats
          5. III. All the other formats
      3. III.1.3. Saving Your Workbook
        1. III.1.3.1. Saving for compatibility (.xls)
        2. III.1.3.2. Saving in Excel Workbook (.xlsx)
        3. III.1.3.3. Saving small using Excel binary workbook (.xlsb)
        4. III.1.3.4. Saving with AutoRecover
          1. III. Setting up AutoRecover
          2. III. Retrieving AutoRecover
      4. III.1.4. Viewing Workbooks
        1. III.1.4.1. Using Page Layout View
        2. III.1.4.2. Using Normal View
        3. III.1.4.3. Using the common interface
      5. III.1.5. Using the Formatting Palette
        1. III.1.5.1. Orientation
        2. III.1.5.2. Print scaling
        3. III.1.5.3. Sheet
      6. III.1.6. Working with Sheet Types
        1. III.1.6.1. Sheet types
        2. III.1.6.2. Making specific sheet types
          1. III. Making a standard worksheet
          2. III. Making a list sheet
          3. III. Making a chart sheet
          4. III. Making an Excel 4.0 macro sheet
        3. III.1.6.3. Using Excel's special Project Gallery
    2. III.2. Operating Inside the Workbook
      1. III.2.1. Interacting with Excel
        1. III.2.1.1. Selecting, editing, and naming cells
        2. III.2.1.2. Clearing a cell
        3. III.2.1.3. Clearing many cells at once
        4. III.2.1.4. Making sense of cursors
      2. III.2.2. Dragging a Series of Text, Numbers, or Dates
        1. III.2.2.1. Filling in a series
        2. III.2.2.2. Having Excel figure out a pattern
        3. III.2.2.3. Using the Custom Lists feature
      3. III.2.3. Entering in General Format
      4. III.2.4. Making Cell Formulas
        1. III.2.4.1. Entering formulas
          1. III. Typing a formula manually
          2. III. Letting Excel type a formula for you
          3. III. Entering a function manually
          4. III. Letting Excel type functions and arguments
        2. III.2.4.2. Using Formula Builder
      5. III.2.5. Knowing When to Be Absolute, Relatively Speaking
        1. III.2.5.1. Using a relative reference
        2. III.2.5.2. Using an absolute reference
        3. III.2.5.3. Comparing relative and absolute references
    3. III.3. Formatting and Collaborating in Excel
      1. III.3.1. Preparing to Format
      2. III.3.2. Formatting Cells
        1. III.3.2.1. Adjusting fonts
        2. III.3.2.2. Applying number and text formats
        3. III.3.2.3. Fitting and positioning content
        4. III.3.2.4. Coloring cells and borders
        5. III.3.2.5. Tilting your text
        6. III.3.2.6. Building borders
      3. III.3.3. Coloring and Shading
      4. III.3.4. Working with Dates and Times
        1. III.3.4.1. Finding today
        2. III.3.4.2. Getting today's serial number
        3. III.3.4.3. Yesterday, tomorrow, and whenever
        4. III.3.4.4. Finding the time of day
      5. III.3.5. Formatting Based on Conditions
      6. III.3.6. Sharing Workbooks
        1. III.3.6.1. Inserting a comment
        2. III.3.6.2. Tracking changes
          1. III. Turning on track changes
          2. III. Working with track changes turned on
          3. III. Merging tracked changes
          4. III. Deciding whose changes to review
          5. III. Accepting and rejecting changes
          6. III. Finishing up
          7. III. Generating a history report
        3. III.3.6.3. Using Share Workbook
          1. III. Activating Share Workbook
          2. III. Administering a shared workbook
          3. III. Protecting a shared workbook
    4. III.4. Controlling Excel
      1. III.4.1. Copying and Pasting
        1. III.4.1.1. Simply copying and pasting
        2. III.4.1.2. Pasting special
          1. III. Turning rows into columns
          2. III. Using Paste Special with objects
          3. III. Copying as a picture in the first place
      2. III.4.2. Moving and Copying Entire Sheets
      3. III.4.3. Creating Camera Magic
        1. III.4.3.1. Customizing the Camera tool
        2. III.4.3.2. Using the Camera tool
      4. III.4.4. Nesting and Nest Building
        1. III.4.4.1. First things first
        2. III.4.4.2. Applying some logic
      5. III.4.5. Correcting Errors
        1. III.4.5.1. Getting rid of hash marks
        2. III.4.5.2. Circular references
          1. III. Fixing circular references
          2. III. Keeping your circular reference
        3. III.4.5.3. Clearing #DIV/0
        4. III.4.5.4. Other error messages
    5. III.5. Heavenly Charting
      1. III.5.1. Making a Chart
      2. III.5.2. Choosing the Chart's Location
        1. III.5.2.1. Moving to a chart sheet
        2. III.5.2.2. Copying to Microsoft Word and PowerPoint
          1. III. Using the Scrapbook
          2. III. Going from Excel to Word
          3. III. Going from Excel to PowerPoint
      3. III.5.3. Applying Error Bars
      4. III.5.4. Making a Gantt Chart
      5. III.5.5. Making a Histogram
        1. III.5.5.1. Making a histogram by using cell formulas
        2. III.5.5.2. Making a histogram by using a chart
    6. III.6. Becoming Versatile with Excel
      1. III.6.1. Helping You Remember
      2. III.6.2. Preparing Your Forms
        1. III.6.2.1. Customizing the Forms toolbar
        2. III.6.2.2. Tabbing in a form
        3. III.6.2.3. Protecting and unprotecting a worksheet
      3. III.6.3. Making Your Own Form Templates
      4. III.6.4. Using Your Form Templates
        1. III.6.4.1. Making ordinary form fields
        2. III.6.4.2. Restricting entry with data validation
        3. III.6.4.3. Restricting entry with form controls
      5. III.6.5. Getting the Web into Excel
        1. III.6.5.1. Copying and pasting
        2. III.6.5.2. Using a Web query
        3. III.6.5.3. Opening a saved Web page
      6. III.6.6. Getting Excel onto the Web
        1. III.6.6.1. Preparing a workbook for the Web
        2. III.6.6.2. Distributing a workbook "as is"
        3. III.6.6.3. Making a Web page
          1. III. Web options
          2. III. Adding automation
    7. III.7. Being Intelligent with Data
      1. III.7.1. Simplifying Database Jargon
      2. III.7.2. Listing the List Rules
        1. III.7.2.1. List Wizard Step 1 — Data locations
        2. III.7.2.2. List Wizard Step 2 — Data types
        3. III.7.2.3. List Wizard Step 3 — List options
      3. III.7.3. Making a List the Fast Way
      4. III.7.4. Working with Data by Using List Manager
      5. III.7.5. Taking the PivotTable Course
      6. III.7.6. Using Excel with Relational Databases
        1. III.7.6.1. Explaining relational databases
        2. III.7.6.2. Installing an ODBC driver
        3. III.7.6.3. Buying an ODBC driver
        4. III.7.6.4. Compatibility with Excel for Windows
    8. III.8. Printing from Excel
      1. III.8.1. Using the Page Setup Dialog
        1. III.8.1.1. Browsing the Sheet tab
          1. III. Print Titles section
          2. III. Print section
        2. III.8.1.2. Using the Margins tab
      2. III.8.2. Working with Headers and Footers
        1. III.8.2.1. Entering a header/footer
        2. III.8.2.2. Finessing your footers (and headers)
      3. III.8.3. Making a Watermark
      4. III.8.4. Adjusting Print Quality
        1. III.8.4.1. Telling your computer what to send to the printer
        2. III.8.4.2. Telling your printer how to do its job
      5. III.8.5. Setting the Paper Size
  9. IV. PowerPoint 2008
    1. IV.1. Revealing PowerPoint
      1. IV.1.1. Getting Up and Running
      2. IV.1.2. Facing Your Audience
      3. IV.1.3. Building and Editing in Normal View
      4. IV.1.4. Organizing Slides in Slide Sorter View
        1. IV.1.4.1. Selecting slides
        2. IV.1.4.2. Changing slide order
        3. IV.1.4.3. Copying and pasting
        4. IV.1.4.4. Deleting the chaff from the wheat
        5. IV.1.4.5. Transitioning from one slide to the next
          1. IV. Setting transition options — Effect
          2. IV. Setting transition options — Sound
          3. IV. Setting transition options — Advance Slide
    2. IV.2. Open Sesame and Shut Sesame
      1. IV.2.1. Opening Special File Formats
        1. IV.2.1.1. Finding out about AutoRecover
        2. IV.2.1.2. Opening password-protected presentations
      2. IV.2.2. Saving in Special Formats
        1. IV.2.2.1. Packaging a PowerPoint presentation
        2. IV.2.2.2. Saving as a movie
        3. IV.2.2.3. Making a Web page
        4. IV.2.2.4. Saving with a password
        5. IV.2.2.5. Saving as a pile of pictures
    3. IV.3. Working with the Whole Show
      1. IV.3.1. Creating a Presentation
        1. IV.3.1.1. Starting from a Microsoft Word document
        2. IV.3.1.2. Starting from Project Gallery
      2. IV.3.2. Choosing a View
        1. IV.3.2.1. Using Normal View
        2. IV.3.2.2. Switching to Slide View
        3. IV.3.2.3. Adding notations in Notes Page View
        4. IV.3.2.4. Switching from one view to another
      3. IV.3.3. Starting from Scratch
      4. IV.3.4. Adding a New Slide
      5. IV.3.5. Formatting the Background
        1. IV.3.5.1. Gradient backgrounds
        2. IV.3.5.2. Clicking for additional options
      6. IV.3.6. Formatting Bullets and Numbers
        1. IV.3.6.1. Customizing bullet and number characters
        2. IV.3.6.2. Living in no-bullet land
        3. IV.3.6.3. Customizing bullets by using SmartArt graphics
      7. IV.3.7. Applying a New Theme
      8. IV.3.8. Creating Smaller Versions with Custom Shows
    4. IV.4. Mastering the Masters
      1. IV.4.1. Putting a Master Slide in Charge
        1. IV.4.1.1. Getting your bearings in Slide Master View
        2. IV.4.1.2. Looking at a new toolbar
      2. IV.4.2. Formatting Slide Layouts
      3. IV.4.3. Adding Another Set of Masters
      4. IV.4.4. Adding More Slide Layouts
      5. IV.4.5. Taking Note of Notes Masters
      6. IV.4.6. Handling Handout Masters
    5. IV.5. Proofing the Presentation
      1. IV.5.1. Banishing Spelling Mistakes
        1. IV.5.1.1. Setting spelling preferences
        2. IV.5.1.2. Getting rid of red squiggles
        3. IV.5.1.3. Checking the whole presentation
        4. IV.5.1.4. Correcting automatically while you type
      2. IV.5.2. Collaborating with Comments
      3. IV.5.3. Remembering to Remember
    6. IV.6. Adding Text, Pictures, Tables, and Charts
      1. IV.6.1. Getting the Right Text Format
      2. IV.6.2. Importing a Batch of Pictures
        1. IV.6.2.1. Making an Automator Action
        2. IV.6.2.2. Running the Automator Action
      3. IV.6.3. Charting the (New) Way
      4. IV.6.4. Tipping the Tables
        1. IV.6.4.1. Making a table the new way
        2. IV.6.4.2. Reformatting a table
    7. IV.7. Applying Animation
      1. IV.7.1. Classifying Custom Animations
      2. IV.7.2. Animating Text
        1. IV.7.2.1. Adding an entrance effect quickly
        2. IV.7.2.2. Getting a little fancier
        3. IV.7.2.3. Start options
        4. IV.7.2.4. Making a moth fly
        5. IV.7.2.5. Changing your mind
      3. IV.7.3. Animating a Chart
    8. IV.8. Presenting Sounds and Movies
      1. IV.8.1. Speaking to Your Audience
        1. IV.8.1.1. Rehearsing timings
        2. IV.8.1.2. Recording narrations
          1. IV. Recording options
          2. IV. Link narrations
      2. IV.8.2. Adding Music and Sounds
        1. IV.8.2.1. Making audio and video play while a slide plays
        2. IV.8.2.2. Adding audio that plays when the slide starts
        3. IV.8.2.3. Adding audio that plays when clicked
        4. IV.8.2.4. Adding audio that plays when moused over
        5. IV.8.2.5. Adding a CD audio track
        6. IV.8.2.6. Recording a sound directly onto a slide
      3. IV.8.3. Filling the Transition Gap
      4. IV.8.4. Adding Narration and Video to a Slide
        1. IV.8.4.1. Creating a video narration
        2. IV.8.4.2. Adding video to a slide
      5. IV.8.5. Using Custom Animation to Control Movies and Audio
      6. IV.8.6. Dealing with Audio and Video Odds and Ends
        1. IV.8.6.1. Hiding sound icons
        2. IV.8.6.2. Linking and embedding
        3. IV.8.6.3. Discerning a sound difference
          1. IV. Insert Sound
          2. IV. Choose a Sound
        4. IV.8.6.4. Making sounds compatible
        5. IV.8.6.5. Making video compatible
          1. IV. Using WMV
          2. IV. Video DRM
    9. IV.9. Printing and Sharing Presentations
      1. IV.9.1. Printing Your Presentations
        1. IV.9.1.1. Printing to PDF files
        2. IV.9.1.2. Printing handouts for everyone
          1. IV. Printing handouts with note-taking lines
          2. IV. Printing handouts with slide notes
          3. IV. Printing the slide outline
          4. IV. Setting headers and footers
      2. IV.9.2. Exploring Sharing Options
        1. IV.9.2.1. Distributing in PowerPoint format
        2. IV.9.2.2. Distributing as a movie
        3. IV.9.2.3. Sending directly to iPhoto
        4. IV.9.2.4. Sending by e-mail or MSN Messenger
        5. IV.9.2.5. Sharing with iChat
          1. IV. Sharing your screen
          2. IV. Sharing with iChat Theater
        6. IV.9.2.6. Sharing by using Google Docs
        7. IV.9.2.7. Exploring slide-sharing sites
      3. IV.9.3. Presenting Live
        1. IV.9.3.1. Using the letter B (or W)
        2. IV.9.3.2. Using Pen tools
        3. IV.9.3.3. Navigating while showing
  10. V. Entourage 2008
    1. V.1. Introducing Entourage: Seven Applications in One
      1. V.1.1. Introducing Entourage
      2. V.1.2. Connecting to the Internet with Entourage's Mail
        1. V.1.2.1. Discerning the Exchange difference
        2. V.1.2.2. Making connections to the world
      3. V.1.3. Keeping Yourself Organized
        1. V.1.3.1. Keeping track of people with your contacts list
        2. V.1.3.2. Keeping track of your events with Calendar
        3. V.1.3.3. Making notes for yourself
        4. V.1.3.4. Assigning tasks
        5. V.1.3.5. Making My Day your day
        6. V.1.3.6. Organizing a project in the Project Center
        7. V.1.3.7. Customizing Entourage toolbars
      4. V.1.4. Automating Entourage
      5. V.1.5. Taking Care of the Entourage Database
        1. V.1.5.1. Verifying database integrity
        2. V.1.5.2. Compacting your database
        3. V.1.5.3. Rebuilding your database
    2. V.2. Welcome to the Setup Assistant
      1. V.2.1. Setting Up with the Setup Assistant
        1. V.2.1.1. Starting without importing anything
          1. V. Setting up an account for Microsoft Exchange
          2. V. Figuring out an IMAP account
        2. V.2.1.2. Importing from a previous version of Entourage
        3. V.2.1.3. Importing from another e-mail program
        4. V.2.1.4. Adding additional e-mail accounts
        5. V.2.1.5. Configuring an e-mail account manually
      2. V.2.2. Digging Deeper into Account Settings
        1. V.2.2.1. Configuring settings
        2. V.2.2.2. Opting for options
        3. V.2.2.3. Settings for IMAP users
        4. V.2.2.4. Accommodating digital signatures and encryption
      3. V.2.3. Touring the Entourage Preferences
        1. V.2.3.1. Going with general admission
        2. V.2.3.2. Customizing the Address Book
        3. V.2.3.3. Changing the To Do List
        4. V.2.3.4. Clarifying the Calendar preferences
        5. V.2.3.5. Fiddling with your fonts
        6. V.2.3.6. Controlling the spell checker
        7. V.2.3.7. Turning off that little mail notification
        8. V.2.3.8. Staying slightly more secure
        9. V.2.3.9. Syncing the services
        10. V.2.3.10. Enjoying the Spotlight
        11. V.2.3.11. Feeding MacBU
        12. V.2.3.12. Nothing to read
        13. V.2.3.13. Gaining your composure
        14. V.2.3.14. Replying and forwarding fun
        15. V.2.3.15. Viewing the colors
    3. V.3. Mastering Mail
      1. V.3.1. Picking a Preview Pane View
      2. V.3.2. Reading Mail
      3. V.3.3. Creating a Message
        1. V.3.3.1. Creating e-mail in Entourage
        2. V.3.3.2. Creating e-mail in Microsoft Word
          1. V. Sending in HTML format
          2. V. Sending as an attached Word document
          3. V. Using Mail Merge
      4. V.3.4. Exploring the Entourage Menu Options
        1. V.3.4.1. Using File menu options
          1. V. Export contacts
          2. V. Create an archive
        2. V.3.4.2. Using Edit menu options
        3. V.3.4.3. Scoping the View menu
        4. V.3.4.4. Minding the toolbar buttons and palettes
        5. V.3.4.5. Sailing through the Script menu
      5. V.3.5. Tooling Down the Toolbar Highway
      6. V.3.6. Picking Apart the Panes
        1. V.3.6.1. Living with the folder list
        2. V.3.6.2. Creating a custom Mail view
        3. V.3.6.3. Manipulating the message list
          1. V. Pop-up in the middle
          2. V. Other preview options
            1. V. Sorting your messages
            2. V. Picking the column headers
            3. V. Assigning a category to a message
            4. V. Creating, changing, and deleting categories
            5. V. Displaying a list of items in a category
      7. V.3.7. Understanding Digital Certificates
    4. V.4. Your Mail Rules and Newsgroups
      1. V.4.1. Sandbagging the Flood of Junk Mail
      2. V.4.2. Building Mailing List Rules
      3. V.4.3. Ruling the Roost
        1. V.4.3.1. Rules about rules
        2. V.4.3.2. Making rules
      4. V.4.4. Keeping on Schedule
      5. V.4.5. Connecting to World Communities by Using Newsgroups
    5. V.5. Personalizing Your PIM
      1. V.5.1. Perusing the Address Book Interface
      2. V.5.2. Meeting Yourself
      3. V.5.3. Adding Friends and Associates
      4. V.5.4. Managing Your Contacts
        1. V.5.4.1. Printing contacts
        2. V.5.4.2. Finding contacts
        3. V.5.4.3. Creating a custom view for a contact
        4. V.5.4.4. Grouping contacts
        5. V.5.4.5. Exporting contacts
        6. V.5.4.6. Mapping contacts
        7. V.5.4.7. Creating custom fields
        8. V.5.4.8. Deleting contacts
      5. V.5.5. Addressing Mail and Invitations
        1. V.5.5.1. Sending from the Address Book
        2. V.5.5.2. Sending a new message or invitation
        3. V.5.5.3. Addressing automatically
        4. V.5.5.4. Using address blocks
      6. V.5.6. Using LDAP Directory Services
        1. V.5.6.1. Setting up an LDAP account
        2. V.5.6.2. Using directory services
    6. V.6. Crafting Your Calendar
      1. V.6.1. Taking a Look at the Interface
      2. V.6.2. Going on Holiday
      3. V.6.3. Adding Calendar Events
      4. V.6.4. Enhancing an Event
        1. V.6.4.1. Opening an existing event
        2. V.6.4.2. Creating a recurring event
        3. V.6.4.3. Inviting others to an event
        4. V.6.4.4. Changing your status
        5. V.6.4.5. Assigning categories
        6. V.6.4.6. Linking to other things
      5. V.6.5. Receiving Invitations
        1. V.6.5.1. Accepting an invitation
          1. V. Accepting with comments
          2. V. Accepting without comments
          3. V. Accepting with no response
        2. V.6.5.2. Tentatively accepting an invitation
        3. V.6.5.3. Declining an invitation
      6. V.6.6. Receiving Acceptances and Rejections
      7. V.6.7. Changing Your Mind
      8. V.6.8. Finding and Searching
        1. V.6.8.1. Conducting a search
        2. V.6.8.2. Saving a custom Calendar view
      9. V.6.9. Using Special Exchange Features
        1. V.6.9.1. Sharing Calendars and other items
        2. V.6.9.2. Delegating authority
      10. V.6.10. Importing an Outlook PST File
      11. V.6.11. Printing Your Calendar
    7. V.7. Keeping Track of Your Day
      1. V.7.1. Bringing Up Reminders
        1. V.7.1.1. Snoozing
        2. V.7.1.2. Fixing an accidental snooze
        3. V.7.1.3. Dismissing forever
      2. V.7.2. Making Notes for Future Reference
        1. V.7.2.1. Looking at the Notes list
        2. V.7.2.2. Making a note on the spot
        3. V.7.2.3. Printing notes
      3. V.7.3. Remembering to Do Things
        1. V.7.3.1. Checking out the Tasks interface
        2. V.7.3.2. Creating a new task
        3. V.7.3.3. Marking a task as completed
        4. V.7.3.4. Creating a new To Do item
        5. V.7.3.5. Printing tasks and To Do lists
      4. V.7.4. Making Your Day with My Day
        1. V.7.4.1. Looking at My Day
        2. V.7.4.2. Choosing a different day or time range
        3. V.7.4.3. Creating a new task
        4. V.7.4.4. Setting My Day preferences
        5. V.7.4.5. Watching a My Day movie
  11. VI. Entourage's Project Center
    1. VI.1. Creating New Projects
      1. VI.1.1. Deciding When to Use Project Center
      2. VI.1.2. Determining the Scope
        1. VI.1.2.1. Single-user projects
        2. VI.1.2.2. Sharing projects
          1. VI. Thinking about security
          2. VI. Controlling consistency
      3. VI.1.3. Starting a New Project
        1. VI.1.3.1. Wizard Step 1 — Setting the framework
        2. VI.1.3.2. Wizard Step 2 — Deciding where and what
          1. VI. Project Watch Folders
          2. VI. Import Items
        3. VI.1.3.3. Wizard Step 3 — Applying rules and tools
          1. VI. Rules
          2. VI. Finder Tools
        4. VI.1.3.4. Wizard Step 4 — Summary
    2. VI.2. Overviewing and Sharing Projects
      1. VI.2.1. Lurking in the Projects List
        1. VI.2.1.1. Opening a project within the Project Center window
        2. VI.2.1.2. Opening a project in its own window
      2. VI.2.2. Touching the Tabs
      3. VI.2.3. Surveying the Overview
        1. VI.2.3.1. Trying out the toolbars
        2. VI.2.3.2. Peeking at the Calendar and Tasks
        3. VI.2.3.3. Customizing the customizable areas
      4. VI.2.4. Sharing a Project
        1. VI.2.4.1. Step 1 — Start the Assistant
        2. VI.2.4.2. Step 2 — Select which project to share
        3. VI.2.4.3. Step 3 — Choose the file location for the shared folder
        4. VI.2.4.4. Step 4 — Share existing items
        5. VI.2.4.5. Step 5 — Decide how to manage new items
        6. VI.2.4.6. Step 6 — Close the Project Sharing Assistant
        7. VI.2.4.7. Changing Project settings
      5. VI.2.5. Taking a Shortcut
    3. VI.3. Keeping on Schedule
      1. VI.3.1. Keeping Track of Events and Tasks
        1. VI.3.1.1. Working with the Calendar
          1. VI. Filtering and making overlays
          2. VI. Changing Calendar views
        2. VI.3.1.2. Working with Tasks
      2. VI.3.2. Exploring the Lower Toolbar
        1. VI.3.2.1. Sharing your project with others
        2. VI.3.2.2. New button
        3. VI.3.2.3. Add button
      3. VI.3.3. Creating a Gantt Chart
        1. VI.3.3.1. Making a very simple Gantt chart
        2. VI.3.3.2. Making a more robust Gantt chart
    4. VI.4. Managing More Project Details
      1. VI.4.1. Viewing Project Mail
      2. VI.4.2. Watching your Project's Files
        1. VI.4.2.1. Adding files to the Files list
        2. VI.4.2.2. Sharing a file
          1. VI. Sharing a file — Method 1
          2. VI. Sharing a file — Method 2
        3. VI.4.2.3. Stop sharing a file
        4. VI.4.2.4. Opening a file
        5. VI.4.2.5. Removing a file from a project
        6. VI.4.2.6. Sending files via e-mail or Microsoft Messenger
          1. VI. Sending a file — Method 1
          2. VI. Sending a file — Method 2
      3. VI.4.3. Speeding Up Things
      4. VI.4.4. Finding Files in Project Gallery
      5. VI.4.5. Associating with Project Contacts
      6. VI.4.6. Storing and Using Clippings
      7. VI.4.7. Using Notes in Project Center
      8. VI.4.8. Working with the Project Palette
  12. 44. The Next Office Version
    1. BC.1.1. What's New in the Next Version of Office for Mac
      1. BC.1.1.1. The return of VBA
      2. BC.1.1.2. New Web services and technologies
    2. BC.1.2. Silverlight
    3. BC.1.3. Storing and Sharing in the Mesh
    4. BC.1.4. Living in Office Live
      1. BC.1.4.1. Office Live Small Business
      2. BC.1.4.2. Office Live Workspace
    5. BC.1.5. Participating in the Future
      1. BC.1.5.1. Sending feedback about
      2. BC.1.5.2. Sending feedback about Live Workspace
  13. 45. Finding What's New in Service Pack 2
    1. BC.2.1. Sharing with Document Connection
      1. BC.2.1.1. Setting things up
        1. BC. Preparing to use a Office Live Workspace
        2. BC. Preparing to use a SharePoint site
        3. BC. Working with your Web browser
      2. BC.2.1.2. Launching Document Connection
        1. BC. Adding Document Connection to the Dock
        2. BC. Adding a location to Document Connection
      3. BC.2.1.3. Working with files
        1. BC. Adding Workspaces (Folders)
        2. BC. Adding files
          1. BC. Adding files with Document Connection
          2. BC. Adding files using your Web browser
        3. BC. Renaming a workspace
        4. BC. Sharing workspaces
        5. BC. Viewing files
        6. BC. Editing
        7. BC. Reading
        8. BC. Uploading
        9. BC. Checking out
        10. BC. Checking in
        11. BC. Drafts
        12. BC. Adding favorite files
        13. BC. Discarding
        14. BC. Deleting files
        15. BC. Empty cache
    2. BC.2.2. Motion Path Animations in PowerPoint

Product information

  • Title: Office 2008 for Mac All-in-One For Dummies®
  • Author(s):
  • Release date: October 2009
  • Publisher(s): For Dummies
  • ISBN: 9780470460412