Office 2007 Migration - 4 hours

Lesson 1: Working in Office 2007
What’s New in Office 2007
What’s What in Office 2007
Using the Ribbon
Using Menus and Toolbars
Using Only the Keyboard
Office’s File Formats

Lesson 2: Common Tasks
in Office 2007
Working with Old Documents
Inserting Special Characters
Inserting and Editing Pictures
Adding and Formatting Shapes
Creating Stylized Text
Researching a Subject

Lesson 3: Viewing and Adding Text
in Word 2007
What’s Where in Word 2007
Composing Different Types
of Documents
Word’s Views
So Many Ways to Do It

Lesson 4: Formatting in Word 2007
Themes, Styles, and Fonts
Setting the Overall Look in Word
Using a Predesigned Table

Lesson 5: Working with Special
Content in Word 2007
Inserting Information with
Smart Tags
Mail Merge
Finalizing Your Document

Lesson 6: Working with Excel 2007
What’s Where in Excel 2007
Changing the Overall Look of Excel 

Lesson 7: Working with Power Point 2007
What’s Where in Power Point 2007
Converting Text into SmartArt Graphics
Modifying the Default Layout

Lesson 8: Working with Messages
in Outlook 2007
What’s Where in Outlook Messages
 Formatting E-mail Messages

Lesson 9: Organization with Outlook 2007
What’s Where in Outlook 2007
Customizing Outlook 2007

Lesson 10: Exchanging Information
Among Office Programs
Creating PDF or XPS Documents
Creating an Image of Your Work
Converting a Scanned Document into Text
Linking to a File or Web page

Lesson 11: Customizing and Securing
Office 2007
Customizing Quick Access Toolbar
Customizing the Window
Customizing Your Editing
Safeguarding a Document
Signing a Document With a Visible Signature
Downloading Office 2007 Add-ins
Checking the Compatibility
Fixing Office 2007

Half Day Class - 4 hours

Lesson 1: Exploring the Excel
Environment
Explore the User Interface
Work with the Ribbon
Work with Contextual Tabs
Use the Excel Galleries
Customize the Excel Interface

Lesson 2: Organizing Data
Explore the Enhancements
in Excel 2007 Spreadsheets
Insert Tables
Format Tables

Lesson 3: Analyzing Data
Apply Conditional Formatting
Sort Data in a Spreadsheet
Filter Data in a Spreadsheet
Apply a Formula

Lesson 4: Presenting Data
Create Charts
Format Charts
Work with Illustrations
Create PivotTables and PivotCharts
Share Excel Charts
Save Data in Presentable Formats

Half Day Class - 4 hours

Lesson 1: Exploring the Word Environment
Explore the User Interface
Work with the Ribbon
Work with Contextual Tabs
Use the Word Galleries
Customize the Word Interface

Lesson 2: Creating Professional
Looking Documents
Apply Styles
Apply Document Themes
Add Building Blocks
Work with Illustrations
Build an Equation
Add Citations and a Bibliography

Lesson 3: Finalizing Documents
Compare Reviewed Documents
Inspect Documents
Apply Digital Signatures
Save a Document

Half Day Class - 4 hours

Lesson 1: Exploring the
PowerPoint Environment
Explore the User Interface
Work with the Ribbon
Work with Contextual Tabs
Use the PowerPoint Galleries
Customize the PowerPoint Interface

Lesson 2: Enhancing the
Presentation Layouts
Create Custom Slide Layouts
Work with Themes

Lesson 3: Creating Dynamic
Presentations
Apply Rich Text and Typography Effects
Enhance Presentations with Graphic Effects
Enhance Table Layout
Work with Charts

Lesson 4: Finalizing
the Presentation
Customize Slide Shows
Secure Presentations
Save a Presentation

Excel 2003 Basics - 4 hours

Lesson 1: Getting Started with Excel
An Overview of Excel
Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help

Lesson 2: Modifying a Worksheet
Move and Copy Data Between Cells
Fill Cells with Series of Data
Edit Cell Data
Insert and Delete Cells, Columns, and Rows
Find, Replace, and Go To Cell Data
Spell Check a Worksheet

