Course Outline

Office 2007 New Features

This class is for Microsoft Office users who are upgrading their software from Office 2003 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 really challenging with significant losses in productivity. Training on this 2007 upgrade is essential to maintaining a productive work environment. Plus you’ll want to learn about the dramatic new improvements to existing features that yield powerful results. Learn about the new common features for all applications, as well as the new application-specific features in Word, Outlook, Excel and PowerPoint. This course focuses on teaching the differences between Office 2003 and Office 2007 for the existing user to make your upgrade experience far more productive. 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 8/20/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600