Microsoft Office 2007: New Features Curriculum Outline

New Features for End Users in Microsoft Office 2007

Target Audience

Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.

Prerequisites

Users should have experience of the standard functionality of Office XP or Office 2003 prior to taking this course.

Expected Duration

1.50 Hours

Objectives :

New Features for End Users in Microsoft Office 2007

Recognize how to perform common tasks using Microsoft Office 2007.

Recognize how to use the key components of Office 2007s new interface.

Use Microsoft Office 2007 to perform common tasks.

Recognize the new features in Word 2007.

Use Word 2007 to complete common tasks.

Back to List

Microsoft Office Excel, PowerPoint, and Outlook 2007

Target Audience

Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.

Prerequisites

Users should have experience of the standard functionality of Office XP or Office 2003 prior to taking this course.

Expected Duration

1.50 Hours

Objectives :

Microsoft Office Excel, PowerPoint, and Outlook 2007

Recognize the new features in Microsoft Excel 2007.

Use Excel 2007 to complete common tasks.

Recognize the new features in Microsoft PowerPoint 2007.

Use PowerPoint 2007 to complete common tasks.

Recognize the new features in Microsoft Outlook 2007.

Use Outlook 2007 to complete common tasks.

Back to List

Microsoft Access 2007 and Microsoft Publisher 2007

Target Audience

Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.

Prerequisites

Users should have experience of the standard functionality of Office XP or Office 2003 prior to taking this course.

Expected Duration

1 Hour]_DURATION ->

Objectives :

Microsoft Access 2007 and Microsoft Publisher 2007

Recognize the new features in Access 2007.

Use Microsoft Access 2007 to create a blank database and sort the data.

Recognize the new features in Publisher 2007.

Choose a template, customize it, and check it using Publisher 2007.

Back to List

Sharing and Collaboration in Microsoft Office Enterprise 2007

Target Audience

Previous Microsoft Office users, including business customers and individual Office users who plan on upgrading to Office 2007, will be candidates for this training.

Prerequisites

Users should have experience of the standard functionality of Office XP or Office 2003 prior to taking this course.

Expected Duration

2 Hours

Objectives :

Sharing and Collaboration in Microsoft Office Enterprise 2007

Recognize how to use Microsoft Office 2007 with SharePoint.

Recognize how to use Microsoft Office 2007 with SharePoint.

Recognize how to use the enhanced note-taking functions in OneNote 2007.

Use OneNote 2007 to create and share a note in a given scenario.

Recognize how to use InfoPath to create a form.

Use InfoPath 2007 to create and distribute a form in a given scenario.

Recognize how to use the features of Groove 2007.

Use Groove 2007 to collaborate in a given scenario.

Back to List

Microsoft Office 2007: Collaborating, Communicating, and Sharing Information Curriculum Outline

Microsoft Office 2007: Collaborating with Groove and Communicator

Target Audience

End User

Expected Duration

2.00 Hours

Objectives :

Create Collaborative Workspaces with Groove 2007

create a shared workspace

invite team members to join a workspace

Use Groove 2007 Collaboration Tools

track important dates using the Calendar and schedule meetings with the Meetings Tool

use the discussion board

add files using the Files Tool and Sharepoint Files Tool

Real-Time Communication with Groove 2007

communicate with team members by sending messages

connect team members with workspace chat

Get Started with Office Communicator 2007

sign into Communicator and add contacts

identify how Communicator facilitates collaboration

customize your presence

Contact Others with Communicator 2007

send and receive instant messages

communicate using voice or video calls

Back to List

Microsoft Office 2007: Sharing Information with OneNote 2007

Target Audience

End User

Expected Duration

0.50 Hour

Objectives :

Creating and Sharing a Notebook Using OneNote 2007

share a notebook and add information to it

initiate a Live Sharing Session and invite participants

Managing and Finding OneNote 2007 Information

organize and manage information in OneNote

use the Instant Search to locate information in notes

Back to List

Microsoft Access 2007 Curriculum Outline

Getting Started with Access 2007

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Plan an Access 2007 Database

plan a database

Get Started with Access 2007

match the main elements of the Access 2007 screen with their functions

use Access Help

Create Databases in Access 2007

create a database from scratch

create a database from a template

Components and Views of an Access 2007 Database

add a blank datasheet to a database

use views

Back to List

Basic Access 2007 Tables

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Creating Tables in Access 2007

create a table from a template in a given scenario

identify the elements in an Access 2007 table

identify the table templates

Using the Design and Datasheet Views in Access 2007

create a table using Datasheet view

create a table using Design view

Modifying Tables in Access 2007

modify a table

modify a table in Design view

create a validation rule

Using Masked Input Fields and Indexing in Access 2007

create a masked input field in a table

apply indexing to a table

Manipulating Data in Records in Access 2007

view, edit, and navigate records

sort and filter data

find and replace data

print records

Setting up Relationships between Access 2007 Tables

create a relationship

Back to List

Basic Access 2007 Forms

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Create Forms in Access 2007

create a form in Access 2007

Add and Configure Controls in Access 2007

add controls to Access 2007 forms

configure controls on an Access 2007 form

Create and Configure Bound Controls in Access 2007

bind controls to a field in Access 2007

configure bound controls in Access 2007

Customizing and Formatting Forms in Access 2007

customize forms in Access 2007

format forms in Access 2007

Creating and Managing Records in Access 2007

create and modify records

navigate between Access 2007 records

sort and filter Access 2007 records

Back to List

Queries and Reports in Access 2007

Target Audience

End-users seeking to attain competency in Access 2007; end-users seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; end-users seeking to obtain Microsoft Application Professional certification; end-users seeking a basic IT certification such as ECDL/ ICDL, or an equivalent.

Expected Duration

2.00 Hours

Objectives :

Create Queries in Access 2007

create a simple query in design view

create a simple query using the Simple Query Wizard

Refine a Query in Access 2007

modify a query in Access 2007

create an expression with the Expression Builder

Add Calculations to a Query in Access 2007

use calculated fields and grouping in Access 2007

Crosstab Queries in Access 2007

create a crosstab query in Access 2007

refine a crosstab query in Access 2007

Unmatched and Duplicate Queries in Access 2007

find unmatched queries in Access 2007

find duplicate queries in Access 2007

Creating and Using Reports in Access 2007

create a basic report in Access 2007

Adding Controls to Access 2007 Reports

add a control to an Access 2007 report

Organizing Access 2007 Reports

recognize how to modify Access 2007 reports

add a group and calculated summary to a report in Access 2007

Back to List

Importing and Exporting Data and Data Presentation in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

1.50 Hours

Objectives :

Import Data into Access 2007

import data into an Access 2007 database

distinguish between the options available for importing data into Access 2007

Export Data from Access 2007

export Access 2007 data

distinguish between the formats you can export to from Access 2007

Collect Data Using E-mail Messages

set up data collection in Access 2007

collect data by using e-mail messages

Create and modify a PivotTable in Access 2007

build an Access 2007 PivotTable

modify a PivotTable in Access 2007

Create and Modify a PivotChart in Access 2007

build a PivotChart in Access 2007

modify an Access 2007 PivotChart

Back to List

Advanced Data Management in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

2.50 Hours

Objectives :

Retrieve Related Data in Access 2007

add a lookup field to an Access 2007 table

add a subdatasheet to a table

Working with the Attachment Feature in Access 2007

add attachments to Access 2007 records

Validate Data in Access 2007

implement data validation in Access 2007

Use Subforms, Subreports, and Conditional Formatting in Access 2007

add Subforms to an Access 2007 database

add Subreports to an Access 2007 database

apply conditional formatting to a form in Access 2007

Joins and Parameter Queries in Access 2007

create and edit joins in Access 2007 databases

create and use simple parameter queries

Action Queries in Access 2007

create and run update and append queries in Access 2007

create and run a make table query

delete data from an Access 2007 database

Access 2007 Queries and SQL

create union queries in Access 2007

recognize how to create or modify Access 2007 tables and indexes using data-definition queries

perform SQL processing on a server

