130163 - Microsoft Office 2007: General Overview Seminar

Duration

1/2 Day (4 hrs.)

Introduction

Elements of this syllabus are subject to change.

Microsoft ® Office 2007. This 4 hour seminar will cover all the changes in Microsoft Office 2007 as well as a general overview of Office 2007.

Audience

This course is designed for users who have worked with earlier versions of Microsoft® Office 2003, and who have upgraded to Microsoft® Office 2007.

Course Objectives

You will explore the interfaces of the Microsoft Office 2007 environments and customize the interface to suit your requirements. You will identify and use the new and enhanced features of Microsoft 2007.

At Course Completion

Upon successful completion of this workshop, students will be able to:

• Identify the new changes in the interface.
• Explore new file formats available.
• Use the new ribbon menu system.
• Use new enhancements to Microsoft Office 2007.

Prerequisites

Students enrolling in this course should understand and have used Microsoft Office 2003.

Course Outline

Lesson 1: Screen Changes in Microsoft Office 2007

- Office Button
- Quick Access Toolbar
- New File Formats

• XML:  reduction in file size & improved recovery

• Easy detection of macros – worms and viruses
  

• Enhanced Application Integration
  

WORD:

EXCEL:

POWERPOINT:

- Converter - free download from Microsoft Office Online
- Screen tips
- Help
- Window Frame
- Navigation Changes

• Tab/Ribbon Navigation change from Menu driven
  
• Minimize Ribbon
  
  
• Move Quick Access Toolbar
  
• “More” Buttons
  
• Dialog Box Launcher
  
• Mini Toolbars
  
• Zoom Slider
  
• Live Preview
  
• Right Click
  
• Control Functions

- Contextual Tabs

• Design
  
• Layout
  
• Format
  

- OFFICE ENHANCEMENTS

• Save As
  PDF & XPS

- Prepare       

• Inspect Document
       
• Compatibility Checker
       
• Save as Final

Recent Documents Placement
Customize – Quick Access Toolbar
Resources – Go Online to

Screen Changes:

Window Frame

• View Buttons moved       

Word Tab:

Home: 

• Styles
       

Insert:

• Pages
         
  
       
• Illustrations
          SmartArt
          Chart
          Equation
         
       
• Quick Parts/Building Blocks
         
        
• Page Layout
          Document Themes - Custom
          Page Setup
         
       
• References
         
       
• Mailings – Wizard gone
             
       
• Review
          Proofing
          Protect – IRM, (save as – tools – general options)
          Compare – Tri-pane
         
       
• View
       

Contextual Tabs:           

• Design
• Layout
• Format

Word Options:   

Popular

Display

Proofing

Save

Advanced

Customize – Quick Access Toolbar

Add-Ins

Trust Center

Resources – Go Online

Screen Changes:

Insert Worksheet Tab

Excel Tabs:

Home: 

• Styles
  • Conditional Formatting
    
  • Format as Table
    
  • Cell Styles

Insert:    

• Tables
  • PivotTable Navigation Changes
• Charts - Wizard Gone, copy, paste
  • Link enhancement
    

Page Layout:    

• Themes - Custom
• Page Setup

Formulas:    

• Function Library
  
• Defined Names
  
  • Create from Selection
• Formula Auditing
  • Replacing Formula Auditing Floater Toolbar
    
• Calculation

Data:    

• Data Tools

Review:    

• Proofing

View: 

Contextual Tabs:

• Design
  
  
• Layout
  
  
• Format

Other Excel Enhancements:

• Spreadsheet Size – mil rows & 1600 columns, XFD1048576

• Formula Autocomplete

Excel Options:

• Popular
• Formulas
  
• Proofing
  
• Save
  
• Advanced
  
• Customize
  
• Add-Ins
  
• Trust Center
  
• Resources

Screen Changes:

Hybrid Navigation

Outlook Tabs:

E-Mail: 

• Message
  
• Insert
  
• Options
  
• Format Text
  

Appointment/Meeting: 

• Appointment & Meeting
• Insert
  
• Format Text

Contacts: 

• Contact
  
• Insert
  
• Format Text

Tasks: 

• Task

• Insert
  

• Format Text

Contextual Tabs:

• Design
  
  
• Layout
  
  
• Format

Other Outlook Enhancements:

• Enhanced To-Do bar
  

• Instant Search
  

• Attachment Preview
  

• Send Calendar Information
  

• Enhanced Electronic Business Card

Outlook Options:

• Editor Options
  • Popular
    
  • Display
    
  • Proofing
    
  • Advanced
    
  • Customize – must be customized in each Outlook Group

Screen Changes:

Window Frame

• View Buttons moved
  

• Fit slide to current window button

PowerPoint Tabs:

Home: 

• Drawing
  
  • Shape Effects
    

Slides: 

• New Slide - Reuse Slide

Insert: 

• Illustrations
  
  • Photo Album
    
  • SmartArt – new text box
    
  • Chart – Excel

Design: 

• Themes - Custom

Animations: 

Slide Show:

Review:

• Proofing

View:

• Presentation Views
  • Slide Master – Custom Slide Layout
    

Contextual Tabs:

• Design
  • Create Graphic
  • Layouts
  • SmartArt Styles
• Layout
• Format
  • Shapes
  • Shape Styles
  • Word Art Style

PowerPoint Options:

• Popular
  • Proofing
    AutoCorrect Options, AutoFormat As You Type, R Auto bullet & numb…
    
• Save
  
• Advanced
  
• Customize
  
• Add-Ins
  
• Trust Center
  
• Resources

top of page