Course Outline

Office 2007 New Features

Description: This course is for Microsoft Office users who are upgrading their software from previous versions of Office to Office 2007. Office 2007 is redesigned with a radical change in user interface. The menus have been eliminated and replaced by "Ribbons" so finding the features you've used in the past can be problematic, resulting in significant lost productivity. Training at the time of conversion is essential to maintaining a productive work environment. Plus you need to learn about the dramatic new improvements in existing features that yield powerful results.

Learn about the new productivity enhancing features in Office 2007. Learn about the new common features for all applications in an overview as well as the new application specific features in Word, Outlook, Excel and PowerPoint. This course is not optimized to provide skill enhancement. Instead, it focuses on teaching the differences between older versions of Office (2000, 2002, 2003) and the new Office 2007 for the existing user. 6 hours

COMMON ELEMENTS

Introducing the New Office User Interface

  • What's new about the user interface?
    • The Office Button
    • The Ribbon
    • The Quick Access Toolbar
  • Review components of the new interface
  • Review changes to the other interface components

Inspection and Compatibility

  • Inspect a document
  • Run compatibility checker

OUTLOOK 2007

Introducing the Outlook 2007 User Interface

  • Review components of the Outlook 2007 main window
    • Menus and toolbars
    • New Navigation Pane and To-do Bar
    • View Pane

Create Contacts and Categories

  • What's new about Contacts
    • Electronic business cards
  • What's new about Categories
    • Colors

Create Messages

  • What's new about Messages
    • Attachment previewing

Create Calendars, Appointments and Meetings

  • What's new about calendars
    • Overlay multiple calendars
    • Send calendars in email messages

Create, Prioritize, Categorize and Assign Tasks

  • What's new about Tasks
    • User interface
    • To-do Bar

Find Outlook Objects and Create Search Folders

  • What's new about searching in Outlook
    • Instant Search

WORD 2007

Create and Format a Word 2007 Document

  • What's new about creating and formatting documents?
    • Using Themes
    • Using Quick Styles
    • Spelling, grammar, and contextual spell check

Tables, Lists, Headers and Footers

  • What's new about tables, lists, and headers and footers?
    • Tables
    • Table styles
    • Quick Tables

Enhance a Document with Graphic Objects

  • What's new about graphic objects?
    • Quick Parts
    • Smart Art
    • Preset format galleries for graphic objects

Finalize the Document

  • Adding finishing touches to your report
    • Cover pages
    • Tables of contents
    • Mark as final

EXCEL 2007

Create, Sort and Filter a Table

  • Distinguishing between Lists, Ranges, Named Ranges and Tables
  • Attributes of a Table

Create a Chart

  • What's new about Charts?
    • Contextual tabs in Interface
    • Formatting including 3-D and new chart types

Work with Functions and Formulas

  • What's new about functions and formulas?
    • Formula ribbon
    • New conditional sum functions
    • New IFERROR function
    • Formula AutoComplete

Format a Report for Printing

  • What's new about formatting reports?
    • New Page Layout View
    • Margins gallery
    • Headers and footers galleries

Apply Conditional Formatting to Cells

  • What's new about conditional formatting?
    • Easy-to-use
    • Data Bars, Color Scales and Icon Sets
    • No longer limited to three format conditions
    • Format rules manager
    • Stop if true option

POWERPOINT 2007

Create a PowerPoint 2007 Presentation

  • What's new about creating presentations?
    • Using themes
    • Using quick styles
  • Setting up the Slide Master and Slide Layouts
  • Create content slides
  • Using Live Preview to consider presentation themes

Use Tables in a Presentation

  • What's new about tables?
  • Using PowerPoint tables
  • Using Word and Excel tables in PowerPoint

Enhance a Presentation

  • Add footer to a presentation
  • Using slide transitions and animations
  • Inserting charts
  • Using Smart Art objects
  • Apply Quick styles
  • Apply themes
  • Using Ink Annotations with slide shows
Prerequisites:  Office 2000, Office 2002, Office 2003 or equivalent experience.
Revised 3/4/09
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600