edit the SQL of a SELECT query and use subqueries

Back to List

Programmability and Administration in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

1.50 Hours

Objectives :

Introducing SharePoint and Access 2007

determine how to move data to a SharePoint site

specify how to publish data to a SharePoint site

Working with Access 2007 and SharePoint Lists

create an Access view of a SharePoint list

work with SharePoint lists

Working Offline and Tracking Access 2007 Data

take SharePoint list data offline

work offline and track data in Access 2007

Use Macros in Access 2007

create and edit Access 2007 macros

run Access 2007 macros

VBA in Access 2007

use VBA to create an event handler in Access 2007

work with event handlers in Access 2007

Back to List

Database Administration in Access 2007

Target Audience

Anyone wishing to become familiar with Microsoft Access 2007 at an advanced level; anyone seeking to obtain Microsoft Application Specialist certification in the use of Microsoft Access 2007; anyone seeking to obtain Microsoft Application Professional certification.

Expected Duration

2.00 Hours

Objectives :

Personalize Access 2007

customize datasheets in Access 2007

Access 2007 Maintenance and Management

recognize how to compact and repair a database

illustrate how to convert earlier Access database formats to Access 2007

specify how to back up databases and restore database files

Optimize Access 2007 Database performance

outline how to view and change object dependencies in Access 2007

illustrate how to analyze objects for performance

outline how to use the database documenter and the Table Analyzer wizard to optimize database performance

Secure Database Information in Access 2007

identify how to enable content for an Access 2007 database

recognize how to hide a database object

Set a password and secure VB code in Access 2007

summarize how to encrypt a database by setting a database password

restate how to protect VB code in Access 2007

Share a Database in Access 2007

determine how to split a database and repair database links

use an Office Access 2007 database in a trusted location

restate how to package, sign, and distribute an Office Access 2007 database

Create a Switchboard in Access 2007

outline how to work with switchboards and the Navigation Pane

outline how to create a custom group and add objects to it

Back to List

Microsoft Excel 2007 Curriculum Outline

Getting Started with Excel 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Expected Duration

1.50 Hours

Objectives :

Spreadsheets and Excel 2007

Match basic Excel 2007 features with their functions

Recognize how to use the Help feature in a given scenario

Create and Navigate Workbooks in Excel 2007

Create a new Excel workbook in a given scenario

Open an existing Excel workbook in a given scenario

Navigate through an Excel workbook

Enter Data and Text in Excel 2007

Enter data in an Excel worksheet in given scenario

Save Work in Excel 2007

Save a new workbook

Distinguish between the common file formats used to save work in Excel 2007

Back to List

Manipulating and Formatting Data and Worksheets

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Expected Duration

3.50 Hours

Objectives :

Copy and Move Data in Excel 2007

Copy or move data in given scenarios

Modify Rows and Columns in Excel 2007

Add, delete, or resize rows and columns in a given scenario

Modify rows and columns to view specific sections of the worksheet

Insert and Modify Worksheets in Excel 2007

Format workbooks in given scenarios

Insert and delete a worksheet

Rename a worksheet and format the tab color

Copy or move worksheets

Format Data in Excel 2007

Apply basic data formatting

Format a data range as a table

Change the position of data in a cell in a given scenario

Identify the functions of Alignment commands

Format Data as a Table in Excel 2007

Work with tables in Excel 2007

Format a data range as a table

Modify an Excel table

Format Numbers in Excel 2007

Apply number formats in a given scenario

Identify the number formatting options available in Excel 2007

Conditional Formatting in Excel 2007

Apply basic conditional formatting rules in a given scenario

Recognize situations when conditional formatting is suitable

Back to List

Reviewing and Printing in Excel 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007

Expected Duration

1.50 Hours

Objectives :

Excel 2007 Review Features

Use Excel 2007 review tools in a given situation

Work with comments

Use the track changes tool

Prepare an Excel 2007 Worksheet for Printing

Customize page setup using the Page Layout View

Adjust page breaks using the Page Break Preview

Print Options in Excel 2007

Print a worksheet in a given scenario

Back to List

Excel 2007 Formulas and Functions

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Expected Duration

2.25 Hours

Objectives :

Basics of Formulas and References in Excel 2007

Identify the elements of a formula

Identify the default order in which calculations occur

Match absolute, relative, mixed, and 3-D references with examples

Insert Formulas in Excel 2007

Insert an Excel 2007 formula

Use names to clarify formulas

Edit formulas

Perform AutoCalculate Functions in Excel 2007

Use the AutoCalculate feature to perform basic functions

Logical, Financial, and Date Functions in Excel 2007

Use a logical function

Use a financial function

Use a date function

Back to List

Excel 2007 Charts, Pictures, Themes, and Styles

Target Audience

Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007

Expected Duration

1.50 Hours

Objectives :

Using Charts in Excel 2007

Insert an Excel 2007 chart

Identify the main elements of a chart

Updating Charts in Excel 2007

Change Excel 2007 charts

Change the data range included in the chart

Move a chart to a new worksheet

Insert Illustrations in Excel 2007

Insert illustrations in Excel 2007

Use Excel 2007 Themes and Styles

Apply a theme

Apply a cell style

Back to List

Advanced Formatting in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Expected Duration

2.50 Hours

Objectives :

Format Charts in Excel 2007

Format chart elements in Excel 2007

Identify Chart Tools commands for customizing chart elements

Save and apply a chart template

Modify Pictures in Excel 2007

Use the Adjust formatting commands to modify a picture

Recognize the commands for formatting a pictures style

Format a pictures size and properties

Create and Edit Excel 2007 Custom Number Formats

Create a custom number format

Identify codes for custom number formats

Use Advanced Conditional Formatting in Excel 2007

Create a new conditional formatting rule

Recognize how conditional formatting cell precedence works

Find cells that have conditional formats

Back to List

Advanced Data Management in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Sorting and Filtering Data in Excel 2007

Sort data

Filter data in a range or table

Subtotal, Group, and Outline Data in Excel 2007

Group and outline data

Insert subtotals in a worksheet

Display different levels of data using outlines

Validate Data in Excel 2007

Specify the data that is allowed in a particular range

Recognize which error alert to use in given examples

Audit and Correct Formulas in Excel 2007

Locate and correct formula errors

Use the Watch Window to audit formulas

Back to List

Advanced Customization in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at Expert level or an equivalent.

Expected Duration

2.00 Hours

Objectives :

Creating Templates in Excel 2007

Create an Excel template

Customizing Themes and Styles in Excel 2007

Create new cell styles in Excel 2007

Customize Excel 2007 themes

Customizing Workbook Settings in Excel 2007

Customize workbook settings

Change the workbook properties

Record and Run an Excel 2007 Macro

Record and run a macro

Match macro security settings with their effects

Work with Excel Macros

Edit and delete macros

Assign a button to a macro and add it to the Quick Access Toolbar

Back to List

Analyzing Data in Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration

3.50 Hours

Objectives :

PivotTable Reports in Excel 2007

create a PivotTable report

rearrange PivotTable data

Excel 2007s PivotTable Tools

customize PivotTable reports

modify the look and feel of a PivotTable report

PivotChart Reports in Excel 2007

create a PivotChart report

modify a PivotChart report

Calculations in Excel 2007 PivotTables Reports

perform calculations in PivotTables reports

recognize when to use each calculation type

Work with Goal Seek and Solver in Excel 2007

use Goal Seek to perform data analysis

use Solver to perform data analysis

Create Scenarios in Excel 2007

create scenarios for what-if analysis

use the Scenario Manager to modify scenarios

Create a Data Table and Project Values in Excel 2007

create a one-variable data table for data analysis

create a two-variable data table for data analysis

project values in a series

Use Advanced Functions in Excel 2007

perform advanced functions

match advanced functions with examples of when you would use them

consolidate data from different workbooks using a Summary function

Back to List

Protecting and Sharing Excel 2007 Workbooks

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration

2.00 Hours

Objectives :

Worksheet and Workbook Protection in Excel 2007

protect a workbook in a given example

