You are previewing Office 2011 for Macintosh: The Missing Manual.
O'Reilly logo
Office 2011 for Macintosh: The Missing Manual

Book Description

In Office 2011 for the Macintosh, Word, Excel, PowerPoint, and the new Outlook for Mac are packed with amazing features, but most people just know the basics. This entertaining guide not only gets you started, it reveals all kinds of useful things you didn't know the software could do -- with plenty of power-user tips and tricks when you're ready for more.

Table of Contents

  1. Office 2011 for Macintosh: The Missing Manual
  2. A Note Regarding Supplemental Files
  3. The Missing Credits
    1. About the Author
    2. About the Creative Team
    3. Acknowledgements
    4. The Missing Manual Series
  4. 1. Introduction
    1. Keeping Up with the Macs
    2. More Integrated Than Ever
    3. What’s New in Office 2011
      1. Word
      2. Outlook
      3. Excel
      4. PowerPoint
      5. Office as a Whole
    4. The Very Basics
    5. About This Book
      1. About the Outline
      2. About→These→Arrows
    6. About the Online Resources
      1. Missing CD
      2. Registration
      3. Feedback
      4. Errata
      5. Newsletter
    7. Safari® Books Online
  5. 1. Word
    1. 2. Word Basics: Opening, Editing, Saving, Printing
      1. Document Basics Covered Quickly
      2. Creating New Documents
        1. A Quick Tour of the Document Window
        2. The Minimalist’s Document Window
        3. Creating Documents from a Template
      3. Opening Documents
      4. Your Point of View
      5. Basic Editing in Word
        1. Natural (and Un-Natural) Selection
        2. Selecting Text with the Keyboard
      6. Undo, Redo and Repeat
      7. Save Me
        1. More Saving Graces
        2. Reducing File Size
        3. Document Password Protection
        4. Save to Web Page
        5. Share Word Documents via Email
      8. Printing from Word
    2. 3. Advanced Editing in Word
      1. Toolbars and the Ribbon
        1. The Standard Toolbar
        2. Introducing the Ribbon
        3. Space-saving Ribbon Tricks
      2. Lists: Bulleted and Numbered
        1. Making Lists with Bullets
        2. Making Numbered and Multi-level Lists
          1. Restart numbering at 1
          2. Managing Multi-level lists
        3. Customizing Word’s Automatic Lists
      3. Line, Page, and Column Breaks
        1. Paragraph Break
        2. Line Break
        3. Page Break
        4. Column Break
        5. Section Break
      4. Find and Replace
        1. Using the Search Box
        2. The Find and Replace Sidebar
        3. The Advanced Find and Replace Window
          1. Search and replace special characters
          2. Find specific formatting
      5. AutoText: Abbreviation Expanders
      6. Spelling and Grammar
        1. Check Spelling as You Type
        2. Checking Spelling and Grammar All at Once
        3. Spelling and Grammar Options
        4. Writing Styles
        5. Custom Dictionaries and Preferred Spellings
          1. Editing the custom dictionary
          2. Creating a new custom dictionary
          3. Adding and removing custom dictionaries
          4. Foreign language dictionaries
          5. Choosing custom dictionaries before spell checking
      7. AutoCorrect
      8. Adding and Formatting Tables
        1. Creating Tables
        2. Creating a Table from the Ribbon
        3. Using the Insert Table Box
        4. Drawing a Table
        5. Editing Your Table
        6. Formatting Tables
      9. Inserting Photos and Media
        1. Inserting a Photo
        2. Playing Audio and Video in your Word Documents
      10. Recording and Running Macros
        1. Creating a Macro
        2. Running a Macro
        3. The Macro Organizer
        4. Learning about Visual Basic
      11. Organizing Your Templates
    3. 4. Setting Up Documents and Pages
      1. Let Word Format Your Document Automatically
      2. Choose a Template
        1. Using Templates
        2. Modifying, Saving, and Installing Templates
      3. Choose a Theme
        1. Finding More Themes
        2. Saving and Sharing Custom Themes
      4. Choose a Quick Style
        1. Writing with Style
        2. Get a New Look with Quick Styles
      5. Manually Formatting Your Document
      6. Choosing Paper Size and Layout
        1. Changing Paper Size
        2. Setting Paper Orientation
      7. Setting Margins
        1. Selecting Preset Margins
        2. Setting Custom Margins
        3. Using the Ruler to Set Margins
        4. Setting Margins for Booklets
      8. Adding Color, Borders, and Watermarks
        1. Choosing Page Color
        2. Adding a Border
        3. Adding a Watermark
      9. Adding Page Numbers, Headers, and Footers
        1. Adding a Page Number
        2. Removing Page Numbers
        3. The Easy Way to Add Headers and Footers
        4. Manually Adding Headers and Footers
      10. Dividing Your Document into Sections
      11. Formatting Paragraphs with Styles
        1. Modifying an Existing Style
          1. Exploring the Modify Style box
        2. Overriding a Style Setting
          1. Reverting to the original style
          2. Clearing formatting
        3. Showing Style Guides
      12. Manual Paragraph Formatting
        1. Paragraph Alignment
        2. Indenting Paragraphs
          1. Using the ruler to indent paragraphs
        3. Spacing Between Paragraphs
        4. Spacing Between Lines
        5. Setting Tabs
          1. How tab stops work
          2. Viewing tab marks in your text
          3. Deleting and editing tabs
        6. Types of Tabs
          1. Tab Leaders
        7. Managing Tab Settings with the Ruler
          1. Setting tab stops
          2. Adjusting and removing tab stops with the ruler
        8. Managing Line and Page Breaks
      13. Formatting Individual Characters
        1. Formatting as You Type with Shortcut Keys
        2. Formatting with the Ribbon or the Font Box
        3. Changing Capitalization
        4. Small Caps for Headers
        5. Advanced Font Formatting
    4. 5. Printing Documents, Envelopes, and Labels
      1. Choosing a Printer
        1. Setting Your Default Printer
        2. Advanced Print Settings
        3. Exploring Printer-Specific Properties
      2. Printing to an Adobe PDF File
      3. Printing Part of Your Document
      4. Printing Envelopes
      5. Printing Labels
      6. Changing Your Print Preferences
      7. Understanding Mail Merge Basics
        1. Common Types of Merge Documents
        2. Mail Merge Lists
      8. The Six Phases of a Mail Merge
      9. Running the Mail Merge Manager
        1. 1. Select Document Type
        2. 2. Select Recipients List
        3. 3. Insert Placeholders
        4. 4. Filter Recipients
          1. Choosing a comparison option
          2. Sorting your recipient list
        5. 5. Preview Results
          1. Editing before the merge
        6. Complete Merge
      10. Advanced Merge Techniques
      11. Merging to Labels and Envelopes
        1. Merging to Labels
          1. Editing labels
          2. Yet another way to format labels
        2. Merging to Envelopes
    5. 6. Working with Long Documents
      1. Switching to Outline View
      2. Promoting and Demoting Headings
      3. Controlling Subheads During Promotion or Demotion
      4. Moving Outline Items
      5. Showing Parts of Your Outline
        1. Expanding and Collapsing Levels
        2. Showing and Hiding Text
        3. Showing Only the First Line
        4. Showing Text Formatting
      6. Notebook: Collecting Random Thoughts
        1. Opening Your Notebook
        2. The Notebook Ribbon
          1. Use the Home tab for daily note taking
          2. Changing your notebook’s appearance
          3. Audio Notes tab when you don’t want to write
        3. Organizing Your Notes
          1. Setting text levels with the keyboard and mouse
          2. Sorting headings
        4. Placing Notes Beside Your Notes
          1. Flagging action items
          2. Important enough to track in Outlook?
        5. Typing Less with Audio Notes
          1. Entering an audio note
          2. Listening to an audio note
        6. Manipulating Notebook Sections
          1. Labeling sections
          2. To line or not to line
          3. Numbering Pages
      7. Navigating a Large Document
        1. Understanding Sections
      8. Creating a Table of Contents
        1. Updating Your Table of Contents
        2. TOC the Harder Way: Using Other Styles
        3. Formatting Your Table of Contents
          1. Quick formatting for tables of contents
          2. Detailed formatting for tables of contents
        4. Deleting a Table of Contents
      9. Creating an Index
        1. Marking an Index Entry
        2. Building an Index
        3. Updating an Index
        4. Deleting an Index
        5. Deleting an Index Entry
      10. Navigating with Hyperlinks
        1. Inserting and Removing Bookmarks
      11. Cross-Referencing Your Document
        1. Deleting Cross-References
        2. Cross-Referencing Figures
        3. Making a Table of Figures
      12. Creating Footnotes and Endnotes
        1. Inserting Footnotes and Endnotes
        2. Formatting Footnotes and Endnotes
          1. Deleting footnote and endnotes
      13. Inserting Citations and Creating a Bibliography
        1. Adding a Citation
        2. Adding a Bibliography
    6. 7. Moving Beyond Text: Publishing Layout View
      1. Starting with a Template: Ready-to-Use Page Designs
      2. Choosing and Using a Template
        1. Arranging the Way Objects Overlap
      3. Adding, Removing and Rearranging Pages
        1. Managing Master Pages
      4. Adding Text and Text Boxes
        1. Formatting Text
        2. Add Color to Your Text Box
        3. Flowing Text Between Boxes
      5. Adding Photos, Clip Art, and Other Graphics
        1. Formatting Graphics
        2. Aligning Objects on the Page
    7. 8. Working Collaboratively
      1. Adding Comments
        1. Deleting Comments
        2. Highlighting Text
      2. Tracking Changes While Editing
        1. Tracking and Viewing Changes
          1. Showing and hiding types of changes
          2. Showing and hiding reviewers’ markup
          3. Customizing your markup view
      3. Printing Edits and Markup
      4. Accepting and Rejecting Changes
      5. Comparing and Merging Documents
      6. Merging Two Documents
      7. Protecting Your Document from Changes
      8. Sharing Documents over SkyDrive or SharePoint
        1. Sharing with SharePoint
  6. 2. Outlook
    1. 9. Outlook: Email and Life Management 101
      1. Starting Outlook the First Time
      2. Outlook Tour
      3. Sending Emails with Outlook
        1. Email Fancy Formatting
        2. Embedding a Picture in Your Email
          1. Adding a Background Picture or Color
        3. Getting Photos from Cameras, Scanners, and Screenshots
        4. Sending Attachments with Your Email
        5. Adding Hyperlinks to Your Email
        6. Creating and Using Email Signatures
        7. About Digitally Signed and Encrypted Email
      4. Receiving Email
        1. Downloading Pictures
        2. Categorize and Arrange Your Emails
        3. Setting Up a Schedule to Send and Receive Email
        4. Managing Junk Mail
    2. 10. Managing Your Contacts
      1. Creating New Contacts
        1. Adding Email Senders to Your Contacts
          1. Adding contact vCards
        2. Editing, Adding and Deleting Contacts
        3. Putting Contacts on the Map
        4. Syncing Outlook Contacts with Your Mac Address Book
      2. Importing Contacts
        1. Importing Contacts and Other Data from Outlook for Windows
      3. Creating Contact Groups
      4. Organizing and Searching for Contacts
      5. Printing Contacts
    3. 11. Calendar: Meetings, Tasks, and Notes
      1. Creating Appointments and Meetings
        1. Adding Appointments
        2. Editing and Deleting Appointments
        3. Creating Recurring Appointments
      2. Adding Meetings
        1. Sending Updates and Canceling Meetings
        2. Responding to a Meeting Invitation
        3. Adding Holidays to Your Calendar
        4. Removing Holidays
      3. Filtering the Displayed Events
      4. Printing Calendars
      5. Be Your Own Task Master
      6. Taking Note
        1. Creating Notes
        2. Emailing and Forwarding Notes
        3. Printing Notes
    4. 12. Customizing Outlook and Managing Data
      1. Changing the Look of Outlook
      2. Creating Your Own Categories
        1. Using Categories to Filter the View
          1. Working with categories in E-mail view
      3. Using Folders and Smart Folders
        1. Manually Adding Folders in Notes and Email
      4. Creating Smart Folders
        1. Using Advanced Searches to Create Smart Folders
      5. Creating Email Rules
      6. Create Multiple Outlook Identities
      7. Using My Day As Outlook Lite
  7. 3. Excel
    1. 13. Basic Excel
      1. Spreadsheet Basics
        1. Opening a Spreadsheet
        2. Data Entry
        3. Basic Formatting
        4. Kinds of Data
          1. Numbers
          2. Text
          3. Dates
          4. Times
        5. Tedium Savings 1: AutoComplete
        6. Tedium Savings 2: Formula AutoComplete
        7. Tedium Savings 3: AutoFill
          1. Using the Fill handle
        8. Selecting Cells (and Cell Ranges)
        9. Moving Things Around
          1. Cutting, copying, and pasting
          2. Paste Special
          3. Drag-and-drop
        10. Inserting and Removing Cells
        11. Find and Replace
        12. Erasing Cells
        13. Tutorial 1: Entering Data
      2. Formula Fundamentals
        1. Basic Calculations
          1. Error checking
        2. Functions
          1. Function screen tips and AutoComplete
          2. The AutoSum button
          3. Looking up functions with the Formula Builder
        3. Order of Calculation
        4. Tutorial 2: Yearly Totals
    2. 14. Building Advanced Workbooks
      1. Naming Cells and Ranges
        1. Creating Names Quickly
        2. Using Names to Look Up Data
      2. References: Absolute and Relative
      3. Workbooks and Worksheets
        1. Working with Multiple Worksheets
        2. Exporting Files
          1. Excel 97-2004 Workbook (.xls)
          2. Comma separated values (.csv)
          3. Tab delimited text (.txt)
          4. Excel template (.xltx)
          5. Web page
          6. Spreadsheet properties
      4. Advanced Formula Magic
        1. Nested Formulas
        2. The Formula Builder
        3. Circular References
          1. Iterations
        4. Connecting to Other Workbooks
        5. Auditing
    3. 15. Excel Data Magic
      1. Excel Tables, the New List Maker
      2. Building Your Table
        1. Naming Your Table and Renaming Headers
        2. Adding New Records and Fields
        3. Rearranging Rows and Columns
        4. Deleting Records, Fields, and Entire Tables
        5. Converting and Deleting a Table
      3. Table Formatting Tricks
        1. Automatic Formatting with Table Options
        2. Conditional Formatting for Cells
      4. Sorting and Filtering Your Table
        1. Hide and Seek with Table Filters
        2. Applying Multiple Filters
      5. The Calculating Table
        1. Building a Lookup Formula for Your Table
      6. Working with Databases
        1. Fetching FileMaker Pro Data
          1. Step 1: Import the database
          2. Step 2: Choose only the data you want
        2. Grabbing Data from the Web
        3. Importing Data from a Text File
      7. Analyzing and Viewing Your Data
        1. Making a PivotTable
          1. Step 1: Choose the data source
          2. Step 2: Choose the cells
          3. Step 3: Pivot
          4. Step 4: Build the table
          5. Step 6: Massage the data
        2. What If Tools Analyze Your Data
          1. Data tables
          2. Goal seek
          3. Scenarios
          4. Tapping the Data menu
        3. Viewing Your Data
          1. Custom views
          2. Outlining
        4. Flag for Follow-Up
        5. Adding a Comment
    4. 16. Excel Macros and Visual Basic
      1. Recording and Playing Macros
        1. Playing and Saving Macros
        2. Absolute vs. Relative Cell References
        3. Using Formulas in Macros
        4. Making Macros Always Available
      2. Introducing Visual Basic for Applications
        1. Opening a Recorded Macro in Visual Basic
        2. Referencing Cells the VB Way
        3. Changing the Contents of a Cell
        4. Getting More Visual Basic Help
    5. 17. Formatting and Charts: Well-Dressed Spreadsheets
      1. Formatting Worksheets
        1. Automatic Formatting with Table Styles
          1. Automatic formatting bonus
        2. The Format Painter
        3. Formatting Cells by Hand
          1. Changing cell size
          2. Hiding and showing rows and columns
        4. Format Cells with Borders and Fill Color
          1. Removing borders
        5. Setting Cell Fill Colors
        6. Changing How Text Looks
          1. Adding number formats
          2. Add or remove decimal places
          3. Changing fonts
          4. Changing the standard fonts
          5. Aligning text
          6. Merging cells
        7. Adding Pictures, Movies, and Text Boxes
          1. Inserting by the Insert menu
      2. Charts
        1. Chart Parts
        2. Step 1: Select the Data
        3. Step 2: Choose a Chart Style
        4. Step 3: Check Your Results
        5. Step 4: Design the Chart Content
        6. Step 5: Refine the Chart’s Appearance
        7. Transparent Bars
        8. Advanced Analysis Charting
          1. Error bars
          2. Trend lines
      3. Sparklines: Small, Intense, Simple Datawords
        1. Formatting Sparklines
        2. Moving and Removing Sparklines
    6. 18. Printing and Sharing Spreadsheets
      1. Printing Worksheets
        1. Print Preview
        2. Print to PDF Files
        3. Page Setup
          1. Page orientation
          2. Margins tab
          3. Header/Footer tab
          4. Sheet tab
      2. Sharing a Workbook
        1. Protecting the Spreadsheet
        2. Tracking Changes
        3. Merging Workbooks
  8. 4. PowerPoint
    1. 19. Planning and Creating Great Presentations
      1. Planning the Presentation
        1. The Goals of Your Presentation
        2. Know Your Audience
        3. Tailor the Presentation to the Audience
        4. Outline the Presentation
        5. Build Your Presentation
        6. Practice
      2. Delivering the Presentation
        1. Welcome Your Audience
        2. Introduce Your Presentation
        3. Making the Presentation
        4. Review
        5. Evaluating the Presentation
          1. Designing an evaluation form
      3. Presentation Hardware
        1. Laptops
        2. Projectors
          1. Choosing a projector
          2. Renting projectors
          3. Projection screens
        3. Remote Controls
    2. 20. Building a PowerPoint Presentation
      1. Step 1. Choose a Template
        1. The Three-Pane View
      2. Step 2: Specify a Theme
      3. Step 3: Add Slides and Choose Layouts
        1. Changing Themes in Midstream
      4. Step 4: Writing the Outline
        1. Using a Word Outline
      5. Step 5: Building the Show
        1. Using Masters
          1. Slide master
          2. Editing the slide master
          3. Adding new elements to a slide master
          4. Slide layouts
          5. Modifying slide layouts
          6. Handout master
          7. Notes master
        2. View Controls
        3. Navigation
        4. Manipulating Your Slides
          1. Inserting new slides
          2. Inserting slides from other presentations
          3. Duplicating a slide
          4. Deleting a slide
          5. Moving slides around
          6. Hiding slides
      6. How to Build a Slide
        1. Using Backgrounds
          1. Changing backgrounds
        2. Working with Text
          1. Editing and formatting text
          2. Formatting bullets
          3. Other characters as bullets
          4. Graphics as bullets
        3. Adding Graphics, Charts, and Tables
          1. Graphics
          2. Tables
          3. Charts
        4. Movies and Sounds
          1. Format Movie options
          2. Format Audio options
          3. Record your own audio
        5. Other Objects
          1. Hyperlink
    3. 21. Putting On the Show
      1. Adding Movement
        1. Transitions
          1. Add a transition
          2. Choosing transition styles
          3. Subtle
          4. Exciting
          5. Dynamic Content
          6. Customizing your transitions
        2. Multimedia Effects
        3. Adding Animations
        4. Putting Controls on Slides
        5. Adding Narration
          1. Adding a soundtrack
      2. Putting On the Show
        1. Setting Up
        2. Rehearsing Your Presentation
        3. Choosing a Navigation Scheme
        4. Presenting Onscreen
        5. Controlling the Show
        6. Using Presenter View
      3. Recycling Your Presentations
        1. Saving Presentations as QuickTime Movies
        2. Broadcasting Presentations on the Web
        3. Saving Slides as Graphics
          1. Send to iPhoto
          2. Save as Pictures
      4. Printing Your Presentation
        1. Page Setup
        2. Printing Your Slides
        3. Notes and Handouts
  9. 5. Office As a Whole
    1. 22. Making the Most of Graphics and Media
      1. Inserting a Graphic or Media Clip
      2. The Clip Art Gallery
        1. Categories
        2. Online
        3. Adding Your Own Clips
        4. Deleting Clips
        5. Search
        6. Working with Clip Art
      3. AutoShapes, Lines, SmartArt, and WordArt
        1. AutoShapes
        2. Lines
        3. Formatting and Editing Shapes and Lines
        4. SmartArt Graphics
        5. WordArt
        6. Aligning Objects
          1. The Drawing grid
          2. Rotating drawing objects
      4. Modifying Graphics with the Format Dialog Box
        1. Formatting Fills
          1. Fill Color: Standard palette
          2. Fill Color: More Colors
          3. Format fill: Gradients
          4. Format fill: Picture or Texture
          5. Format fill: Pattern
        2. Drawing Lines
        3. Adding Shadows
        4. Glow and Soft Edges Effects
        5. Creating Reflections
        6. 3-D Format
        7. 3-D Rotation
        8. Adjust Picture
        9. Artistic Filters
        10. Cropping Graphics
        11. Formatting Text Boxes
        12. Size Adjustments
        13. Adjust Position
      5. Storing Favorites in the Scrapbook
      6. Object Linking and Embedding (OLE)
        1. Creating Linked Objects
        2. Editing Linked Objects
        3. Repairing a Broken Link
        4. Overriding Automatic Updating
        5. Creating Embedded Objects
        6. Editing Embedded Objects
    2. 23. Customizing Office
      1. Customizing the Ribbon
      2. Customizing Your Toolbars
        1. Showing Other Toolbars
        2. Creating Custom Toolbars
          1. To move a button or delete it from a toolbar
          2. To add a button to a toolbar
          3. To design a new toolbar from scratch
        3. Attaching Custom Toolbars to Documents
      3. Redesigning Your Menus
        1. Adding a Command
        2. Removing a Menu Command
        3. Adding a Menu
        4. Removing a Menu
        5. Moving Whole Menus, or Specific Commands
        6. Resetting Everything Back to Normal
      4. Reassigning Key Combinations
      5. AppleScripting Office
      6. What is AppleScript?
        1. Why Use AppleScript?
      7. Installing and Running Office Scripts
        1. Installing Applets and Droplets
        2. Installing Script Menu Scripts
        3. Running the Scripts
  10. 6. Appendixes
    1. A. Installation and Troubleshooting
      1. Installing Office
        1. Using the Installer
        2. Removing Office
      2. Troubleshooting
        1. Check for a Bad Settings or Preference File
        2. Uninstall and Reinstall Office
        3. Research Your Problem Online
    2. B. The Office Help System
      1. Office Help
      2. Help from Mac OS X
      3. Web-Based Help
    3. C. Office 2011, Menu by Menu
      1. Application Menu
        1. About [Program Name]
        2. Online Registration
        3. Application Menu Preferences
        4. Work Offline (Outlook only)
        5. Turn Off (or On) Office Reminders (Outlook only)
        6. Services
        7. Hide [Program Name]
        8. Hide Others
        9. Show All
        10. Quit [Program Name]
      2. Excel Menus
      3. File Menu
        1. New Workbook
        2. New from Template
        3. Open
        4. Open URL
        5. Open Recent
        6. Close
        7. Save
        8. Save As
        9. Save as Web Page
        10. Save Layout
        11. Web Page Preview
        12. Page Setup
        13. Print Area
        14. Print
        15. Properties
      4. Edit Menu
        1. Undo
        2. Repeat/Redo
        3. Cut, Copy, Copy to Scrapbook
        4. Paste, Paste from Scrapbook, Paste Special
        5. Paste Special
        6. Fill
        7. Clear
        8. Delete
        9. Delete Sheet
        10. Move or Copy Sheet
        11. Find
        12. Replace
        13. Go To
        14. Links
        15. Object
      5. View Menu
        1. Normal
        2. Page Layout
        3. Ribbon
        4. Toolbars
        5. Formula Bar
        6. Status Bar
        7. Media Browser
        8. Toolbox
        9. Formula Builder
        10. Scrapbook
        11. Reference Tools
        12. Compatibility Report
        13. Header and Footer
        14. Comments
        15. Ruler
        16. Custom Views
        17. Full Screen
        18. Zoom
        19. Sized with Window
        20. Chart Window
      6. Insert Menu
        1. Cells
        2. Rows
        3. Columns
        4. Chart
        5. Sparklines
        6. Table
        7. Sheet
        8. Page Break
        9. Function
        10. Name
        11. New Comment
        12. Photo
        13. Audio
        14. Movie
        15. Clip Art
        16. Symbol
        17. Shape
        18. Text Box
        19. SmartArt Graphic
        20. WordArt
        21. Object
        22. Hyperlink
      7. Format Menu
        1. Cells
        2. Row
        3. Column
        4. Selected Chart Area
        5. Sheet
        6. Conditional Formatting
        7. Style
      8. Tools Menu
        1. Spelling
        2. Thesaurus
        3. Dictionary
        4. Language
        5. AutoCorrect
        6. Error Checking
        7. Share Workbook
        8. Track Changes
        9. Merge Workbooks
        10. Protection
        11. Flag for Follow Up
        12. Goal Seek
        13. Scenarios
        14. Auditing
        15. Macros
        16. Add-Ins
        17. Customize Keyboard
      9. Data Menu
        1. Sort
        2. Filter
        3. Clear Filters
        4. Advanced Filter
        5. Form
        6. Subtotals
        7. Validation
        8. Data Table
        9. Text to Columns
        10. Consolidate
        11. Group and Outline
        12. PivotTable Report
        13. Get External Data
        14. Refresh Data
      10. Chart Menu
        1. Chart Type
        2. Save as Template
        3. Move Chart
        4. Source Data
        5. Add Data
        6. Add Trendline
        7. 3-D Rotation
      11. Window Menu
        1. Minimize
        2. Zoom Window
        3. Bring All to Front
        4. New Window
        5. Arrange
        6. Hide
        7. Unhide
        8. Split
        9. Freeze Panes
        10. Window List
      12. Help Menu
        1. Search
        2. Excel Help
        3. Welcome to Excel
        4. Get Started with Excel
        5. Check for Updates
        6. Visit the Product Web Site
        7. Send Feedback about Excel
      13. Scripts Menu
        1. About this Menu
        2. Sample Automator Workflows
      14. Outlook Menus
      15. File Menu
        1. New
        2. Open
        3. Open Another User’s Folder
        4. Close
        5. Save
        6. Save As
        7. Folder
        8. Import
        9. Export
        10. Page Setup
        11. Print
      16. Edit Menu
        1. Undo
        2. Redo
        3. Cut
        4. Copy
        5. Copy to Scrapbook
        6. Paste
        7. Paste From Scrapbook
        8. Paste and Match Style
        9. Clear
        10. Select All
        11. Duplicate
        12. Delete
        13. Find
        14. Spelling and Grammar
        15. Substitutions
        16. Transformations
        17. Speech
        18. Special Characters
      17. View Menu
        1. Previous
        2. Next
        3. Go To
        4. Columns
        5. Arrange By
        6. View specific Menus:
        7. Reading Pane
        8. Media Browser
        9. Toolbox – Scrapbook
        10. Toolbox – Reference Tools
        11. Navigation Pane
        12. Ribbon
        13. Hide/Show Toolbar
        14. Customize Toolbar
      18. Message Menu
        1. Reply
        2. Reply to All
        3. Forward
        4. Forward Special
        5. Forward as Attachment
        6. Mark as Read
        7. Mark as Unread
        8. Mark All as Read
        9. Attachments
        10. Sender
        11. Junk Mail
        12. Priority
        13. Follow Up
        14. Categorize
        15. Rules
        16. Move
      19. Draft
        1. Send
        2. HTML Format
        3. Check Names.
        4. Attachments
        5. Signatures
        6. Security
        7. Priority
        8. Follow Up
        9. Categorize
      20. Meeting
        1. Invite Attendees
        2. Recurrence
        3. Time Zone
        4. Signatures
        5. Show As
        6. Private
        7. Categorize
      21. Contact
        1. New E-Mail Message To
        2. New Meeting With
        3. New IM Contact
        4. Forward as vCard
        5. Map Address
        6. Update from Directory
        7. This Contact is Me
        8. Follow Up
        9. Categorize
        10. Move
      22. Task
        1. Mark as Complete
        2. Reply
        3. Reply All
        4. Forward
        5. Recurrence
        6. Priority
        7. Follow Up
        8. Categorize
        9. Move
      23. Note
        1. Forward as Email
        2. Forward as Attachment
        3. Categorize
        4. Move
      24. Format Menu
        1. Font
        2. Style
        3. Size
        4. Color
        5. Highlight
        6. Text Encoding
        7. Increase Font Size
        8. Decrease Font Size
        9. Alignment
        10. Numbered List
        11. Bulleted List
        12. Increase Indent
        13. Decrease Indent
        14. Hyperlink
      25. Tools Menu
        1. Run Schedule
        2. Send & Receive
        3. IMAP Folders
        4. Out of Office (used with Exchange)
        5. Public Folders (used with Exchange)
        6. Rules
        7. Junk E-Mail Protection
        8. Accounts
      26. Window Menu
        1. Minimize
        2. Zoom Window
        3. Progress
        4. Error Log
        5. My Day
        6. Contact Search
        7. Window List
      27. Help Menu
        1. Search
        2. Outlook Help
        3. Welcome to Outlook
        4. Get Started with Outlook
        5. Check for Updates
        6. Visit the Product Web Site
        7. Send Feedback about Outlook
      28. Scripts Menu
        1. About this Menu
      29. PowerPoint Menus
      30. File Menu
        1. New, New from Template, Open, Open URL, Open Recent, Close, Save, Save As
        2. Save as Pictures
        3. Save as Movie
        4. Share
        5. Reduce File Size
        6. Restrict Permissions
        7. Page Setup, Print
        8. Properties
      31. Edit Menu
        1. Undo, Repeat/Redo, Cut, Copy, Copy to Scrapbook
        2. Paste, Paste from Scrapbook
        3. Paste Special
        4. Clear
        5. Select All
        6. Duplicate
        7. Delete Slide
        8. Find
        9. Special Characters
        10. Object
      32. View Menu
        1. Normal, Slide Sorter, Notes Page, Presenter View, Slide Show
        2. Master
        3. Ribbon
        4. Toolbars
        5. Message Bar
        6. Media Browser
        7. Toolbox
        8. Custom Animation
        9. Scrapbook
        10. Reference Tools
        11. Compatibility Report
        12. Header and Footer
        13. Comments
        14. Ruler
        15. Guides
        16. Zoom
      33. Insert Menu
        1. New Slide
        2. Duplicate Slide
        3. Slides From
        4. Section
        5. Text Box
        6. WordArt
        7. Header and Footer
        8. Date and Time
        9. Slide Number
        10. Table
        11. Chart
        12. SmartArt Graphic
        13. Photo, Audio, Movie, Clip Art, Symbol, Shape, Object, and Hyperlink
      34. Format Menu
        1. Font
        2. Paragraph
        3. Bullets and Numbering
        4. Columns
        5. Alignment
        6. Text Direction
        7. Change Case
        8. Replace Fonts
        9. Theme Colors
        10. Slide Background
        11. Shape
      35. Arrange
        1. Reorder Objects
        2. Reorder Overlapping Objects
        3. Bring to Front
        4. Send to Back
        5. Bring Forward
        6. Send Backward
        7. Group
        8. Ungroup
        9. Regroup
        10. Rotate or Flip
        11. Align or Distribute
      36. Tools Menu
        1. Spelling, Thesaurus, Dictionary, Language, AutoCorrect, Flag for Follow Up
        2. Macros
        3. Add-Ins
      37. Slide Show Menu
        1. Play from Start
        2. Play from Current Slide
        3. Broadcast Slide Show
        4. Custom Shows
        5. Presenter View
        6. Rehearse
        7. Record Slide Show
        8. Action Buttons
        9. Action Settings
        10. Custom Animation
        11. Transitions
        12. Hide Slide
        13. Set Up Show
      38. Window Menu
        1. Minimize Window, Zoom Window, New Window, Arrange All, Bring All to Front
        2. Cascade
        3. Next Pane
        4. Window List
      39. Help Menu
      40. AppleScript Menu
      41. Word Menus
      42. File Menu
        1. New Blank Document, New from Template, Open, Open URL, Open Recent, Close, Save, Save As
        2. Save as Web Page
        3. Share
        4. Web Page Preview
        5. Restrict Permissions
        6. Reduce File Size
        7. Page Setup, Print
        8. Properties
      43. Edit Menu
        1. Undo, Repeat/Redo, Cut, Copy, Copy to Scrapbook
        2. Paste, Paste Special
        3. Paste and Match Formatting
        4. Clear
        5. Select All
        6. Links
        7. Object
      44. View Menu
        1. Draft, Web Layout, Outline, Print Layout, Notebook Layout, Publishing Layout, Full Screen
        2. Ribbon
        3. Toolbars
        4. Sidebar
        5. Message Bar
        6. Toolbox
        7. Styles
        8. Citations
        9. Scrapbook
        10. Reference Tools
        11. Compatibility Report
        12. Ruler
        13. Header and Footer
        14. Footnotes
        15. Master Document
        16. Markup
        17. Reveal Formatting
        18. Zoom
      45. Insert Menu
        1. Break
        2. Page Numbers
        3. Date and Time
        4. AutoText
        5. Field
        6. New Comment
        7. Caption
        8. Cross-reference
        9. Index and Tables
        10. Watermark
        11. Tables
        12. Chart
        13. SmartArt Graphic
        14. Photo, Audio, Movie, Clip Art, Symbol, Shape,
        15. Text Box
        16. WordArt
        17. Equation
        18. File
        19. Object
        20. HTML Object
        21. Bookmark
        22. Hyperlink
      46. Format Menu
        1. Font
        2. Paragraph
        3. Document
        4. Bullets and Numbering
        5. Borders and Shading
        6. Columns
        7. Tabs
        8. Drop Cap
        9. Text Direction
        10. Change Case
        11. AutoFormat
        12. Style
        13. [Object]
      47. Font Menu
      48. Tools Menu
        1. Spelling and Grammar
        2. Thesaurus
        3. Hyphenation
        4. Dictionary
        5. Language
        6. Word Count
        7. AutoCorrect
        8. Track Changes
        9. Merge Documents
        10. Protect Document
        11. Block Authors
        12. Unblock All My Blocked Areas
        13. Protect Documents
        14. Flag for Follow Up
        15. Mail Merge Manager
        16. Envelopes
        17. Labels
        18. Letter Wizard
        19. Contacts
        20. Macros
        21. Templates and Add-Ins
        22. Customize Keyboard
      49. Table Menu
        1. Draw Table
        2. Insert
        3. Delete
        4. Select
        5. Merge Cells
        6. Split Cells
        7. Split Table
        8. AutoFit and Distribute
        9. Heading Rows Repeat
        10. Convert
        11. Sort
        12. Formula
        13. Gridlines
        14. Table Properties
      50. Window Menu
        1. Zoom Window, Minimize Window, Bring All to Front
        2. New Window
        3. Arrange All
        4. Split
        5. Window List
      51. AppleScript Menu
      52. Help Menu
    4. D. SkyDrive and Office Web Apps
      1. Why Compute in the Cloud?
      2. Signing Up for SkyDrive and Office Web Apps
      3. Storing Files on SkyDrive
        1. Using the Document Connection to SkyDrive
        2. Creating SkyDrive and Sharing Folders
        3. Managing Your SkyDrive Folders
      4. Working with the Office Web Apps
        1. Moving Documents Between Web Apps and Office 2011 Programs
  11. Index
  12. About the Author
  13. Colophon
  14. Copyright