Lesson 3: Performing Calculations
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference
Change Font Size and Type
Add Borders and Color to Cells
Change Column Width and Row Height

Lesson 4: Formatting a Worksheet
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply an AutoFormat
Apply Styles

Lesson 5: Developing a Workbook
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

Lesson 6: Printing Workbook Contents
Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range

Lesson 7: Customizing Layout
Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

Intermediate Excel 2003 - 4 hours

Lesson 1: Creating and
Applying Templates
Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-based Research Tools

Lesson 2: Creating and
Modifying Charts
Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram

Lesson 3: Working with
Graphic Objects
Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with
Advanced Formulas
Create and Apply a Name
for a Range of Cells
Calculate Across Worksheets
Calculate with Date and
Time Functions
Calculate with Financial Functions
Calculate with Statistical Functions
Calculate with Lookup
and Reference Functions
Calculate with Logical Functions

Lesson 5: Sorting
and Filtering Data
Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet

Lesson 6: Using Excel with
the Web
Export Excel Data
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Advanced Excel 2003 - 4 hour

Lesson 1: Streamlining Workflow
Create a Macro
Edit a Macro
Customize Access to Excel Commands
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Lesson 2: Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures

Lesson 3: Auditing Worksheets
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and Evaluate Formulas
Group and Outline Data

Lesson 4: Analyzing Data
Create a Trend Line
Create Scenarios
Perform What-If Analysis
Develop a PivotTable© Report
Develop a PivotChart© Report
Perform Statistical Analysis
with the Analysis Tool Pak

Lesson 5: Working with
Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Lesson 6: Importing and Exporting Data
Export to Microsoft Word
Import a Word Table
Import Text Files

Lesson 7: Structuring XML Workbooks
Develop XML Maps
Import, Add, and Export XML Data
Manage XML Workbooks
Apply XML View Options

Word 2003 Basics - 4 hours

Lesson 1: Creating a Basic Document
The Word Environment
Get Help Using Word
Enter Text
Save a New Document
Preview a Document
Print a Document

Lesson 2: Editing a Document
Navigate in a Document
Insert Text
Select Text
Create an AutoText Entry
Move and Copy Text
Delete Blocks of Text
Undo Changes
Find and Replace Text

Lesson 3: Formatting Text
Change Font and Size
Apply Font Styles and Effects
Change Text Color
Highlight Text
Copy Formats
Clear Formatting
Find and Replace Text Formatting

Lesson 4: Formatting Paragraphs
Set Tabs
Change Paragraph Alignment
Indent Paragraphs
Add Borders and Shading
Apply Styles
Create Lists
Change Spacing Between
Paragraphs and Lines

Lesson 5: Proofing a Document
Use the Thesaurus
Check Spelling and Grammar
Create a New Default Dictionary
Check Word Count
Modify a Document in Print Preview

Lesson 6: Adding Tables
Create a Table
Enter Data in a Table
AutoFormat a Table
Convert Text to a Table

Lesson 7: Inserting Graphic Elements
Insert Symbols and Special Characters
Insert a Clip Art Picture
Add a Watermark

Lesson 8: Controlling Page Appearance
Set Page Orientation
Change Page Margins
Apply a Page Border
Add Headers and Footers
Insert a Page Break

Intermediate Word 2003 - 4 hours

Lesson 1: Managing Lists
Sort a List
Restart a List
Create an Outline Numbered List
Customize List Appearance

Lesson 2: Customizing Tables
and Charts
Sort a Table
Modify Table Structure
Merge or Split Cells
Position Text in a Table Cell
Apply Borders and Shading
Perform Calculations in a Table
Create a Chart from a Word Table
Modify a Chart

Lesson 3: Customizing Formatting
Modify Character Spacing
Add Text Effects
Control Paragraph Flow

Lesson 4: Working with Custom Styles
Create a Character or Paragraph Style
Modify an Existing Style
Create a List Style
Create a Table Style

Lesson 5: Modifying Pictures
Set Picture Contrast or Brightness
Crop a Picture
Wrap Text Around a Picture

Lesson 6: Creating Customized
Graphic Elements
Draw Shapes and Lines
Insert WordArt
Insert Text Boxes
Create Diagrams

