Office 2004 for Macintosh: The Missing Manual

Office 2004 for Macintosh: The Missing Manual

by Mark H. Walker, Franklin Tessler, Paul Berkowitz
Released February 2005
Publisher(s): O'Reilly Media, Inc.
ISBN: 9780596008208

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Buy on Amazon Buy on ebooks.com
Start your free trial

Book description

Microsoft Office is the number-one selling software for the Mac; the Word, Excel, Powerpoint, and Entourage applications are more dominant in the Mac world than they are among PC users. And Microsoft has greatly improved and enhanced Office 2004 to take advantage of the latest Mac OX features. In short, Microsoft Office for the Mac is wildly popular and better than ever. But as incredible and powerful it is, the Office 2004 suite comes without a single page of printed instructions. That means you're left to forge your own path through its countless innovative and useful new features and tools--until now. Office 2004 for Mac: The Missing Manual is the manual that should have been in the box. It's the map that clearly and easily guides both beginners and veterans through this new suite. Mark H. Walker, Franklin Tessler, and Paul Berkowitz deliver all the practical information you need to master the basics and make the most of all four Office 2004 programs--Word, Excel, Powerpoint, and Entourage. It's four books in one! According to Microsoft's own research, the average Office user taps into less than fifteen percent of the suite's features. With first-rate writing, a handcrafted index, and the trademark humor and clarity of every Missing Manual, Office 2004 for Mac: The Missing Manual will change that. Because this isn't an authorized book, Walker, Tessler, and Berkowitz candidly point out which features are gems in the rough worthy of your focused attention--and which are junkware that you best continue to overlook. Whether you're an Office beginner eager to master one or all of the applications in the suite or a longtime Office user looking for detailed coverage of what's new (and what's removed) in Office 2004 and hoping to implement power-user techniques for better and more efficient work, this funny and friendly, comprehensive guide will prove indispensable.

Table of contents

  1. Table of Contents
  2. The Missing Credits
    1. About the Authors
    2. About the Creative Team
    3. Acknowledgments
    4. The Missing Manual Series
  3. Introduction
    1. Keeping Up with the Macs
    2. More Integrated Than Ever
    3. What’s New in Office 2004
      1. Word
      2. Excel
      3. PowerPoint
      4. Entourage
      5. Office as a Whole
    4. The Very Basics
    5. About This Book
      1. About the Outline
      2. About - These - Arrows
      3. About MissingManuals.com
      4. Safari-Enabled
  4. Part One: Word
    1. Chapter 1: Basic Word Processing
      1. Creating and Opening Documents
        1. The Project Gallery
        2. Opening Documents with the Open Command
        3. Returning to Favorite Documents
          1. The Recent Files list
          2. The Work menu
      2. Word Processing Basics
      3. A Window into Word (1/3)
      4. A Window into Word (2/3)
      5. A Window into Word (3/3)
        1. Title Bar
        2. The Ruler
        3. Scroll Bar and Navigator Buttons
        4. Split Box
        5. Window Menu
        6. Status Bar
        7. Standard Toolbar
        8. Formatting Palette
      6. The Views
        1. Normal View
        2. Online Layout View
        3. Page Layout View
        4. Outline View
        5. Notebook Layout View
        6. Master Document View
      7. Every Conceivable Variation on Saving
        1. AutoRecovery
        2. Save As Options
        3. Fast Saves
        4. Backing Up
      8. Printing (1/4)
      9. Printing (2/4)
      10. Printing (3/4)
      11. Printing (4/4)
        1. The Print Button
        2. File - Print
          1. Copies and Pages
          2. Layout
          3. Output options
          4. Print settings
          5. Advanced settings
          6. Microsoft Word
          7. Summary
          8. Saving custom settings
          9. Preview
          10. Save as PDF, FAX, and Cancel
        3. File - Page Setup
          1. Print Preview
          2. Print Preferences
          3. Printing Envelopes and Labels
            1. Printing envelopes
            2. Printing labels
          4. Sending It Electronically
    2. Chapter 2: Editing in Word
      1. The Many Ways to Select Text
        1. Multi-Selection
      2. Moving Text Around (1/2)
      3. Moving Text Around (2/2)
        1. Copy (or Cut) and Paste
          1. The Paste Options smart button
        2. Paste Special
        3. Paste as Hyperlink
        4. Drag-and-Drop
          1. Drag-and-drop between programs
          2. Dragging and dropping to the desktop
      4. Navigating Your Documents
        1. What the Keys Do
        2. Keystrokes: The Missing Manual
        3. The Go To Command
        4. The Navigator Buttons
      5. Finding and Replacing (1/2)
      6. Finding and Replacing (2/2)
        1. Find
        2. Replace
        3. Advanced Find
        4. Finding by Format
        5. Finding Invisible Characters
      7. Spelling and Grammar (1/3)
      8. Spelling and Grammar (2/3)
      9. Spelling and Grammar (3/3)
        1. Check Spelling as You Type
        2. Checking Spelling and Grammar All at Once
        3. Spelling and Grammar Options
        4. Writing Styles
        5. Custom Dictionaries and Preferred Spellings
          1. Editing the custom dictionary
          2. Creating a new custom dictionary
          3. Adding and removing custom dictionaries
          4. Foreign language dictionaries
          5. Choosing custom dictionaries before spell checking
          6. Exclude dictionaries
      10. Five Ways to Type Less (1/3)
      11. Five Ways to Type Less (2/3)
      12. Five Ways to Type Less (3/3)
        1. Click and Type
        2. AutoCorrect
        3. AutoText: Abbreviation Expanders
          1. Setting up an AutoText entry
          2. Triggering AutoText entries
          3. AutoText graphics
          4. AutoText fields
        4. Project Gallery Templates
        5. AutoFormat
          1. Autoformatting as you type
          2. Autoformatting in one pass
    3. Chapter 3: Formatting in Word
      1. The Formatting Palette
      2. Character Formatting (1/2)
      3. Character Formatting (2/2)
        1. Choosing Fonts
        2. Font Sizes
        3. Styles of Type
        4. Typing in Color
        5. Special Text Effects
        6. Small Caps, All Caps
        7. Hidden Text
      4. Lists
        1. Extra Features in the Bullets and Numbering Dialog Box
          1. Customizing a bulleted list
          2. Customizing a numbered list
      5. Paragraph Formatting (1/3)
      6. Paragraph Formatting (2/3)
      7. Paragraph Formatting (3/3)
        1. Alignment and Spacing
          1. Horizontal
          2. Line spacing
          3. Orientation
        2. Paragraph Spacing
        3. Indentation
        4. Tabs
          1. Default tabs
          2. Setting tabs
          3. Tab types
          4. Applying tabs to paragraphs and styles
        5. Borders and Shading
          1. Text and paragraph borders
          2. Extra features in the Borders and Shading dialog box
          3. Page borders
          4. Shading
          5. Extra features in the Borders and Shading dialog box
      8. Document Formatting
        1. Margins
        2. Gutters and Mirrors
      9. Section Formatting
        1. Inserting and Removing Section Breaks
        2. Formatting Within Sections
          1. Page numbering across sections
    4. Chapter 4: Styles, Page Layout, and Tables
      1. Styles
        1. Where Styles Are Stored
        2. Applying Styles
        3. Creating Styles by Example
        4. Creating Styles in the Dialog Box
        5. Changing, Deleting, or Copying Styles
          1. Deleting styles
          2. Transferring styles
      2. Page Layout
        1. Inserting Breaks
          1. Paragraph break
          2. Line break
          3. Page break
          4. Column break
          5. Section break
        2. Working with Columns
          1. Adding columns using the Standard toolbar
          2. Adding columns using the Columns dialog box
          3. How columns look and flow
          4. Adjusting column widths
      3. Automatic Hyphenation
        1. Hyphenation Settings
        2. Manual Hyphenation
        3. Hard Hyphens
      4. Text Boxes (1/2)
      5. Text Boxes (2/2)
        1. Creating Text Boxes
        2. The Text Box Toolbar
        3. Formatting Within Text Boxes
          1. Changing the background color or border style
          2. Sizing text boxes
        4. Working with Linked Text Boxes
          1. Copying linked text boxes
          2. Deleting one text box in a chain
          3. Grouping text boxes
        5. Text Wrapping and Layering
          1. Wrapping text around things
          2. Layering text with graphics
      6. Pictures and Drawings
        1. Inline vs. Page Graphics
        2. Converting Inline Graphics into Page Graphics
      7. Charts and Spreadsheets
      8. Tables
        1. Creating Tables
          1. Inserting a table
          2. Drawing a table
          3. Typing into tables
          4. Selecting cells
          5. Sizing rows and columns
          6. Adding rows and columns
          7. Deleting table parts
        2. Formatting Tables
          1. Autoformatting tables
          2. Table headings
          3. Cell margins and spacing
          4. Text formatting within cells
          5. Table layout on the page
          6. Nested tables
          7. Merging and splitting cells
          8. Converting text to a table
          9. Converting a table into text
          10. Formulas in tables
          11. Sorting tables
    5. Chapter 5: Comments, Change Tracking, and Versions
      1. Comments
        1. Adding Comments
        2. Reviewing Comments
          1. Deleting comments
        3. Navigating Comments
      2. Change Tracking (1/2)
      3. Change Tracking (2/2)
        1. Getting Ready for Change Tracking
          1. Identify yourself
          2. Turning on change tracking
        2. Making Changes
          1. Changing tracking options
        3. Reviewing Changes One by One
          1. Reviewing changes: light edits
          2. Reviewing changes: heavier edits
        4. Accepting or Rejecting All Changes
        5. Merging Tracked Changes
      4. Comparing Documents
      5. Versioning
        1. Saving a Version
        2. Opening a Version
        3. Spinning Off a Version
        4. Deleting a Version
    6. Chapter 6: Notebooks, Outlining, and Master Documents
      1. Notebook Layout View
        1. Opening Your Notebook
        2. The Notebook Layout Toolbar
        3. Organizing Your Notes
          1. Setting Text Levels with the Keyboard and Mouse
          2. Setting Text Levels with the Formatting Palette
          3. Sorting Headings
        4. Placing Notes Beside Your Notes
          1. Flagging Action Items
          2. Important Enough to Track in Entourage?
        5. Typing Less with Audio Notes
          1. Entering an Audio Note
          2. Listening to an Audio Note
        6. Manipulating Notebook Sections
          1. Labeling Sections
          2. To Line or Not to Line
          3. Numbering Pages
      2. The Outliner (1/2)
      3. The Outliner (2/2)
        1. Building an Outline
          1. Collapsing and expanding an outline
        2. Outlining an Existing Document
        3. Numbering an Outline
          1. Renumbering a numbered outline
        4. Customizing an Outline
          1. Using the Custom Outline dialog box
          2. Advanced outline customization
      4. The Document Map
        1. What’s in the Document Map
        2. Viewing and Navigating the Document Map
        3. Customizing the Document Map
      5. Master Documents (1/2)
      6. Master Documents (2/2)
        1. Creating a New Master Document
          1. Spinning off a document
          2. Incorporating a document
        2. Viewing Master Documents
        3. Working with Master Documents
          1. Opening and expanding subdocuments
          2. Moving and renaming subdocuments
          3. Splitting and combining subdocuments
          4. “Removing” a subdocument
          5. Deleting Subdocuments
        4. Master Documents and Formatting
        5. Master Document Security
          1. Locking and unlocking subdocuments
          2. Assigning passwords
          3. Sharing a Master Document on a Network
    7. Chapter 7: Advanced Word Processing
      1. Headers and Footers
        1. Creating Headers and Footers
          1. Positioning headers and footers
          2. Title pages
          3. Bound-book pages
          4. Different headers (and footers) for different sections
      2. Footnotes and Endnotes
        1. Deleting Footnotes and Endnotes
        2. Controlling Footnote Flow
      3. Line Numbers
      4. Templates (1/2)
      5. Templates (2/2)
        1. Document Templates
          1. Creating a document template
          2. Using a document template
        2. Global Templates
        3. Modifying a Template
        4. Attaching a Document Template
        5. The Organizer
        6. Normal and Global Templates
          1. The Normal template
          2. Loading a template as global
          3. Unloading a global template
      6. AutoSummarize
        1. Creating an AutoSummary
          1. Type of summary
      7. Fields
        1. Inserting Fields
          1. Building fields in the Field dialog box
        2. Modifying Fields with Switches
        3. What a Field Does
        4. Working with Fields in a Document
          1. Displaying fields
          2. Updating fields
          3. Locking, unlocking, and unlinking fields
          4. Field printing options
      8. Bookmarks
        1. Adding Bookmarks
        2. Deleting Bookmarks
        3. Navigating by Bookmark
        4. Viewing Bookmarks
      9. Captions
        1. Inserting Captions
        2. Adding Text to Captions
        3. Deleting and Editing Captions
        4. Updating Captions
        5. AutoCaptioning
        6. Turning AutoCaptions Off
      10. Cross-References
        1. Inserting Cross-References
        2. Modifying and Deleting Cross-References
      11. Creating a Table of Contents
        1. TOC the Easiest Way: Using Built-in Headings
        2. TOC the Harder Way: Using Other Styles
        3. Updating or Deleting a Table of Contents
        4. Table of Figures and Table of Authorities
          1. Table of Figures
          2. Table of Authorities
      12. Indexing (1/2)
      13. Indexing (2/2)
        1. Phase 1: Create Index Entries
          1. Cross-references
          2. Page range entries
        2. Phase 2: Editing Index Field Codes (Optional)
        3. Phase 3: Building the Index
        4. Phase 4: Cleaning Up the Index
      14. Data Merges (1/4)
      15. Data Merges (2/4)
      16. Data Merges (3/4)
      17. Data Merges (4/4)
        1. Preparing Data Sources
        2. Creating a New Data Source
        3. Using an Existing Data Source
        4. Creating the Main Document
        5. Previewing, Formatting, Preparing to Merge
        6. Merging Straight to the Printer
          1. Customizing merge printing
          2. Query Options
        7. Merging to a New Document
        8. Merging to Email
        9. Labels and Envelopes
          1. Merging onto labels
          2. Editing labels
          3. Propagating labels
          4. Merging onto envelopes
      18. Macros (1/2)
      19. Macros (2/2)
        1. Creating a Macro
        2. Running a Macro
        3. The Macro Organizer
        4. Learning about Visual Basic
    8. Chapter 8: Word Meets Web
      1. Word as Web Browser
        1. Opening Web Pages from the Web
        2. Opening Web Pages from Your Hard Drive
        3. Viewing HTML Code for a Web Page
      2. Creating a Web Page in Word (1/2)
      3. Creating a Web Page in Word (2/2)
        1. Designing a Site Map
        2. Basic Web-Page Layout
          1. Themes
          2. Style Gallery
          3. Backgrounds
          4. Font colors
          5. Other text effects
          6. Tables in Web page layout
      4. Graphics, Sounds, and Movies
        1. Downloading Graphics from the Web
          1. Text wrapping and graphics
        2. Bullets and Dividers
        3. Horizontal Lines
        4. Movies
          1. Giving a movie a poster frame
          2. Removing a movie
        5. Background Sounds
      5. Hyperlinks (1/2)
      6. Hyperlinks (2/2)
        1. Linking to Another Place or Another Word Document
          1. The easy way (copy and paste)
          2. The longer way (using bookmarks or headings)
        2. Linking to an Application or Mac File
        3. Linking to Another Web Site
          1. By typing a URL
          2. By dragging a URL
          3. By using a Favorite or History
        4. Email Hyperlinks
        5. Selecting and Editing Hyperlinks
          1. Hyperlink colors
        6. Removing Hyperlinks
      7. Web Forms
      8. Saving Web Pages
        1. Web Options
        2. Lost in the Translation
        3. Posting Your Web Site Online
  5. Part Two: Entourage
    1. Chapter 9: Entourage Email and Newsgroups
      1. The Big Picture
        1. Entourage Functions
        2. The Toolbar
      2. Setting Up Entourage (1/2)
      3. Setting Up Entourage (2/2)
        1. Setting Up a Second Email Account
        2. Configuring Your Account Manually
      4. Sending and Receiving Mail (1/9)
      5. Sending and Receiving Mail (2/9)
      6. Sending and Receiving Mail (3/9)
      7. Sending and Receiving Mail (4/9)
      8. Sending and Receiving Mail (5/9)
      9. Sending and Receiving Mail (6/9)
      10. Sending and Receiving Mail (7/9)
      11. Sending and Receiving Mail (8/9)
      12. Sending and Receiving Mail (9/9)
        1. Send and Receive All
          1. The Progress window
          2. Checking a specific email account
        2. Advanced Mail-Getting Features
          1. Automatic checking on a schedule
          2. The hotel-room feature: online accounts
          3. Restricting download sizes
          4. Ofline access
        3. Reading a Message
          1. Icons in the message list
        4. How to Process a Message
          1. Deleting messages
          2. Replying to messages
          3. Editing messages
          4. Reformatting messages
          5. Forwarding messages
          6. Redirecting messages
          7. Printing messages
          8. Filing messages
          9. Flagging messages
          10. Linking messages
          11. Prioritizing messages
        5. Opening Attachments
          1. When attachments don’t open
        6. Using Message Rules
          1. Setting up message rules
          2. Two sneaky message-rule tricks
        7. Writing a Message
          1. Step 1: Addressing the message
          2. Step 2: The Subject line
          3. Step 3: Composing the body
          4. Step 4: Choosing a format (HTML or plain text)
          5. Step 5: Adding a signature
          6. Step 6: Add any file attachments
          7. Step 7: Send your email on its way
        8. Email Netiquette
          1. Mailing List Etiquette
      13. Newsgroups (1/3)
      14. Newsgroups (2/3)
      15. Newsgroups (3/3)
        1. Setting Up an Account
        2. Download the List of Newsgroups
        3. Finding Newsgroups and Messages
        4. Reading Messages
        5. Composing, Forwarding, and Replying to Messages
        6. Usenet Netiquette
        7. Mail and News Preferences
          1. Read panel
          2. Compose panel
          3. Reply & Forward panel
          4. View panel
    2. Chapter 10: Calendar, Tasks, and the Project Center
      1. The Calendar
        1. Working with Views
          1. Displaying days, weeks, and months
      2. Recording Events (1/2)
      3. Recording Events (2/2)
      4. What to Do with an Appointment (1/2)
      5. What to Do with an Appointment (2/2)
        1. Editing Events
        2. Rescheduling Events
        3. Lengthening or Shortening Events
        4. Printing Events
        5. Deleting Events
        6. Sending Invitations
          1. Sending the invitation
          2. Receiving an invitation
          3. Receiving RSVPs for your invitation
        7. Adding Holidays
      6. Saving Calendars as Web Pages
      7. Tasks
        1. Changing Your Views
        2. Creating Tasks
        3. Other Task Tricks
          1. Editing a task
          2. Checking off a task
          3. Deleting a task
          4. Printing tasks
          5. Linking tasks
      8. Office Notifications
        1. The Notifications Window
        2. Acting on Notifications
        3. Configuring Office Notifications
          1. Turn Office Notifications on or off
          2. Turn Office Notifications sounds on or off
      9. Project Center (1/3)
      10. Project Center (2/3)
      11. Project Center (3/3)
        1. Starting a Project
        2. The Project Center Window
        3. Project Views
        4. Getting Around the Project Center
          1. Overview
          2. Schedule
          3. Mail
          4. Files
          5. Contacts
          6. Clippings
          7. Notes
        5. Sharing
          1. Sharing a project
          2. Sharing the shared project
      12. Accessing Projects from Other Office Programs
    3. Chapter 11: Address Book and Notes
      1. Address Book
        1. A Tour of Address Book World
        2. Creating Contacts
          1. The long form
          2. Opening, editing, and deleting contacts
          3. Creating groups
        3. Importing Contacts
          1. The Import Assistant
        4. Exporting Contacts and Archives
        5. Using Contacts
          1. Sending email to someone
          2. Flagging a contact
          3. Using contacts in Word
        6. Five Very Impressive Buttons
        7. Printing the Address Book
      2. The Note Pad
        1. Notes Mode
        2. Creating Notes
        3. Printing Notes
    4. Chapter 12: Advanced Entourage
      1. Palm Synchronization
      2. About Conduits (1/2)
      3. About Conduits (2/2)
        1. Installing the Software
          1. Running the installer
        2. Conduit Settings
          1. Private records
          2. Special settings
        3. Doing the HotSync
          1. How the data differs
      4. Multiple Identities
        1. Creating a New Identity
      5. Finding Messages
        1. The Find Window
        2. Advanced Find
        3. Find Related
      6. Links
        1. Using Links
      7. Categories
        1. Setting Up Categories
        2. Assigning a Category
      8. Checking Your Spelling
      9. The Script Menu
  6. Part Three: Excel
    1. Chapter 13: Basic Excel
      1. Spreadsheet Basics
        1. Opening a Spreadsheet
        2. Data Entry
        3. Kinds of Data
          1. Numbers
          2. Text
          3. Dates
          4. Times
        4. Tedium Savings 1: AutoComplete
        5. Tedium Savings 2: AutoFill
          1. Using the Fill handle
        6. Selecting Cells (and Cell Ranges)
        7. Moving Things Around
          1. Cutting, copying, and pasting
          2. Paste Special
          3. Drag-and-drop
        8. Inserting and Removing Cells
        9. Find and Replace
        10. Erasing Cells
        11. Tutorial 1: Entering Data
      2. Formula Fundamentals (1/3)
      3. Formula Fundamentals (2/3)
      4. Formula Fundamentals (3/3)
        1. Basic Calculations
          1. Error checking
        2. Functions
          1. Function screen tips
          2. The AutoSum button
          3. Looking up functions
          4. Using the Calculator to assemble formulas
        3. Order of Calculation
        4. Tutorial 2: Yearly Totals
          1. Named ranges
          2. References: absolute and relative
      5. Excel, the List Maker (1/3)
      6. Excel, the List Maker (2/3)
      7. Excel, the List Maker (3/3)
        1. Building Your List with the List Wizard
        2. What to Do with a List
          1. Add a row or column
          2. Delete a row or column
          3. Rearrange a row or column
          4. Sort and filter the list
          5. Use the total row
          6. Move or delete the whole list object
        3. The List Menu
    2. Chapter 14: Formatting and Charts
      1. Formatting Worksheets
        1. Automatic Formatting
        2. The Format Painter
        3. Formatting Cells by Hand
          1. Changing cell size
          2. Cell borders and colors 1: The Format Cells window
          3. Hiding and showing rows and columns
          4. Cell borders and colors 2: The Formatting Palette
        4. Changing How Text Looks
          1. Adding number formats
          2. Add or remove decimal places
          3. Changing fonts
          4. Aligning text
          5. Merging cells
        5. Adding Pictures and Movies
          1. Inserting by the Picture submenu
          2. Inserting by the Add Objects palette
      2. Charts (1/3)
      3. Charts (2/3)
      4. Charts (3/3)
        1. Step 1: Select the Data
        2. Step 2: Choose a Chart Style
        3. Step 3: Set up Your Rows or Columns
        4. Step 4: Add More Series
        5. Step 5: Design the Chart
        6. Step 6: Tell Excel Where to Put It
        7. Step 7: Tweak the Chart to Perfection
        8. Transparent Bars
        9. Advanced Charting
          1. Error bars
          2. Trend lines
      5. Printing Worksheets (1/2)
      6. Printing Worksheets (2/2)
        1. Print Preview (Microsoft’s)
        2. Print Preview (Apple’s)
        3. Page Setup
          1. Page tab
          2. Margins tab
          3. Header/Footer tab
          4. Sheet tab
    3. Chapter 15: Advanced Spreadsheeting
      1. Workbooks and Worksheets
        1. Working with Multiple Worksheets
        2. Sharing a Workbook
          1. Protecting the spreadsheet
        3. Tracking Changes
        4. Merging Workbooks
        5. Exporting Files
          1. Text (tab delimited)
          2. Template
          3. Web page
          4. Spreadsheet properties
      2. Advanced Formula Magic
        1. Nested Formulas
        2. The Formula Palette
        3. Circular References
          1. Iterations
        4. Connecting to Other Workbooks
        5. Auditing
      3. Working with Databases
        1. Fetching FileMaker Pro Data
          1. Step 1: Import the database
          2. Step 2: Choose only the data you want
        2. Grabbing Data from the Web
        3. Importing Data from a Text File
      4. Opening the Excel Toolbox (1/4)
      5. Opening the Excel Toolbox (2/4)
      6. Opening the Excel Toolbox (3/4)
      7. Opening the Excel Toolbox (4/4)
        1. Making a PivotTable
          1. Step 1: Choose the data source
          2. Step 2: Choose the cells
          3. Step 3: Direct the PivotTable
          4. Step 4: Pivot
          5. Step 5: Build the table
          6. Step 6: Massage the data
        2. Analyzing Your Data
          1. Data tables
          2. Goal seek
          3. Scenarios
          4. Solver
          5. Tapping the Data menu
          6. Data form
        3. Viewing Your Data
          1. Custom views
          2. Reports
          3. Outlining
        4. Flag for Follow-Up
        5. Adding a Comment
      8. Macros: Making Excel Work for You
        1. Recording a Macro
        2. Playing a Macro
        3. Sharing Macros
  7. Part Four: PowerPoint
    1. Chapter 16: Basic PowerPoint
      1. Triple View
      2. Step 1: Specify a Design
        1. Canned Design Templates
        2. Complete Slideshows, Including Prewritten Text
        3. Custom-Built Slideshows Based on Your Input
        4. Starting from Scratch
        5. Changing Designs in Midstream
        6. The New Slide Dialog Box
      3. Step 2: Writing the Outline
        1. Using a Word Outline
      4. Step 3: Building the Show
        1. Using Masters
          1. Slide master
          2. Editing the slide master
          3. Adding new elements to a slide master
          4. Title slide master
          5. Handout master
          6. Notes master
        2. View Controls
        3. Navigation
        4. Manipulating Your Slides
          1. Inserting new slides
          2. Inserting slides from other presentations
          3. Deleting a slide
          4. Moving slides around
      5. How to Build a Slide (1/3)
      6. How to Build a Slide (2/3)
      7. How to Build a Slide (3/3)
        1. Using Backgrounds
          1. Changing backgrounds
        2. Working with Text
          1. Editing and formatting text
          2. Formatting bullets
          3. Other characters as bullets
          4. Graphics as bullets
        3. Adding Graphics, Charts, and Tables
          1. Graphics
          2. Microsoft Word tables
          3. PowerPoint tables
          4. Movies and sounds
          5. Charts
          6. Other objects
          7. Hyperlink
    2. Chapter 17: Advanced PowerPoint
      1. Making a Slideshow
        1. Transitions
          1. How transitions work
          2. Kinds of transitions
          3. Customizing your transitions
        2. Putting On the Show
          1. Setting up
          2. Rehearsing your presentation
          3. Choosing a navigation scheme
          4. Presenting onscreen
          5. Controlling the show
        3. Putting Controls on Slides
        4. Using Presenter Tools
        5. Recycling Your Presentations
          1. Hiding slides
      2. Multimedia Effects (1/2)
      3. Multimedia Effects (2/2)
        1. Adding Animations
          1. Preset animations
          2. Custom animations
        2. Narration
        3. Saving Presentations as QuickTime Movies
        4. Saving Presentations for the Web
        5. Saving Slides as Graphics
      4. Printing Your Presentation
        1. Page Setup
        2. Printing Your Slides
        3. Notes and Handouts
  8. Part Five: Microsoft Office as a Whole
    1. Chapter 18: The Project Gallery and Toolbox
      1. The Project Gallery
        1. Opening Documents
        2. Choosing Made Easy
          1. New
          2. Recent
          3. Project
          4. Learn
          5. Customize
          6. Tweaking the Project Gallery
          7. Ditching the Project Gallery
      2. Toolbox
        1. Scrapbook
        2. Organizing Clippings
      3. Reference Tools
      4. Projects Palette
      5. Compatibility Checker
    2. Chapter 19: Customizing Office
      1. Customizing Your Toolbars
        1. Showing Other Toolbars
        2. Creating Custom Toolbars
          1. To move a button or delete it from a toolbar
          2. To add a button or design a new toolbar from scratch
        3. Attaching Custom Toolbars to Documents
      2. Redesigning Your Menus
        1. Adding a command
        2. Removing a menu command
        3. Adding a menu
        4. Removing a menu
        5. Moving whole menus, or specific commands
        6. Resetting everything back to normal
      3. Reassigning Key Combinations
    3. Chapter 20: The Graphics Programs of Office
      1. Inserting a Graphic
      2. The Clip Gallery
        1. Categories
        2. Online
        3. Adding Your Own Clips
        4. Deleting Clips
        5. Search
        6. Working with Clip Art
      3. AutoShapes and WordArt
        1. AutoShapes
        2. WordArt
      4. Lines and Shapes: The Drawing Toolbar
        1. Editing Drawn Objects
        2. Aligning Drawn Objects
          1. The Drawing grid
          2. Rotating drawing objects
      5. Formatting Pictures and Drawings (1/2)
      6. Formatting Pictures and Drawings (2/2)
        1. Colors and Lines Tab
          1. Fill Color: Standard palette
          2. Fill Color: More Colors
          3. Fill Color: Fill Effects
          4. Transparency
          5. Line pop-up menus (drawing objects only)
          6. Pick Line Color/Pick Fill Color
          7. Arrows (drawing objects only)
        2. Size Tab
        3. Picture Tab (Picture Objects Only)
      7. The Picture Toolbar
      8. Object Linking and Embedding (OLE)
        1. Creating Linked Objects
        2. Editing Linked Objects
        3. Repairing a broken link
        4. Overriding Automatic Updating
        5. Creating Embedded Objects
        6. Editing Embedded Objects
    4. Chapter 21: AppleScripting Office
      1. What is AppleScript?
        1. Why Use AppleScript?
      2. Installing and Running Office Scripts
        1. Downloading Scripts
        2. Installing Applets (Script Applications) and Droplets
        3. Installing Entourage Script Menu Scripts
        4. Installing Word, Excel, and PowerPoint Scripts
        5. Running the Scripts
      3. Starter Scripts (1/2)
      4. Starter Scripts (2/2)
        1. Add BCC (Entourage)
        2. Attach vCard (Entourage)
        3. Remove Extra Carriage Returns (Word)
        4. Merge Columns (Excel)
      5. Learning More
        1. Basics of AppleScript
        2. AppleScript in Depth
        3. Office 2004 AppleScript
        4. Scripts for Entourage, Word, Excel, PowerPoint
  9. Index
    1. A
    2. B
    3. C
    4. D
    5. E
    6. F
    7. G
    8. H
    9. I
    10. J
    11. K
    12. L
    13. M
    14. N
    15. O
    16. P
    17. Q
    18. R
    19. S
    20. T
    21. U
    22. V
    23. W
  10. Colophon

Product information

  • Title: Office 2004 for Macintosh: The Missing Manual
  • Author(s): Mark H. Walker, Franklin Tessler, Paul Berkowitz
  • Release date: February 2005
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9780596008208