apply worksheet protection in a given example

Authenticate Workbooks with Excel 2007

identify the features of digital signatures in Excel 2007

Share Workbooks in Excel 2007

share workbooks on a network location

merge shared workbooks

Publish Excel 2007 Workbooks to SharePoint

publish a workbook to a SharePoint library

perform basic actions using SharePoint

Back to List

Exchanging Data with Excel 2007

Target Audience

End users seeking proficiency in the use of Microsoft Excel 2007 at a power user level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2007 at an Expert level or an equivalent.

Expected Duration

2.50 Hours

Objectives :

Link, Import, and Embed Data in Excel 2007

create links to data

identify how to import data

embed a file in a workbook

Create Database Queries in Excel 2007

create database queries in Excel 2007

import an entire Access table

Import Excel 2007 Data into Other Applications

import Excel data into Access

copy Excel data to Word

import Excel data into Outlook

Introduction to XML in Excel 2007

identify how XML works in Excel

recognize the components of a basic XML system

Work with XML Data in Excel 2007

create an XML map and map elements to it

import XML data

export XML data into mapped cells

Back to List

Microsoft Outlook 2007 Curriculum Outline

Getting Started with Outlook 2007

Target Audience

End User

Expected Duration

1.50 Hours

Objectives :

First Steps in Outlook 2007

Launch Outlook 2007

Recognize how incoming e-mail messages are displayed in the Inbox

Recognize Outlook window features and their functions

Creating an E-mail Message in Outlook 2007

Create a new e-mail message

Viewing Incoming E-mails and Replying in Outlook 2007

Preview an incoming e-mail message

View an e-mail message in the Inbox using the Reading Pane

View an incoming e-mail message in a separate window

Reply to an e-mail message

Basic Help Features in Outlook 2007

Get help using the Browsing categories feature, given a scenario

Get help using the Searching feature, given a scenario

Get help using the Table of Contents feature, given a scenario

Back to List

Formatting and Managing E-mail in Outlook 2007

Target Audience

End User

Expected Duration

1.50 Hours

Objectives :

E-mail Formatting in Outlook 2007

Format an e-mail message, given a scenario

Apply stationery and themes to an e-mail message, given a scenario

Signatures and AutoReplies in Outlook 2007

Create a signature for an e-mail message in a given scenario

Create an auto-reply in a given scenario

E-mail Options in Outlook 2007

Set up a Read and Delivery receipt in a given scenario

Recall an e-mail message in a given scenario

Add voting buttons to an e-mail message in a given scenario

Respond to a poll in an e-mail message, given a scenario

E-mail Attachments in Outlook 2007

Add an attachment to an e-mail message in a given scenario

Preview an e-mail attachment in a given scenario

Edit an e-mail attachment in a given scenario

Color Coding and Flagging E-mail in Outlook 2007

Use color coding to organize e-mail messages in the Inbox, given a scenario

Use color categories to organize e-mail messages in the Inbox, given a scenario

Add a flag to an e-mail message in a given scenario

E-mail Arrangement Options in Outlook 2007

Arrange e-mail messages in the Inbox using the View menu, given a scenario

Use the Search Folders feature to view different types of e-mail messages in the Inbox, given a scenario

Use the Inbox column headings to arrange e-mail messages, given a scenario

Arrange read and unread e-mail messages in the Inbox, given a scenario

Back to List

Using the Calendar in Outlook 2007

Target Audience

End User

Expected Duration

2.00 Hours

Objectives :

Introduction to the Outlook 2007 Calendar

Configure how the Calendar is displayed, given a scenario

Appointments and Events in Outlook 2007

Schedule an appointment directly in the Calendar, given a scenario

Schedule an appointment using the appointment form, given a scenario

Schedule an appointment from an e-mail message attachment, given a scenario

Scheduling Meetings in Outlook 2007

Use the Meeting Requests feature to schedule a meeting, given a scenario

Use the Plan a Meeting feature to schedule a meeting, given a scenario

Recognize how to change an appointment to a meeting, given a scenario

Managing Meetings in Outlook 2007

Respond to a meeting request in a given scenario

Change a meeting request in a given scenario

Track a meeting in a given scenario

Cancel a meeting in a given scenario

Updating and Repeating Calendar Entries in Outlook 2007

Edit Calendar entries in a given scenario

Create a recurring Calendar entry in a given scenario

Change an existing Calendar entry to a recurring entry in a given scenario

Edit a recurring entry in a given scenario

Customizing the Outlook 2007 Calendar

Customize the calendar using the Calendar Options dialog box, given a scenario

Customize calendar entries by applying color to them, given a scenario

Customize the To-Do bar, given a scenario

Customize the calendar by creating additional calendars, given a scenario

Back to List

Using Contacts, Tasks, Notes, and Customizing the Interface in Outlook 2007

Target Audience

End User

Expected Duration

2.75 Hours

Objectives :

Creating Contacts in Outlook 2007

Create a new contact using the New Contact feature, given a scenario

Create a distribution list, given a scenario

Recognize how to create a contact from an e-mail that you receive

Recognize how to create multiple contacts from the same company

Viewing and Using Contacts in Outlook 2007

View your contacts, given a scenario

Perform tasks using your contacts, given a scenario

Send a contact as an electronic business card, given a scenario

Creating Tasks in Outlook 2007

Create a task, given a scenario

Recognize how to view your tasks

Recognize how to update a task, given a scenario

Managing Tasks in Outlook 2007

Assign a task, given a scenario

Reclaim an assigned task that has been rejected

Track a task that you have assigned, given a scenario

Recognize the different ways to display tasks

Using Notes in Outlook 2007

Create a note, given a scenario

Customize a note, given a scenario

Recognize how to change the view of the Notes folder

Customization of the Outlook 2007 Interface

Customize Outlook Today for the Outlook interface, given a scenario

Add folders to Favorite Folders, given a scenario

Work with shortcuts, given a scenario

Customize the Navigation Pane, given a scenario

Back to List

Completing Searches, Printing Items, and Working with RSS Feeds in Outlook 2007

Target Audience

End User

Expected Duration

1.50 Hours

Objectives :

Organizing and Sharing Folders in Outlook 2007

Create a private folder with permission for other users to access it, given a scenario

Create a public folder with permission to share it with other users, given a scenario

Move items between private and public folders, given a scenario

Searches and Search Folders in Outlook 2007

Recognize how to perform a basic search using Instant Search

Recognize how to perform an advanced search using Instant Search

Create a Search Folder, given a scenario

Printing Items in Outlook 2007

Print Outlook items, given a scenario

RSS Feeds in Outlook 2007

Add an RSS Feed, given a scenario

Read an RSS Feed, given a scenario

Cancel an RSS Feed, given a scenario

Back to List

Customizing Views, Tracking Items, and Adding E-Mail Accounts to Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Office Outlook 2007.

Expected Duration

1.50 Hours

Objectives :

Customizing Views in Outlook 2007

Create a new view in Outlook 2007

Customize an Outlook 2007 view

Customizing Menus and Toolbars in Outlook 2007

Create a custom toolbar

Recognize how to customize menus and toolbars

Customize the Quick Access toolbar

Configuring E-mail Accounts in Outlook 2007

Add a new e-mail account to Outlook 2007

Change e-mail account settings in Outlook 2007

Remove an e-mail account in a given scenario

The Journal in Outlook 2007

Record a Journal entry in a given scenario

Recognize how to open and configure the Journal

Use the timeline to change the start and end date of a Journal entry in a given scenario

Back to List

Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Office Outlook 2007.

Expected Duration

1.50 Hours

Objectives :

Filtering E-mail Using Rules in Outlook 2007

Create a rule from a template in a given scenario

Create a rule from a message in a given scenario

Run a rule manually in a given scenario

Modify a rule in a given scenario

Out of Office Assistant and Public Folder Rules

Create a rule for the Out of Office Assistant in a given scenario

Add a rule to a public folder in a given scenario

Using Alerts in Outlook 2007

Switch on desktop alerts in a given scenario