Lesson 7: Controlling Text Flow
Insert Section Breaks
Insert Columns
Link Text Boxes

Lesson 8: Automating Common Tasks
Run a Macro
Create a Macro
Modify a Macro
Customize Toolbars and Buttons
Add Menu Items

Lesson 9: Automating Document Creation
Create a Document Based on a Template
Create a Document by Using a Wizard
Create or Modify a Template
Change the Default Template Location
Insert a Macro Button Field in a Template

Lesson 10: Performing Mail Merges
The Mail Merge Process
Perform a Merge on Existing Documents
Merge Envelopes and Labels
Use Word to Create a Data Source

Advanced Word 2003- 4 hours

Lesson 1: Creating and
Distributing Forms
Create a Form Template
Insert Fields in a Form Template
Protect a Form
Test the Form

Lesson 2: Automating Tasks
Run a Macro
Record a Macro
Edit a Macro
Create Toolbar Buttons
Create Custom Menus

Lesson 3: Referencing
Document Information
Insert Bookmarks
Insert Footnotes and Endnotes
Add Captions
Create Cross-References

Lesson 4: Preparing a Document
for Publication
Set Book Margins
Create Custom Headers and Footers
Compile a Table of Contents
Index the Document
Create a Master Document

Lesson 5: Revising Documents
Create Document Versions
Distribute a Document
Track Changes to a Document
Review Document Changes

Lesson 6: Modifying an HTML Page
Save Word Documents as Web Pages
Edit Web Pages in Word
Insert Scrolling Text
Place a Movie Clip in a Web Page
Insert a Background Sound

Outlook Essentials - 4 hours

Lesson 1: Getting Started with Outlook
Log On to Outlook
The Outlook Environment
Compose and Send a Simple Message
Open a Message
Reply to a Message
Print a Message
Delete a Message

Lesson 2: Composing Messages
Address a Message
Format a Message
Check Spelling and Grammar
Attach a File
Forward a Message

Lesson 3: Managing Mail
Open and Save an Attachment
Flag a Message
Create a Folder
Move Messages to a Folder
Copy Messages to Folders
Delete a Folder

Lesson 4: Scheduling Appointments
The Outlook Calendar
Schedule an Appointment
Assign a Category to an Appointment
Update Calendar Entries

Lesson 5: Scheduling Meetings
Schedule a Meeting
Reply to a Meeting Request
Propose a New Meeting Time
Track Meeting Responses
Update a Meeting Request
Cancel a Meeting Request
Print the Calendar

Lesson 6: Managing Contacts
Add a Contact
Sort Contacts
Find a Contact
Generate a Map
Edit a Contact
Delete a Contact
Print Contacts

Lesson 7: Managing Tasks
Create a Task
Edit a Task
Update a Task

Lesson 8: Using Notes
Create a Note
Edit a Note
Copy a Note

Intermediate Outlook - 4 hours

Lesson 1: Customizing Your Mail
Use Message Stationery
Create Custom Stationery
Modify Message Settings
Modify Delivery Options
Notify Users That You Will Be
Out Of the Office

Lesson 2: Working With
Contacts
Sharing Contacts With Other Users
Export Contact Lists
Link Items To A Contact
Forward Note To Contact
Creating a Distribution List

Lesson 3: Managing Your Work
Assign a Task
Reply To a Task Request
Send a Task Update
Specifying Default Settings For
Tracking Assigned Tasks
Track Assigned Tasks
Sharing Task Information With Other Users

Lesson 4: Organizing Your
Mailbox and Calendar
Organizing Outlook Items
Sort Messages Using Multiple Criteria
Assigning Messages to Categories
Group Messages
Filter Messages
Organize Messages By Using Colors
Find Specified Messages
Manage Messages with Rules
Apply Conditional Formats
to Calendar Appointments

Lesson 5: Customizing Outlook
Customize the Toolbars
Creating a New Toolbar
Customize the Menu
Create Shortcuts
Create Custom Views
Customize Outlook Today
Specify AutoCorrect Settings
Change the Office Assistant Settings
Display an Additional Time Zone

