Microsoft Project 2007 Advanced
Upcoming Course Dates
Microsoft Project 2007 Advanced
Melbourne
Show more Melbourne coursesSydney
Show more Sydney coursesBrisbane
Show more Brisbane coursesDuration
2 Days (9:00 am – 4:00 pm)Downloads
Practice FilesMeals Provided
Lunch and refresmentsPrint-Friendly
Print this pageDelivery Methods
Public, In-house, Closed GroupSkills 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]
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
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







Odyssey Training is a national Australian provider of professional, technical and management training and consultancy. We run customised training and scheduled training courses in Brisbane, Cairns, Melbourne, Sydney and Townsville. We have been a major outsource partner for local and national projects across the private and public sectors. Quality Assurance System conforming to AS/NZS ISO 9001:2008 (Certification no. 1075). Odyssey Training is also a signatory to the Government’s Information Technology Conditions v5 (GITC v5) – Q-953.