Odyssey Training header goes here

Microsoft Project 2007 Advanced

Upcoming Course Dates
Microsoft Project 2007 Advanced

Melbourne
24 Jul 2012 $850
25 Oct 2012 $850
Show more Melbourne courses
19 Feb 2013 $850
Show less courses
Sydney
19 Jul 2012 $850
23 Oct 2012 $850
Show more Sydney courses
11 Feb 2013 $850
Show less courses
Brisbane
26 Jul 2012 $795
08 Oct 2012 $795
Show more Brisbane courses
10 Jan 2013 $795
Show less courses
  • Duration
    2 Days (9:00 am – 4:00 pm)
  • Downloads
    Practice Files  
  • Meals Provided
    Lunch and refresments
  • Print-Friendly
    Print this page
  • Delivery Methods
    Public, In-house, Closed Group
  • Skills Assessment
    Take the test

Expected Outcomes

  • Create, use and customise templates and views and use filters
  • Export Project data to other applications and Import data into Microsoft Project 2007 including linking to Outlook Tasks.
  • Create a shared resource pool, combine and link multiple projects & downsize a larger project
  • Record Macros & edit macros using VBA
  • Create calculated fields containing formulas or functions
  • Earned Value Reporting and use Progress Lines to track a project
  • Track actual progress in usage views and Contour Resource Usage, Automatically Level resources and use PERT analysis to determine task durations

Prerequisites

Participants will need to have attended or have a good working knowledge of the topics covered in the Microsoft Project Introduction course.

Who Should Attend this Course

This course has been developed for people wanting to utilise the advanced features of Project to manage Project data and produce a variety of advanced reports.

Topics Covered [Click to Show All]

Customising Views
Custom Combination Views
Placing Views on The Menu

Customising Tables
Creating a new Table
Show/Hide Columns
Customising Fields
Renaming Fields
Custom Field Functions
Value Lists
Formula
Graphical Indicator Fields

Filters
AutoFilters
Creating Filters
Filter Criteria
Grouping

Creating Templates
Using Templates
Create a Template
Editing an Existing Template
Using Organiser to Edit Templates

Integration with Other Applications
Copy, Paste & Linking to other applications
Embedding in other applications
Exporting to Excel and Export File Formats
Security Settings
Export Map Wizard
Importing Outlook Tasks
Importing Excel data
Copy Picture Wizard

Excel Pivot Tables Reporting
Visual Reports (2007 only)
Customising Project Reports
Modifying Predefined Reports
Crosstabulation Reports
Creating a Crosstabulation Report
Sharing Custom Reports

Earned Value Analysis
Understanding Earned Value
Interpreting Earned Value
% Complete vs Physical % Complete
Viewing Earned Value Data

PERT Analysis
Manually Calculate Task Duration
Is manual calculation necessary?
View PERT Analysis Results
PERT Gantt charts
PERT vs. CPM
Network Diagrams
Work Breakdown Structure
Viewing WBS
Edit the WBS

Advanced Project Tracking
Progress Lines
Tracking in the Usage Views

Automatic Resource Levelling

Contouring Resource Usage

Multiple Files
Opening Multiple Files
Create and use a Workspace
Hiding Project Files
Unhide Project Files

Project Linking
Master and Sub-projects
Remove a sub project
Breaking Task Links between Projects
Inserting Links
Combining Projects

Shared Resource Pool
Create a Resource Pool
Sharing a Resource Pool
Assigning Resources from a Resource Pool
Levelling Shared Resources
Checking Pool Links
Managing Shared Resource Files

Downsizing a Large Project

Macros
Macro Security
Record a Macro
Play a Macro
Assign a Macro to a Menu Command
Assign a Macro to a button on a toolbar
Fixing Mistakes

Visual Basic for Applications (VBA)
The Visual Basic Editor
Editing a VBA Sub-Routine