Lesson 6: Sharing Outlook
Information
Specify Folder Permissions
Delegate Access to Folders
Access Another User's Folders
Save a Calendar as a Web Page
Create a Public Folder
Post to a Public Folder

Lesson 7: Saving and
Archiving Mail
Saving Message In Alternate
File Formats
Creating Office Documents
from within Outlook
Archive Messages Manually
Archive Messages Automatically
Protect Personal Folders
Use Mailbox Cleanup

3A - 4 hours

3B - 4 hours

Lesson 1: Working with Contacts
Import a vCard
Create a Mail Merge
Generate a Map for a Contacts Address

Lesson 2: Communicating with
E-mail Alternatives
Send and Receive Instant Messages
Subscribe to a Newsgroup
View Newsgroup Messages

Lesson 3: Tracking Work Activities
using the Journal
Record a Journal Entry Automatically
Manually Record a Journal Entry
Modify a Journal Entry

Lesson 4: Configuring and
Securing Outlook
Configure a Dial-up Connection
Add an Account to Your Profile
View Secure E-mail Options
View Security Zone Settings

Lesson 5: Interacting with
the Internet
Publish Free/Busy Information over the Internet
Schedule an Online Meeting
Add an Internet Shortcut
Create a Folder Home Page
Insert a Hyperlink

Lesson 6: Working Offline
and Remotely
Create Offline Folders
Make a Folder Available Offline
Create a Send/Receive Group
Download Messages

Lesson 7: Creating a
Custom Form
Add Fields to a Form
Save a Form
Test a Form

Power Point 2003 Basics - 4 hours

Lesson 1: An Orientation to PowerPoint
The PowerPoint Environment
Orientation to Views
Navigate Through a Presentation
Edit Slide Text
Save the Presentation
Run a Slide Show

Lesson 2: Beginning a Presentation
Create a New Presentation
Change Background Color
Add Slides to a Presentation
Enter Text
Create a Presentation from
a Microsoft Word Outline

Lesson 3: Formatting Text Slides
Apply Character Formats
Align Text
Change Line Spacing
Change Indents

Lesson 4: Adding Tables to
a Presentation
Create a Table
Format Tables
Insert a Table from Microsoft Word

Lesson 5: Charting Data
Create a Column Chart
Edit Chart Data
Change Chart Type
Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects
Resize Objects
Copy and Duplicate Objects
Move Objects
Changing Object Orientation
Format Objects
Group and Ungroup Objects
Change the Order of Objects

Lesson 7: Adding Images to
a Presentation
Add Clip Art
Add a Picture from a File
Draw Lines and Shapes
Insert WordArt

Lesson 8: Preparing to Deliver
a Presentation
Spell Check
Arrange Slides
Add Transitions
Create Speaker Notes
Send a Presentation to Microsoft Word
Print the Presentation
Package a Presentation for CD

Power Point 2003- Beyond the Basics - 4 hours

Lesson 1: Creating a Custom
Design Template
Define Design Template Characteristics
Create a Custom Color Scheme
Set Up a Slide Master
Format Custom Bullets
Add a Footer
Modify the Notes Master
Save a Custom Design Template

Lesson 2: Adding Organization
Charts and Diagrams
Working with Organization Charts
Update an Organization Chart
Applying a Chart Layout
Create a Diagram
Draw a Flowchart

Lesson 3: Adding Special Effects
Add Sound and Movies
Add Animation
Emphasize Objects
Set a Motion Path
Set the Order of Effects

Lesson 4: Creating Web
Presentations
Create a Group Home Page with
the AutoContent Wizard
Hyperlink to a Web Page
Publish as a Web Page

Lesson 5: Collaborating
in PowerPoint
Set Password Protection
Work with Comments
Send a Presentation for Review
Merge Revision Copies
Apply Reviewer Changes

Lesson 6: Delivering a Presentation
Hyperlink Within PowerPoint
Add an Action Button
Set Up a Custom Show
Annotate a Presentation
Working with Narrations and Slide Timings
Set Up a Slide Show to Repeat Automatically

Excel 2007 Basics - 4 hours

