You are previewing Microsoft® Office 2010 Bible.
O'Reilly logo
Microsoft® Office 2010 Bible

Book Description

The best of the best from the bestselling authors ofExcel, Word, and PowerPoint Bibles!

Take your pick of applications from the Office 2010 suite and your choice of leading experts to show you how to use them. This Office 2010 Bible features the best-of-the-best content from the Excel 2010 Bible, by "Mr. Spreadsheet" John Walkenbach; the Word 2010 Bible by Microsoft MVP Herb Tyson; the PowerPoint 2010 Bible, by PowerPoint expert Faithe Wempen; and coverage of Access 2010 from Microsoft MVP Michael Alexander. If you want to quickly and effectively begin using Office 2010, start in the experts' corner with this must-have book.

  • Gives you the best-of-the-best content on Office 2010 from the leading experts, authors, and contributors to our Excel, Word, PowerPoint, and Access Bibles

  • Includes content from John Walkenbach, aka "Mr. Spreadsheet"; Word expert and Microsoft MVP Herb Tyson; PowerPoint expert Faithe Wempen; and Excel and Access expert and Microsoft MVP Michael Alexander

  • Takes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to conquer critical business tasks

  • Hones in with expert coverage of the topics within each application that you need to know most

  • Covers even more from Outlook and other key Office topics

Get the best of four books in one with this power-packed reference!

