O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Office 2007 LiveLessons

Video Description

You’ve got Microsoft Office 2007...now get the most out of it, faster and more easily than ever before! In 50 quick video lessons, J. Peter Bruzzese shows you all you need to maximize your productivity with Office 2007’s best tools and shortcuts, and its brand-new ribbon interface! Microsoft Office 2007 teaches Office 2007’s most sophisticated features and techniques visually: just watch! You’ll master high-powered Office 2007 skills at your own pace--and get specific answers and solutions immediately, whenever you need them! These practical videos simplify powerful Office 2007 features like Word mail merges, blog editing, and document encryption...Excel PivotTables, conditional formatting, and automatic data entry...SmartArt and PowerPoint slide masters...Outlook’s new To-Do Bar and RSS feeds...and plenty more!

Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading experts.

  • LiveLessons are video courses that are organized into bite-sized, self-contained sessions--you’ll learn key skills in as little as five minutes!

  • Each session begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.

  • Follow along as your instructor shows exactly how to get great results in your real-world environment.

  • Section 1:  Getting Started with Office 2007                                                                     

    Lesson 1:  An Initial Tour of Office 2007  [4:41]

    Lesson 2:  File Formats and Compatibility Solutions   [6:23]

    Lesson 3:  Working with Themes between Office Applications [6:16]

    Lesson 4:  Utilizing Help in Office 2007   [4:15]

    Lesson 5:  Setting Options for Office and Individual Applications  [4:28]

    Project 1:  Create the Ultimate Office Working Environment  [6:18]

    Section 2:  Word 2007

    Lesson 6:  Finding All Your Favorite Tools  [6:30]

    Lesson 7:  Document Encryption (and more)  [9:03]

    Lesson 8:  Using Word as a Blog Editor [3:56]

    Lesson 9:  Inspect Your Document and Remove Metadata [5:00]

    Lesson 10:  Working with Tables  [6:53]

    Lesson 11:  Convert a Document to PDF or XPS  [6:32]

    Lesson 12:  Using Academic Tools (Footnotes, Endnotes, Citations)  [7:25]

    Lesson 13:  Using Track Changes and Comments [8:38]

    Lesson 14:  Quick Parts and the Building Block Organizer [5:59]

    Lesson 15:   How to Perform a Mail Merge  [9:10]

    Project 2:  Create a Three-Fold Brochure  [6:55]

    Section 3:  Excel 2007

    Lesson 16:  Maneuvering Through Workbooks and Worksheets  [9:48]

    Lesson 17:  Automatic Data Entry Methods   [8:59]

    Lesson 18:  Formatting Cells Manually, with Styles, and with Themes  [8:42]

    Lesson 19:  Conditional Formatting (Data Bars, Color Scales, Icon Sets) [4:56]

    Lesson 20:  Basic Excel Formulas  [3:30]

    Lesson 21:  Basic Excel Functions   [9:44]

    Lesson 22:  Excel Function Groups (Advanced Function Possibilities) [4:58]

    Lesson 23:  Troubleshoot Function Errors  [8:31]

    Lesson 24:  Use Tables to Sort and Filter Data    [8:17]

    Lesson 25:  Creating Pivot Tables  [7:45]

    Lesson 26:  Protecting Your Workbook and Worksheets [11:55]

    Lesson 27:  Illustrations and Smart Art in Excel  [10:16]

    Lesson 28:  Basic Chart Building  [10:42]

    Lesson 29:  Advanced Chart Creation   [12:17]

    Lesson 30:  Printing Your Worksheets [6:13]

    Project 3:  Working with a Loan Amortization Table [7:14]

    Section 4:  PowerPoint 2007

    Lesson 31:  Create a Simple Slide Show  [6:45]

    Lesson 32:  Insert Graphics, SmartArt, and Charts  [6:12]

    Lesson 33:  Add Movies and Sound to Your Presentation  [8:21]

    Lesson 34:  Slide Animations and Transitions [8:52]

    Lesson 35:  Altering the Design of Your Presentation  [5:58]

    Lesson 36:  Using the Presenter View   [6:40]

    Lesson 37:  Record and Rehearse Timings for Your Presentation  [5:39]

    Lesson 38:  Changing Slide Masters  [4:48]

    Lesson 39:  Working with Handout and Notes Masters  [4:38]

    Lesson 40:  Working with PowerPoint Print Features  [4:25]

    Project 4:  Add a Photo Album to Your Presentation [6:33]

    Section 5:  Outlook 2007

    Lesson 41:  Navigating Outlook 2007  [7:48]

    Lesson 42:  Creating and Sending Email   [10:48]

    Lesson 43:  Formatting Email   [8:46]

    Lesson 44:  Working with Contacts  [4:00]

    Lesson 45:  Map Your Contact     [1:52]

    Lesson 46:  Flagging Tasks and Auto Reminders  [5:19]

    Lesson 47:  Using the New To-Do Bar    [6:24]

    Lesson 48:  Writing and Viewing Notes [3:32]

    Lesson 49:  Using the Journal Feature   [4:35]

    Lesson 50

    Table of Contents

    1. Microsoft Office 2007 Overview
      1. Microsoft Office 2007 Overview 00:03:55
    2. Getting Started with Office 2007
      1. Learning Objectives 00:01:44
      2. Lesson 1: An Initial Tour of Office 2007 00:05:52
      3. Lesson 2: File Formats and Compatibility Solutions 00:07:34
      4. Lesson 3: Working with Themes between Office Applications 00:07:27
      5. Lesson 4: Utilizing Help in Office 2007 00:05:26
      6. Lesson 5: Setting Options for Office and Individual Applications 00:05:39
    3. Project 1
      1. Project 1: Create the Ultimate Office Working Environment 00:07:29
    4. Working with Word 2007
      1. Learning Objectives 00:01:46
      2. Lesson 6: Finding All Your Favorite Tools 00:07:41
      3. Lesson 7: Document Encryption (and more) 00:10:14
      4. Lesson 8: Using Word as a Blog Editor 00:05:07
      5. Lesson 9: Inspect Your Document and Remove Metadata 00:06:11
      6. Lesson 10: Working with Tables 00:08:04
      7. Lesson 11: Convert a Document to PDF or XPS 00:07:43
      8. Lesson 12: Using Academic Tools (Footnotes, Endnotes, Citations) 00:08:36
      9. Lesson 13: Using Track Changes and Comments 00:09:49
      10. Lesson 14: Quick Parts and the Building Block Organizer 00:07:10
      11. Lesson 15: How to Perform a Mail Merge 00:10:21
    5. Project 2
      1. Project 2: Create a Three-Fold Brochure 00:08:06
    6. Working with Excel 2007
      1. Learning Objectives 00:01:53
      2. Lesson 16: Maneuvering Through Workbooks and Worksheets 00:11:00
      3. Lesson 17: Automatic Data Entry Methods 00:10:11
      4. Lesson 18: Formatting Cells Manually, with Styles, and with Themes 00:09:53
      5. Lesson 19: Conditional Formatting (Data Bars, Color Scales, Icon Sets) 00:06:07
      6. Lesson 20: Basic Excel Formulas 00:04:41
      7. Lesson 21: Basic Excel Functions 00:10:55
      8. Lesson 22: Excel Function Groups (Advanced Function Possibilities) 00:06:09
      9. Lesson 23: Troubleshoot Function Errors 00:09:42
      10. Lesson 24: Use Tables to Sort and Filter Data 00:09:29
      11. Lesson 25: Creating Pivot Tables 00:08:56
      12. Lesson 26: Protecting Your Workbook and Worksheets 00:13:06
      13. Lesson 27: Illustrations and Smart Art in Excel 00:11:27
      14. Lesson 28: Basic Chart Building 00:11:53
      15. Lesson 29: Advanced Chart Creation 00:13:28
      16. Lesson 30: Printing Your Worksheets 00:07:24
    7. Project 3
      1. Project 3: Working with a Loan Amortization Table 00:08:26
    8. Working with PowerPoint 2007
      1. Learning Objectives 00:01:50
      2. Lesson 31: Create a Simple Slide Show 00:07:56
      3. Lesson 32: Insert Graphics, SmartArt, and Charts 00:07:23
      4. Lesson 33: Add Movies and Sound to your Presentation 00:09:32
      5. Lesson 34: Slide Animations and Transitions 00:10:03
      6. Lesson 35: Altering the Design of Your Presentation 00:07:09
      7. Lesson 36: Using the Presenter View 00:07:51
      8. Lesson 37: Record and Rehearse Timings for Your Presentation 00:06:50
      9. Lesson 38: Changing Slide Masters 00:05:59
      10. Lesson 39: Working with Handout and Notes Masters 00:05:49
      11. Lesson 40: Working with PowerPoint Print Features 00:05:36
    9. Project 4
      1. Project 4: Add a Photo Album to your Presentation 00:07:44
    10. Working with Outlook 2007
      1. Learning Objectives 00:01:47
      2. Lesson 41: Navigating Outlook 2007 00:08:59
      3. Lesson 42: Creating and Sending Email 00:11:59
      4. Lesson 43: Formatting Email 00:09:57
      5. Lesson 44: Working with Contacts 00:05:11
      6. Lesson 45: Map Your Contact 00:03:03
      7. Lesson 46: Flagging Tasks and Auto Reminders 00:06:30
      8. Lesson 47: Using the New To-Do Bar 00:07:35
      9. Lesson 48: Writing and Viewing Notes 00:04:44
      10. Lesson 49: Using the Journal Feature 00:05:46
      11. Lesson 50: RSS Feeds 00:06:00
    11. Project 5
      1. Project 5: Using Rules to Control the Direction of Your Mail 00:11:18