Extend the onscreen duration of a desktop alert in a given scenario

Set up an alert for a SharePoint library in a given scenario

Introducing the Junk E-mail Filter in Outlook 2007

Recognize how the Junk E-mail Filter works

Recognize the functions of the filter lists

Controlling Junk E-mail in Outlook 2007

Set the level of junk e-mail protection to low in a given scenario

Add e-mail addresses to the Safe Senders and Blocked Senders lists in a given scenario

Mark an e-mail as not junk in a given scenario

Empty the Junk E-mail folder in a given scenario

Back to List

Working with SharePoint, Calendars, and Forms in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the use of Microsoft Office Outlook 2007.

Expected Duration

0.50 Hour

Objectives :

Working with SharePoint Files in Outlook 2007

Connect to a SharePoint library from Outlook in a given scenario

Open a SharePoint file from Outlook in a given scenario

Disconnect Outlook from SharePoint in a given scenario

Managing SharePoint Tasks and Contacts in Outlook 2007

Create an Outlook task for a SharePoint site in a given scenario

Add an event to a SharePoint calendar from Outlook in a given scenario

Add a SharePoint contact to Outlook in a given scenario

Creating and Using a Group Schedule in Outlook 2007

Create a group schedule in a given scenario

Display the group schedule for times outside working hours in a given scenario

Send a meeting request message from a group schedule in a given scenario

Using Internet Calendars in Outlook 2007

Add an Internet Calendar subscription to Outlook in a given scenario

Publish a calendar to Microsoft Office Online in a given scenario

Sharing the Calendar in Outlook 2007

Open another persons calendar in a given scenario

Add a delegate in a given scenario

Introduction to Forms in Outlook 2007

Choose a form in a given scenario

Creating and Publishing Forms in Outlook 2007

Create a form in a given scenario

Modify a form action in a given scenario

Test and publish a form to a library in a given scenario

Back to List

Data Security, Archiving, and Working Offline in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2007.

Expected Duration

2.50 Hours

Objectives :

Setting Security Options in Outlook 2007

disable add-ins in a given scenario

disable all macros except digitally signed ones in a given scenario

add someone to the Trusted Publishers list in a given scenario

Using Digital Certificates in Outlook 2007

get a digital ID in a given scenario

digitally sign an e-mail, given a scenario

back up a digital ID in a given scenario

use an encrypted e-mail message

Archiving Data and Managing the Mailbox Size in Outlook 2007

specify the frequency of AutoArchive in a given scenario

Manually archive Outlook 2007 items in a given scenario

set AutoArchive options for a specific folder in a given scenario

clean up your mailbox in a given scenario

Using Data Files in Outlook 2007

create a Personal Folders file in a given scenario

change the data file where content is saved in a given scenario

open a Personal Folders file in a given scenario

Configuring Remote Connections in Outlook 2007

set up remote connections to Outlook in a given scenario

access your e-mail via Outlook Web Access in a given scenario

Working offline with Exchange

configure a Cached Exchange mode setting in a given scenario

set up a prompt to work offline in a given scenario

Using Send/Receive Groups and Remote Mail

create a Send/Receive group in a given scenario

download the offline address book in a given scenario

filter the items that are downloaded to your offline folders in a given scenario

process Remote Mail headers in a given scenario

Back to List

IRM, Instant, Text, and Unified Messaging in Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2007.

Expected Duration

0.50 Hour

Objectives :

Instant and Text Messaging from Outlook 2007

turn on instant message online status in Outlook in a given scenario

create and send a text message in a given scenario

forward an Outlook item as a text message in a given scenario

Unified Messaging in Outlook 2007

configure Unified Messaging in a given scenario

play a voice message on a telephone in a given scenario

Back to List

Business Contact Manager with Outlook 2007

Target Audience

Personnel at all levels of the enterprise; end users seeking competency in the advanced functionality of Microsoft Outlook 2007.

Expected Duration

2.00 Hours

Objectives :

Getting Started with Business Contact Manager

distinguish the types of records used in BCM

recognize the functions of BCM interface elements

Configuring Accounts, Contacts, and Opportunities

create an Account in BCM in a given scenario

create a new business contact for an account in a given scenario

create an opportunity in a given scenario

Creating Marketing Campaigns and Business Projects

create a Marketing Campaign in a given scenario

track the results of a Marketing Campaign in a given scenario

create a business project in a given scenario

Generating Linked Items for BCM Records

link an account to an opportunity in a given scenario

link a file to an account in a given scenario

link a phone log to a record in a given scenario

Managing Linked Items in BCM

view a communication history in a record in a given scenario

link an item to more than one record in a given scenario

move a link to another record in a given scenario

auto-link an e-mail message to a record in a given scenario

Using Reports in BCM

create a report in a given scenario

export a report in a given scenario

launch a Marketing Campaign from a report

Protecting and Sharing Data in BCM

select a new database for your profile in a given scenario

delete and restore a database in a given scenario

export data from a database in a given scenario

Back to List

Microsoft PowerPoint 2007 Curriculum Outline

Getting Started with PowerPoint 2007

Target Audience

End User

Expected Duration

1.0 Hour

Objectives :

First Steps in PowerPoint 2007

recognize the functions of elements of the PowerPoint screen

recognize the steps for adding a command to the Quick Access Toolbar

Creating Your First Presentation in PowerPoint 2007

create a basic presentation in PowerPoint 2007

format content in a PowerPoint presentation

add slides to a presentation

change the layout of a PowerPoint slide

Using Views in PowerPoint 2007

change the default view in PowerPoint 2007

match PowerPoint views with their descriptions

Using the Help Features in PowerPoint 2007

search online Help in PowerPoint

Back to List

Adding Graphics to Presentations in PowerPoint 2007

Target Audience

End User

Expected Duration

1.5 hours

Objectives :

Using Themes in PowerPoint 2007

apply a theme to a presentation in PowerPoint 2007

customize a theme in a PowerPoint 2007 presentation

Inserting Objects in PowerPoint 2007

insert objects in PowerPoint presentations

SmartArt graphics in PowerPoint 2007

modify the appearance of PowerPoint slides using SmartArt graphics

Creating Charts and Tables in PowerPoint 2007

add a chart or a table in PowerPoint

modify the data in an embedded chart

Formatting Charts and Tables in PowerPoint 2007

change the appearance of a PowerPoint chart

modify the appearance of a PowerPoint table

Back to List

Adding Multimedia and Animations to Presentations

Target Audience

End User

Expected Duration

1.0 hours

Objectives :

Inserting Multimedia in PowerPoint 2007

insert a multimedia clip in a presentation

insert a sound clip in PowerPoint

Animating Slide Content in PowerPoint 2007

animate an object in PowerPoint

Specifying Slide Transitions in PowerPoint 2007

specify a transition for a slide in PowerPoint

recognize the options for transitioning between slides in a presentation

Adding Navigation Elements in PowerPoint 2007

identify the ways to enhance navigation in a PowerPoint presentation

add a hyperlink to a slide

add an action button to a slide

Back to List

Creating Custom Slide Shows in PowerPoint 2007

Target Audience

Office personnel at all levels; those wishing to become familiar with PowerPoint 2007.

Expected Duration

0.5 Hour

Objectives :

Creating Custom Slide Shows in PowerPoint 2007

customize a PowerPoint slide show

hide a slide in a custom slide show

Delivering Slide Shows in PowerPoint 2007

identify the options for writing on a slide during a presentation

turn on presenter view

create a self-running presentation

Back to List

Distributing Presentations in PowerPoint 2007

Target Audience

Office personnel at all levels; those wishing to become familiar with PowerPoint 2007.

Expected Duration

0.5 Hour

Objectives :

Securing and Printing Presentations in PowerPoint 2007

secure a presentation in PowerPoint 2007

print a PowerPoint slide show

Distributing Presentations in PowerPoint 2007

distribute a PowerPoint presentation

Back to List

Microsoft Project 2007 Curriculum Outline

Creating and Designing a Project with Project 2007