Lesson 1: Creating a Basic
Worksheet
Explore the User Interface
and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick
Access Toolbar (QAT)

Lesson 2: Performing Calculations
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions

Lesson 3: Modify a Worksheet
Manipulate Data
Insert and Delete Cells,
Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Post ion Cell Contents
Apply Cell Styles

Lesson 5: Printing Workbook Contents
Print Workbook Using Default Print Options
Set Print Options
Set Page Breaks

Lesson 6: Managing Large Workbooks
Format Worksheet Tabs
Mange Worksheets in a Workbook
Manage the View of Large Worksheets

Intermediate Excel 2007 - 4 hours

Lesson 1: Calculating Data with
Advanced Formulas
Manage Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical
and Lookup Functions

Lesson 2: Organizing Worksheet
and Table Data
Create and Modify Tables
Format Tables
Sort and Filter Worksheet or Table Data
Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts
Create a Chart
Modify Charts
Format Charts

Lesson 4: Analyzing Data Using
Pivot Tables and Charts
Create a Pivot Table Report
Analyze Data Using Pivot Charts

Lesson 5:Inserting Graphic Objects
Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects

Lesson 6: Customizing
and Enhancing Workbooks
Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates

Advanced Excel 2007 - 4 hour

Lesson 1: Streamlining Workflow
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Lesson 2: Collaborating with Others
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signature
Restrict Document Access

Lesson 3: Auditing Worksheets
Trace Cells
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline

Lesson 4: Analyzing Data
Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis
with the Analysis ToolPak

Lesson 5: Working with
Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Lesson 6: Importing and
Exporting Data
Export Excel Data
Import a Delimited Text File

Lesson 7: Using Excel
with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Lesson 7: Structuring XML Workbooks
Develop XML Maps
Import and Export XML Data

Word 2007 Basics - 4 hours

Lesson 1: Creating a Basic Document
Explore the User Interface
Open and View a Document
Customize the Word Environment
Obtain Help
Enter Text
Save a Document
Preview and Print a Document

Lesson 2: Editing a Document
Navigate and Select Text
Insert, Delete, or Rearrange Text
Undo Changes
Search and Replace Text

Lesson 3: Formatting Text
Change Font Appearance
Highlight Text

Lesson 4: Formatting Paragraphs
Set Tabs to Align Text
Control Paragraph Layout
Add Borders and Shading
Apply Styles
Create Lists
Manage Formatting

Lesson 5: Adding Tables
Create a Table
Modify the Table Structure
Format a Table
Convert Text to a Table or Table to Text

Lesson 6: Inserting Graphic Elements
Adding Visual Effects
Insert Illustrations

Lesson 7: Controlling Page Appearance
Control Page Layout
Apply a Page Border and Color
Add Watermarks
Add Headers and Footers

Lesson 8: Proofing a Document
Check Spelling, Grammar and Word Count
Enhance Textual Meaning Using the Thesaurus
Customize AutoCorrect Options

Intermediate Word 2007 - 4 hours

Lesson 1: Managing Lists
Sort a List
Renumber Lists
Customize Lists

Lesson 2: Customizing Formatting
with Styles
Create or Modify a Text Style
Create a Custom List or Table Style
Apply Default and Customized
Document Themes

Lesson 3: Customizing Formatting
Modify Character Spacing
Add Text Effects
Control Paragraph Flow

Lesson 4: Modifying Pictures
Resize a Picture
Adjust Picture Appearance Settings
Wrap Text Around a Picture

Lesson 5: Creating Customized
Graphic Elements
Create Text Boxes and Pull Quotes
Draw Shapes
Add WordArt and Other Special
Effects to Text
Create Complex Illustrations with SmartArt

Lesson 6: Inserting Content
Using Quick Parts
Insert Building Blocks
Create Building Blocks
Modify Building Blocks
Insert Fields Using Quick Parts

Lesson 7: Controlling Text Flow
Control Paragraph Flow
Insert Section Breaks
Insert Columns
Link Text Boxes to Control Text Flow

Lesson 8: Automating Document
Creation
Using Templates to Automate
Document Creation
Create a Document Based
on a Template
Create Template

