Advanced Microsoft Project.

Do you want to Master the World’s Most Popular Project Management tool?

Our promise to you: “By the end of this course – you will be incredibly comfortable with Advanced Microsoft Project concepts and techniques – and you will be able to use Project as a BOSS.

You will be able to create, manage and track world class schedules – with complex requirements of resources, allocations, budgets,
reporting and tracking – all the way to project completion!!!”

At the end of this Advanced Microsoft Project, you will have a complete understanding of the higher functions of Project. You will be able to perform the most advanced features of managing a project and operate multiple projects.

Your Project expertise will enable you to customize your layouts and take your macro skills on to new levels of sophistication while your ability to create and use templates will speed up your future Project process.

This course is the FIRST, ONLY, and most comprehensive ADVANCED Microsoft Project course that brings the THREE ASPECTS TOGETHER – 1) ADVANCED Microsoft Project Concepts and Techniques 2) Project Management Principles AND 3) hands-on exercises.

NO OTHER book, tutorial or course offers these unique set, anywhere.

This course is officially accredited by Microsoft.

You might be interested in MS Project Essentials as a prerequisite to this course.

YOU WILL LEARN HOW TO

This course aims to show delegates how to become expert users of MS Project. It assumes that delegates have an understanding a familiarity with Project but do not use currently use all of its functionality and shows them how to make the best use of that additional functionality.

You may have used Microsoft Project to manage projects for years; you may even know how to use Microsoft Project to correct resourced run-away projects.

But can you create colorful portfolio level dashboards across all your projects? Do you know how to use resource pools and subprojects? Can you create custom outline codes and customized fields and make them available to plans?

This fascinating class provides an entry point to the beginning of an exciting discovery of the lesser-known aspects of Microsoft Project. This may well be the beginning of your interest in preparing for the international Microsoft Project exam.

IMPORTANT COURSE INFORMATION

Prerequisites

This course assumes that you have attended our Introduction/Intermediate level Microsoft Project training course or you have a good understanding of Microsoft Project.

It also assumes that you have an understanding of project management techniques and can create/manage a project.

Certificate

Participants who fully attend this course and complete the test on the last day will receive official Microsoft Certificate.

COURSE OUTLINE

Top 10 pitfalls of MS Project – and how to avoid them
• What is a Master Project?
• Creating a “MASTER PROJECT”
• MASTER PROJECT – Read, Link, Update and Delete
• Social Networking for your Project Plans
• File Handling: 10 Super Tips
Top 10 pitfalls of MS Project – and how to avoid them
• What is a Master Project?
• Creating a “MASTER PROJECT”
• MASTER PROJECT – Read, Link, Update and Delete
• Social Networking for your Project Plans
• File Handling: 10 Super Tips

Module 2: Project Initiation
Resource Pool – THE CONCEPT
• Three Techniques to create a Resource Pool
• How to connect to a Resource Pool – 3 Examples
• Shared Resources – The Nitty Gritty Details
• Three Types of Access Modes – Resource Pool
• Automated WBS Code Definition

Setting Priorities between Projects
• Outline Numbering, Defining WBS Codes, and Renumbering

Module 3: Project Planning – Part 1
Planning according to Work or Duration
• Powerful custom fields – part 1
• Powerful custom fields – part 2
• Custom fields – Example 1 – Simple Data
• Custom Fields – Example 2 – Calculated field values
• Custom Fields – Example 3 – Handling Summary Tasks
• Custom Fields – Example 4 – Graphical Displays
• Custom Fields – Example 5 – Taxonomy
• Custom Fields – Example 6 – Programmed formatting
• Overallocation Desensitizing – 3 Advanced Techniques
• Summary task assignment PITFALLS

Module 4: Advanced Planning Microsoft Project – Part 2
Understanding Earned Value Analysis – FUNDAMENTALS
• Planning a project to track Earned Value
• Percentage Complete vs. Percentage Physical Complete
• Planning to Track Progress in the future
• IMPORTING Update Tracking Information
• ADVANCED TRACKING of your Project

Module 5: Custom Filters and Groups
Creating custom filters
• Filtering using calculations
• Creating custom groups

Module 6: Custom Calculated Fields
Creating custom fields
• Calculated custom fields
• Using custom indicators

Module 6: Custom Tables and Views
Creating a table
• Creating a view

Module 7: Comparison
Comparing versions of plans
• Working with the Timeline Feature
• Create Custom Reports
• Create Templates
• Using the Organizer

Module 8: Budgeting Resources
Creating and tracking resource budgets
• Analyze Project Data using Excel
• Creating custom export maps
• Calculation Options with Status Date
• Using Interim Plans

Module 9: Manage Costs in Microsoft Project
Create Different Cost Rates for Resources
• Change the Resource Cost on Individual Tasks
• Alter Costs Based on Time Periods
• Assign Overtime Costs and Work to Resources

Module 10: Working with Multiple Projects
Combining Multiple Projects as a Programme
• Creating a Shared Resource Pool
• Assigning Resources using a Resource Pool
• Using Cost Rate Tables with a Resource Pool
• Identifying the Critical Path or Paths in a Programme

Module 11: Import and Export Information
File Formats Supported by Microsoft Project
• Mapping Project Information
• Exporting Microsoft Project Information
• Importing Information into Microsoft Project

Module 12: Tracking Progress and Project Actuals
Moving a Project
• Entering Task Progress as Scheduled
• Updating and Monitoring Progress using a Status Date
• Updating Actuals
• Reschedule Incomplete Work

Module 13: Reporting on Projects
Reporting on Progress
• Manipulate Built-In Reports
• Earned Value Reporting
• Work with Multiple Baselines
• Distribute Project Data in Other Formats

Module 14: Consolidation
Creating a Project containing Summary Task Requirements

Creating More Subprojects

Using and Sharing a Resource Pool
• How to Access a Project File with Shared Resource Pool
• Making Changes on the Resource Pool

Module 15: Costs
Module 15: Costs

Module 16: Type of Reports
Burndown Reports
• Cost Reporting
• Standard Cost Reports

Module 17: Earned Value Analysis
Basic Requirements; Percent Complete; 3 Key Values
• Applying Earned Value Analysis to a Project
• Earned Value Analysis and Reporting

Overtime
• Task Calendars
• The Ribbon
• Customizing the Ribbon
• Custom Fields
• How to Setup a Custom Field
• Adding Data into the Custom Field; Formulae in Custom Fields
• Alternative of Setting AutoRag Status; Calculations in Formulae for Custom Fields
Overtime
• Task Calendars
• The Ribbon
• Customizing the Ribbon
• Custom Fields
• How to Setup a Custom Field
• Adding Data into the Custom Field; Formulae in Custom Fields
• Alternative of Setting AutoRag Status; Calculations in Formulae for Custom Fields

Module 19: WBS Codes and Outline Codes
Custom Outline Codes
• Macros
• Recording Macros
• Understanding How Macros Work and Modifying What It Does
• Macros Security
• Running a macro
• Assigning macros to toolbars

Module 20: Visual Reporting
Exporting Data from Project to Other Software
• Export Selected Data into Excel
• Visual Analysis for Data Exported to Excel
• Project Portfolio Management, Project Server 2013, and Project Online; Closing
• Using, modifying and creating visual reports

Module 21: Project Templates