Overview/Description
In the corporate world, the project is a fundamental building block. Each project in which a company engages is unique, and fulfills an individual or corporate goal. And each project comprises a series of related tasks that culminate in a project deliverable. Microsoft Office Project 2007 is a comprehensive tool for project managers responsible for the overall design of projects, enabling them to engage in task assignment and management, resource allocation, costs, and budget control in an easy and intuitive way. Microsoft Office Project 2007 also enables the collection and sharing of project progress information with a projects team members and stakeholders. This course outlines the basics of project management, and shows how to create and manage a new project using Microsoft Office Project 2007.

Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project 2007; end users seeking competence in Microsoft Office Project 2007.

Expected Duration
3.50 Hours

Basic Concepts in Project Management

recognize the distinguishing features of projects

interpret the relationships between the elements of a project

match project management phases with their descriptions

Introducing Office Project 2007

turn the Project Guide on or off

access views in Project 2007

match Project 2007 reports with their descriptions

Using Help in Project 2007

access Help in Project 2007

recognize Project 2007s Help options

Creating a Project

create and save a new project

create a new project from a template

Defining a Project

define a project

define general work times for a project

Entering Project Tasks

create a task list

set a tasks duration

recognize the characteristics of milestone tasks

Organizing Project Tasks

create a project structure

Scheduling Project Tasks

create a task dependency link

recognize the characteristics of task dependencies

creating a recurring task

split a task

Adding Links, Constraints, and Information to Tasks

add information to a task

add a hyperlink to a task

impose a constraint on a task

Back to List

Specifying and Assigning Resources in Project 2007

Overview/Description
In Microsoft Office Project 2007, people, equipment, and materials are collectively referred to as resources. A large part of a project managers responsibilities is managing these resources, whether that be assigning resource work times, leveling resources that are overallocated, and overseeing the budgeting and costs of resources. This course provides an overview of resource management for projects, and will help you get to grips with Microsoft Office Project 2007s robust resource management tools.

Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project 2007; end users seeking competence in Microsoft Office Project 2007.

Expected Duration
2.50 Hours

Specifying Resources and Work Times

add a work resource to a project

add a material resource to a project

set the working time for a resource

Assigning Resources

assign a work resource to a task

assign a material resource to a task

add information to a resource assignment

Changing and Controlling the Schedule

disable effort-driven scheduling

change the task type in a given scenario

apply a contour to a task in a given scenario

Leveling Overallocated Resources

level a resource

find out what resources have been overallocated

Managing Costs

add a cost for a resource

recognize costs that need to be fixed

Back to List

Tracking and Reporting Progress with Project 2007

Overview/Description
Project stakeholders have a vested interest in the projects progress so information needs to be tracked, recorded, and reported. A project manager needs to decide on the information to be tracked, and how to track it. Microsoft Office Project 2007 helps a project manager by making this process easy. Baselines and interim plans, for example, create benchmarks for a projects progress. Built-in views and reports helps a project manager to assess a projects progress. Project managers also have the option to customize a new view or report. This course explores these features of Microsoft Office Project 2007 and how a project manager can use them to address a projects tracking and reporting needs.

Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project 2007; end users seeking competence in Microsoft Office Project 2007.

Expected Duration
2.50 Hours

Understanding Baselines

create a baseline for a project

create an interim plan

clear a baseline

Tracking Basics

track project information for a task

use the correct task tracking method in a given scenario

Preparing for Tracking

recognize the functions of Project 2007s tracking tools

prepare a project for tracking

identify the tracking view to use in a given scenario

Checking Progress

check the progress of a project

display progress lines

Selecting a View or Report

identify the available reporting options in Project 2007

select a view in a given scenario

select a report in a given scenario

Changing Views and Reports

change the information in a view

change the appearance of the Gantt chart view

recognize the reasons for identifying the critical path

Formatting and Printing a Report

format a report for printing

set up and print a report or view

identify the print options available from the Print Current View wizard

Back to List

Advanced Customization with MS Project 2007

Overview/Description
With Microsoft Office Project 2007, project managers can define how project data is recorded, reported, and displayed, using customizable, built-in templates. They can also customize the interface by adding or removing tools from the applications default toolbars. And before project data is distributed, a project manager can format fields and views to meet particular needs. Additionally, if you need to modify information associated with tasks and resources, create custom tables, or create a work breakdown structure, Project 2007 provides a flexible, all-encompassing solution. This course outlines the basics of customizing Microsoft Office Project 2007, and also provides insights into some of the advanced customization features

Target Audience
Business managers, project managers, planners, and team members wishing to gain advanced knowledge of Microsoft Office Project Professional 2007; candidates for the Microsoft User Specialist certification; end users seeking competence in Microsoft Office Project Professional 2007

Expected Duration
2.00 Hours

Customizing Settings and Toolbars in Project 2007

modify the default settings in Project 2007

create a custom toolbar

Customizing Templates in Project 2007

customize the Project Global template

recognize the conditions for customizing the Enterprise Global template

save a project as a template

Customizing Fields and Forms in Project 2007

add a custom field in Project 2007

create a custom form

Customizing Tasks and Resources in Project 2007

add information to tasks

add custom information to resources

create a custom table

Using WBS Codes in Project 2007

recognize the uses of WBS codes

create a new WBS code

Back to List

Project Data Management and Performance with MS Project 2007

Overview/Description
Project managers often share Project 2007 data with other applications, such as Microsoft Excel and Microsoft Outlook. When importing and exporting information in this way, the information must first be sorted, filtered, and grouped to customize the informations appearance. Information also needs to be timely and actual work performed, actual start and finish dates, and actual costs must all be updated. This course outlines the basics of importing and exporting, sorting, filtering, and grouping information to meet a projects needs. It also discusses creating and sharing resource pools in a multi-project environment, how to manage the efficient use of limited resources to keep multiple projects on schedule, and how to create task dependencies across multiple projects

Target Audience
Business managers, project managers, planners, and team members who want to track and manage project tasks, costs, and resources; candidates for Microsoft User Specialist certification; anyone wishing to gain a basic understanding of Microsoft Office Project Professional 2007; end users seeking competence in Microsoft Office Project Professional 2007

Expected Duration
3.00 Hours

Importing and Exporting Data

import data into a project

import a task list into a project

export data from Project 2007

Sorting Project Information in Project 2007

recognize the basic sorting options in Project 2007

perform an advanced sort in Project 2007

Applying Filters and Groups in Project 2007

apply a filter in Project 2007

create a custom group

Updating Project Information

update actual work for a project

update the actual start and finish dates for a task

update the actual and remaining duration for a task

update percentages for a task

Updating Actual Costs

recognize the purpose of Project 2007s Cost tables

update costs in Project 2007

Consolidating Projects in Project 2007

create subprojects for a consolidated project

consolidate a project

recognize the different options for saving a consolidated project

view critical paths for subprojects in a consolidated project

Sharing and Consolidating Resources in Project 2007

share a projects resources in a resource pool

disable a resource pool

Creating Dependencies Across Projects in Project 2007

create an external dependency

update external dependencies

Back to List

Mentoring 70-632 TS: Microsoft Office Project 2007, Managing Projects

Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 70-632 TS: Microsoft Office Project 2007, Managing Projects. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.

Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Expected Duration (hours)
0.0

Lesson Objectives

Mentoring 70-632 TS: Microsoft Office Project 2007, Managing Projects

Configuring Tools and Options

Setting Up a Project

Estimating, Scheduling, and Budgeting Tasks

Resourcing Project Plans

Updating and Reporting on Project Performance

Course Number:
mnt70632

Back to List

TestPrep 70-632 TS: Microsoft Office Project 2007, Managing Projects

Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.

Prerequisites
The associated SkillSoft certification content should be completed before attempting this TestPrep. This will maximize the effectiveness of the preparation exam.

Expected Duration (hours)
0.0

Lesson Objectives

TestPrep 70-632 TS: Microsoft Office Project 2007, Managing Projects

Configuring Tools and Options

Setting Up a Project

Estimating, Scheduling, and Budgeting Tasks

Resourcing Project Plans

Updating and Reporting on Project Performance