Table of Contents

  1. Copyright
  2. About the Authors
    1. About the Technical Editor
  3. Credits
  4. Acknowledgments
  5. Introduction
    1. Who Should Read This Book
    2. How This Book Is Organized
      1. Part I: Common Office Features
      2. Part II: Creating Documents with Word
      3. Part III: Making the Numbers Work with Excel
      4. Part IV: Persuading and Informing with PowerPoint
      5. Part V: Organizing Messages, Contacts, and Time with Outlook
      6. Part VI: Designing Publications with Publisher
      7. Part VII: Managing Information with Access and OneNote
      8. Part VIII: Sharing and Collaboration
      9. What Is on the Website
      10. Conventions and Features
    3. Where to Go from Here
  6. I. Common Office Features
    1. 1. Welcome to Microsoft Office 2010
      1. 1.1. Learning about Office Applications
        1. 1.1.1. Word
        2. 1.1.2. Excel
        3. 1.1.3. PowerPoint
        4. 1.1.4. Outlook
      2. 1.2. Taking Advantage of Other Office Applications
        1. 1.2.1. Publisher
        2. 1.2.2. Access
        3. 1.2.3. OneNote
      3. 1.3. Starting an Application
      4. 1.4. Closing an Application
      5. 1.5. Finding Files
      6. 1.6. Getting Help
        1. 1.6.1. Browsing Help Contents
        2. 1.6.2. Searching Office.com
      7. 1.7. Summary
    2. 2. Navigating in Office
      1. 2.1. Discoverability
      2. 2.2. The "Results-Oriented" User Interface
      3. 2.3. Ribbons and Things
        1. 2.3.1. Title Bar
        2. 2.3.2. The Tab Row
        3. 2.3.3. KeyTips
        4. 2.3.4. Ribbon
          1. 2.3.4.1. Groups, or Chunks
          2. 2.3.4.2. Contextual Tools
        5. 2.3.5. Quick Access Toolbar
        6. 2.3.6. Live Preview
        7. 2.3.7. Galleries
        8. 2.3.8. The MiniBar or Mini Toolbar
        9. 2.3.9. Shortcut or Contextual Menus
        10. 2.3.10. Enhanced ScreenTips
        11. 2.3.11. Dialog Boxes and Launchers
        12. 2.3.12. Task Panes
        13. 2.3.13. Status Bar
      4. 2.4. Go Backstage with File
      5. 2.5. Options
        1. 2.5.1. Truth in Advertising, or What's in a Name?
        2. 2.5.2. Advanced ... versus Not Advanced?
      6. 2.6. Working with Dialog Boxes
        1. 2.6.1. Navigating Dialog Boxes
        2. 2.6.2. Using Tabbed Dialog Boxes
      7. 2.7. Summary
    3. 3. Mastering Fundamental Operations
      1. 3.1. Working with Files
        1. 3.1.1. Understanding Office 2010 File Formats
        2. 3.1.2. Creating a New, Blank File
        3. 3.1.3. Creating a File with a Document Template
        4. 3.1.4. Saving and Naming a File
        5. 3.1.5. Opening a File
        6. 3.1.6. Closing a File
      2. 3.2. Printing a File
        1. 3.2.1. Performing a Basic Preview and Print
        2. 3.2.2. Understanding Page Design Settings
        3. 3.2.3. Choosing Print Settings and Printing
      3. 3.3. Working with Multiple Windows
        1. 3.3.1. Switching to Another File or Application Window
        2. 3.3.2. Arranging Windows
      4. 3.4. Moving and Copying Information
        1. 3.4.1. Understanding the Clipboard
        2. 3.4.2. Selecting Information
        3. 3.4.3. Copying
        4. 3.4.4. Cutting
        5. 3.4.5. Pasting
      5. 3.5. Finding and Replacing
      6. 3.6. Spell Checking
      7. 3.7. AutoCorrect, AutoFormat, and Actions
      8. 3.8. Styles and Live Preview
      9. 3.9. Summary
  7. II. Creating Documents with Word
    1. 4. Making a Document
      1. 4.1. Creating a Blank File
        1. 4.1.1. Typing Text
        2. 4.1.2. Using Word Wrap
        3. 4.1.3. Inserting versus Overtyping
        4. 4.1.4. Using Default Tabs
        5. 4.1.5. Making a New Paragraph
      2. 4.2. Creating a File from a Template
        1. 4.2.1. Understanding Templates
        2. 4.2.2. Creating the File from the Template
        3. 4.2.3. Working with Template Content
      3. 4.3. Saving and File Formats
        1. 4.3.1. Convert
        2. 4.3.2. Save & Send (Formerly Publish)
      4. 4.4. Compatibility with Previous Versions of Word
        1. 4.4.1. To .doc or Not to .doc
        2. 4.4.2. Persistent Save As
        3. 4.4.3. Microsoft Office Compatibility Pack
      5. 4.5. .docx versus .docm
        1. 4.5.1. Converting a .docx File into a .docm File
      6. 4.6. Understanding .docx
      7. 4.7. Navigation Tips and Tricks
        1. 4.7.1. Tricks with Clicks
          1. 4.7.1.1. Triple-Clicking
          2. 4.7.1.2. Ctrl+Clicking
          3. 4.7.1.3. Alt+Clicking
          4. 4.7.1.4. Alt+Dragging
          5. 4.7.1.5. Shift+Click
          6. 4.7.1.6. Multi-Selecting
        2. 4.7.2. Seldom Screen
          1. 4.7.2.1. Split Box
          2. 4.7.2.2. View Rulers
          3. 4.7.2.3. Select Browse Object
        3. 4.7.3. Keyboard
          1. 4.7.3.1. Other Built-In Keystrokes
          2. 4.7.3.2. Office 2003 Menu Keystrokes
          3. 4.7.3.3. Custom Keystrokes
      8. 4.8. Views
        1. 4.8.1. Draft View Is the New Normal View
        2. 4.8.2. Print Layout
        3. 4.8.3. Full Screen Reading
        4. 4.8.4. Web Layout
        5. 4.8.5. Outline (Master Document Tools)
      9. 4.9. Summary
    2. 5. Formatting 101: Font/Character Formatting
      1. 5.1. The Big Picture
      2. 5.2. Styles and Character/Font Formatting
        1. 5.2.1. Style versus Direct
      3. 5.3. Character Formatting
        1. 5.3.1. Formatting Techniques
          1. 5.3.1.1. Repeat Formatting (F4)
          2. 5.3.1.2. Copy Formatting
            1. 5.3.1.2.1. Format Painter
            2. 5.3.1.2.2. Keyboard Method
          3. 5.3.1.3. Clear Formatting
        2. 5.3.2. The Font Group
          1. 5.3.2.1. Typeface or Font
          2. 5.3.2.2. Font Size
            1. 5.3.2.2.1. Grow/Shrink Tools and Keyboard Shortcuts
          3. 5.3.2.3. Color
            1. 5.3.2.3.1. Text Color
            2. 5.3.2.3.2. Shading
            3. 5.3.2.3.3. Highlighting
          4. 5.3.2.4. Change Case
          5. 5.3.2.5. Language
        3. 5.3.3. The Font Dialog Box
          1. 5.3.3.1. OpenType Features
        4. 5.3.4. The Mini Toolbar
        5. 5.3.5. Character-Formatting Shortcut Keys
      4. 5.4. Summary
    3. 6. Paragraph Formatting
      1. 6.1. Styles and Paragraph Formatting
      2. 6.2. When to Use Styles
      3. 6.3. What Exactly Is a Paragraph, Anyway?
        1. 6.3.1. Paragraph-Formatting Attributes
        2. 6.3.2. Paragraph-Formatting Techniques
      4. 6.4. Structural Formatting
        1. 6.4.1. Indentation
          1. 6.4.1.1. Mirror Indents
        2. 6.4.2. Alignment
        3. 6.4.3. Tabs
          1. 6.4.3.1. Tabs versus Tables
      5. 6.5. Paragraph Decoration
        1. 6.5.1. Numbering/Bullets
          1. 6.5.1.1. Line Numbering
          2. 6.5.1.2. Additional Paragraph Controls
        2. 6.5.2. Shading
          1. 6.5.2.1. What's That Dot?
        3. 6.5.3. Borders and Boxes
      6. 6.6. Random Bonus Tip #1—Sort Paragraphs That Aren't in a Table
      7. 6.7. Random Bonus Tip #2—Move Paragraphs Easily
      8. 6.8. Summary
    4. 7. Styles
      1. 7.1. Styles Group
        1. 7.1.1. Using Styles
          1. 7.1.1.1. Apply Styles Task Pane
        2. 7.1.2. Creating and Modifying Styles
          1. 7.1.2.1. Style-by-Example
        3. 7.1.3. Quick Style Sets
          1. 7.1.3.1. Modifying and Creating Quick Style Sets
          2. 7.1.3.2. Changing Your Mind
      2. 7.2. Styles Task Pane
        1. 7.2.1. Manage Styles
          1. 7.2.1.1. Recommended Styles
          2. 7.2.1.2. Restricted Styles
        2. 7.2.2. Style Inspector
      3. 7.3. Summary
    5. 8. Page Setup and Sections
      1. 8.1. Page Setup Basics
        1. 8.1.1. Section Formatting
          1. 8.1.1.1. Section Breaks
          2. 8.1.1.2. Inserting Section Breaks
          3. 8.1.1.3. Automatic Section Breaks
        2. 8.1.2. Styles, Section Formatting, and Paragraph Formatting
          1. 8.1.2.1. Saving Section Formatting for Reuse
        3. 8.1.3. Page Setup Choices
          1. 8.1.3.1. Margins
          2. 8.1.3.2. Orientation
          3. 8.1.3.3. Size
          4. 8.1.3.4. Columns
        4. 8.1.4. Page Layout Settings
          1. 8.1.4.1. Fixing or Changing a Section Break
          2. 8.1.4.2. Vertical Page Alignment
      2. 8.2. Page Borders
      3. 8.3. The Header and Footer Layer
        1. 8.3.1. Document Sections
      4. 8.4. Header and Footer Navigation and Design
        1. 8.4.1. Editing the Header and Footer Areas
        2. 8.4.2. Header and Footer Styles
        3. 8.4.3. Section Surfing
        4. 8.4.4. Link to Previous
        5. 8.4.5. Different First Page
        6. 8.4.6. Different Odd & Even Pages
        7. 8.4.7. Show Document Text
        8. 8.4.8. Distance from Edge of Paper
      5. 8.5. Adding Header and Footer Material
        1. 8.5.1. Page Numbers
          1. 8.5.1.1. Insert Page Numbers
          2. 8.5.1.2. Where Do Page Margin Numbers Really Go?
          3. 8.5.1.3. Deleting Page Numbers
          4. 8.5.1.4. Formatting Page Numbers
      6. 8.6. Themes
        1. 8.6.1. What Are Themes?
        2. 8.6.2. Using Built-In Themes
      7. 8.7. Summary
    6. 9. Tables and Graphics
      1. 9.1. Quick Start
      2. 9.2. Table Basics
        1. 9.2.1. Inserting Tables from Scratch
          1. 9.2.1.1. AutoFit Behavior
        2. 9.2.2. Inserting Tables Based on Existing Data
          1. 9.2.2.1. Convert Text to Table Dialog Box
          2. 9.2.2.2. Convert Table to Text Dialog Box
        3. 9.2.3. Handling Tables
          1. 9.2.3.1. Selecting Tables, Rows, and Columns
          2. 9.2.3.2. Copying Table Matter
          3. 9.2.3.3. Moving and Copying Columns
          4. 9.2.3.4. Moving and Copying Rows
        4. 9.2.4. Table Properties
          1. 9.2.4.1. Preferred Width
          2. 9.2.4.2. Alignment
          3. 9.2.4.3. Text Wrapping
      3. 9.3. Table Layout and Design
        1. 9.3.1. Modifying Table Layout
          1. 9.3.1.1. Deleting Tables and Table Parts
          2. 9.3.1.2. Deleting Tables
          3. 9.3.1.3. Deleting Rows, Columns, and Cells
          4. 9.3.1.4. Inserting Rows, Columns, and Cells
          5. 9.3.1.5. Controlling How Tables Break
          6. 9.3.1.6. Merge
          7. 9.3.1.7. Splitting Cells, Rows, and Columns
          8. 9.3.1.8. Cell Size
          9. 9.3.1.9. Alignment
          10. 9.3.1.10. Text Direction
          11. 9.3.1.11. Cell Margins and Cell Spacing
          12. 9.3.1.12. Tables That Span Multiple Pages
          13. 9.3.1.13. Sorting Tables
        2. 9.3.2. Table Math
        3. 9.3.3. Modifying Table Design
          1. 9.3.3.1. Table Styles
            1. 9.3.3.1.1. Table Style Options
          2. 9.3.3.2. Shading
          3. 9.3.3.3. Borders and Table Drawing
            1. 9.3.3.3.1. Drawing Tables from Scratch
          4. 9.3.3.4. The Table Eraser
      4. 9.4. Inserting Pictures from Files
        1. 9.4.1. If Your Picture Format Isn't Supported
      5. 9.5. Pictures from the Clipboard and Internet
      6. 9.6. Manipulation 101
        1. 9.6.1. Wrapping
          1. 9.6.1.1. Setting Wrapping and Wrapping Defaults
        2. 9.6.2. Dragging and Nudging
        3. 9.6.3. Resizing and Cropping
          1. 9.6.3.1. Resizing
          2. 9.6.3.2. Cropping
          3. 9.6.3.3. Picture Styles
          4. 9.6.3.4. Picture Effects
        4. 9.6.4. Adjust
        5. 9.6.5. Arranging Pictures on the Page
      7. 9.7. Inserting Clip Art
      8. 9.8. SmartArt
        1. 9.8.1. Inserting SmartArt
          1. 9.8.1.1. Changing Layout
          2. 9.8.1.2. SmartArt Styles
          3. 9.8.1.3. SmartArt Formatting
      9. 9.9. Summary
    7. 10. Data Documents and Mail Merge
      1. 10.1. Understanding Data Sources
      2. 10.2. Choosing the Type of Data Document
        1. 10.2.1. Restoring a Word Document to Normal
      3. 10.3. Attaching a Data Source
        1. 10.3.1. Selecting Recipients
          1. 10.3.1.1. Editing Data
          2. 10.3.1.2. Sorting Records
          3. 10.3.1.3. Filtering Records
            1. 10.3.1.3.1. Understanding AND and OR
          4. 10.3.1.4. Duplicates
          5. 10.3.1.5. Find Recipient
          6. 10.3.1.6. Validate Addresses
      4. 10.4. Assembling a Data Document
        1. 10.4.1. Merge Fields
          1. 10.4.1.1. Address Block
          2. 10.4.1.2. Greeting Line
        2. 10.4.2. Rules
        3. 10.4.3. Match Fields
        4. 10.4.4. Preview Results
        5. 10.4.5. Find Recipient
        6. 10.4.6. Update Labels
        7. 10.4.7. Highlight Merge Fields
        8. 10.4.8. Auto Check for Errors
        9. 10.4.9. Finishing the Merge
          1. 10.4.9.1. Edit Individual Documents
          2. 10.4.9.2. Print Documents
          3. 10.4.9.3. Send E-mail Messages
      5. 10.5. Mail Merge Task Pane/Wizard
        1. 10.5.1. Step 1: Document Type
        2. 10.5.2. Step 2: Starting Document
        3. 10.5.3. Step 3: Select Recipients
        4. 10.5.4. Step 4: Write Your Letter
        5. 10.5.5. Step 5: Preview Your Letters
        6. 10.5.6. Step 6: Complete the Merge
      6. 10.6. Summary
    8. 11. Security, Tracking, and Comments
      1. 11.1. Protection Types
        1. 11.1.1. Restricting Permission (Information Rights Management)
          1. 11.1.1.1. Removing Access Restrictions
        2. 11.1.2. Digital Signatures
          1. 11.1.2.1. How to Digitally Sign a Word Document
          2. 11.1.2.2. Removing a Signature
        3. 11.1.3. Document Inspector (Removing Private/Personal Information)
          1. 11.1.3.1. What Is Invisible Content?
        4. 11.1.4. Formatting and Editing Restrictions
          1. 11.1.4.1. Limit Formatting to a Selection of Styles
          2. 11.1.4.2. No Changes (Read-Only)
          3. 11.1.4.3. Comments
          4. 11.1.4.4. Tracked Changes
          5. 11.1.4.5. Filling in Forms
        5. 11.1.5. Password to Open/Modify
          1. 11.1.5.1. Applying Passwords to Open and/or Modify a Word Document
      2. 11.2. Comments and Tracked Changes
        1. 11.2.1. Comments
          1. 11.2.1.1. Viewing Comments
          2. 11.2.1.2. Inserting, Editing, and Deleting Comments
        2. 11.2.2. Tracked Changes
          1. 11.2.2.1. Track Changes Options
          2. 11.2.2.2. Turn on Tracked Changes
        3. 11.2.3. Show Markup
        4. 11.2.4. Display for Review
        5. 11.2.5. Reviewing Pane
      3. 11.3. Reviewing Comments and Changes
        1. 11.3.1. Accepting and Rejecting Comments
        2. 11.3.2. Accepting and Rejecting Changes
      4. 11.4. Protecting Documents for Review
      5. 11.5. Summary
  8. III. Making the Numbers Work with Excel
    1. 12. Using Excel Worksheets and Workbooks
      1. 12.1. What Is Excel Good For?
      2. 12.2. What's New in Excel 2010?
      3. 12.3. Understanding Workbooks and Worksheets
      4. 12.4. Moving around a Worksheet
        1. 12.4.1. Navigating with Your Keyboard
        2. 12.4.2. Navigating with Your Mouse
      5. 12.5. Introducing Excel's Ribbon Tabs
        1. 12.5.1. Ribbon Tabs
        2. 12.5.2. Contextual Tabs
      6. 12.6. Creating Your First Excel Worksheet
        1. 12.6.1. Getting Started on Your Worksheet
        2. 12.6.2. Filling in the Month Names
        3. 12.6.3. Entering the Sales Data
        4. 12.6.4. Formatting the Numbers
        5. 12.6.5. Making Your Worksheet Look a Bit Fancier
        6. 12.6.6. Summing the Values
        7. 12.6.7. Creating a Chart
        8. 12.6.8. Printing Your Worksheet
        9. 12.6.9. Saving Your Workbook
      7. 12.7. Summary
    2. 13. Entering and Editing Worksheet Data
      1. 13.1. Exploring the Types of Data You Can Use
        1. 13.1.1. About Numeric Values
        2. 13.1.2. About Text Entries
        3. 13.1.3. About Formulas
      2. 13.2. Entering Text and Values into Your Worksheets
      3. 13.3. Entering Dates and Times into Your Worksheets
        1. 13.3.1. Entering Date Values
        2. 13.3.2. Entering Time Values
      4. 13.4. Modifying Cell Contents
        1. 13.4.1. Erasing the Contents of a Cell
        2. 13.4.2. Replacing the Contents of a Cell
        3. 13.4.3. Editing the Contents of a Cell
        4. 13.4.4. Learning Some Handy Data-Entry Techniques
          1. 13.4.4.1. Automatically Moving the Cell Pointer after Entering Data
          2. 13.4.4.2. Using Navigation Keys instead of Pressing Enter
          3. 13.4.4.3. Selecting a Range of Input Cells before Entering Data
          4. 13.4.4.4. Using Ctrl+Enter to Place Information into Multiple Cells Simultaneously
          5. 13.4.4.5. Entering Decimal Points Automatically
          6. 13.4.4.6. Using Auto Fill to Enter a Series of Values
          7. 13.4.4.7. Using AutoComplete to Automate Data Entry
          8. 13.4.4.8. Forcing Text to Appear on a New Line within a Cell
          9. 13.4.4.9. Using AutoCorrect for Shorthand Data Entry
          10. 13.4.4.10. Entering Numbers with Fractions
          11. 13.4.4.11. Simplifying Data Entry by Using a Form
          12. 13.4.4.12. Entering the Current Date or Time into a Cell
      5. 13.5. Applying Number Formatting
        1. 13.5.1. Using Automatic Number Formatting
        2. 13.5.2. Formatting Numbers by Using the Ribbon
        3. 13.5.3. Using Shortcut Keys to Format Numbers
        4. 13.5.4. Formatting Numbers Using the Format Cells Dialog Box
      6. 13.6. Summary
    3. 14. Essential Worksheet and Cell Range Operations
      1. 14.1. Learning the Fundamentals of Excel Worksheets
        1. 14.1.1. Working with Excel Windows
          1. 14.1.1.1. Moving and Resizing Windows
          2. 14.1.1.2. Switching among Windows
          3. 14.1.1.3. Closing Windows
          4. 14.1.1.4. Activating a Worksheet
        2. 14.1.2. Adding a New Worksheet to Your Workbook
        3. 14.1.3. Deleting a Worksheet You No Longer Need
        4. 14.1.4. Changing the Name of a Worksheet
        5. 14.1.5. Changing a Sheet Tab Color
        6. 14.1.6. Rearranging Your Worksheets
        7. 14.1.7. Hiding and Unhiding a Worksheet
      2. 14.2. Controlling the Worksheet View
        1. 14.2.1. Zooming in or out for a Better View
        2. 14.2.2. Viewing a Worksheet in Multiple Windows
        3. 14.2.3. Comparing Sheets Side-by-Side
        4. 14.2.4. Splitting the Worksheet Window into Panes
        5. 14.2.5. Keeping the Titles in View by Freezing Panes
        6. 14.2.6. Monitoring Cells with a Watch Window
      3. 14.3. Working with Rows and Columns
        1. 14.3.1. Inserting Rows and Columns
        2. 14.3.2. Deleting Rows and Columns
        3. 14.3.3. Hiding Rows and Columns
        4. 14.3.4. Changing Column Widths and Row Heights
          1. 14.3.4.1. Changing Column Widths
          2. 14.3.4.2. Changing Row Heights
      4. 14.4. Understanding Cells and Ranges
        1. 14.4.1. Selecting Ranges
        2. 14.4.2. Selecting Complete Rows and Columns
        3. 14.4.3. Selecting Noncontiguous Ranges
        4. 14.4.4. Selecting Multisheet Ranges
        5. 14.4.5. Selecting Special Types of Cells
        6. 14.4.6. Selecting Cells by Searching
      5. 14.5. Copying or Moving Ranges
        1. 14.5.1. Copying by Using Ribbon Commands
        2. 14.5.2. Copying by Using Shortcut Menu Commands
        3. 14.5.3. Copying or Moving by Using Drag-and-Drop
        4. 14.5.4. Copying to Adjacent Cells
        5. 14.5.5. Copying a Range to Other Sheets
        6. 14.5.6. Using the Office Clipboard to Paste
        7. 14.5.7. Pasting in Special Ways
        8. 14.5.8. Using the Paste Special Dialog Box
          1. 14.5.8.1. Performing Mathematical Operations without Formulas
          2. 14.5.8.2. Skipping Blanks when Pasting
          3. 14.5.8.3. Transposing a Range
      6. 14.6. Using Names to Work with Ranges
        1. 14.6.1. Creating Range Names in Your Workbooks
          1. 14.6.1.1. Using the New Name Dialog Box
          2. 14.6.1.2. Using the Name Box
          3. 14.6.1.3. Using the Create Names from Selection Dialog Box
        2. 14.6.2. Managing Names
      7. 14.7. Adding Comments to Cells
        1. 14.7.1. Formatting Comments
        2. 14.7.2. Working Further with Comments
      8. 14.8. Summary
    4. 15. Introducing Formulas and Functions
      1. 15.1. Understanding Formula Basics
        1. 15.1.1. Using Operators in Formulas
        2. 15.1.2. Understanding Operator Precedence in Formulas
        3. 15.1.3. Using Functions in Your Formulas
          1. 15.1.3.1. Examples of Formulas That Use Functions
          2. 15.1.3.2. Function Arguments
          3. 15.1.3.3. More about Functions
      2. 15.2. Entering Formulas into Your Worksheets
        1. 15.2.1. Entering Formulas Manually
        2. 15.2.2. Entering Formulas by Pointing
        3. 15.2.3. Pasting Range Names into Formulas
        4. 15.2.4. Inserting Functions into Formulas
        5. 15.2.5. Function Entry Tips
      3. 15.3. Editing Formulas
      4. 15.4. Using Cell References in Formulas
        1. 15.4.1. Using Relative, Absolute, and Mixed References
        2. 15.4.2. Changing the Types of Your References
        3. 15.4.3. Referencing Cells outside the Worksheet
          1. 15.4.3.1. Referencing Cells in Other Worksheets
          2. 15.4.3.2. Referencing Cells in Other Workbooks
      5. 15.5. Using Formulas in Tables
        1. 15.5.1. Summarizing Data in a Table
        2. 15.5.2. Using Formulas within a Table
        3. 15.5.3. Referencing Data in a Table
      6. 15.6. Correcting Common Formula Errors
        1. 15.6.1. Handling Circular References
        2. 15.6.2. Specifying When Formulas Are Calculated
      7. 15.7. Tips for Working with Formulas
        1. 15.7.1. Don't Hard-Code Values
        2. 15.7.2. Using the Formula Bar as a Calculator
        3. 15.7.3. Making an Exact Copy of a Formula
        4. 15.7.4. Converting Formulas to Values
      8. 15.8. Summary
    5. 16. Working with Dates and Times
      1. 16.1. How Excel Handles Dates and Times
        1. 16.1.1. Understanding Date Serial Numbers
        2. 16.1.2. Entering Dates
        3. 16.1.3. Understanding Time Serial Numbers
        4. 16.1.4. Entering Times
        5. 16.1.5. Formatting Dates and Times
        6. 16.1.6. Problems with Dates
          1. 16.1.6.1. Excel's Leap Year Bug
          2. 16.1.6.2. Pre-1900 Dates
          3. 16.1.6.3. Inconsistent Date Entries
      2. 16.2. Date-Related Worksheet Functions
        1. 16.2.1. Displaying the Current Date
        2. 16.2.2. Displaying Any Date
        3. 16.2.3. Generating a Series of Dates
        4. 16.2.4. Converting a Nondate String to a Date
        5. 16.2.5. Calculating the Number of Days Between Two Dates
        6. 16.2.6. Calculating the Number of Workdays between Two Dates
        7. 16.2.7. Offsetting a Date Using only Workdays
        8. 16.2.8. Calculating the Number of Years between Two Dates
        9. 16.2.9. Calculating a Person's Age
        10. 16.2.10. Determining the Day of the Year
        11. 16.2.11. Determining the Day of the Week
        12. 16.2.12. Determining the Date of the Most Recent Sunday
        13. 16.2.13. Determining the First Day of the Week after a Date
        14. 16.2.14. Determining the Nth Occurrence of a Day of the Week in a Month
        15. 16.2.15. Calculating Dates of Holidays
          1. 16.2.15.1. New Year's Day
          2. 16.2.15.2. Martin Luther King, Jr. Day
          3. 16.2.15.3. Presidents' Day
          4. 16.2.15.4. Easter
          5. 16.2.15.5. Memorial Day
          6. 16.2.15.6. Independence Day
          7. 16.2.15.7. Labor Day
          8. 16.2.15.8. Columbus Day
          9. 16.2.15.9. Veterans Day
          10. 16.2.15.10. Thanksgiving Day
          11. 16.2.15.11. Christmas Day
        16. 16.2.16. Determining the Last Day of a Month
        17. 16.2.17. Determining whether a Year Is a Leap Year
        18. 16.2.18. Determining a Date's Quarter
      3. 16.3. Time-Related Functions
        1. 16.3.1. Displaying the Current Time
        2. 16.3.2. Displaying any Time
        3. 16.3.3. Calculating the Difference between Two Times
        4. 16.3.4. Summing Times that Exceed 24 Hours
        5. 16.3.5. Converting from Military Time
        6. 16.3.6. Converting Decimal Hours, Minutes, or Seconds to a Time
        7. 16.3.7. Adding Hours, Minutes, or Seconds to a Time
        8. 16.3.8. Rounding Time Values
        9. 16.3.9. Working with Non-Time-of-Day Values
      4. 16.4. Summary
    6. 17. Creating Formulas That Count and Sum
      1. 17.1. Counting and Summing Worksheet Cells
      2. 17.2. Basic Counting Formulas
        1. 17.2.1. Counting the Total Number of Cells
        2. 17.2.2. Counting Blank Cells
        3. 17.2.3. Counting Non-Blank Cells
        4. 17.2.4. Counting Numeric Cells
        5. 17.2.5. Counting Text Cells
        6. 17.2.6. Counting Non-text Cells
        7. 17.2.7. Counting Logical Values
        8. 17.2.8. Counting Error Values in a Range
      3. 17.3. Advanced Counting Formulas
        1. 17.3.1. Counting Cells by Using the COUNTIF Function
        2. 17.3.2. Counting Cells Based on Multiple Criteria
          1. 17.3.2.1. Using And Criteria
          2. 17.3.2.2. Using Or Criteria
          3. 17.3.2.3. Combining And and Or Criteria
        3. 17.3.3. Counting the Most Frequently Occurring Entry
        4. 17.3.4. Counting the Occurrences of Specific Text
          1. 17.3.4.1. Entire Cell Contents
          2. 17.3.4.2. Partial Cell Contents
          3. 17.3.4.3. Total Occurrences in a Range
        5. 17.3.5. Counting the Number of Unique Values
        6. 17.3.6. Creating a Frequency Distribution
          1. 17.3.6.1. The FREQUENCY Function
          2. 17.3.6.2. Using Formulas to Create a Frequency Distribution
          3. 17.3.6.3. Using the Analysis ToolPak to Create a Frequency Distribution
          4. 17.3.6.4. Using a PivotTable to Create a Frequency Distribution
      4. 17.4. Summing Formulas
        1. 17.4.1. Summing All Cells in a Range
        2. 17.4.2. Computing a Cumulative Sum
        3. 17.5.3. Summing the "Top n" Values
      5. 17.6. Conditional Sums Using a Single Criterion
        1. 17.6.1. Summing Only Negative Values
        2. 17.6.2. Summing Values Based on a Different Range
        3. 17.6.3. Summing Values Based on a Text Comparison
        4. 17.6.4. Summing Values Based on a Date Comparison
      6. 17.7. Conditional Sums Using Multiple Criteria
        1. 17.7.1. Using And Criteria
        2. 17.7.2. Using Or Criteria
        3. 17.7.3. Using And and Or Criteria
      7. 17.8. Summary
    7. 18. Getting Started Making Charts
      1. 18.1. What Is a Chart?
      2. 18.2. Understanding How Excel Handles Charts
        1. 18.2.1. Embedded Charts
        2. 18.2.2. Chart Sheets
      3. 18.3. Creating a Chart
      4. 18.4. Hands On: Creating and Customizing a Chart
        1. 18.4.1. Selecting the Data
        2. 18.4.2. Choosing a Chart Type
        3. 18.4.3. Experimenting with Different Layouts
        4. 18.4.4. Trying Another View of the Data
        5. 18.4.5. Trying Other Chart Types
        6. 18.4.6. Trying Other Chart Styles
      5. 18.5. Working with Charts
        1. 18.5.1. Resizing a Chart
        2. 18.5.2. Moving a Chart
        3. 18.5.3. Copying a Chart
        4. 18.5.4. Deleting a Chart
        5. 18.5.5. Adding Chart Elements
        6. 18.5.6. Moving and Deleting Chart Elements
        7. 18.5.7. Formatting Chart Elements
        8. 18.5.8. Printing Charts
      6. 18.6. Understanding Chart Types
        1. 18.6.1. Choosing a Chart Type
      7. 18.7. Summary
    8. 19. Communicating Data Visually
      1. 19.1. About Conditional Formatting
      2. 19.2. Specifying Conditional Formatting
        1. 19.2.1. Formatting Types You Can Apply
        2. 19.2.2. Making Your Own Rules
      3. 19.3. Conditional Formats That Use Graphics
        1. 19.3.1. Using Data Bars
          1. 19.3.1.1. A Simple Data Bar
          2. 19.3.1.2. Using Data bars in Lieu of a Chart
        2. 19.3.2. Using Color Scales
          1. 19.3.2.1. A Color Scale Example
        3. 19.3.3. Using Icon Sets
          1. 19.3.3.1. An Icon Set Example
          2. 19.3.3.2. Another Icon Set Example
      4. 19.4. Creating Formula-Based Rules
        1. 19.4.1. Understanding Relative and Absolute References
        2. 19.4.2. Conditional Formatting Formula Examples
          1. 19.4.2.1. Identifying Weekend Days
          2. 19.4.2.2. Displaying Alternate-Row Shading
          3. 19.4.2.3. Creating Checkerboard Shading
          4. 19.4.2.4. Shading Groups of Rows
          5. 19.4.2.5. Displaying a Total Only When All Values Are Entered
      5. 19.5. Working with Conditional Formats
        1. 19.5.1. Managing Rules
        2. 19.5.2. Copying Cells That Contain Conditional Formatting
        3. 19.5.3. Deleting Conditional Formatting
        4. 19.5.4. Locating Cells That Contain Conditional Formatting
      6. 19.6. Introducing Sparklines
        1. 19.6.1. Sparkline Types
        2. 19.6.2. Creating Sparklines
        3. 19.6.3. Customizing Sparklines
          1. 19.6.3.1. Sizing Sparkline Cells
          2. 19.6.3.2. Handling Hidden or Missing Data
          3. 19.6.3.3. Changing the Sparkline Type
          4. 19.6.3.4. Changing Sparkline Colors and Line Width
          5. 19.6.3.5. Highlighting Certain Data Points
          6. 19.6.3.6. Adjusting Sparkline Axis Scaling
        4. 19.6.4. Specifying a Date Axis
        5. 19.6.5. Auto-updating Sparklines
      7. 19.7. Summary
  9. IV. Persuading and Informing with PowerPoint
    1. 20. A First Look at PowerPoint 2010
      1. 20.1. What's New in PowerPoint 2010?
        1. 20.1.1. Backstage View
        2. 20.1.2. Better Support for Video Import and Editing
        3. 20.1.3. Output to Video and DVD
        4. 20.1.4. Collaboration
        5. 20.1.5. Other Changes
      2. 20.2. Learning Your Way around PowerPoint
        1. 20.2.1. Starting and Exiting PowerPoint
      3. 20.3. Changing the View
        1. 20.3.1. Normal View
        2. 20.3.2. Slide Sorter View
        3. 20.3.3. Slide Show View
        4. 20.3.4. Notes Page View
      4. 20.4. Zooming In and Out
      5. 20.5. Enabling Optional Display Elements
        1. 20.5.1. Ruler
        2. 20.5.2. Gridlines
        3. 20.5.3. Guides
        4. 20.5.4. Color/Grayscale/Pure Black and White Views
      6. 20.6. Opening a New Display Window
        1. 20.6.1. Arranging Windows
        2. 20.6.2. Switching among Windows
      7. 20.7. Summary
    2. 21. Creating a Presentation, Slides, and Text
      1. 21.1. Starting a New Presentation
        1. 21.1.1. Starting a Blank Presentation from Scratch
        2. 21.1.2. Starting a Presentation from a Template or Theme
          1. 21.1.2.1. Using a Sample Template
          2. 21.1.2.2. Using an Online Template
          3. 21.1.2.3. Using a Saved Template
        3. 21.1.3. Basing a New Presentation on an Existing One
        4. 21.1.4. Basing a New Presentation on Content from Another Application
      2. 21.2. Saving Your Work
        1. 21.2.1. Saving for the First Time
        2. 21.2.2. Saving Subsequent Times
        3. 21.2.3. Changing Drives and Folders
          1. 21.2.3.1. Changing the Save Location (Windows 7)
          2. 21.2.3.2. Changing the Save Location (Windows Vista)
          3. 21.2.3.3. Changing the Save Location (Windows XP)
        4. 21.2.4. Saving in a Different Format
          1. 21.2.4.1. Saving Slides as Graphics
          2. 21.2.4.2. Saving Slide Text Only
        5. 21.2.5. Specifying Save Options
      3. 21.3. Setting Passwords for File Protection
      4. 21.4. Closing and Reopening Presentations
        1. 21.4.1. Closing a Presentation
        2. 21.4.2. Opening a Presentation
        3. 21.4.3. Opening a File from a Different Program
        4. 21.4.4. Finding a Presentation File to Open
      5. 21.5. Creating New Slides
        1. 21.5.1. Creating New Slides from the Outline Pane
        2. 21.5.2. Creating a Slide from the Slides Pane
        3. 21.5.3. Creating a Slide from a Layout
        4. 21.5.4. Copying Slides
      6. 21.6. Inserting Content from External Sources
        1. 21.6.1. Copying Slides from Other Presentations
        2. 21.6.2. Inserting New Slides from an Outline
          1. 21.6.2.1. Tips for Better Outline Importing
          2. 21.6.2.2. Importing from Other Text-Based Formats
          3. 21.6.2.3. Post-Import Cleanup
        3. 21.6.3. Opening a Word Document as a New Presentation
        4. 21.6.4. Importing Text from Web Pages
      7. 21.7. Managing Slides
        1. 21.7.1. Selecting Slides
        2. 21.7.2. Deleting Slides
        3. 21.7.3. Undoing Mistakes
        4. 21.7.4. Rearranging Slides
      8. 21.8. Using Content Placeholders
        1. 21.8.1. Inserting Content into a Placeholder
        2. 21.8.2. Placeholders versus Manually Inserted Objects
      9. 21.9. Creating Text Boxes Manually
        1. 21.9.1. When Should You Use a Manual Text Box?
        2. 21.9.2. Creating a Text Box Manually
      10. 21.10. Working with Text Boxes
        1. 21.10.1. Selecting Text Boxes
        2. 21.10.2. Sizing a Text Box
        3. 21.10.3. Positioning a Text Box
        4. 21.10.4. Changing a Text Box's AutoFit Behavior
      11. 21.11. Summary
    3. 22. Working with Layouts, Themes, and Masters
      1. 22.1. Understanding Layouts and Themes
        1. 22.1.1. Themes versus Templates
        2. 22.1.2. Where Themes Are Stored
        3. 22.1.3. Themes, Layouts, and Slide Master View
      2. 22.2. Changing a Slide's Layout
      3. 22.3. Applying a Theme
        1. 22.3.1. Applying a Theme from the Gallery
        2. 22.3.2. Applying a Theme from a Theme or Template File
      4. 22.4. Changing Colors, Fonts, and Effects
        1. 22.4.1. Understanding Color Placeholders
        2. 22.4.2. Switching Color Themes
        3. 22.4.3. Understanding Font Placeholders
        4. 22.4.4. Switching Font Themes
        5. 22.4.5. Changing the Effect Theme
      5. 22.5. Creating and Managing Custom Color and Font Themes
        1. 22.5.1. Creating a Custom Color Theme
        2. 22.5.2. Sharing a Custom Color Theme with Others
        3. 22.5.3. Deleting a Custom Color Theme
        4. 22.5.4. Creating a Custom Font Theme
        5. 22.5.5. Sharing a Custom Font Theme with Others
        6. 22.5.6. Deleting a Custom Font Theme
      6. 22.6. Changing the Background
        1. 22.6.1. Applying a Background Style
        2. 22.6.2. Applying a Background Fill
        3. 22.6.3. Working with Background Graphics
          1. 22.6.3.1. Displaying and Hiding Background Graphics
          2. 22.6.3.2. Deleting Background Graphics
          3. 22.6.3.3. Adding Your Own Background Graphics
      7. 22.7. Working with Placeholders
        1. 22.7.1. Formatting a Placeholder
        2. 22.7.2. Moving, Deleting, or Restoring Placeholders
        3. 22.7.3. Displaying the Date, Number, and Footer on Slides
          1. 22.7.3.1. Date and Time
          2. 22.7.3.2. Slide Number
          3. 22.7.3.3. Footer
          4. 22.7.3.4. Don't Show on Title Slide
      8. 22.8. Customizing and Creating Layouts
        1. 22.8.1. Understanding Content Placeholders
        2. 22.8.2. Adding a Custom Placeholder
        3. 22.8.3. Deleting and Restoring a Custom Placeholder
        4. 22.8.4. Overriding the Slide Master Formatting for a Layout
        5. 22.8.5. Creating a New Layout
        6. 22.8.6. Renaming a Layout
        7. 22.8.7. Duplicating and Deleting Layouts
        8. 22.8.8. Copying Layouts between Slide Masters
      9. 22.9. Managing Slide Masters
        1. 22.9.1. Creating and Deleting Slide Masters
        2. 22.9.2. Renaming a Slide Master
        3. 22.9.3. Preserving a Slide Master
      10. 22.10. Managing Themes
        1. 22.10.1. Creating a New Theme
        2. 22.10.2. Renaming a Theme
        3. 22.10.3. Deleting a Theme
        4. 22.10.4. Copying a Theme from Another Presentation
      11. 22.11. Summary
    4. 23. Working with Tables and Charts
      1. 23.1. Creating a New Table
        1. 23.1.1. Creating a Table with the Insert Table Dialog Box
        2. 23.1.2. Creating a Table from the Table Button
        3. 23.1.3. Drawing a Table
      2. 23.2. Moving Around in a Table
      3. 23.3. Selecting Rows, Columns, and Cells
      4. 23.4. Editing a Table's Structure
        1. 23.4.1. Resizing the Overall Table
        2. 23.4.2. Inserting or Deleting Rows and Columns
        3. 23.4.3. Merging and Splitting Cells
      5. 23.5. Applying Table Styles
      6. 23.6. Formatting Table Cells
        1. 23.6.1. Changing Row Height and Column Width
        2. 23.6.2. Table Margins and Alignment
        3. 23.6.3. Applying Borders
        4. 23.6.4. Applying Fills
          1. 23.6.4.1. Filling Individual Cells
          2. 23.6.4.2. Applying an Overall Table Fill
          3. 23.6.4.3. Filling a Table with a Picture
        5. 23.6.5. Applying a Shadow to a Table
        6. 23.6.6. Applying a 3-D Effect to a Table
        7. 23.6.7. Changing Text Alignment
        8. 23.6.8. Changing Text Direction
      7. 23.7. Understanding Charts
        1. 23.7.1. Parts of a Chart
        2. 23.7.2. PowerPoint 2010 versus Legacy Charts
      8. 23.8. Starting a New Chart
      9. 23.9. Working with Chart Data
        1. 23.9.1. Plotting by Rows versus by Columns
        2. 23.9.2. Redefining the Data Range
      10. 23.10. Chart Types and Chart Layout Presets
      11. 23.11. Working with Labels
        1. 23.11.1. Working with Chart Titles
        2. 23.11.2. Working with Axis Titles
        3. 23.11.3. Working with Legends
        4. 23.11.4. Adding Data Labels
        5. 23.11.5. Adding a Data Table
      12. 23.12. Controlling the Axes
        1. 23.12.1. Using Axis Presets
        2. 23.12.2. Setting Axis Scale Options
        3. 23.12.3. Setting a Number Format
      13. 23.13. Formatting a Chart
        1. 23.13.1. Clearing Manually Applied Formatting
        2. 23.13.2. Formatting Titles and Labels
        3. 23.13.3. Applying Chart Styles
        4. 23.13.4. Formatting the Chart Area
        5. 23.13.5. Formatting the Legend
        6. 23.13.6. Formatting Gridlines and Walls
        7. 23.13.7. Formatting the Data Series
      14. 23.14. Rotating a 3-D Chart
      15. 23.15. Summary
    5. 24. Using SmartArt Diagrams, Clip Art, and Pictures
      1. 24.1. Understanding SmartArt Types and Their Uses
        1. 24.1.1. List
        2. 24.1.2. Process
        3. 24.1.3. Cycle
        4. 24.1.4. Hierarchy
        5. 24.1.5. Relationship
        6. 24.1.6. Matrix
        7. 24.1.7. Pyramid
        8. 24.1.8. Picture
      2. 24.2. Inserting a Diagram
      3. 24.3. Editing SmartArt Text
      4. 24.4. Modifying SmartArt Structure
        1. 24.4.1. Inserting and Deleting Shapes
        2. 24.4.2. Adding Bullets
        3. 24.4.3. Promoting and Demoting Text
        4. 24.4.4. Changing the Flow Direction
        5. 24.4.5. Reordering Shapes
        6. 24.4.6. Repositioning Shapes
        7. 24.4.7. Resetting a Graphic
        8. 24.4.8. Changing to a Different Diagram Layout
      5. 24.5. Modifying a Hierarchy Diagram Structure
        1. 24.5.1. Inserting and Deleting Shapes
        2. 24.5.2. Changing a Person's Level in the Organization
        3. 24.5.3. Controlling Subordinate Layout Options
      6. 24.6. Formatting a Diagram
        1. 24.6.1. Applying a SmartArt Style
        2. 24.6.2. Changing SmartArt Colors
        3. 24.6.3. Manually Applying Colors and Effects to Individual Shapes
        4. 24.6.4. Manually Formatting the Diagram Text
        5. 24.6.5. Making a Shape Larger or Smaller
        6. 24.6.6. Resizing the Entire SmartArt Graphic Object
        7. 24.6.7. Editing in 2D
        8. 24.6.8. Changing the Shapes Used in the Diagram
      7. 24.7. Saving a SmartArt Diagram as a Picture
      8. 24.8. Choosing Appropriate Clip Art
      9. 24.9. About the Clip Organizer
      10. 24.10. Inserting Clip Art on a Slide
      11. 24.11. Clip Art Search Methods
        1. 24.11.1. Using Multiple Keywords
        2. 24.11.2. Specify Which Media File Types to Find
        3. 24.11.3. Work with Found Clips
      12. 24.12. Working with Clip Art Collections
        1. 24.12.1. Opening and Browsing the Clip Organizer
        2. 24.12.2. Using the Clip Organizer to Insert Clip Art
        3. 24.12.3. Creating and Deleting Folders
        4. 24.12.4. Moving Clips between Collections
        5. 24.12.5. Cataloging Clips
          1. 24.12.5.1. Working with CIL or MPF Files
        6. 24.12.6. Deleting Clips from the Clip Organizer
        7. 24.12.7. Making Clips Available Offline
        8. 24.12.8. Browsing for More Clips on Office.com
      13. 24.13. Understanding Raster Graphics
        1. 24.13.1. Resolution
          1. 24.13.1.1. Resolution on Preexisting Graphics Files
          2. 24.13.1.2. Resolution on Graphics You Scan Yourself
          3. 24.13.1.3. Resolution on Digital Camera Photos
        2. 24.13.2. Color Depth
        3. 24.13.3. File Format
      14. 24.14. Importing Image Files into PowerPoint
        1. 24.14.1. Linking to a Graphic File
        2. 24.14.2. Acquiring Images from a Scanner
        3. 24.14.3. Acquiring Images from a Digital Camera
        4. 24.14.4. Capturing and Inserting Screenshots
      15. 24.15. Sizing and Cropping Photos
        1. 24.15.1. Sizing a Photo
        2. 24.15.2. Cropping a Photo
        3. 24.15.3. Resetting a Photo
      16. 24.16. Compressing Images
        1. 24.16.1. Reducing Resolution and Compressing Images in PowerPoint
        2. 24.16.2. Reducing Resolution with a Third-Party Utility
      17. 24.17. Summary
    6. 25. Building Animation Effects, Transitions, and Support Materials
      1. 25.1. Understanding Animation and Transitions
      2. 25.2. Assigning Transitions to Slides
        1. 25.2.1. Setting Transition Effects and Timings
        2. 25.2.2. More about Transition Sounds
        3. 25.2.3. Rehearsing and Recording Transition Timings
      3. 25.3. Animating Slide Content
        1. 25.3.1. Understanding Animations
        2. 25.3.2. Choosing an Animation Effect
        3. 25.3.3. Animating Parts of a Chart
      4. 25.4. The When and How of Handouts
      5. 25.5. Creating Handouts
        1. 25.5.1. Choosing a Layout
        2. 25.5.2. Printing Handouts
        3. 25.5.3. Setting Printer-Specific Options
        4. 25.5.4. Using the Handout Master
        5. 25.5.5. Setting the Number of Slides per Page
        6. 25.5.6. Using and Positioning Placeholders
        7. 25.5.7. Setting Handout and Slide Orientation
        8. 25.5.8. Formatting Handouts
      6. 25.6. Creating Speaker Notes
        1. 25.6.1. Typing Speaker Notes
        2. 25.6.2. Changing the Notes Page Layout
        3. 25.6.3. Printing Notes Pages
      7. 25.7. Printing an Outline
      8. 25.8. Printing Slides
      9. 25.9. Summary
    7. 26. Preparing and Delivering a Live Presentation
      1. 26.1. Starting and Ending a Show
      2. 26.2. Using the Onscreen Show Controls
        1. 26.2.1. Moving from Slide to Slide
        2. 26.2.2. Jumping to Specific Slides
        3. 26.2.3. Blanking the Screen
      3. 26.3. Using the Onscreen Pen
      4. 26.4. Hiding Slides for Backup Use
        1. 26.4.1. Hiding and Unhiding Slides
        2. 26.4.2. Showing a Hidden Slide during a Presentation
      5. 26.5. Using Custom Shows
        1. 26.5.1. Ideas for Using Custom Shows
        2. 26.5.2. Creating Custom Shows
        3. 26.5.3. Editing Custom Shows
        4. 26.5.4. Copying Custom Shows
        5. 26.5.5. Deleting Custom Shows
        6. 26.5.6. Displaying a Custom Show
          1. 26.5.6.1. Navigating to a Custom Show
          2. 26.5.6.2. Navigating Back to the Main Show
          3. 26.5.6.3. Creating a Hyperlink to a Custom Show
        7. 26.5.7. Using a Custom Show as the Main Presentation
      6. 26.6. Giving a Presentation on a Different Computer
        1. 26.6.1. Copying a Presentation to CD
        2. 26.6.2. Creating a CD Containing Multiple Presentation Files
        3. 26.6.3. Setting Copy Options
        4. 26.6.4. Copying a Presentation to Other Locations
      7. 26.7. Working with Audiovisual Equipment
        1. 26.7.1. Presenting with Two Screens
        2. 26.7.2. Configuring Display Hardware for Multi-screen Viewing
        3. 26.7.3. Setting Up a Presentation for Two Screens
        4. 26.7.4. Presenting with Two Screens Using Presenter View
      8. 26.8. Summary
  10. V. Organizing Messages, Contacts, and Time with Outlook
    1. 27. Fundamentals of E-mail
      1. 27.1. Setting Up Your E-mail Accounts
        1. 27.1.1. Automatic E-mail Account Setup
        2. 27.1.2. Manual E-mail Account Setup (POP and IMAP)
          1. 27.1.2.1. If Your Account Settings Don't Work
          2. 27.1.2.2. More Account Settings
            1. 27.1.2.2.1. General
            2. 27.1.2.2.2. Outgoing Server
            3. 27.1.2.2.3. Connection
            4. 27.1.2.2.4. Advanced
        3. 27.1.3. Manual E-mail Account Setup (Exchange Server)
        4. 27.1.4. Manual E-mail Account Setup (Web)
      2. 27.2. Modifying Account Settings
      3. 27.3. Using Outlook Profiles
        1. 27.3.1. Understanding Profiles
        2. 27.3.2. Creating a New Profile
        3. 27.3.3. Switching Profiles
      4. 27.4. Composing and Sending Messages
        1. 27.4.1. Quick Compose and Send
        2. 27.4.2. Message Addressing Options
        3. 27.4.3. Changing the Reply To Address
        4. 27.4.4. Entering Recipients Manually
        5. 27.4.5. Entering Recipients from Your Contacts (Address Book)
        6. 27.4.6. Sending Attachments
      5. 27.5. Reading and Replying to Messages
        1. 27.5.1. Reading a Message
          1. 27.5.1.1. Marking Messages as Read or Unread
          2. 27.5.1.2. Using the Reading Pane
          3. 27.5.1.3. Other Actions for Received Messages
        2. 27.5.2. Replying to and Forwarding Messages
        3. 27.5.3. Working with Received Attachments
          1. 27.5.3.1. Saving Attachments
          2. 27.5.3.2. Viewing Attachments
          3. 27.5.3.3. Opening Attachments
      6. 27.6. Understanding the Inbox Display
      7. 27.7. Understanding Files and Folders
      8. 27.8. Outlook Data Files
        1. 27.8.1. Offline Folders File
      9. 27.9. Working with Outlook Folders
        1. 27.9.1. Outlook's Default Folders
        2. 27.9.2. Creating a New E-mail Folder
        3. 27.9.3. Creating a New Non–E-mail Folder
        4. 27.9.4. Organizing Folders in Groups
          1. 27.9.4.1. Creating a New Group
          2. 27.9.4.2. Working with Groups
        5. 27.9.5. Working with Folders, Groups, and Items
          1. 27.9.5.1. Viewing Folder Contents
          2. 27.9.5.2. Moving or Copying Items
          3. 27.9.5.3. Moving, Copying, Deleting, and Renaming Folders
      10. 27.10. Deleting Items and Using the Deleted Items Folder
      11. 27.11. Setting Options for an Individual E-mail Message
        1. 27.11.1. Changing the Send Account
        2. 27.11.2. Saving Sent Items
        3. 27.11.3. Sending Items with a Message
          1. 27.11.3.1. Sending a Calendar
          2. 27.11.3.2. Sending a Business Card
        4. 27.11.4. Setting Message Importance and Sensitivity
        5. 27.11.5. Setting Message Restrictions
        6. 27.11.6. Flagging a Message for Follow-up
        7. 27.11.7. Assigning a Message to a Category
        8. 27.11.8. Requesting Delivery and Read Receipts
        9. 27.11.9. Delaying Delivery and Setting Message Expiration
      12. 27.12. Setting Global E-mail Options
      13. 27.13. Summary
    2. 28. Processing and Securing E-mail
      1. 28.1. Understanding Junk E-mail Filtering
      2. 28.2. Setting Junk E-mail Options
      3. 28.3. Blocking and Allowing Specific Addresses
        1. 28.3.1. Defining Safe Senders
        2. 28.3.2. Blocking/Allowing Individual Senders
        3. 28.3.3. Defining Safe Recipients
        4. 28.3.4. Defining Blocked Senders
        5. 28.3.5. International Junk E-mail Options
      4. 28.4. Understanding E-mail Rule Basics
      5. 28.5. Creating a New Rule
        1. 28.5.1. Selecting a Rule Template
        2. 28.5.2. Editing a Rule Description
        3. 28.5.3. Finishing the Rule
        4. 28.5.4. Creating a Rule from a Blank Template
      6. 28.6. Some Rule Examples
        1. 28.6.1. Rule Example 1
        2. 28.6.2. Rule Example 2
        3. 28.6.3. Rule Example 3
      7. 28.7. Managing Rules
      8. 28.8. Protecting against Viruses
        1. 28.8.1. On-demand E-mail Scan
      9. 28.9. Dealing with Attachments
        1. 28.9.1. Automatically Blocked Attachments
        2. 28.9.2. Other Attachment Types
        3. 28.9.3. Sending Blocked File Types
      10. 28.10. Macro Security
      11. 28.11. Using Certificates and Digital Signatures
        1. 28.11.1. Obtaining a Digital ID
        2. 28.11.2. Importing/Exporting Digital IDs
        3. 28.11.3. Receiving Digitally Signed Messages
        4. 28.11.4. Obtaining Other People's Public Keys
        5. 28.11.5. Encrypting and Digitally Signing Messages
        6. 28.11.6. Encrypting Messages
        7. 28.11.7. Digitally Signing Messages
      12. 28.12. HTML Message Dangers
      13. 28.13. Summary
    3. 29. Working with Contacts
      1. 29.1. Understanding Outlook Contacts
      2. 29.2. The Contacts Window
        1. 29.2.1. Adding a New Contact Group
        2. 29.2.2. Customizing a Contacts View
        3. 29.2.3. Finding Contacts
      3. 29.3. Adding Contacts
        1. 29.3.1. Adding a Contact Manually
        2. 29.3.2. Adding a Contact from a Received E-mail
        3. 29.3.3. Adding a Contact from an Outlook Contact
      4. 29.4. Sending an E-mail to a Contact or Group
      5. 29.5. More about Contacts
        1. 29.5.1. The Contact Window
          1. 29.5.1.1. Full Name
          2. 29.5.1.2. Phone Numbers
          3. 29.5.1.3. Addresses
          4. 29.5.1.4. Picture
          5. 29.5.1.5. E-mail Addresses
          6. 29.5.1.6. Notes
        2. 29.5.2. Other Contact Displays
          1. 29.5.2.1. Details View
          2. 29.5.2.2. Activities View
          3. 29.5.2.3. Certificates View
          4. 29.5.2.4. All Fields View
        3. 29.5.3. Editing the Business Card
        4. 29.5.4. Dialing the Phone
        5. 29.5.5. Sending Contact Information by E-mail
        6. 29.5.6. Other Contact Actions
          1. 29.5.6.1. Viewing a Map of the Contact's Address
          2. 29.5.6.2. Inviting the Contact to a Meeting
          3. 29.5.6.3. Assigning a Task to a Contact
          4. 29.5.6.4. Viewing the Contact's Web Page
          5. 29.5.6.5. Tagging a Contact for Follow-up
      6. 29.6. Performing a Mail Merge from Your Contacts
      7. 29.7. Working with Multiple Address Books
      8. 29.8. Setting Contact Options
      9. 29.9. Summary
    4. 30. Working with Appointments and Tasks
      1. 30.1. Understanding the Outlook Calendar
      2. 30.2. Using the Calendar
        1. 30.2.1. Working with Calendar Views
          1. 30.2.1.1. Using the Calendar Day View
          2. 30.2.1.2. Using the Calendar Work Week and Week Views
          3. 30.2.1.3. Using the Calendar Month View
        2. 30.2.2. Using the To-Do Bar with Appointments
      3. 30.3. Working with Appointments
        1. 30.3.1. Creating a Simple Appointment
        2. 30.3.2. Editing and Deleting Appointments
        3. 30.3.3. Appointment Options
          1. 30.3.3.1. Scheduling Recurring Events
          2. 30.3.3.2. Using Appointment Reminders
          3. 30.3.3.3. Using Other Time Zones
          4. 30.3.3.4. Forwarding an Appointment
          5. 30.3.3.5. Assigning Appointments to Categories
          6. 30.3.3.6. Setting Appointment Importance
          7. 30.3.3.7. Marking an Appointment as Private
          8. 30.3.3.8. Determining How an Appointment Displays on the Scheduling Page
      4. 30.4. Searching the Calendar
      5. 30.5. Setting Calendar Options
      6. 30.6. Understanding Tasks
      7. 30.7. Using the Tasks Feature
      8. 30.8. Creating a New Task
        1. 30.8.1. Entering Task Details
        2. 30.8.2. Assigning a Task
        3. 30.8.3. Specifying Task Recurrence
      9. 30.9. Working with Assigned Tasks
        1. 30.9.1. Receiving a Task Assignment
          1. 30.9.1.1. Receiving Accept/Decline Notifications
        2. 30.9.2. Task Status Reports
        3. 30.9.3. Sending a Status Report Manually
      10. 30.10. Other Ways of Viewing Tasks
        1. 30.10.1. Viewing Tasks on the To-Do Bar
        2. 30.10.2. Viewing Tasks on the Calendar
      11. 30.11. Setting Task Options
      12. 30.12. Summary
  11. VI. Designing Publications with Publisher
    1. 31. Introducing Publisher
      1. 31.1. The Publisher Workspace
      2. 31.2. Using a Template to Create a Publication
      3. 31.3. Working with Text
        1. 31.3.1. Typing Text in a Placeholder
        2. 31.3.2. Creating a Placeholder and Adding Text
        3. 31.3.3. Inserting a Text File
        4. 31.3.4. Resizing, AutoFlow, and Linked Text Boxes
        5. 31.3.5. Formatting Text
        6. 31.3.6. The Measurement Task Pane
      4. 31.4. Working with Graphics
        1. 31.4.1. Inserting a Picture File
        2. 31.4.2. Inserting a Clip Art Image
        3. 31.4.3. Changing a Placeholder Picture
        4. 31.4.4. Formatting Pictures
        5. 31.4.5. Drawing Lines and Shapes
      5. 31.5. Working with Tables
        1. 31.5.1. Entering and Editing Table Data
        2. 31.5.2. Working with the Table Format
      6. 31.6. Summary
    2. 32. Designing Dazzling Publications with Publisher
      1. 32.1. Adding Special Effects
        1. 32.1.1. BorderArt
        2. 32.1.2. Drop Caps
        3. 32.1.3. WordArt
        4. 32.1.4. Text Effects and Typography Tools
      2. 32.2. Using Building Blocks
      3. 32.3. Updating a Publication
        1. 32.3.1. Changing the Background
        2. 32.3.2. Changing Page Settings
        3. 32.3.3. Changing Colors
      4. 32.4. Fine-Tuning Objects
        1. 32.4.1. Aligning Objects
        2. 32.4.2. Grouping Objects
        3. 32.4.3. Wrapping and Hyphenating Text
      5. 32.5. Working with Pages
        1. 32.5.1. Adding Pages
        2. 32.5.2. Numbering Pages
      6. 32.6. Checking and Printing
        1. 32.6.1. Using the Design Checker
        2. 32.6.2. Printing
      7. 32.7. Preparing for Outside Printing
      8. 32.8. Summary
  12. VII. Managing Information with Access and OneNote
    1. 33. An Introduction to Database Development
      1. 33.1. The Database Terminology of Access
        1. 33.1.1. Databases
        2. 33.1.2. Tables
        3. 33.1.3. Records and Fields
        4. 33.1.4. Values
      2. 33.2. Relational Databases
      3. 33.3. Access Database Objects and Views
        1. 33.3.1. Datasheets
        2. 33.3.2. Queries
        3. 33.3.3. Data-Entry and Display Forms
        4. 33.3.4. Reports
        5. 33.3.5. Database Objects
      4. 33.4. A Five-Step Design Method
        1. 33.4.1. Step 1: The Overall Design—From Concept to Reality
        2. 33.4.2. Step 2: Report Design
        3. 33.4.3. Step 3: Data Design
          1. 33.4.3.1. Customer Information
          2. 33.4.3.2. Sales Information
          3. 33.4.3.3. Line-Item Information
        4. 33.4.4. Step 4: Table Design
        5. 33.4.5. Step 5: Form Design
      5. 33.5. Summary
    2. 34. Creating Access Tables
      1. 34.1. Getting Started with Access
        1. 34.1.1. The Templates Section
        2. 34.1.2. The Office Backstage View
      2. 34.2. Creating a Database
      3. 34.3. The Access 2010 Environment
        1. 34.3.1. The Navigation Pane
        2. 34.3.2. The Ribbon
        3. 34.3.3. Other Relevant Features of the Access Environment
      4. 34.4. Creating a New Table
        1. 34.4.1. The Importance of Naming Conventions
        2. 34.4.2. The Table Design Process
        3. 34.4.3. Adding a New Table to the Database
        4. 34.4.4. Using the Table Tools Design Tab
          1. 34.4.4.1. Primary Key Button
          2. 34.4.4.2. Insert Rows Button
          3. 34.4.4.3. Delete Rows Button
          4. 34.4.4.4. Property Sheet Button
          5. 34.4.4.5. Indexes Button
        5. 34.4.5. Working with Fields
          1. 34.4.5.1. Naming a Field
          2. 34.4.5.2. Specifying a Data Type
          3. 34.4.5.3. Specifying Data Validation Rules
          4. 34.4.5.4. Assigning Field Data Types
            1. 34.4.5.4.1. Text Data Type
            2. 34.4.5.4.2. Memo Data Type
            3. 34.4.5.4.3. Number Data Type
            4. 34.4.5.4.4. Date/Time Data Type
            5. 34.4.5.4.5. Currency
            6. 34.4.5.4.6. AutoNumber
            7. 34.4.5.4.7. Yes/No
            8. 34.4.5.4.8. OLE Object
            9. 34.4.5.4.9. Attachment
            10. 34.4.5.4.10. Hyperlink Data Type
            11. 34.4.5.4.11. Lookup Wizard
          5. 34.4.5.5. Entering a Field Description
      5. 34.5. Creating a Table
        1. 34.5.1. Using AutoNumber Fields
        2. 34.5.2. Completing tblCustomers
      6. 34.6. Setting the Primary Key
        1. 34.6.1. Choosing a Primary Key
        2. 34.6.2. Creating the Primary Key
        3. 34.6.3. Creating Composite Primary Keys
      7. 34.7. Indexing Access Tables
        1. 34.7.1. The Importance of Indexes
        2. 34.7.2. Multiple-Field Indexes
        3. 34.7.3. When to Index Tables
      8. 34.8. Printing a Table Design
      9. 34.9. Saving the Completed Table
      10. 34.10. Manipulating Tables
        1. 34.10.1. Renaming tables
        2. 34.10.2. Deleting Tables
        3. 34.10.3. Copying Tables in a Database
        4. 34.10.4. Copying a Table to Another Database
      11. 34.11. Adding Records to a Database Table
        1. 34.11.1. Opening a Datasheet
        2. 34.11.2. Moving within a Datasheet
        3. 34.11.3. Using the Navigation Buttons
        4. 34.11.4. Entering New Data
        5. 34.11.5. Saving the Record
        6. 34.11.6. Understanding Automatic Data-Type Validation
      12. 34.12. Navigating Records in a Datasheet
        1. 34.12.1. Moving between Records
        2. 34.12.2. Finding a Specific Value
      13. 34.13. Changing Values in a Datasheet
        1. 34.13.1. Manually Replacing an Existing Value
        2. 34.13.2. Fields That You Can't Edit
      14. 34.14. Summary
    3. 35. Creating and Entering Data with Basic Access Forms
      1. 35.1. Adding a Form
        1. 35.1.1. Creating a New Form
          1. 35.1.1.1. Using the Form Command
          2. 35.1.1.2. Using the Form Wizard
        2. 35.1.2. Looking at Special Types of Forms
          1. 35.1.2.1. Navigation Forms
          2. 35.1.2.2. Multiple Items Forms
          3. 35.1.2.3. Split Forms
          4. 35.1.2.4. Datasheet Forms
        3. 35.1.3. Resizing the Form Area
        4. 35.1.4. Saving Your Form
      2. 35.2. Working with Controls
        1. 35.2.1. The Different Control Types
          1. 35.2.1.1. Bound Controls
          2. 35.2.1.2. Unbound Controls
          3. 35.2.1.3. Calculated Controls
        2. 35.2.2. Adding a Control
          1. 35.2.2.1. Using the Controls Group
          2. 35.2.2.2. Using the Field List
      3. 35.3. Selecting and Deselecting Controls
        1. 35.3.1. Selecting a Single Control
        2. 35.3.2. Selecting Multiple Controls
        3. 35.3.3. Deselecting Controls
      4. 35.4. Manipulating Controls
        1. 35.4.1. Resizing a Control
        2. 35.4.2. Sizing Controls Automatically
        3. 35.4.3. Moving a Control
        4. 35.4.4. Aligning Controls
        5. 35.4.5. Modifying the Appearance of a Control
        6. 35.4.6. Grouping Controls
        7. 35.4.7. Attaching (and Reattaching) a Label to a Control
        8. 35.4.8. Changing a Control's Type
        9. 35.4.9. Copying a Control
        10. 35.4.10. Deleting a Control
      5. 35.5. Understanding Properties
        1. 35.5.1. Displaying the Property Sheet
        2. 35.5.2. Getting Acquainted with the Property Sheet
        3. 35.5.3. Changing a Control's Property Setting
        4. 35.5.4. Naming Control Labels and Their Captions
      6. 35.6. Entering Records in Form View
        1. 35.6.1. The Form View Ribbon Appearance
        2. 35.6.2. Navigating between Fields
        3. 35.6.3. Moving between Records in a Form
      7. 35.7. Changing Values in a Form
        1. 35.7.1. Controls That You Can't Edit
        2. 35.7.2. Working with Pictures and OLE Objects
        3. 35.7.3. Entering Data in a Memo Field
        4. 35.7.4. Entering Data in a Date Field
        5. 35.7.5. Using Option Groups
        6. 35.7.6. Using Combo Boxes and List Boxes
        7. 35.7.7. Switching to Datasheet View
        8. 35.7.8. Saving a Record
      8. 35.8. Printing a Form
      9. 35.9. Summary
    4. 36. Selecting Data with Queries
      1. 36.1. Understanding Queries
        1. 36.1.1. What Queries Are
        2. 36.1.2. Types of Queries
        3. 36.1.3. What Queries Can Do
        4. 36.1.4. What Queries Return
      2. 36.2. Creating a Query
      3. 36.3. Adding Fields
        1. 36.3.1. Adding a Single Field
        2. 36.3.2. Adding Multiple Fields
      4. 36.4. Displaying the Recordset
      5. 36.5. Working with Fields
        1. 36.5.1. Selecting a Field in the QBE Grid
        2. 36.5.2. Changing Field Order
        3. 36.5.3. Resizing Columns in the QBE Grid
        4. 36.5.4. Removing a Field
        5. 36.5.5. Inserting a Field
        6. 36.5.6. Providing an Alias for the Field Name
        7. 36.5.7. Showing a Field
      6. 36.6. Changing the Sort Order
      7. 36.7. Displaying Only Selected Records
        1. 36.7.1. Understanding Selection Criteria
        2. 36.7.2. Entering Simple String Criteria
        3. 36.7.3. Entering Other Simple Criteria
      8. 36.8. Printing a Query's Recordset
      9. 36.9. Saving a Query
      10. 36.10. Adding More Than One Table to a Query
      11. 36.11. Working with the Table Pane
        1. 36.11.1. Looking at the Join Line
        2. 36.11.2. Manipulating Field Lists
        3. 36.11.3. Moving a Table
        4. 36.11.4. Removing a Table
        5. 36.11.5. Adding More Tables
        6. 36.11.6. Viewing Table Names
        7. 36.11.7. Adding Multiple Fields
      12. 36.12. Understanding Multi-Table Query Limitations
        1. 36.12.1. Overcoming Query Limitations
          1. 36.12.1.1. Updating a Unique Index (Primary Key)
          2. 36.12.1.2. Replacing Existing Data in a Query with a One-to-Many Relationship
          3. 36.12.1.3. Updating Fields in Queries
      13. 36.13. Summary
    5. 37. Presenting Data with Access Reports
      1. 37.1. Introducing Reports
        1. 37.1.1. Identifying the Different Types of Reports
          1. 37.1.1.1. Tabular Reports
          2. 37.1.1.2. Columnar Reports
          3. 37.1.1.3. Mailing-Label Reports
        2. 37.1.2. Distinguishing between Reports and Forms
      2. 37.2. Creating a Report, from Beginning to End
        1. 37.2.1. Defining the Report Layout
        2. 37.2.2. Assembling the Data
        3. 37.2.3. Creating the Report with the Report Wizard
          1. 37.2.3.1. Creating a New Report
          2. 37.2.3.2. Selecting the Grouping Levels
          3. 37.2.3.3. Defining the Group Data
          4. 37.2.3.4. Selecting the Sort Order
          5. 37.2.3.5. Selecting Summary Options
          6. 37.2.3.6. Selecting the Layout
          7. 37.2.3.7. Opening the Report Design
          8. 37.2.3.8. Adjusting the Report's Layout
          9. 37.2.3.9. Choosing a Theme
          10. 37.2.3.10. Using the Print Preview Window
          11. 37.2.3.11. Publishing in Alternate Formats
          12. 37.2.3.12. Viewing the Report Design Window
        4. 37.2.4. Printing the Report
        5. 37.2.5. Saving the Report
      3. 37.3. Summary
    6. 38. Keeping Information at Hand with OneNote
      1. 38.1. Who Needs OneNote and Why
      2. 38.2. Touring OneNote
      3. 38.3. Creating a Notebook
      4. 38.4. Creating a Section
      5. 38.5. Creating a Page
      6. 38.6. Inserting Notes
        1. 38.6.1. Plain Notes
        2. 38.6.2. Tagged Notes
        3. 38.6.3. Extra Writing Space
        4. 38.6.4. Formatting Information
      7. 38.7. Inserting an Outlook Task
      8. 38.8. Inserting a Picture or File
      9. 38.9. Inserting a Screen Clipping
      10. 38.10. Writing on a Page
      11. 38.11. Using Linked Note Taking
      12. 38.12. Organizing, Finding, and Sharing
        1. 38.12.1. Reorganizing
        2. 38.12.2. Viewing Tagged Notes
        3. 38.12.3. Searching Notes
        4. 38.12.4. Saving Note Information for Others
      13. 38.13. Summary
  13. VIII. Sharing and Collaboration
    1. 39. SharePoint and SkyDrive
      1. 39.1. What Happened to Workspace Management?
      2. 39.2. Accessing Your SharePoint Server
        1. 39.2.1. Using Office 2010 with SharePoint 2010
        2. 39.2.2. Using Save to SharePoint from Backstage View
        3. 39.2.3. Co-authoring
          1. 39.2.3.1. Blocking and Locking
        4. 39.2.4. Co-authoring Indicators
      3. 39.3. Save to Web (SkyDrive)
        1. 39.3.1. Creating a SkyDrive Account
        2. 39.3.2. Accessing SkyDrive Documents
          1. 39.3.2.1. Adding a SkyDrive Shortcut to Your Favorites List
      4. 39.4. Summary
    2. 40. SharePoint Workspace
      1. 40.1. Who Needs SharePoint Workspace 2010?
      2. 40.2. Groove Workspaces versus SharePoint Workspaces
      3. 40.3. Using the SharePoint Workspace 2010 Client
        1. 40.3.1. Deleting an Account
        2. 40.3.2. The SharePoint Workspace 2010 Interface
      4. 40.4. SharePoint Workspaces
        1. 40.4.1. Deleting a SharePoint Workspace
      5. 40.5. Groove Workspaces
        1. 40.5.1. Workspaces
          1. 40.5.1.1. Adding Documents and Folders to a Groove Workspace
          2. 40.5.1.2. Deleting Workspaces
        2. 40.5.2. Sending Workspace Invitations
        3. 40.5.3. Canceling Pending Invitations
        4. 40.5.4. Accepting Workspace Invitations
        5. 40.5.5. Working with Groove Documents
      6. 40.6. Shared Folders
        1. 40.6.1. Deleting a Shared Folder
      7. 40.7. Summary
    3. 41. Integration with Other Office Applications
      1. 41.1. OneNote
        1. 41.1.1. Printing from Word to OneNote
        2. 41.1.2. Sending from OneNote to Word
      2. 41.2. Excel
        1. 41.2.1. Using Excel Content in Word
          1. 41.2.1.1. Clipboard
          2. 41.2.1.2. Chart
          3. 41.2.1.3. Object
            1. 41.2.1.3.1. Create from File
            2. 41.2.1.3.2. Create New
          4. 41.2.1.4. From Spreadsheet to Table
        2. 41.2.2. Using Word Content in Excel
          1. 41.2.2.1. Clipboard
          2. 41.2.2.2. Drag-and-Drop
          3. 41.2.2.3. Object
      3. 41.3. PowerPoint
        1. 41.3.1. Converting Word to PowerPoint Presentations
        2. 41.3.2. Converting PowerPoint Presentations to Word Documents
      4. 41.4. Outlook
        1. 41.4.1. Using the Outlook Address Book in Word
      5. 41.5. Summary
  14. A. Customizing Office
    1. A.1. Finding Program Options
      1. A.1.1. Opening the Options Dialog Box
      2. A.1.2. Navigating in the Dialog Box
    2. A.2. Using Common Options
    3. A.3. Top Word Options
    4. A.4. Top Excel Options
    5. A.5. Top PowerPoint Options
    6. A.6. Top Access Options
    7. A.7. Top Outlook Options
    8. A.8. Customizing the Quick Access Toolbar
    9. A.9. Customizing the Ribbon
  15. B. Optimizing Your Office Installation
    1. B.1. Using the Setup Disc
    2. B.2. Activating Microsoft Office
    3. B.3. Getting Updates
    4. B.4. Adding or Removing Office Features
    5. B.5. Running Microsoft Office Diagnostics
    6. B.6. Repairing Your Installation
  16. C. International Support and Accessibility Features
    1. C.1. Understanding and Choosing Text Encoding in Word
    2. C.2. Enabling Editing Languages for Office Programs
    3. C.3. Language Translation Features
    4. C.4. Accessibility Features
      1. C.4.1. Zoom
      2. C.4.2. Full Screen Reading
      3. C.4.3. Ease of Access