Lesson 9: Automating Mail Merges
Perform a Mail Merge
Mail Merge Envelopes and Labels
Use Word to Create a Data Source

Lesson 10: Using Macros
to Automate Tasks
Perform Task Automatically
Using a Macro
Create a Macro

Advanced Word 2007 - 4 hours

Lesson 1: Using Word 2007 with
Other Programs
Link to an Excel 2007 Worksheet
Link a Chart to Excel Data
Send a Document Outline to
Office Power Point
Extract Text from a Fax
Send a Document as an Email Message

Lesson 2: Collaborating
on Documents
Modify User Information
Send a Document for Review
Review a Document
Compare Document Changes
Merge Document Changes
Review Track Changes and Comments

Lesson 3: Managing Document Versions
Create a New Version of a Document
Compare document Versions
Merge Document Versions

Lesson 4: Adding Reference
Marks and Notes
Insert Bookmarks
Insert Footnotes and Endnotes
Add Captions
Add Hyperlinks
Add Cross-References
Add Citations and a Bibliography

Lesson 5: Making Long Documents
Easier to Use
Insert Blank and Cover Pages
Insert an Index
Insert Table of Figures
Insert Table of Authorities
Insert Table of Contents
Create a Master Document
Automatically Summarize a Document

Lesson 6: Securing a Document
Update a Document's Properties
Hide Text
Remove Personal Information
from a Document
Set Formatting and Editing Restrictions
Add a Digital Signature to a Document
Restrict Document Access

Outlook 2007 Essentials - 4 hours

Lesson 1: Getting Started with Outlook
Explore the Outlook Interface
Send a Simple Message
Reading Messages
Reply to and Forward a Message
Print a Message
Delete a Message

Lesson 2: Composing Messages
Address a Message
Format a Message
Check Spelling and Grammar
Attach a File

Lesson 3: Organizing Messages
Open and Save an Attachment
Flag a Message
Organize Content with Folders

Lesson 4: Managing Contacts
Add a Contact
Sort and Find Contacts
Find the Geographical Location of a Contact
Manage Contacts

Lesson 5: Scheduling Appointments
Explore the Outlook Calendar
Schedule an Appointment
Assign Categories and Edit Appointments

Lesson 6: Scheduling Meetings
Schedule a Meeting
Reply to a Meeting Request
Propose a New Meeting Time
Manage Meetings
Print the Calendar

Lesson 7: Managing Tasks and Notes
Create a Task
Edit and Update a Task
Create a Note
Edit a Note
Display a Note on the Desktop

Intermediate 2007 Outlook - 4 hours

Lesson 1: Setting Calendar Options
Set Work Days and Times
Display an Additional Time Zone
Set Availability Options

Lesson 2: Customizing Message Options
Modify Message Settings
Modify Delivery Options
Change the Message Format
Notify Others that You will
be Out of the Office
Create a Distribution List
Insert a Hyperlink

Lesson 3: Tracking Work Activities
Using the Journal
Automatically Record a Journal Entry
Manually Record a Journal Entry
Modify a Journal Entry

Lesson 4: Managing Tasks
Assign a Task
Reply to a Task Request
Send a Task Update
Track Assigned Tasks

Lesson 5: sharing Folder Information
Specify Folder Permissions
Delegate Access to Folders
Delegate Access to Folders
Access another User's Folder
Send Calendar Information in
an Email Message

Lesson 6: Customizing the Outlook
Environment
customize the Toolbar
Create a New Toolbar
Customize the Menu Bar
Customize the Quick Access Toolbar
Customize the To-Do Bar
Create a Folder Home Page

Lesson 7: Locating Outlook Items
Sort Messages Using Multiple Criteria
find Messages
Find Outlook Items Using Multiple Criteria
Filter Messages
Organize Messages
Manage Junk Email

Lesson 8: Working with Public Folders
Create a Public Folder
Add Users to a Public Folder
Post Information in a Public Folder
Send an Email Message to a Public Folder

Advanced Outlook 2007- 4 hours

Lesson 1: Personalize Your Email
Apply Stationary and Themes
Create a Custom Theme
Create Signatures
Modify Signatures
Configure Email Message Security
Settings

