Microsoft Project Advanced

This course has been developed for people wanting to utilise the advanced features of Microsoft Project to manage complex projects.

1 day course
What you will learn:
  • Create calculated fields containing formulas or functions in Microsoft Project 2016
  • Create, use and customise templates
  • Export Microsoft Project 2016 data to other applications and Import data into Microsoft Project 2016 including linking to SharePoint
  • Earned Value Analysis
  • Create a shared resource pool, combine and link multiple projects & downsize a larger project
  • Record macros and edit macros using VBA
What you'll get:
Capped class sizes
Post Course Support
Course prerequisites

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

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.


Topics covered in this training course
  • Formulas
  • Graphical Indicator Fields
  • Create a Template from an Existing Project
  • Using a New Template
  • Editing an Existing Template
  • Using Organiser to Edit Templates
  • Copy and Paste
  • Linking
  • Embedding
  • Exporting to Excel
  • Export Map Wizard
  • Importing Excel data into Project
  • Copy Picture of Gantt Chart
  • Integration with SharePoint
  • Exporting Report Data
  • Understanding Earned Value
  • Interpreting Earned Value
  • Viewing Earned Value Data



  • Customise the WBS
  • Opening Multiple Files
  • Hiding Project Files
  • Unhide Project Files
  • Comparing Projects
  • Master and Sub-projects
  • Remove a sub project
  • Breaking Task Links between Projects
  • Inserting Links
  • Combining Projects
  • Create a Resource Pool
  • Sharing a Resource Pool
  • Assigning Resources from a Resource Pool
  • Levelling Shared Resources
  • Checking Pool Links
  • Managing Shared Resource Files
  • Macro Security
  • Record a Macro
  • Play a Macro
  • Assign a Macro to the Quick Access Toolbar
  • Assign a Macro to the Ribbon
  • Fixing Mistakes
  • The Visual Basic Editor
  • Editing a VBA Sub-Routine
- +

Need your training approved? Get a quote

Need your training approved? Get a quote