Back to Search Results

Training Course Summary:

Welcome to Microsoft Office 2007, the newest suite of information productivity applications. Since you use Office in your job, you'll want to learn the new features of Office 2007 that will help to streamline your work. In this course, you'll learn the new features of Word, Excel, PowerPoint, Access, and Outlook.

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

explore the new features in the Office 2007 environment.
use the new features of Word.
use the new features of Excel.
use the new features of PowerPoint.
use the new features of Access
use the new features of Outlook
describe the other applications in the Office suite.

Pre-Requisites:

Before taking this course, students are required to take the following courses or have equivalent knowledge:

- Windows XP: Introduction
- Word, Excel, PowerPoint, Outlook and Access 2000: Introduction

Who Should Attend:

An experienced end user who has used Office 2000, XP or 2003 with basic knowledge of the applications, and needs to know the new features of Office 2007.

Training Course Overview/Content:

Lesson 1: Using the Office 2007 Environment

- General Environment
The Ribbon
Tabs, Groups and Commands
Dialog Box Launcher
Quick Access Toolbar
Microsoft Office Button
Mini Toolbar
Views & Zooming
Keyboard Shortcuts
- File Formats
File Formats
PDF and XPS
- Formatting
Themes
SmartArt Graphics
Charting
- Security
Document Inspector
Digital Signatures
Integration
Compatibility
SharePoint

Lesson 2: Using the New Features of Word

- New Formatting Features
Live Previews
Quick Styles
Typography
- New Content Features
Pre-formatted Content
Quick Parts
Equation Builder
Content Controls
Citations and References
- New Proofing Features
Tri Pane Review Panel
Word Count
Contextual Spell Checking
Read Mode
- New Conversion Features
File Types

Lesson 3: Using the New Features of Excel

- New General Features
Increased Capacity
More Templates
File Types
- New Formatting Features
Galleries
Conditional Formatting
- New Formula Features
Resizable Formula Bar
AutoComplete
Name Manager
- New Analysis Features
Excel Tables
Filtering and Sorting
PivotTable Enhancements
- New Proofing Features
Page Layout View

Lesson 4: Using the New Features of PowerPoint

- New General Features
Viewing Presentations
Ribbon Tabs
Contextual Tabs
- New Formatting Features
Live Previews
Custom Slide Layouts
Typography
Consistency
Graphics Effects
Slide Libraries
- New Content Features
SmartArt Graphics
Convert bullet to SmartArt Graphic
- New Slide Show Features
Custom slide shows
Setup options
Presenter view
- New Conversion Features
PowerPoint 2007 New Elements
Upgrade Presentations
File Types

Lesson 5: Using the New Features of Access

- New General Features
Getting Started Window
Navigation Pane
Status Bar
Tabbed documents
File Type
Help
Security
Formatting
- New Table Features
Sorting and Filtering
Field Enhancements
Data Type Recognition
Datasheet Total Row
Adding Fields
- New Form and Report Features
Quick Create
New Layout Views
New Report View
Split Forms
Group and Sort
Stacked and Tabular Layouts
- New Integration Features
Import and Export Wizards
Data Collection
SharePoint Services

Lesson 6: Using the New Features of Outlook

- New General Features
The Ribbon
Navigation Pane
To-do Bar
Colour Categorise
Instant Search
RSS Feeds
Auto Account Setup
Working Offline
- New Email Features
Creating Messages
Signatures
Calendar Snapshots
Out of Office
Flags
Attachment Previewer
Voicemail and Faxes
- New Calendar Features
Enhanced Views
Tasks Area
Overlay Calendars
Meeting Recommendations
- New Contact Features
Electronic Business Cards
- New Security Features
Junk Email
Anti-Phishing Messages
- New Integration Features
InfoPath Forms

Lesson 7: Other Applications in the Office Suite

- Communicator 2007
- Groove 2007
- InfoPath 2007
- OneNote 2007
- Project 2007
- Publisher 2007
- SharePoint Designer 2007
- Visio 2007
- Expressions 2007