Course Number:
TP70632_eng

Back to List

Microsoft Project Server 2007 Curriculum Outline

Initiating Projects with Project Server 2007

Overview/Description
In today’s business environment, rarely does a company have a single project manager overseeing a single project. Businesses are fast-paced, with multiple project managers in charge of a variety of projects, often across many locations. Microsoft Office Project Server 2007 is the main component of the Microsoft Office Enterprise Project Management Solution and the toolset best suited to keep project managers, teams, and stakeholders updated with the latest multi-project information. This course introduces some of the features and processes of Project Server 2007, including implementing a collaborative Microsoft Office Enterprise Project Management (EPM) solution, and working with Project Web Access. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office Project Server 2007: Managing Projects 70-633 exam. Passing this exam will earn the learner the MCTS: Enterprise Project Management with Microsoft Office Project Server 2007 certification. In turn, this certification counts as a credit toward the MCTS: Microsoft Certified IT Professional: Enterprise Project Management with Microsoft Office Project Server 2007 certification.

Target Audience
Business managers, project managers, and project team members who want to begin using Project Server 2007 and PWA in a multi-project environment; anyone wishing to gain a basic understanding of Mircrosoft Office Project Server 2007; end users seeking competence with Microsoft Office Project Server 2007.

Prerequisites
Familiarity with Microsoft Windows and Office environments, and a basic knowledge of project management concepts contained in the Project Management Institutes Project Management Body of Knowledge (PMBOK Guide).

Expected Duration (hours)
2.5

Lesson Objectives
Initiating Projects with Project Server 2007

Recognize some of the main capabilities of Project Server 2007

Recognize some of the main permissions allowed to default groups

Recognize some of the main new features of Project Server 2007

Create an enterprise project

Create an enterprise project

Recognize key aspects of initiating a project

Create a workspace site for a project

Import projects to Project Server 2007

Create a risk

Create a project workspace site

Import a project to Project Server 2007

Create a risk

Track project processes using PWA

Create a project proposal and resource plan

Create a project activity plan

Manage documents in a projects document library

Track project issues

Create a project proposal and resource plan

Create a folder structure in the documents library and upload a document

Course Number:
mo_psmp_a01_dt_enus

Back to List

Planning Projects with Project Server 2007

Overview/Description
Successful projects are the result of successful project plans. By combining the use of Microsoft’s Office Project Professional with use of Office Project Server, a project manager has the tools to manage and oversee all aspects of project plans and deliverables. This course describes the project, scope, and schedule, risk, and staffing management plans, and how a project manager can combine the benefits of using Office Project Web Access and Office Project Server 2007 to ensure projects come to a successful conclusion. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office Project Server 2007: Managing Projects 70-633 exam. Passing this exam will earn the learner the MCTS: Enterprise Project Management with Microsoft Office Project Server 2007 certification. In turn, this certification counts as a credit toward the MCTS: Microsoft Certified IT Professional: Enterprise Project Management with Microsoft Office Project Server 2007 certification.

Target Audience
System administrators, project managers, project support staff, and IT professionals tasked with the responsibility of planning, implementing, and using Microsoft Office Project Server 2007 in conjunction with Microsoft Office Project 2007 in a project enterprise environment; learners preparing for the tecnical support certification exams.

Prerequisites
Familiarity with Microsoft Windows and Office environments; a basic knowledge of project management concepts and terminology found in the Project Management Institutes Book of Knowledge (PMBOK Guide).

Expected Duration (hours)
2.0

Lesson Objectives
Planning Projects with Project Server 2007

Recognize key elements of the Project Management Plan

Create the scope management plan for a project

Recognize key elements of the Project Schedule Plan

Create tasks

Specify WBS codes

Create project deliverables

Create inter-project dependencies

Customize the Deliverables feature in PWA

Create project deliverables and dependencies, and customize the Deliverables feature

Course Number:
mo_psmp_a02_dt_enus

Back to List

Managing Resource Capacity in Project Server 2007

Overview/Description
Resource capacity management is the ability to plan the right combinations of resources, skills, availability, and costs to get the task done. To do this without overlooking a task or under or over-utilizing a resource is a project manager’s ultimate goal. This course identifies the types of resources available to both project managers and project teams, and the management tools used to ensure the most efficient use of these resources using Microsoft Office Project Server 2007. This course also describes how to plan cost management and risk management for a project. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office Project Server 2007: Managing Projects 70-633 exam. Passing this exam will earn the learner the MCTS: Enterprise Project Management with Microsoft Office Project Server 2007 certification. In turn, this certification counts as a credit toward the MCTS: Microsoft Certified IT Professional: Enterprise Project Management with Microsoft Office Project Server 2007 certification.

Target Audience
System administrators, project managers, project support staff, and IT professionals tasked with the responsibility of planning, implementing, and using Microsoft Office Project Server 2007 in conjunction with Microsoft Office Project 2007 in a project enterprise environment; learners preparing for the technical support certification exams.

Prerequisites
Familiarity with Microsoft Windows and Office environments; a basic knowledge of project management concepts and terminology found in the Project Management Institutes Book of Knowledge (PMBOK Guide).

Expected Duration (hours)
2.5

Lesson Objectives
Managing Resource Capacity in Project Server 2007

Distinguish between organizational project team structures

Create and modify an Enterprise Resource Pool

Use the Resource Center for project administration

Use the Build Team feature to build a project team

View and change work resource availability

View resource assignments

Define the resources for a project

Recognize key techniques for estimating project costs

Establish and update baselines for project costs

Recognize key elements in planning risk management for a project

Work with baselines for project costs

Course Number:
mo_psmp_a03_dt_enus

Back to List

Executing Projects with Project Server 2007

Overview/Description
Successfully executing a project is like mastering an art form of making things happen as planned. Microsoft Office Project Server 2007 can help project managers do that. This course explains how the execution of the project plan through efficient resource management, communicating project information to stakeholders, and quality assurance can be achieved. The course also explores time and timesheets and the concept of administrative time using Office Project Server 2007. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office Project Server 2007: Managing Projects 70-633 exam. Passing this exam will earn the learner the MCTS: Enterprise Project Management with Microsoft Office Project Server 2007 certification. In turn, this certification counts as a credit toward the MCTS: Microsoft Certified IT Professional: Enterprise Project Management with Microsoft Office Project Server 2007 certification.

Target Audience
System administrators, project managers, project support staff, and IT professionals tasked with the responsibility of planning, implementing, and using Microsoft Office Project Server 2007 in conjunction with Microsoft Office Project 2007 in a project enterprise environment; learners preparing for the technical support certification exams.

Prerequisites
Familiarity with Microsoft Windows and Office environments; a basic knowledge of project management concepts and terminology found in the Project Management Institutes Book of Knowledge (PMBOK Guide).

Expected Duration (hours)
2.0

Lesson Objectives
Executing Projects with Project Server 2007

Use project communication features

Recognize key techniques for performing quality assurance

Use PWA for allocating resources

Use the Resource Substitution Wizard for allocating resources

Link documents and items in Project Server 2007

Allocate project resources

Create links for project documents and items

Create a timesheet

Record administrative time using the Enterprise Global Resource Pool calendar

Set up alerts and reminders

Create a timesheet

Enter administrative time

Create notifications

Course Number:
mo_psmp_a04_dt_enus

Back to List

Monitoring, Controlling, and Closing Projects

Overview/Description
As a project gets underway, project managers need to monitor task progress and resource usage to address unexpected events. Performance metrics should be in place to provide snapshots of a projects progress, enabling project managers to be proactive in addressing areas of concern. They also need to confirm that both the administrative and contract closing procedures are implemented to ensure the proper storage or disposal of project information. This course covers how Office Project 2007 and Office Project Web Access 2007 – part of Project Server 2007 – facilitate the monitoring and tracking of tasks, the application of performance metrics by way of status and task reports, and the project closing procedures. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office Project Server 2007: Managing Projects 70-633 exam. Passing this exam will earn the learner the MCTS: Enterprise Project Management with Microsoft Office Project Server 2007 certification. In turn, this certification counts as a credit toward the MCTS: Microsoft Certified IT Professional: Enterprise Project Management with Microsoft Office Project Server 2007 certification.