Lesson 2: Organizing Outlook Items
Group Items
Create Search Folders
Apply Conditional Formatting

Lesson 3: Manage Outlook Data Files
Create a Data File
Add Outlook Data Files to a Mail Profile
Change Data File Settings

Lesson 4: Working with Contacts
Forward Contacts
Edit an Electronic Business Card
Export Contacts
Perform a Mail Merge
Link Items to Business Contact Manager

Lesson 5: Saving and Archiving Email
Save Messages in Alternate Formats
Archive Messages
Protect Personal Folders

Lesson 6: Creating a Custom Form
Add Form Fields
Save a Form as a Template
Test a Form

Lesson 7: Working Offline
and Remotely
Make Folders Available Offline
Configure RPC Over HTTP
Download Selected Messages
Publish Calendar Information
to Office Online

Power Point 2007 Basics - 4 hours

Lesson 1: Getting Started with
PowerPoint
Explore the User Interface
Navigate and View a Presentation
Using Power Point Help
Enter Text
Save a Presentation

Lesson 2: Creating a Presentation
Create a Presentation
Edit Text
Add Slides to a Presentation
Arrange Slides
Work with Themes

Lesson 3: Formatting Text on Slides
Apply Character Formats
Apply Paragraph Formats
Format Text Placeholders

Lesson 4: Adding Graphical Objects
to a Presentation
Insert ClipArt and Pictures
Draw Shapes
Insert WordArt

Lesson 5: Modifying Objects
Work with Objects
Change Object Orientation
Format Objects
Group and Ungroup Objects
Arrange Objects

Lesson 6: Adding Tables
to a Presentation
Create a Table
Format Tables
Insert a Table from Microsoft Word

Lesson 7: Inserting Charts
in a Presentation
Create a Chart
Edit Chart Data
Modify a Chart
Paste a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver
a Presentation
Review Content
Add Transitions
Apply an Animation Effect
Create Speaker Notes
Print the Presentation

Power Point 2007 - Beyond the Basics - 4 hours

Lesson 1: Customizing the
PowerPoint Environment
Customize the Quick Access Toolbar (QAT)
Personalize the PowerPoint Interface
Customize Save Options
Apply Advanced Customization

Lesson 2: Adding Organization
Charts and Diagrams
Working with Organization Charts
Update an Organization Chart
Applying a Chart Layout
Create a Diagram
Draw a Flowchart

Lesson 3: Adding Special Effects
Add Sound and Movies
Add Animation
Emphasize Objects
Set a Motion Path
Set the Order of Effects

Lesson 4: Creating Web
Presentations
Create a Group Home Page with
the AutoContent Wizard
Hyperlink to a Web Page
Publish as a Web Page

Lesson 5: Collaborating
in PowerPoint
Set Password Protection
Work with Comments
Send a Presentation for Review
Merge Revision Copies
Apply Reviewer Changes

Lesson 6: Delivering a
Presentation
Hyperlink Within PowerPoint
Add an Action Button
Set Up a Custom Show
Annotate a Presentation
Working with Narrations
and Slide Timings
Set Up a Slide Show to
Repeat Automatically

Acrobat Basics - 4 hours

Lesson 1: Creating PDFs from
Technical Documents
Create PDF Documents from
within Microsoft Visio
Create PDF Documents from
within Autodesk AutoCAD
Measure Technical Drawing Content

Lesson 2: Enhancing
PDF Documents
Embed Multimedia
Create Actions
Optimize PDF Files
Batch Process PDF Documents
Make a PDF Document More Accessible
Reproduce a PDF Document
for Other Displays

Lesson 3: Creating Interactive
PDF Forms
Create a PDF Form
Add Text Form Fields
Create Calculations
Create Fields with Predefined
Responses
Create Buttons
Organize Collected Data
in a Spreadsheet

Lesson 4: Preparing PDF Files
for Commercial Printing
Examine the Commercial Printing Overview
Choose Appropriate Methods of Creating
PDF Files for Prepress
Apply Color Management Settings
Create and Apply Appropriate Adobe
PDF Settings for Prepress
Preview Printed Effects on Screen

