by Yvonne Johnson | Released February 2011 | ISBN: 9780132378024

Using Microsoft Office for Mac 2011 also has 58 instructional videos that walk you through steps in the book or provide you with additional information that supplements topics in the book. Video instructions cover such topics as using the Scrapbook in Word,creating AutoText entries, creating email signatures, setting recurring appointments and tasks, using conditional formatting in Excel, animating slide elements and applying slide transitions in PowerPoint, and uploading files to a SkyDrive folder. Additionally, 16 audio files also provide you with supplemental information on such topics as creating Automator workflows, macro and security issues, setting up an Exchange email account, editing master slides in PowerPoint, using absolute cell references in Excel, and working with documents on a Sharepoint server. Show and hide more

1. • Tell Me More Media 1.1—Creating Automator Workflows 00:05:18
   • Show Me Media 1.2—Printing a Document with the Print Command 00:04:09
   • Show Me Media 1.3—E-mailing a Document 00:01:14
   • Show Me Media 1.4—Creating a Calendar from a Template 00:04:17
2. • Show Me Media 2.1—Using Browse Objects to Navigate 00:02:43
   • Show Me Media 2.2—Using the Advanced Find and Replace Command 00:06:54
   • Show Me Media 2.3—Using the Scrapbook 00:06:12
   • Tell Me More Media 2.4—Setting Grammar Preferences 00:03:48
3. • Show Me Media 3.1—Setting Paragraph Alignment, Indents, and Spacing 00:05:40
   • Show Me Media 3.2—Setting Tabs in the Tabs Dialog Box 00:04:51
   • Show Me Media 3.3—Setting Tabs on the Ruler 00:03:27
   • Tell Me More Media 3.4—Using Quick Styles 00:03:01
   • Show Me Media 3.5—Drawing a Table 00:01:13
4. • Show Me Media 4.1—Creating an AutoText Entry 00:02:12
   • Show Me Media 4.2—Using the Thesaurus 00:02:24
   • Show Me Media 4.3—Recording a Macro 00:06:49
   • Tell Me More Media 4.4—Macros and Security Issues 00:02:43
   • Show Me Media 4.5—Removing the Background of a Photo 00:02:54
5. • Show Me Media 5.1—Numbering Text in a Notebook 00:01:33
   • Show Me Media 5.2—Recording Audio Notes in a Notebook 00:03:03
   • Tell Me More Media 5.3—Setting Audio Preferences 00:02:57
   • Show Me Media 5.4—Using the Scribble Tools 00:01:42
6. • Show Me Media 6.1—Using a Template to Create a Publication 00:03:43
   • Tell Me More Media 6.2—Exploring Lorem Ipsum Text 00:02:47
   • Show Me Media 6.3—Creating Linked Text Boxes and Filling Them with a Story 00:01:28
   • Show Me Media 6.4—Inserting a SmartArt Graphic 00:02:04
7. • Tell Me More Media 7.1—Setting Up an Exchange Account 00:03:35
   • Show Me Media 7.2—Applying a Background Color 00:02:14
   • Show Me Media 7.3—Creating Signatures 00:02:36
   • Show Me Media 7.4—Deleting E-mail Messages 00:02:21
8. • Tell Me More Media 8.1—Performing Advanced Searches 00:05:25
   • Show Me Media 8.2—Adding and Deleting Fields on a Contact Form 00:01:45
   • Show Me Media 8.3—Creating a Contact Group 00:03:08
   • Show Me Media 8.4—Adding and Deleting Categories 00:02:09
9. • Show Me Media 9.1—Customizing the Work View 00:01:19
   • Show Me Media 9.2—Creating a Nonrecurring Appointment 00:03:17
   • Show Me Media 9.3—Setting a Recurring Appointment 00:03:05
   • Tell Me More Media 9.4—Setting Preferences for My Day 00:03:21
10. • Show Me Media 10.1—Creating a Task 00:01:25
    • Show Me Media 10.2—Creating a Recurring Task 00:02:06
    • Show Me Media 10.3—Making Changes to a Task 00:01:43
    • Tell Me More Media 10.4—Creating Separate To-Do Lists with Categories 00:02:40
    • Show Me Media 10.5—Creating Notes 00:01:17
11. • Show Me Media 11.1—Adding a Slide 00:01:38
    • Show Me Media 11.2—Adding Text to a Placeholder 00:03:02
    • Show Me Media 11.3—Adding a Photo to a Placeholder 00:02:01
    • Show Me Media 11.4—Working with Layers 00:01:39
    • Show Me Media 11.5—Typing the Outline for a Presentation 00:03:52
    • Show Me Media 11.6—Creating a Presentation with Both Methods 00:03:40
    • Tell Me More Media 11.7—Editing the Master Slide Layouts 00:03:19
12. • Show Me Media 12.1—Assigning an Action 00:03:34
    • Show Me Media 12.2—Animating Slide Elements 00:04:29
    • Show Me Media 12.3—Applying a Transition 00:02:39
    • Tell Me More Media 12.4—Annotating Slides 00:01:56
13. • Show Me Media 13.1—Taking a Tour of the Excel Window 00:05:32
    • Show Me Media 13.2—Entering a Formula with the Pointing Method 00:01:50
    • Show Me Media 13.3—Copying Formulas with Relative Cell References 00:02:46
    • Tell Me More Media 13.4—Using Absolute Cell References 00:02:30
14. • Show Me Media 14.1—Inserting Cells Show Me—Importing Music 00:01:09
    • Show Me Media 14.2—Creating an Excel Style 00:02:57
    • Tell Me More Media 14.3—Using Conditional Formatting 00:06:58
    • Show Me Media 14.4—Modifying and Enhancing Charts 00:03:12
15. • Show Me Media 15.1—Sorting a Database on Multiple Fields 00:03:21
    • Tell Me More Media 15.2—Sorting on Conditional Formatting 00:02:08
    • Show Me Media 15.3—Filtering Data 00:02:57
    • Show Me Media 15.4—Using the Pointing Method for 3D Formulas 00:02:29
16. • Show Me Media 16.1—Reviewing Each Edit and Comment in Word 00:02:34
    • Show Me Media 16.2—Turning On and Protecting Track Changes in Excel 00:01:40
    • Show Me Media 16.3—Accepting and Rejecting Changes in Excel 00:01:56
    • Show Me Media 16.4—Comparing and Reviewing Presentations 00:03:17
17. • Show Me Media 17.1—Touring the Document Connection 00:02:45
    • Show Me Media 17.2—Uploading Files to a SkyDrive Folder 00:01:22
    • Tell Me More Media 17.3—Working with Documents on SharePoint 00:02:34
    • Show Me Media 17.4—Presenting a PowerPoint Presentation on the Web 00:03:27
Show and hide more