You are previewing Learn Office 2011 for Mac OS X.
O'Reilly logo
Learn Office 2011 for Mac OS X

Book Description

Office for Mac remains the leading productivity suite for Mac, with Apple's iWork and the free OpenOffice.org trailing far behind. And now it's being updated with a cleaner interface and more compatibility with Exchange and SharePoint.

Beginning Office 2011 for Mac OS X offers a practical, hands-on approach to using Office 2011 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user.

This book provides the best combination of accessible and focused coverage of the Office 2011 applications. Rather than cover every little-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office.

Table of Contents

  1. Copyright
  2. About the Authors
  3. About the Technical Reviewer
  4. Acknowledgments
  5. Introduction
    1. Who Is This Book For?
    2. What Does This Book Cover?
    3. Conventions Used in This Book
  6. I. Building Essential Office Skills
    1. 1. Getting Up to Speed with the Office Applications
      1. 1.1. Meeting the Office Applications and Learning What You Can Do with Them
        1. 1.1.1. Microsoft Word
        2. 1.1.2. Microsoft Excel
        3. 1.1.3. Microsoft PowerPoint
        4. 1.1.4. Microsoft Outlook
      2. 1.2. Understanding the Common Features of the Applications
        1. 1.2.1. The Title Bar and the Close, Minimize, and Zoom Buttons
        2. 1.2.2. The Toolbars
        3. 1.2.3. The Ribbon
        4. 1.2.4. The Status Bar
      3. 1.3. Opening Applications
        1. 1.3.1. Opening an Application from the Dock
        2. 1.3.2. Opening an Application from the Applications Folder
        3. 1.3.3. Making a Application Launch Automatically
      4. 1.4. Creating a Document
      5. 1.5. Saving a Document
      6. 1.6. Closing a Document
      7. 1.7. Opening a Document
      8. 1.8. Closing an Application
      9. 1.9. Summary
    2. 2. Learning Common Tools Across the Office Suite
      1. 2.1. Using the Menus, the Toolbars, and the Ribbon
        1. 2.1.1. Using the Menus
        2. 2.1.2. Using the Toolbars
        3. 2.1.3. Using the Ribbon
        4. 2.1.4. Giving Commands from the Ribbon
        5. 2.1.5. Minimizing the Ribbon
      2. 2.2. Using the Toolbox
        1. 2.2.1. Using the Scrapbook to Collect Items
          1. 2.2.1.1. Adding an Item to the Scrapbook
          2. 2.2.1.2. Inserting an Item from the Scrapbook
          3. 2.2.1.3. Deleting an Item from the Scrapbook
        2. 2.2.2. Using the Reference Tools Palette to Look Up Information
        3. 2.2.3. Using the Compatibility Report Pane to Check a Document's Compatibility with Older Versions of the Application
      3. 2.3. Sharing a Document with Other People
        1. 2.3.1. Sending a Document via E-mail
        2. 2.3.2. Saving a Document to SkyDrive
        3. 2.3.3. Saving a Document to a SharePoint Site
      4. 2.4. Saving Time and Effort with AutoCorrect
        1. 2.4.1. Choosing Standard AutoCorrect Options
        2. 2.4.2. Choosing AutoFormat As You Type Options
        3. 2.4.3. Choosing Math AutoCorrect Options
        4. 2.4.4. Creating AutoCorrect Entries
        5. 2.4.5. Creating AutoCorrect Exceptions
        6. 2.4.6. Working with Smart Buttons
      5. 2.5. Checking Spelling and Grammar
        1. 2.5.1. Checking Spelling
          1. 2.5.1.1. Checking Spelling as You Type
          2. 2.5.1.2. Checking Spelling in the Whole Document
        2. 2.5.2. Checking Grammar in Word and Outlook
          1. 2.5.2.1. Controlling How the Spelling Checker Works in Word and PowerPoint
          2. 2.5.2.2. Choosing Grammar and Style Options for Word and Outlook
        3. 2.5.3. Taking Control over Spelling Checks with Custom Dictionaries
          1. 2.5.3.1. Understanding How Custom Dictionaries Work
          2. 2.5.3.2. Coming to Grips with Your Custom Dictionaries
          3. 2.5.3.3. Creating a Custom Dictionary
          4. 2.5.3.4. Adding Words to or Removing Words from a Custom Dictionary
          5. 2.5.3.5. Turning Off, Removing, or Deleting a Custom Dictionary
      6. 2.6. Printing Documents
        1. 2.6.1. Printing a Full Copy of the Document Quickly
        2. 2.6.2. Printing Exactly What You Need
      7. 2.7. Summary
    3. 3. Working with Text
      1. 3.1. Entering Text in Your Documents
        1. 3.1.1. Entering Text in Documents Using Copy and Paste
        2. 3.1.2. Entering Text by Scanning a Document and Using Optical Character Recognition
        3. 3.1.3. Entering Text by Using Speech Recognition
        4. 3.1.4. Inserting Symbols in a Document
          1. 3.1.4.1. Inserting a Symbol Using the Symbol Browser Pane
          2. 3.1.4.2. Inserting a Symbol or Special Character Using the Symbol Dialog Box in Word
      2. 3.2. Navigating with the Keyboard and Selecting Objects
      3. 3.3. Applying Direct Formatting to Text and Objects
      4. 3.4. Using Cut, Copy, and Paste
        1. 3.4.1. Using Standard Cut, Copy, and Paste in the Office Applications
      5. 3.5. Using Find and Replace
        1. 3.5.1. Searching Quickly with the Search Box on the Standard Toolbar
        2. 3.5.2. Locating Text with the Find Dialog Box or Advanced Find Dialog Box
        3. 3.5.3. Replacing Text with Replace
      6. 3.6. Creating Tables
        1. 3.6.1. Inserting a Table
          1. 3.6.1.1. Inserting a Table Using the New Panel on the Ribbon
          2. 3.6.1.2. Inserting a Table Using the Insert Table Dialog Box
        2. 3.6.2. Drawing a Table
        3. 3.6.3. Merging and Splitting Cells in a Table
        4. 3.6.4. Adding Content to a Table
        5. 3.6.5. Formatting a Table
      7. 3.7. Creating Hyperlinks
      8. 3.8. Summary
    4. 4. Using Pictures and Shapes in Your Documents
      1. 4.1. Understanding How You Position Graphical Objects
      2. 4.2. Choosing Where to Insert a Graphical Object
      3. 4.3. Inserting Clip Art
        1. 4.3.1. Inserting a Clip Art Picture Using the Clip Art Browser
        2. 4.3.2. Inserting a Clip Art Picture Using the Clip Gallery
        3. 4.3.3. Managing Your Clip Art Items with the Clip Gallery
          1. 4.3.3.1. Adding Your Own Pictures to the Clip Gallery
          2. 4.3.3.2. Downloading Clip Art Items from the Microsoft Office Web site
          3. 4.3.3.3. Organizing the Clip Gallery with Categories
      4. 4.4. Inserting Pictures in Your Documents
        1. 4.4.1. Inserting Pictures from iPhoto
        2. 4.4.2. Inserting Pictures from Your Mac's File System
      5. 4.5. Adding and Formatting a Shape
        1. 4.5.1. Applying a Style to a Shape
      6. 4.6. Rotating a Graphical Object
      7. 4.7. Positioning a Graphical Object
      8. 4.8. Choosing Text Wrapping in Word
      9. 4.9. Making a Picture Look the Way You Want It
        1. 4.9.1. Adjusting a Picture's Sharpness, Brightness, Contrast, and Colors
        2. 4.9.2. Applying a Picture Style
        3. 4.9.3. Cropping a Picture
        4. 4.9.4. Saving Space by Compressing Pictures
      10. 4.10. Inserting SmartArt
      11. 4.11. Arranging Graphical Objects to Control Which Is Visible
        1. 4.11.1. Arranging Graphical Objects Using the Arrange Submenu
        2. 4.11.2. Rearranging Graphical Objects with Dynamic Reordering
      12. 4.12. Summary
    5. 5. Customizing Office to Suit You
      1. 5.1. Choosing Which Toolbars to Display and How to Display Them
        1. 5.1.1. Choosing Which Toolbars to Display
        2. 5.1.2. Switching the Standard Toolbar Between Icons and Text and Icons Only
        3. 5.1.3. Undocking and Docking the Formatting Toolbar
      2. 5.2. Customizing the Toolbars and Menus in Word, Excel, and PowerPoint
        1. 5.2.1. Preparing to Customize the Toolbars, Menu Bars, or Menus
        2. 5.2.2. Finding the Commands to Add to the Toolbars or Menus
        3. 5.2.3. Customizing a Toolbar
          1. 5.2.3.1. Adding an Item to a Toolbar
          2. 5.2.3.2. Removing an Item from a Toolbar
          3. 5.2.3.3. Repositioning Items on a Toolbar
          4. 5.2.3.4. Changing How a Toolbar Button or Menu Item Appears
          5. 5.2.3.5. Adding a Built-in Menu to a Toolbar
        4. 5.2.4. Customizing a Menu
          1. 5.2.4.1. Adding an Item to a Menu
          2. 5.2.4.2. Moving a Menu Item
          3. 5.2.4.3. Renaming a Menu Item
          4. 5.2.4.4. Removing an Item from a Menu
        5. 5.2.5. Customizing the Menu Bar
          1. 5.2.5.1. Creating a New Menu
          2. 5.2.5.2. Removing an Existing Menu
          3. 5.2.5.3. Changing the Order of the Menus
        6. 5.2.6. Customizing the Context Menus in PowerPoint
        7. 5.2.7. Creating Custom Toolbars Containing the Commands You Need
        8. 5.2.8. Resetting a Toolbar to Its Default Buttons
      3. 5.3. Customizing the Ribbon in Word, Excel, and PowerPoint
        1. 5.3.1. Opening the Ribbon Preferences Pane
        2. 5.3.2. Choosing General Options for the Ribbon
        3. 5.3.3. Choosing Which Tabs and Groups to Display
        4. 5.3.4. Closing the Ribbon Preferences Pane
      4. 5.4. Customizing the Toolbar in Outlook
        1. 5.4.1. Changing How the Buttons Appear
        2. 5.4.2. Changing Which Buttons Appear on the Toolbar
      5. 5.5. Creating Custom Keyboard Shortcuts in Word and Excel
      6. 5.6. Choosing Essential Preferences in Word, Excel, and PowerPoint
        1. 5.6.1. Opening the Preferences Dialog Box or Preferences Window
        2. 5.6.2. Setting Your User Name, Initials, and Address
        3. 5.6.3. Choosing Whether to Display the Gallery Dialog Box When the Application Opens
        4. 5.6.4. Choosing Whether to Receive Feedback with Sound
        5. 5.6.5. Choosing Whether to Confirm Launching Other Applications
        6. 5.6.6. Changing the Number of Recent Documents the Application Tracks
        7. 5.6.7. Choosing the Default Format for Saving Documents
          1. 5.6.7.1. Setting the Default Document Format in Word
          2. 5.6.7.2. Setting the Default Workbook Format in Excel
          3. 5.6.7.3. Setting the Default Presentation Format in PowerPoint
        8. 5.6.8. Setting AutoRecover to Keep Backups of Your Documents for Safety
        9. 5.6.9. Setting the Default Folders for Saving Your Documents and Presentations
          1. 5.6.9.1. Setting the Default Folder for Saving Word Documents
          2. 5.6.9.2. Setting the Default Folder for Saving PowerPoint Presentations
      7. 5.7. Summary
  7. II. Creating Documents with Microsoft Word
    1. 6. Entering Text and Using Views
      1. 6.1. Entering Text in Your Word Documents
        1. 6.1.1. Inserting the Text from a File in a Document
        2. 6.1.2. Inserting Prebuilt Blocks of Text with AutoText
      2. 6.2. Selecting Text in Word-Specific Ways
        1. 6.2.1. Selecting Text with the Mouse
        2. 6.2.2. Selecting Text with the Extend Selection Feature
        3. 6.2.3. Selecting Multiple Items at Once
      3. 6.3. Moving with Keyboard Shortcuts and the Browse Object
      4. 6.4. Telling Word Where to Find Your Templates
      5. 6.5. Creating Backup Documents and Recovering from Disaster
      6. 6.6. Using Views and Windows to See What You Need
        1. 6.6.1. Picking the Right View for What You're Doing
          1. 6.6.1.1. Using Print Layout View to See How a Document Will Look When Printed
          2. 6.6.1.2. Using Full Screen View to See More of a Document
          3. 6.6.1.3. Using Web Layout View to Get a Preview of Web Pages
          4. 6.6.1.4. Developing a Document in Outline View
          5. 6.6.1.5. Using Draft View
          6. 6.6.1.6. Taking Notes in Notebook Layout View
          7. 6.6.1.7. Laying Out a Document in Publishing Layout View
        2. 6.6.2. Opening Extra Windows
        3. 6.6.3. Splitting the Document Window into Two Panes
      7. 6.7. Summary
    2. 7. Adding Style: Formatting Your Documents
      1. 7.1. Understanding Word's Many Types of Formatting
        1. 7.1.1. Understanding Direct Formatting and When to Use It
        2. 7.1.2. Understanding Styles and When to Use Them
      2. 7.2. Formatting Your Documents the Best Way
      3. 7.3. Applying Styles to a Document
        1. 7.3.1. Applying Styles from the Quick Styles Box on the Ribbon
        2. 7.3.2. Applying Styles with the Styles Pop-Up Menu on the Formatting Toolbar
        3. 7.3.3. Applying Styles with the Styles Pane
        4. 7.3.4. Applying Styles Using the Style Dialog Box
        5. 7.3.5. Applying Different Quick Styles to a Document
        6. 7.3.6. Changing the Styles in the Quick Style Gallery
        7. 7.3.7. Applying Styles Using the Keyboard
        8. 7.3.8. See Which Styles a Document Uses
      4. 7.4. Creating Custom Styles
        1. 7.4.1. Creating a Custom Style by Example
          1. 7.4.1.1. Choosing the Font Formatting for a Style
          2. 7.4.1.2. Choosing the Paragraph Formatting for the Style
          3. 7.4.1.3. Adding Bullets or Numbering to the Style
          4. 7.4.1.4. Adding Borders and Shading to the Style
          5. 7.4.1.5. Adding Language Formatting to the Style
          6. 7.4.1.6. Creating the Style
        2. 7.4.2. Modifying an Existing Style
          1. 7.4.2.1. Changing a Style Using the Modify Style Dialog Box
          2. 7.4.2.2. Updating a Style with New Formatting
      5. 7.5. Applying Direct Formatting on Top of Styles
        1. 7.5.1. Copying and Pasting Formatting Using the Format Painter
      6. 7.6. Navigating Quickly Around Your Documents
        1. 7.6.1. Using the Sidebar
        2. 7.6.2. Using Find and Replace
          1. 7.6.2.1. Highlighting All Instances of a Search Term
          2. 7.6.2.2. Searching Only Part of the Document
          3. 7.6.2.3. Changing the Search Direction
          4. 7.6.2.4. Finding Search Terms That Match the Case You Type
          5. 7.6.2.5. Restricting the Search to Whole Words
          6. 7.6.2.6. Using Wildcards to Find Variable Text
          7. 7.6.2.7. Finding Words That Sound Like Other Words
          8. 7.6.2.8. Finding All Forms of a Word
          9. 7.6.2.9. Searching for Special Characters
          10. 7.6.2.10. Searching Only at the Start or End of a Word
          11. 7.6.2.11. Finding Formatting
        3. 7.6.3. Replacing Text, Formatting, and Styles
          1. 7.6.3.1. Replacing Text
          2. 7.6.3.2. Replacing Formatting or Styles
        4. 7.6.4. Navigating with Go To
      7. 7.7. Summary
    3. 8. Creating Complex Documents and Layouts
      1. 8.1. Working with Word's Extra Table Features
        1. 8.1.1. Converting Existing Text into a Table
        2. 8.1.2. Converting a Table to Text
        3. 8.1.3. Nesting One Table Inside Another Table
      2. 8.2. Creating Complex Documents with Multiple Sections
      3. 8.3. Adding Headers, Footers, and Page Numbers
        1. 8.3.1. Adding Headers and Footers to a Document
          1. 8.3.1.1. Creating Different Headers and Footers for Different Pages
          2. 8.3.1.2. Using Different Headers and Footers in Different Sections of a Document
          3. 8.3.1.3. Delete a Header or Footer
        2. 8.3.2. Inserting Page Numbers in a Document
      4. 8.4. Creating Newspaper-Style Columns of Text
        1. 8.4.1. Breaking Your Columns with Column Breaks
        2. 8.4.2. Removing Multiple Columns from a Section or Document
      5. 8.5. Using Bookmarks, Fields, and References
        1. 8.5.1. Marking Important Parts of a Document with Bookmarks
          1. 8.5.1.1. Insert a Bookmark to Mark Part of a Document
          2. 8.5.1.2. Navigating from Bookmark to Bookmark
          3. 8.5.1.3. Seeing Where Bookmarks Are in Your Documents
          4. 8.5.1.4. Deleting a Bookmark You No Longer Need
        2. 8.5.2. Inserting Automated Information with Fields
          1. 8.5.2.1. Inserting a Field
          2. 8.5.2.2. Examining and Updating a Field
        3. 8.5.3. Adding Cross-References to Other Parts of a Document
      6. 8.6. Creating Long Documents with Outline View
        1. 8.6.1. How Outlines Work
        2. 8.6.2. Developing the Outline of a Document
          1. 8.6.2.1. Switching to Outline View
          2. 8.6.2.2. Creating Headings in Outline View
        3. 8.6.3. Promoting and Demoting Headings
        4. 8.6.4. Expanding and Collapsing the Outline and Headings
        5. 8.6.5. Moving Paragraphs Up and Down the Document
        6. 8.6.6. Switching from Outline View to Another View
      7. 8.7. Adding Footnotes and Endnotes
        1. 8.7.1. Adding a Footnote
        2. 8.7.2. Adding an Endnote
        3. 8.7.3. Customizing Footnotes and Endnotes to Suit Your Document
        4. 8.7.4. Converting Footnotes to Endnotes or Endnotes to Footnotes
        5. 8.7.5. Navigating Among and Viewing Footnotes or Endnotes
      8. 8.8. Summary
    4. 9. Creating Business Documents with Mail Merge
      1. 9.1. Understanding How Mail Merge Works
      2. 9.2. Creating the Main Document for the Mail Merge
      3. 9.3. Selecting the Recipients for the Mail Merge
        1. 9.3.1. Creating a New Data Source in Word
        2. 9.3.2. Opening an Existing Data Source
        3. 9.3.3. Using Contacts from the Office Address Book
        4. 9.3.4. Using Contacts from the Mac OS X Address Book
        5. 9.3.5. Using Data from a FileMaker Pro Database
      4. 9.4. Inserting Placeholders in Your Main Document
      5. 9.5. Filtering the Recipients of the Merge Document
      6. 9.6. Previewing the Results of the Mail Merge
      7. 9.7. Completing the Mail Merge
        1. 9.7.1. Merging Individual Documents to a Printer
        2. 9.7.2. Merging to a New Document
        3. 9.7.3. Merging to E-mail Messages
      8. 9.8. Restoring a Mail Merge Main Document to a Normal Document
      9. 9.9. Summary
    5. 10. Revising and Reviewing Documents
      1. 10.1. Understanding How You Can Work on Documents with Your Colleagues
      2. 10.2. Editing a Document Simultaneously with Your Colleagues
      3. 10.3. Sharing Documents with Your Colleagues on a Network
      4. 10.4. Tracking the Changes in a Document
        1. 10.4.1. Choosing Which Changes to Track
        2. 10.4.2. Turning On Track Changes for a Document
        3. 10.4.3. Ensuring Your Colleagues Use the Track Changes Feature
        4. 10.4.4. Working in a Document with Track Changes On
        5. 10.4.5. Choosing How to View the Document's Changes and Markup
        6. 10.4.6. Controlling Which Changes Word Displays
        7. 10.4.7. Integrating Tracked Changes into a Document
        8. 10.4.8. Using Track Changes in Full Screen View
      5. 10.5. Adding Comments to a Document
        1. 10.5.1. Adding a Comment
        2. 10.5.2. Viewing and Reviewing Comments
        3. 10.5.3. Deleting Comments
      6. 10.6. Comparing or Combining Different Versions of the Same Document
      7. 10.7. Summary
    6. 11. Printing, Securing, and Sharing Documents
      1. 11.1. Using Word's Features for Printing Documents
        1. 11.1.1. Printing a Custom Range of Pages
        2. 11.1.2. Printing Markup and Other Items
          1. 11.1.2.1. Choosing Whether to Print Markup—or Only Markup
          2. 11.1.2.2. Printing Document Properties, Styles, AutoText Entries, and Key Assignments
      2. 11.2. Securing a Document
        1. 11.2.1. Removing Sensitive Information from a Document
        2. 11.2.2. Protecting a Document with a Password
        3. 11.2.3. Marking a Document As Read-Only
      3. 11.3. Making a Document You Can Open with Earlier Versions of Word
      4. 11.4. Creating PDF Documents for Digital Distribution
      5. 11.5. Summary
  8. III. Analyzing Data with Microsoft Excel
    1. 12. Creating Workbooks and Entering Data
      1. 12.1. Creating and Saving a New Workbook
        1. 12.1.1. Creating a New Workbook
        2. 12.1.2. Saving a Workbook
      2. 12.2. Navigating the Excel Interface, Worksheets, and Workbooks
        1. 12.2.1. Understanding Workbooks, Worksheets, Columns, and Rows
      3. 12.3. Moving the Active Cell
        1. 12.3.1. Selecting and Manipulating Cells
      4. 12.4. Enter Data in Your Worksheets
        1. 12.4.1. Typing Data in a Cell
        2. 12.4.2. Editing a Cell
        3. 12.4.3. Entering Data Quickly Using AutoFill
        4. 12.4.4. Using AutoFill's Built-in Capabilities
          1. 12.4.4.1. Creating Your Own Custom AutoFill Lists
        5. 12.4.5. Pasting Data into a Worksheet
          1. 12.4.5.1. Using Paste and Paste Options
          2. 12.4.5.2. Controlling Pasted Data with the Paste Special Command
        6. 12.4.6. Copying and Moving Data with Drag and Drop
      5. 12.5. inserting, deleting, and rearranging worksheets
        1. 12.5.1. Inserting and Deleting Worksheets
        2. 12.5.2. Rearranging the Worksheets in a Workbook
      6. 12.6. Making Excel Display Worksheets the Way You Need
        1. 12.6.1. Understanding Excel's Views
        2. 12.6.2. Splitting the Window to View Separate Parts of a Worksheet
        3. 12.6.3. Opening Extra Windows to Show Other Parts of a Workbook
        4. 12.6.4. Changing the Window and Arranging Open Windows
        5. 12.6.5. Zooming to Show the Data You Need to See
        6. 12.6.6. Freezing Rows and Columns So That They Stay On-Screen
      7. 12.7. Summary
    2. 13. Formatting Your Worksheets
      1. 13.1. Working with Rows and Columns
        1. 13.1.1. Inserting and Deleting Rows, Columns, and Cells
        2. 13.1.2. Setting Row Height
        3. 13.1.3. Setting Column Width
        4. 13.1.4. Hiding Rows and Columns
      2. 13.2. Formatting Cells and Ranges
        1. 13.2.1. Understanding the Three Main Tools for Applying Formatting
        2. 13.2.2. Controlling How Data Appears by Applying Number Formatting
        3. 13.2.3. Setting the Workbook's Overall Look by Applying a Theme
        4. 13.2.4. Setting Alignment
        5. 13.2.5. Choosing Font Formatting
        6. 13.2.6. Applying Borders and Fills
        7. 13.2.7. Applying Protection to Cells
      3. 13.3. Applying Conditional Formatting to Identify Particular Values
        1. 13.3.1. Understanding Excel's Preset Types of Conditional Formatting
        2. 13.3.2. Applying a Preset Form of Conditional Formatting
      4. 13.4. Using Data Validation to Check for Invalid Entries
      5. 13.5. Formatting Quickly with Table Formatting and Styles
        1. 13.5.1. Formatting with Table Formatting
        2. 13.5.2. Formatting with Styles
          1. 13.5.2.1. Meeting Excel's Styles
          2. 13.5.2.2. Applying a Style
          3. 13.5.2.3. Creating Custom Styles
          4. 13.5.2.4. Copying Styles from One Workbook to Another
          5. 13.5.2.5. Deleting Styles You Don't Need
      6. 13.6. Adding Headers and Footers to Your Worksheets
        1. 13.6.1. Adding Headers and Footers Using the Page Setup Dialog Box
        2. 13.6.2. Adding Headers and Footers Directly on the Worksheet
      7. 13.7. Printing Your Excel Worksheets and Workbooks
        1. 13.7.1. Telling Excel Which Part of the Worksheet to Print
        2. 13.7.2. Checking the Page Layout and Where the Page Breaks Fall
        3. 13.7.3. Printing a Worksheet or Workbook
      8. 13.8. Sharing Your Workbooks with Your Colleagues
        1. 13.8.1. Protecting a Workbook or Some of Its Worksheets
          1. 13.8.1.1. Protecting a Workbook
          2. 13.8.1.2. Protecting a Worksheet
        2. 13.8.2. Sharing a Workbook So That Your Colleagues Can Edit It
        3. 13.8.3. Working in a Shared Workbook
        4. 13.8.4. Resolving Conflicts in a Shared Workbook
      9. 13.9. Summary
    3. 14. Creating Powerful and Persuasive Charts
      1. 14.1. Learning the Essentials of Charts in Excel
        1. 14.1.1. Understanding Embedded Charts and Chart Sheets
        2. 14.1.2. Understanding the Components of a Chart
          1. 14.1.2.1. Chart Area and Plot Area
          2. 14.1.2.2. Chart Axes
          3. 14.1.2.3. Categories and Data Series
          4. 14.1.2.4. Chart Title and Axis Titles
          5. 14.1.2.5. Data Markers, Gridlines, and Data Labels
        3. 14.1.3. Understanding Excel's Chart Types and Choosing Which to Use
      2. 14.2. Creating, Laying Out, and Formatting a Chart
        1. 14.2.1. Creating a Chart
        2. 14.2.2. Changing a Chart from an Embedded Chart to a Chart Sheet
        3. 14.2.3. Changing the Chart Type
        4. 14.2.4. Switching the Rows and Columns in a Chart
        5. 14.2.5. Changing the Source Data for a Chart
        6. 14.2.6. Choosing the Layout for the Chart
        7. 14.2.7. Adding a Separate Data Series to a Chart
        8. 14.2.8. Applying a Style to a Chart
        9. 14.2.9. Adding a Title to a Chart
        10. 14.2.10. Adding Axis Titles to the Chart
        11. 14.2.11. Changing the Scale or Numbering of an Axis
        12. 14.2.12. Adding a Legend to a Chart
        13. 14.2.13. Adding Axis Labels from a Range Separate from the Chart Data
        14. 14.2.14. Adding Data Labels to the Chart
        15. 14.2.15. Choosing Which Gridlines to Display
        16. 14.2.16. Formatting a Chart Wall and Chart Floor
        17. 14.2.17. Formatting Individual Chart Elements
      3. 14.3. Copying Chart Formatting
      4. 14.4. Reusing Your Own Designs by Creating Custom Chart Types
      5. 14.5. Adding Sparklines to Your Worksheets
        1. 14.5.1. Inserting Sparklines
        2. 14.5.2. Formatting Your Sparklines
      6. 14.6. Summary
    4. 15. Crunching Numbers with Formulas and Functions
      1. 15.1. Understanding the Difference Between Formulas and Functions
      2. 15.2. Referring to Cells and Ranges in Formulas and Functions
        1. 15.2.1. Referring to a Cell
        2. 15.2.2. Referring to Ranges
        3. 15.2.3. Referring to Named Cells and Ranges
      3. 15.3. Performing Custom Calculations by Creating Formulas
        1. 15.3.1. Meeting Excel's Calculation Operators
        2. 15.3.2. Using the Calculation Operators
        3. 15.3.3. Understanding the Order in Which Excel Evaluates Operators
        4. 15.3.4. Nesting Parts of Formulas to Control Operator Precedence
        5. 15.3.5. Entering Formulas Quickly by Copying and Using AutoFill
        6. 15.3.6. Troubleshooting Common Problems with Formulas
          1. 15.3.6.1. Understanding Common Errors—and Resolving Them
          2. 15.3.6.2. Seeing the Details of an Error in a Formula
          3. 15.3.6.3. Tracing an Error Back to Its Source
          4. 15.3.6.4. Displaying All the Formulas in a Worksheet
          5. 15.3.6.5. Seeing Which Cells a Formula Uses
          6. 15.3.6.6. Removing Circular References
      4. 15.4. Performing Standard Calculations by Inserting Functions
        1. 15.4.1. Understanding Function Names and Arguments
        2. 15.4.2. Inserting Functions with the AutoSum Pop-up Menu
        3. 15.4.3. Inserting Functions with the Formula Builder
        4. 15.4.4. Inserting Functions with the Insert Pop-up Menu
        5. 15.4.5. Inserting Functions by Typing Them into a Worksheet
      5. 15.5. Summary
    5. 16. Creating Simple Databases and Solving Business Problems
      1. 16.1. Creating Databases in Excel
        1. 16.1.1. Understanding What You Can and Can't Do with Excel Database Tables
        2. 16.1.2. Creating a Database Table and Returning Data
          1. 16.1.2.1. Creating a Database Table
          2. 16.1.2.2. Customizing the Database Table's Looks
          3. 16.1.2.3. Entering Data in a Database Table
            1. 16.1.2.3.1. Entering Data Directly in the Database Table
            2. 16.1.2.3.2. Entering Data Using a Data-Entry Form
        3. 16.1.3. Resizing a Database Table
        4. 16.1.4. Sorting a Database Table by One or More Fields
          1. 16.1.4.1. Sorting Quickly by a Single Field
          2. 16.1.4.2. Sorting a Database Table by Multiple Fields
        5. 16.1.5. Identifying and Removing Duplicate Records in a Database Table
        6. 16.1.6. Filtering a Database Table
      2. 16.2. Solving Business Problems with Scenarios and Goal Seek
        1. 16.2.1. Examining Different Scenarios in a Worksheet
          1. 16.2.1.1. Creating the Worksheet for Your Scenarios
          2. 16.2.1.2. Opening the Scenario Manager Dialog Box
          3. 16.2.1.3. Creating Scenarios
          4. 16.2.1.4. Applying Protection to Your Scenarios
          5. 16.2.1.5. Editing and Deleting Scenarios
          6. 16.2.1.6. Switching Among Your Scenarios
          7. 16.2.1.7. Merging Scenarios into a Single Worksheet
          8. 16.2.1.8. Creating Reports from Your Scenarios
        2. 16.2.2. Using Goal Seek
      3. 16.3. Summary
    6. 17. Manipulating Data with PivotTables
      1. 17.1. Understanding What PivotTables Are and What You Can Do with Them
      2. 17.2. Creating and Laying Out a PivotTable
        1. 17.2.1. Creating a PivotTable Automatically
        2. 17.2.2. Creating a PivotTable Manually
          1. 17.2.2.1. Understanding How the PivotTable Framework and PivotTable Builder Window Work
          2. 17.2.2.2. Adding the Fields to the PivotTable Framework
        3. 17.2.3. Changing the PivotTable to Show Different Data
        4. 17.2.4. Changing the Function Used to Summarize a Field
      3. 17.3. Controlling the Design of a PivotTable
      4. 17.4. Formatting a PivotTable
        1. 17.4.1. Applying a PivotTable Style
        2. 17.4.2. Choosing Options for a PivotTable Style
      5. 17.5. Naming a PivotTable and Setting Options for It
        1. 17.5.1. Renaming a PivotTable
        2. 17.5.2. Choosing Display Options for a PivotTable
        3. 17.5.3. Choosing Layout Options for a PivotTable
        4. 17.5.4. Choosing Data Options for a PivotTable
        5. 17.5.5. Refreshing the Data in a PivotTable
        6. 17.5.6. Changing the Source of a PivotTable
      6. 17.6. Sorting and Filtering a PivotTable
      7. 17.7. Summary
  9. IV. Creating Presentations with Microsoft PowerPoint
    1. 18. Starting to Build a Presentation in PowerPoint
      1. 18.1. Creating a Presentation
      2. 18.2. Changing a Presentation's Theme, Fonts, or Colors
      3. 18.3. Changing the Slide Size or Orientation
      4. 18.4. Navigating the PowerPoint Window
      5. 18.5. Add Content to a Slide
      6. 18.6. Adding, Deleting, and Rearranging Slides
        1. 18.6.1. Adding a Slide
        2. 18.6.2. Deleting a Slide
        3. 18.6.3. Rearranging Slides
      7. 18.7. Using Views to Work on Your Presentation
        1. 18.7.1. Creating Your Slides in Normal View
        2. 18.7.2. Rearranging Your Slides in Slide Sorter View
        3. 18.7.3. Creating Notes Pages in Notes Page View
        4. 18.7.4. Running a Presentation in Slide Show View
        5. 18.7.5. Opening Extra Windows to See Different Parts of the Presentation
      8. 18.8. Creating the Outline of a Presentation
      9. 18.9. Organizing Your Slides into Sections
      10. 18.10. Collaborating on a Presentation with Your Colleagues
        1. 18.10.1. Editing a Presentation Simultaneously with Your Colleagues
        2. 18.10.2. Comparing Two Copies of the Same Presentation
      11. 18.11. Summary
    2. 19. Creating Clear and Compelling Slides
      1. 19.1. Planning the Slides in Your Presentation
      2. 19.2. Choosing Slide Layouts to Suit the Contents
        1. 19.2.1. Using PowerPoint's Built-in Slide Layouts
        2. 19.2.2. Creating Custom Slide Layouts
      3. 19.3. Formatting Text on Your Slides
        1. 19.3.1. Changing the Font, Font Size, and Alignment
        2. 19.3.2. Changing the Indentation and Line Spacing of Text
        3. 19.3.3. Rotating Text
        4. 19.3.4. Using Bulleted Lists
          1. 19.3.4.1. Creating a Bulleted List
          2. 19.3.4.2. Making Sure Your Bulleted Lists Are Readable
          3. 19.3.4.3. Livening Up Your Slides with Custom Bullets
      4. 19.4. Adding Tables, SmartArt, Charts, and Hyperlinks to Slides
        1. 19.4.1. Adding Tables to Slides
          1. 19.4.1.1. Creating a Table from Scratch
          2. 19.4.1.2. Importing a Table from Word
          3. 19.4.1.3. Creating a Table from Excel Worksheet Data
        2. 19.4.2. Adding SmartArt Graphics to Slides
        3. 19.4.3. Adding Charts to Slides
          1. 19.4.3.1. Creating a Chart in a New Embedded Workbook
          2. 19.4.3.2. Pasting a Chart from Excel into a PowerPoint Slide
        4. 19.4.4. Adding Hyperlinks to Slides
      5. 19.5. Summary
    3. 20. Adding Life and Interest to a Presentation
      1. 20.1. Adding Pictures to a Presentation
      2. 20.2. Adding Movies and Sounds to a Presentation
        1. 20.2.1. Adding a Movie to a Slide
          1. 20.2.1.1. Adding a Movie from the Movie Browser
          2. 20.2.1.2. Adding a Movie from a File
          3. 20.2.1.3. Making the Movie Look and Play the Way You Want
        2. 20.2.2. Adding a Sound to a Slide
          1. 20.2.2.1. Adding a Sound from the Audio Browser Pane
          2. 20.2.2.2. Adding a Sound from a File
          3. 20.2.2.3. Recording Audio into a Slide
          4. 20.2.2.4. Positioning the Sound and Setting Its Volume
      3. 20.3. Adding Transitions to Slides
      4. 20.4. Adding Animations to Slides
        1. 20.4.1. Understanding the Essentials of Animations
        2. 20.4.2. Adding an Animation to an Object
        3. 20.4.3. Changing the Order of Animations
        4. 20.4.4. Using Animation to Display Bulleted Paragraphs One at a Time
        5. 20.4.5. Animating SmartArt Graphics, Charts, and Tables
          1. 20.4.5.1. Animating a SmartArt Graphic
          2. 20.4.5.2. Animating a Chart
          3. 20.4.5.3. Animating a Table
      5. 20.5. Keeping Extra Information Up Your Sleeve with Hidden Slides
      6. 20.6. Creating Custom Slide Shows Within a Presentation
        1. 20.6.1. Opening the Custom Shows Dialog Box
        2. 20.6.2. Creating a Custom Slide Show
        3. 20.6.3. Playing a Custom Slide Show
        4. 20.6.4. Editing or Deleting a Custom Slide Show
      7. 20.7. Summary
    4. 21. Delivering a Presentation Live or Online
      1. 21.1. Getting Ready to Deliver a Presentation in Person
        1. 21.1.1. Setting Up Your Display and Choosing the Resolution
        2. 21.1.2. Using Presenter View
        3. 21.1.3. Practicing Your Presentation
        4. 21.1.4. Rehearsing Timings for Slides
      2. 21.2. Delivering a Presentation to a Live Audience
        1. 21.2.1. Starting a Presentation
        2. 21.2.2. Displaying the Slides You Need
        3. 21.2.3. Annotating the Slides
        4. 21.2.4. Controlling a Presentation Using the Keyboard
        5. 21.2.5. Displaying a White Screen or Black Screen
      3. 21.3. Creating a Handout for a Presentation
      4. 21.4. Recording Narration into a Presentation
      5. 21.5. Exporting and Sharing a Presentation
        1. 21.5.1. Broadcasting a Slide Show
        2. 21.5.2. Saving a Presentation as Pictures
        3. 21.5.3. Saving a Presentation as a Movie
      6. 21.6. Summary
  10. V. E-mailing and Organizing with Outlook
    1. 22. Using E-mail Effectively
      1. 22.1. Setting Up Outlook
        1. 22.1.1. Launching Outlook
        2. 22.1.2. Adding an E-mail Account to Outlook
          1. 22.1.2.1. Adding an IMAP or POP E-mail Account to Outlook
          2. 22.1.2.2. Adding a Microsoft Exchange Account to Outlook
        3. 22.1.3. Importing an Existing E-mail Account
      2. 22.2. Meeting the Outlook Interface
        1. 22.2.1. Using the Toolbar, Ribbon, and Menu Bar
        2. 22.2.2. Using and Customizing the Navigation Pane
        3. 22.2.3. Using and Customizing the Message List and Reading Pane
          1. 22.2.3.1. Arranging and Sorting the Message List
          2. 22.2.3.2. Changing the Sort Order
          3. 22.2.3.3. Choosing Whether to Group Items
          4. 22.2.3.4. Viewing Conversations
        4. 22.2.4. Using and Customizing the Reading Pane
      3. 22.3. Sending and Receiving Messages
        1. 22.3.1. Sending an E-mail Message
          1. 22.3.1.1. Creating a New Message
          2. 22.3.1.2. Choosing Which Account to Send the Message From
          3. 22.3.1.3. Addressing the Message
          4. 22.3.1.4. Adding the Subject Line and Message Contents
          5. 22.3.1.5. Choosing Options for a Message
          6. 22.3.1.6. Checking the Spelling in a Message
          7. 22.3.1.7. Sending the Message
        2. 22.3.2. Receiving and Reading Messages
      4. 22.4. Sending and Receiving Attachments
        1. 22.4.1. Sending a File As an Attachment
        2. 22.4.2. Receiving a File as an Attachment
      5. 22.5. Replying to and Forwarding Messages
      6. 22.6. Deleting, Storing, and Organizing Messages
        1. 22.6.1. Moving a Message to a Mail Folder
        2. 22.6.2. Creating a New Mail Folder
      7. 22.7. Adding Consistent Closings to Your Messages with Signatures
      8. 22.8. Dealing with Spam
        1. 22.8.1. Removing Nonspam Messages from the Junk E-mail Folder
        2. 22.8.2. Marking Spam Messages as Junk
        3. 22.8.3. Changing Your Junk E-mail Protection Settings
        4. 22.8.4. Creating a List of Safe Domains for E-mail
        5. 22.8.5. Removing Senders You've Blocked by Mistake
      9. 22.9. Summary
    2. 23. Keeping Your Contacts in Order
      1. 23.1. Creating Contacts
        1. 23.1.1. Creating a Contact from Scratch
        2. 23.1.2. Importing Contacts from Other Address Books
          1. 23.1.2.1. Importing Contacts from Address Book and MobileMe with Sync Services
          2. 23.1.2.2. Creating and Importing vCard Files from Address Book
          3. 23.1.2.3. Creating and Importing vCard Files from Yahoo! Address Book
          4. 23.1.2.4. Creating and Importing vCard Files from Google Contacts
          5. 23.1.2.5. Importing Contacts from Entourage
          6. 23.1.2.6. Importing Contacts from a CSV File
          7. 23.1.2.7. Importing Contacts from vCard Files
          8. 23.1.2.8. Importing Contacts from an Excel Worksheet
      2. 23.2. Working with Contacts
        1. 23.2.1. Viewing Your Contacts
        2. 23.2.2. Arranging Your Contacts
        3. 23.2.3. Searching for a Contact
        4. 23.2.4. Editing Contact Information
        5. 23.2.5. Communicating with Your Contacts
      3. 23.3. Summary
    3. 24. Managing Your Calendar
      1. 24.1. Meeting the Calendar Interface
        1. 24.1.1. Displaying the Dates You Want
        2. 24.1.2. Customizing the Calendar Settings
        3. 24.1.3. Understanding Appointments, Events, and Meetings
      2. 24.2. Creating Appointments and Events
        1. 24.2.1. Creating One-Shot Appointments
          1. 24.2.1.1. Creating a One-Shot Appointment Quickly
          2. 24.2.1.2. Creating a One-Shot Appointment or Event with Full Details
        2. 24.2.2. Creating Repeating Appointments
      3. 24.3. Scheduling Meetings
        1. 24.3.1. Setting Up a Meeting
        2. 24.3.2. Tracking the Status of Meeting Invitations You've Sent
        3. 24.3.3. Dealing with Invitations to Meetings
      4. 24.4. Summary
    4. 25. Working with Tasks and Notes
      1. 25.1. Creating Tasks
        1. 25.1.1. Meeting the Tasks Interface
        2. 25.1.2. Creating One-Shot Tasks
        3. 25.1.3. Creating Recurring Tasks
        4. 25.1.4. Viewing, Arranging, and Filtering the Task List
          1. 25.1.4.1. Choosing Which Columns to Display in the Task List
          2. 25.1.4.2. Rearranging the Columns
          3. 25.1.4.3. Filtering Tasks to Show the Ones You're Interested In
        5. 25.1.5. Viewing Your Tasks in the My Day Window
        6. 25.1.6. Managing Your Tasks
          1. 25.1.6.1. Editing an Existing Task
          2. 25.1.6.2. Marking a Task for Follow-Up
          3. 25.1.6.3. Marking a Finished Task as Complete
      2. 25.2. Taking Notes
        1. 25.2.1. Meeting the Notes Interface
        2. 25.2.2. Creating a Note
        3. 25.2.3. Editing and Using Your Notes
      3. 25.3. Summary