Lesson 5: Finalizing PDF Files
for Commercial Printing
Preflight Documents
Create PDF/X Compliant Files
Create a Composite
Create Color Separations

Intermediate Acrobat - 4 hours

Lesson 1: Creating PDFs from
Technical Documents
Create PDF Documents from
within Microsoft Visio
Create PDF Documents from
within Autodesk AutoCAD
Measure Technical Drawing Content

Lesson 2: Enhancing PDF Documents
Embed Multimedia
Create Actions
Optimize PDF Files
Batch Process PDF Documents
Make a PDF Document More Accessible
Reproduce a PDF Document
for Other Displays

Lesson 3: Creating Interactive Forms
in Adobe Designer
Create a PDF Form
Add Text Form Fields
Create Calculations
Create Fields with Predefined Responses
Create Buttons
Organize Collected Data in a Spreadsheet

Lesson 4: Preparing PDF Files for
Commercial Printing
Examine the Commercial Printing Overview
Choose Appropriate Methods of Creating
PDF Files for Prepress
Apply Color Management Settings
Create and Apply Appropriate Adobe PDF
Settings for Prepress
Preview Printed Effects on Screen

Lesson 5: Finalizing PDF Files
for Commercial Printing
Preflight Documents
Create PDF/X Compliant Files
Create a Composite
Create Color Separations

Adobe Photoshop Elements

Lesson 1: Photoshop Elements Workspace
About Workspaces
Context Menus and Shortcuts
Tools
Palettes and Bins
Undo, Redo, and Cancel

Lesson 2: Getting Photos
Bringing Photos into the Organizer
Local Files, CDs, and DVDs
Cameras and Card Readers
Scanners
Setting Import Preferences

Lesson 3: Viewing Photos in Organizer
Photo Browser
Map View
Date View

Lesson 4: Tagging and
Organizing Photos
Using the Tags Palette
Creating a Tag
Attaching Tags to Photos
Editing Tags and Categories
Creating Collections

Lesson 5: Selecting Parts
of an Image
Making Selections
Modifying Selections
Anti-aliasing and Feathering

Lesson 6: Correcting and
Understanding Color
Color Correction Basis
Adjusting Shadows and Light
Adjusting Color Saturation and Hue
Understanding Color

Lesson 7: Cropping and
Resizing Photos
Cropping
Image Size and Resolution

Lesson 8: Retouching
and Transforming
Retouching
Sharpening
Transforming

Lesson 9: Effects, Styles,
and Filters
Painting
Adding Text and Shapes
Transforming

Lesson 10: Retouching and Transforming
Retouching
Sharpening
Transforming

Lesson 11: Optimizing for
Web and E-mail
Optimizing Images
Dithering in Web Images
Previewing Web Images

Lesson 12: Printing Photos
Printer Options
Exporting Photos

Computer Basics - 4 hours

Lesson 1: Getting started
Orientation to personal computers
The system unit
Connecting the components
Starting the computer

Lesson 2: Input devices
The keyboard
The mouse
Other input devices

Lesson 3: Processing
The CPU
Memory

Lesson 4: Storage
An overview of storage devices
The hard-disk drive
Network Drives
Other storage devices

Lesson 5: Output devices
Monitors
Printers
Modems & Network Cards
Sound

Lesson 6: The operating system
An introduction to Windows operating system
Folder management concepts

Lesson 7: Windows survival guide
The Windows Desktop
Organizing the Desktop
Managing Documents - where they are stored

Lesson 8: Application software
Using application software
     -Outlook E-mail concepts
     -Word concepts
     -Excel concepts

1A - 3 hours

1B - 3 hours

Lesson 1: Today’s Computers
Processors
Memory
System Buses
Input/Output
Audio & Video Standards
Storage
Printing Technologies
 

Lesson 2: Computer Networking
Switched network services
Dedicated network services
Cloud network services
Connectivity to telecommunication services
Routers
Wireless technologies
 

1c - 2 hours

Lesson 3: Operating Systems
Novell NetWare
SuSE Linux
Microsoft
Sun Solaris