Books & Videos

Table of Contents

  1. Chapter 1 Introduction

    1. Keeping Up with the Macs

    2. More Integrated Than Ever

    3. What’s New in Office 2011

    4. The Very Basics

    5. About This Book

    6. About the Online Resources

    7. Safari® Books Online

  2. Word

    1. Chapter 2 Word Basics: Opening, Editing, Saving, Printing

      1. Document Basics Covered Quickly
      2. Creating New Documents
      3. Opening Documents
      4. Your Point of View
      5. Basic Editing in Word
      6. Undo, Redo and Repeat
      7. Save Me
      8. Printing from Word
    2. Chapter 3 Advanced Editing in Word

      1. Toolbars and the Ribbon
      2. Lists: Bulleted and Numbered
      3. Line, Page, and Column Breaks
      4. Find and Replace
      5. AutoText: Abbreviation Expanders
      6. Spelling and Grammar
      7. AutoCorrect
      8. Adding and Formatting Tables
      9. Inserting Photos and Media
      10. Recording and Running Macros
      11. Organizing Your Templates
    3. Chapter 4 Setting Up Documents and Pages

      1. Let Word Format Your Document Automatically
      2. Choose a Template
      3. Choose a Theme
      4. Choose a Quick Style
      5. Manually Formatting Your Document
      6. Choosing Paper Size and Layout
      7. Setting Margins
      8. Adding Color, Borders, and Watermarks
      9. Adding Page Numbers, Headers, and Footers
      10. Dividing Your Document into Sections
      11. Formatting Paragraphs with Styles
      12. Manual Paragraph Formatting
      13. Formatting Individual Characters
    4. Chapter 5 Printing Documents, Envelopes, and Labels

      1. Choosing a Printer
      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
      8. The Six Phases of a Mail Merge
      9. Running the Mail Merge Manager
      10. Advanced Merge Techniques
      11. Merging to Labels and Envelopes
    5. Chapter 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
      6. Notebook: Collecting Random Thoughts
      7. Navigating a Large Document
      8. Creating a Table of Contents
      9. Creating an Index
      10. Navigating with Hyperlinks
      11. Cross-Referencing Your Document
      12. Creating Footnotes and Endnotes
      13. Inserting Citations and Creating a Bibliography
    6. Chapter 7 Moving Beyond Text: Publishing Layout View

      1. Starting with a Template: Ready-to-Use Page Designs
      2. Choosing and Using a Template
      3. Adding, Removing and Rearranging Pages
      4. Adding Text and Text Boxes
      5. Adding Photos, Clip Art, and Other Graphics
    7. Chapter 8 Working Collaboratively

      1. Adding Comments
      2. Tracking Changes While Editing
      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
  3. Outlook

    1. Chapter 9 Outlook: Email and Life Management 101

      1. Starting Outlook the First Time
      2. Outlook Tour
      3. Sending Emails with Outlook
      4. Receiving Email
    2. Chapter 10 Managing Your Contacts

      1. Creating New Contacts
      2. Importing Contacts
      3. Creating Contact Groups
      4. Organizing and Searching for Contacts
      5. Printing Contacts
    3. Chapter 11 Calendar: Meetings, Tasks, and Notes

      1. Creating Appointments and Meetings
      2. Adding Meetings
      3. Filtering the Displayed Events
      4. Printing Calendars
      5. Be Your Own Task Master
      6. Taking Note
    4. Chapter 12 Customizing Outlook and Managing Data

      1. Changing the Look of Outlook
      2. Creating Your Own Categories
      3. Using Folders and Smart Folders
      4. Creating Smart Folders
      5. Creating Email Rules
      6. Create Multiple Outlook Identities
      7. Using My Day As Outlook Lite
  4. Excel

    1. Chapter 13 Basic Excel

      1. Spreadsheet Basics
      2. Formula Fundamentals
    2. Chapter 14 Building Advanced Workbooks

      1. Naming Cells and Ranges
      2. References: Absolute and Relative
      3. Workbooks and Worksheets
      4. Advanced Formula Magic
    3. Chapter 15 Excel Data Magic

      1. Excel Tables, the New List Maker
      2. Building Your Table
      3. Table Formatting Tricks
      4. Sorting and Filtering Your Table
      5. The Calculating Table
      6. Working with Databases
      7. Analyzing and Viewing Your Data
    4. Chapter 16 Excel Macros and Visual Basic

      1. Recording and Playing Macros
      2. Introducing Visual Basic for Applications
    5. Chapter 17 Formatting and Charts: Well-Dressed Spreadsheets

      1. Formatting Worksheets
      2. Charts
      3. Sparklines: Small, Intense, Simple Datawords
    6. Chapter 18 Printing and Sharing Spreadsheets

      1. Printing Worksheets
      2. Sharing a Workbook
  5. PowerPoint

    1. Chapter 19 Planning and Creating Great Presentations

      1. Planning the Presentation
      2. Delivering the Presentation
      3. Presentation Hardware
    2. Chapter 20 Building a PowerPoint Presentation

      1. Step 1. Choose a Template
      2. Step 2: Specify a Theme
      3. Step 3: Add Slides and Choose Layouts
      4. Step 4: Writing the Outline
      5. Step 5: Building the Show
      6. How to Build a Slide
    3. Chapter 21 Putting On the Show

      1. Adding Movement
      2. Putting On the Show
      3. Recycling Your Presentations
      4. Printing Your Presentation
  6. Office As a Whole

    1. Chapter 22 Making the Most of Graphics and Media

      1. Inserting a Graphic or Media Clip
      2. The Clip Art Gallery
      3. AutoShapes, Lines, SmartArt, and WordArt
      4. Modifying Graphics with the Format Dialog Box
      5. Storing Favorites in the Scrapbook
      6. Object Linking and Embedding (OLE)
    2. Chapter 23 Customizing Office

      1. Customizing the Ribbon
      2. Customizing Your Toolbars
      3. Redesigning Your Menus
      4. Reassigning Key Combinations
      5. AppleScripting Office
      6. What is AppleScript?
      7. Installing and Running Office Scripts
  7. Appendixes

    1. Appendix Installation and Troubleshooting

      1. Installing Office
      2. Troubleshooting
    2. Appendix The Office Help System

      1. Office Help
      2. Help from Mac OS X
      3. Web-Based Help
    3. Appendix Office 2011, Menu by Menu

      1. Application Menu
      2. Excel Menus
      3. File Menu
      4. Edit Menu
      5. View Menu
      6. Insert Menu
      7. Format Menu
      8. Tools Menu
      9. Data Menu
      10. Chart Menu
      11. Window Menu
      12. Help Menu
      13. Scripts Menu
      14. Outlook Menus
      15. File Menu
      16. Edit Menu
      17. View Menu
      18. Message Menu
      19. Draft
      20. Meeting
      21. Contact
      22. Task
      23. Note
      24. Format Menu
      25. Tools Menu
      26. Window Menu
      27. Help Menu
      28. Scripts Menu
      29. PowerPoint Menus
      30. File Menu
      31. Edit Menu
      32. View Menu
      33. Insert Menu
      34. Format Menu
      35. Arrange
      36. Tools Menu
      37. Slide Show Menu
      38. Window Menu
      39. Help Menu
      40. AppleScript Menu
      41. Word Menus
      42. File Menu
      43. Edit Menu
      44. View Menu
      45. Insert Menu
      46. Format Menu
      47. Font Menu
      48. Tools Menu
      49. Table Menu
      50. Window Menu
      51. AppleScript Menu
      52. Help Menu
    4. Appendix 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
      4. Working with the Office Web Apps
  1. Colophon