Target Audience
System administrators, project managers, project support staff, and IT professionals tasked with the responsibility of planning, implementing, and using Microsoft Office Project Server 2007 in conjunction with Microsoft Office Project 2007 in a project enterprise environment; learners preparing for the technical support certification exams.

Prerequisites
Familiarity with Microsoft Windows and Office environments; a basic knowledge of project management concepts and terminology found in the Project Management Institutes Book of Knowledge (PMBOK Guide).

Expected Duration (hours)
2.5

Lesson Objectives
Monitoring, Controlling, and Closing Projects

Recognize how to monitor a project

Create tasks and report their progress

Update tasks using Project 2007

Update tasks using Outlook 2007

Create a new task

Report the progress of a project task

Update tasks

Create a status report for a project team

Analyze reports using Project Center views

Recognize the function of Data Analysis view

Set up a project status report

Analyze project information using views

Perform Project Server 2007 activities related to the project closing process

Create and modify an enterprise template

Close tasks to updates

Create and edit an enterprise template

Course Number:
mo_psmp_a05_dt_enus

Back to List

Microsoft Publisher 2007 Curriculum Outline

Creating Customized Publications with Publisher 2007

Overview/Description
Microsoft Office Publisher 2007 helps you expand your creativity by enabling you to customize and share a wide range of personal and business publications to suit both home and office requirements. You can use this application to quickly create and personalize professional-looking publications such as newsletters and flyers. This course explores the wide range of available templates and the creating, editing, printing, and publishing tools at your disposal. It also introduces the new features of Microsoft Publisher 2007, and delves into redesigned and enhanced familiar features.

Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2007

Expected Duration
2.00 Hours

Lesson Objectives:

Introducing Publisher 2007

recognize where to locate common commands in Publisher 2007

Using Publisher 2007 to Create a Publication

change placeholder text and images in a predesigned template

open a publication type

add content to a blank publication

Tailoring and Adapting Publisher 2007 Templates

customize schemes and select options

create new business information

save publication in another file format

Reusing Publisher 2007 Content

create master pages for repeating page elements

save items to and reuse items from the Content Library

reformat existing publications as different publication types

Achieve Professional Results with Publisher 2007

arrange and group objects on the page

add decorative text features

format a picture

Use Publisher 2007s Design Checker

use the Design Checker to find problems in a publication

Prepare and Print a Publisher 2007 Publication

print a publication using a desktop printer

recognize how to prepare for commercial printing

Back to List

Extending Publisher 2007 Beyond Publications

Overview/Description
You can do more with Office Publisher 2007 than create basic desktop publications. New and enhanced capabilities guide you through the processes of creating and distributing your work either in print, on the Web, or by e-mail. This course explains such Microsoft Office Publisher 2007 features as e-mail and catalog merging capabilities, e-mail templates, and web page creation and customization

Target Audience
Office personnel at all levels; those wishing to become familiar with Publisher 2007

Expected Duration
1.50 Hours

Lesson Objectives:

Use Publisher 2007s Mail Merge Feature

create a mail merge

recognize how to format personal information in a data source

Merge Catalog Information with Publisher 2007

create a catalog merge

Send E-mail Messages with Publisher 2007

send a publication as an e-mail message

use an e-mail merge to create and send personalized e-mails

Create a Basic Web Site with Publisher 2007

create a basic web site using a predesigned template

enhance your web site with additional design features

Use Publisher 2007 to Convert and Publish Files to Web

convert to a web publication and format the navigation bar

prepare a print newsletter for web publication

publish files to the web

Back to List

Microsoft SharePoint Server 2007 Curriculum Outline

SharePoint 2007 Essentials

Target Audience

End users of Office SharePoint Server 2007

Prerequisites

A basic understanding of how to use Internet Explore 7 and basic word-processing skills

Expected Duration

2.75 Hours

Objectives :

SharePoint 2007 Essentials

• Distinguish between sites, workspaces, and pages, and create lists and libraries.
• Add new files to SharePoint, check files in and out of it, and set an alert for the document library.
• Add lists, files, and alerts in SharePoint.
• Add a new discussion and an alert to a discussion board, and use instant messaging.
• Perform a basic search for information in SharePoint 2007.
• Use a discussion board and search for information.
• Integrate the SharePoint 2007 calendar with the Outlook 2007 calendar.
• Integrate the SharePoint 2007 document library with Outlook 2007.
• Create a SharePoint workspace from within an Office application.
• Integrate and use SharePoint 2007 with Office applications.

Back to List

Creating and Managing Personal Sites and Searches in SharePoint 2007

Target Audience

End users of Office SharePoint Server 2007

Prerequisites

A basic understanding of how to use Internet Explore 7 and basic word-processing skills

Expected Duration

2.50 Hours

Objectives :

Creating and Managing Personal Sites and Searches in SharePoint 2007

• Create and customize your own My Site in SharePoint 2007.
• Distinguish between public and private content on your My Site, and set privacy controls for personal content.
• Create and use your own My Site, and set privacy controls for it.
• Add and work with Web Parts and RSS feeds in SharePoint 2007.
• Create a wiki page and a blog in SharePoint 2007.
• Create your own custom features in SharePoint 2007.
• Find information on SharePoint 2007 using the Search Center.
• Create a search scope in SharePoint 2007.
• Search for information using the Search Center and create a search scope.

Back to List

Microsoft Visio 2007 Curriculum Outline

Creating Visio 2007 Diagrams

Overview/Description
Microsoft Visio 2007 is a powerful diagramming software that enables you to create different types of diagrams and work environments. This course shows how Visio 2007 has predefined templates and stencils that enable you to create diagrams quickly and efficiently; along with the Visio Help features that allow you to tap into the vast knowledge base both within the help files and online through the Microsoft knowledge base. Once the diagrams have been created, this course demonstrates how to manipulate the shapes and connectors before saving and printing them.

Target Audience

Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments.

Expected Duration

2.0 hours

Objectives :

Introduction to Visio 2007

Match Visio-specific terms with definitions

The Visio 2007 Interface

• Identify the main elements of the Visio interface
• Access task panes and additional toolbars

  Find Help in Visio 2007

• Use Visio help features
• Recognize when to use each type of Help

  Create Diagrams using Visio 2007 Templates

• Open a template
• Add shapes to a diagram

  Work with Shapes in Visio 2007

• Rearrange stencils
• Select and modify shapes

  Connect Shapes in Visio 2007

• Connect shapes
• Organize and modify connections

  Saving, Previewing, and Printing in Visio 2007

• Save a Visio 2007 diagram
• Set up pages before printing
• Preview and print a Visio diagram

Back to List

Enhancing and Customizing Diagrams in Visio 2007

Overview/Description
Visio 2007 provides the tools to create diagrams by adding shapes and text to create complex networking and business diagrams. This course will show how to position and manipulate shapes, alter views and page orders, and manipulate text and text characteristics within Visio 2007 diagrams.

Target Audience

Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments.

Expected Duration

2.5 hours

Objectives :

Position Shapes in Visio 2007

Position shapes with grids, rulers, and guides

Automatically lay out shapes

Identify the layout options available

Manipulate Shapes in Visio 2007

• Manipulate shapes in a given scenario
• Reorder and group shapes

  View Diagrams and Alter Pages in Visio 2007

• Adjust the view of a diagram
• Create and modify pages

  Apply a Theme in Visio 2007

• Apply a theme to a diagram

  Adding Text to Visio 2007 Diagrams

• Add text to Visio diagrams
• Work with comments
• Add headers and footers

  Working with Text in Visio 2007

• Select and edit text
• Format text
• Reposition text

  Creating Tables in Visio 2007

• Use tabs to format text in table form
• Create a table using shapes

Back to List

Collaborating and Using Visio 2007 With Other Programs

