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: Getting Up to Speed

Video Description

These tutorials make all programs in Microsoft Office 2007 a breeze to use. You are introduced to the new interfaces and taught how to use each application's key features. This includes how to save time creating shortcuts for formatting Word documents, spreadsheets, and presentations. Plus, see how to manage your email, calendar, and list of contacts. Learn how to use Office 2007 efficiently and effectively with minimal effort now!

Table of Contents

  1. CHAPTER 1: GETTING STARTED WITH WORD
    1. INTRODUCTION 00:01:25
    2. Touring the New Office 2007 Interface 00:04:34
    3. Formatting Basic Text 00:05:48
    4. Applying Formatting to a Paragraph 00:01:43
    5. Creating Bulleted & Numbered Lists 00:02:19
    6. Working with Styles 00:05:17
    7. Making Changes to the Styles 00:04:17
    8. Saving & Removing Formatting 00:02:03
    9. Changing Style Sets 00:01:48
    10. Proofing Your Work 00:04:18
  2. CHAPTER 2: REFINING WORD DOCUMENTS
    1. INTRODUCTION 00:00:28
    2. Adding Headers & Footers 00:04:14
    3. Inserting Watermarks 00:02:30
    4. Formatting the Overall Document 00:02:27
    5. Inserting Graphical Elements 00:06:22
    6. Inserting Clip Art 00:03:17
    7. Using SmartArt 00:05:02
    8. Inserting Tables 00:03:33
    9. Formatting Tables 00:05:11
    10. Creating a Cover Page with Themes 00:04:06
    11. Saving a Document 00:05:59
    12. Outputting to PDF 00:02:16
  3. CHAPTER 3: EXPLORING EXCEL®
    1. INTRODUCTION 00:00:34
    2. Touring the Excel Interface 00:04:59
    3. Inserting, Moving & Selecting Content 00:07:58
    4. Format Numerical Data & Reference Cells 00:04:46
    5. Building a Table & Using AutoFill 00:09:04
    6. Inserting & Deleting Rows & Columns 00:02:58
    7. Introducing Formulas 00:06:43
    8. Introducing Functions 00:07:20
    9. Using the Insert Function Dialog Box 00:04:06
    10. Using Statistical Functions & the Status Bar 00:05:12
    11. Using Auditing Commands 00:02:48
    12. Exploring Absolute Cell Referencing 00:06:33
    13. Naming Cell Ranges & Using Name Manager 00:06:19
    14. Pasting Data & Using the Clipboard 00:06:29
  4. CHAPTER 4: FORMATTING & STYLIZING IN EXCEL®
    1. INTRODUCTION 00:00:31
    2. Formatting Cells 00:02:56
    3. Using Format Painter 00:04:21
    4. Number Formatting 00:06:03
    5. Using Cell Styles 00:02:31
    6. Creating Cell Styles 00:01:38
    7. Changing Styles 00:04:30
    8. Using & Creating Table Styles 00:05:32
    9. Filtering a Table Layout 00:03:37
    10. Using Conditional Formatting 00:05:06
    11. Formatting Worksheets with Themes 00:01:52
    12. Inserting Graphical Elements 00:07:10
    13. Managing Multiple Worksheets 00:08:32
    14. Outputting a Document 00:07:09
    15. Saving a Document 00:06:24
  5. CHAPTER 5: POWERING UP WITH POWERPOINT®
    1. INTRODUCTION 00:00:36
    2. Touring the PowerPoint Interface 00:01:26
    3. Formatting Text 00:05:04
    4. Changing the Slide Layout 00:01:27
    5. Adding Additional Slides 00:04:15
    6. Creating a Slide Design 00:04:18
    7. Customizing Slides 00:02:00
    8. Inserting Objects 00:05:19
    9. Using SmartArt 00:04:31
    10. Creating & Formatting Charts 00:05:07
    11. Using WordArt Styles 00:01:40
    12. Changing Chart Types 00:03:10
    13. Applying Themes 00:05:17
    14. Setting Animation Effects 00:04:55
    15. Working with Different Views 00:01:25
    16. Setting Up a Slide Show 00:02:15
    17. Running a Slide Show 00:02:43
    18. Outputting a Presentation 00:05:12
  6. CHAPTER 6: STAYING CONNECTED IN OUTLOOK®
    1. INTRODUCTION 00:00:29
    2. Touring the Outlook Interface 00:02:13
    3. Using E-mail 00:03:27
    4. Creating Signatures & New Folders 00:03:22
    5. Using a Calendar & Adding Events 00:03:13
    6. Working with Multiple Calendars 00:01:37
    7. Sharing Calendars 00:04:05
    8. Adding & Viewing Contacts 00:02:50
    9. Creating, Viewing & Flagging Tasks 00:03:45
  7. CHAPTER 7: MANAGING DATA WITH ACCESS™
    1. INTRODUCTION 00:00:27
    2. Introducing Access & Touring the Interface 00:02:27
    3. Adding & Deleting Contacts 00:03:16
    4. Filtering Data 00:01:50
    5. Creating & Exporting Forms 00:05:10
    6. Creating Reports 00:03:54
    7. Exporting Data 00:04:02
  8. CHAPTER 8: A SEAMLESS OFFICE 2007 WORKFLOW
    1. INTRODUCTION 00:00:35
    2. Formatting & Sorting Data 00:03:25
    3. Using Freeze Panes 00:02:27
    4. Grouping Data into Outlines 00:02:15
    5. Creating Charts in Excel 00:06:09
    6. Sharing Workbooks 00:04:52
    7. Using Excel with Word 00:03:00
    8. Protecting a Document 00:03:34
    9. Using Cross-References 00:05:27
    10. Inserting Objects 00:01:53
    11. Using Excel with PowerPoint 00:03:19
    12. Publishing Handouts to Word 00:01:37
    13. Going from Word to Outlook 00:04:12
    14. Sending Invites with Outlook 00:02:31
    15. Sending Meeting Requests 00:02:04
    16. Final Comments & Credits 00:02:20