Overview/Description
Visio 2007 is a powerful collaboration tool that allows the user to to show content from other applications and also allows content in Visio to be linked to other types of files. This course will show how to link, embed, import and export content and drawings in order to allow for collaboration with other programs while using Visio 2007.

Target Audience

Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments.

Expected Duration

0.9 hours

Objectives :

Tracking and Reviewing Changes with Visio 2007

Add and review markup comments

Add markup changes to the original diagram

Links and Hyperlinks in Visio 2007

• Insert hyperlinks
• Create links between Visio and other applications

  Embed Files with Visio 2007

• Embed files and shapes into Visio 2007
• Edit an embedded diagram

  Import and Export between Visio 2007 and Other Programs

• Import a graphic into Visio
• Export shapes and drawings

Back to List

Microsoft Word 2007 Curriculum Outline

Getting Started with Word 2007

Target Audience

TBC

Expected Duration

1.0 Hour

Objectives :

Starting Work in a New Word 2007 Document

Enter and delete text in a Word document

The Word 2007 Screen

Locate the main elements of Word 2007s screen

Match the main features of Word 2007s screen with their descriptions

Navigating Documents in Word 2007

Recognize methods for navigating through a Word document given a scenario

Identify methods for paging through a document

Back to List

Working with Text and Paragraphs in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.60 Hours

Objectives :

Word 2007s Formatting Features

Identify the formatting options in Word

Use the Home tab to format text

Format Text in Word 2007

Apply basic text formatting in a scenario

Cut, Copy, and Paste Text in Word 2007

Cut and paste text in a Word document

Copy and paste text in a Word document

Add Lists and Symbols in Word 2007

Create lists in a Word document

Add symbols in a Word document

Set Margins and Indents in Word 2007

Work with margins in a Word document

Set indents in a Word document

Work with Paragraphs in Word 2007

Use tab stops

Align text in a Word document

Back to List

Structuring, Editing, Saving, and Opening Documents in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Insert Page and Section Breaks in Word 2007

Insert a page break

Insert a section break

Adjust Spacing and Inserting Columns in Word 2007

Adjust spacing in a Word document

Insert columns in a Word document

Use Basic Editing Tools in Word 2007

Correct spelling errors in a document

Correct grammar errors in a document

Save and Open Word 2007 Documents

Save a new Word document

Save an existing document

Open an existing Word document in a given scenario

Save Word 2007 Documents in Different Formats

Save a Word document in PDF format

Save a Word document as a web page

Back to List

Printing, Help, and Automated Formatting in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.5 Hours

Objectives :

Preview and Print a Document in Word 2007

Print a file

Preview a page before printing

Use Word 2007’s Help and Research Options

Use Word Help

Use Words Research feature

Use Word 2007s Style Options

Apply a style to selected text

Create a new Quick Style

Apply a new Quick Style set to a document

Use Word 2007’s AutoCorrect Features

Use AutoCorrect

Use Smart Tags

Use Word 2007’s Templates

Create a blank template

Create a template based on an existing document

Create a new template based on an existing template

Use Word 2007’s Building Blocks

Create a reusable building block

Distribute a building block with a template

Back to List

Working with Documents in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Headers, Footers, and Page Numbers in Word 2007

Insert a header

Insert a footer |w

Insert page numbers |w

Navigate Word 2007 Documents using Views

Navigate a Word document using the Outline view

Navigate a Word document using Full Screen Reading view

Navigate using Line Numbers, Thumbnails, and Document Map

Navigate a document using line numbers

Navigate a Word document using Document map

Navigate a Word document using Thumbnails

Use Word 2007’s Drawing Tools

Add a shape

Insert WordArt

Work with Pictures and SmartArt graphics in Word 2007

Add a picture

Add clip art

Add a SmartArt graphic

Back to List

Advanced Formatting in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.20 Hours

Objectives :

Page Formatting in Word 2007

Add a page border

Position a page border

Add a text border

Watermarks and Backgrounds in Word 2007

Add a watermark to a document

Add a custom background to a document

Themes and Document Statistics in Word 2007

Apply a theme

Change document properties

Footnotes and Endnotes in Word 2007

Insert a footnote

Insert an endnote

Customize an endnote

Back to List

Advanced Document Navigation and Document Reviews in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Creating Tables of Contents in Word 2007

Create a table of contents

Identify the function of a table of contents

Modify a table of contents

Hyperlinks and Bookmarks in Word 2007

Create a hyperlink

Add a bookmark

Create Indexes and Cross-References in Word 2007

Insert an index

Modify an index

Create an index using a concordance file

Document Review Features in Word 2007

Use the track changes feature to edit a document

Insert a comment

Document Recovery in Word 2007

Use the Document Recovery Pane

Backing Up and Repairing Word 2007 Documents

Save backup copies of documents

Use the file recovery converter

Back to List

Using Tables, Charts, and Graphics in Word 2007

Target Audience

Personnel at all levels of the enterprise; end-users seeking to attain competency in Word 2007; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL3, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Formatting Tables

Format a table

Display or hide gridlines

Convert text to a table or vice versa

Modify Table Structure in Word 2007

Add a cell, row, or column to a table

Merge cells in a table

Sort Table Data in Word 2007

Sort table contents

Create Word 2007 Tables from Excel

Embed a selection from an Excel worksheet in a Word document

Distinguish between linked and embedded objects

Link to an Excel worksheet in a Word document

Working with Charts in Word 2007

Insert a chart into a Word document

Paste an Excel chart into Word

Back to List

Advanced Data Manipulation Features in Word 2007

Target Audience

Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2007; advanced end-users seeking to obtain Microsoft Office certification at in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent.

Expected Duration

1.00 Hour

Objectives :

Use Forms in Word 2007

Add form controls

Match the form type with its appropriate use

Add protection to content controls in a form

Protect a form document

Use Fields in Word 2007

Create a field

Modify a field

Use Mail Merge features in Word 2007

Create a form letter using mail merge

Print envelopes or labels

Back to List

Advanced Document Features in Word 2007

Target Audience

Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2007; advanced end-users seeking to obtain Microsoft Office certification at in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent.

Expected Duration

1.00 Hour

Objectives :

Using Macros in Word 2007

Record a macro

Edit a macro

Customizing Word 2007s Interface

Add a command to the Quick Access Toolbar

Use Master Documents in Word 2007

Create a master document

Create subdocuments

Manage Master Documents in Word 2007

Modify a master document

Manage subdocuments

Back to List

Collaborative Features in Word 2007

Target Audience

Personnel at all levels of the enterprise; advanced end-users seeking to attain proficiency in Word 2007; advanced end-users seeking to obtain Microsoft Office certification at in the use of Microsoft Word 2007; end-users seeking a basic IT certification such as ECDL/ ICDL4, or an equivalent.

Expected Duration

1.50 Hours

Objectives :

Securing Document Formatting in Word 2007

Lock document formatting

Assign a password to a document

Document Protection in Word 2007

Use the Document Inspector

Add a digital signature

SharePoint Collaboration in Word 2007

Upload a Word document to SharePoint

Working with HTML in Word 2007

Save a document as a web page

Set options for saving a Word document as a web page

Creating Blogs in Word 2007

Recognize how to get a blog account

Create a blog post

Back to List

Mentoring Using Word 2007

Overview/Description
SkillSoft Mentors are available to help students with their studies for the Using Word 2007 exam. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.

Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Expected Duration (hours)
0.0

Lesson Objectives

Mentoring Using Word 2007

Creating and Customizing Documents

Formatting Content

Working with Visual Content

Organizing Content

Reviewing Documents

Sharing and Securing Content

Course Number:
mntwd2007 <
Back to List

TestPrep Using Word 2007

Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.

Prerequisites
The associated SkillSoft certification content should be completed before attempting this TestPrep. This will maximize the effectiveness of the preparation exam.

Expected Duration (hours)
0.0

Lesson Objectives

TestPrep Using Word 2007

Creating and Customizing Documents

Formatting Content

Working with Visual Content

Organizing Content

Reviewing Documents

Sharing and Securing Content

Course Number:
TPWD2007_eng <
Back to List