Download our guide to end user applications

Microsoft Project - Advanced

  • Length 1 day
Course overview
View dates &
book now

Why study this course

Microsoft Project is one of the most popular scheduling and project management programs on the market.

This course builds on the skills developed in Microsoft Project - Beginner and Intermediate courses, and covers advanced skills and features. You'll learn about macros, graphical reports, custom reports, and managing large Project files with SubProjects.

After completion of this course you may also be interested in our Agile Project Management Foundation and PRINCE2 Foundation courses.

Note: Project 2016, Project 2019, Project 2021, and Project 365 are all desktop application versions of Microsoft Project. Project 2016, Project 2019, and Project 2021 are the perpetual, bought-outright, stand-alone versions of the software; Project 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.

Nexacu Public Schedule

Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.

Request Course Information


What you’ll learn

At the completion of this course you should be comfortable with:

  • Understanding and creating Custom Fields to show non-standard data

  • Understanding lookup fields, calculations, and traffic light custom formatting

  • Working with Work Breakdown Structure Codes and creating custom WBS schemes

  • Exploring the in-built Graphical Reports in Project and creating new custom Reports

  • Creating Visual Reports using Pivot Tables in Project

  • Understanding and creating Project Templates

  • Understanding how to use a common Resource Pool between several projects

  • Understanding how Projects can be linked, combined into Master Projects, and split into smaller SubProjects

  • Introduction to using Macros in Project


Microsoft Solutions Partner - Cloud - Training Services Logo

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level.  We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ. 


Who is the course for?

This course is designed for those who need to use the advanced features of Microsoft Project such as macros, graphical reports, custom reports, and managing large Project files.


Course subjects

Custom Fields

  • Understanding Custom Fields

  • Creating Custom Fields

  • Inserting Custom Fields

  • Creating a Formula in a Custom Field

  • Modifying a Formula

  • Testing a Formula

  • Understanding Graphical Indicator Custom Field

  • Creating Graphical Indicator Custom Field

  • Creating a Lookup Custom Field

  • Creating an Outline Code Mask

  • Entering Lookup Table Values

  • Using a Lookup Table

WBS Codes

  • Understanding WBS Codes

  • Creating WBS Codes

  • Altering Tasks with Custom WBS Codes

  • Renumbering WBS Codes

  • Editing Custom WBS Codes

Custom Views

  • Preparing for the Custom View

  • Creating a Custom Filter for the View

  • Creating a Custom Group for the View

  • Creating a Custom Table for the View

  • Creating the Custom View

  • Removing a Custom View and its Components

Graphical Reports

  • Understanding Graphical Reports

  • How Graphical Reports Work

  • Running a Report

  • Formatting Chart Objects

  • Manipulating Report Data

  • Filtering Report Data

  • Cloning an Existing Report

  • Creating a New Report

  • Enhancing Report Appearance

  • Making Reports Global

  • Removing Unwanted Reports

Visual Reports

  • Understanding Visual Reports

  • Understanding Excel Visual Reports

  • Creating a Visual Report from a Template

  • Choosing Fields to Display in a Visual Report

  • Changing the X Axis Categories

  • Filtering a Visual Report

  • Formatting a Visual Report

  • Saving a Visual Report as a Template

  • Using a Custom Visual Report Template

Project Templates

  • Understanding Project Templates

  • Examining the Templates

  • Saving a Project as a Template

  • Using a Custom Project Template

  • Specifying the Personal Templates Folder

  • Using the Personal Template Folder

  • Modifying a Template

  • Understanding the Global Template

  • Organising the Global Template

  • Applying a Newly Organised Item

  • Removing Items from the Global Template

Microsoft Project Files

  • Opening a Project 2007 File

  • Moving a Project’s Start Date

  • Working with Multiple Files

  • Hiding Open Files

Linking and Combining Projects

  • Understanding Linked Projects

  • Combining Projects

  • Viewing a Combined Project

  • Printing from a Combined Project

  • Setting a Combined Project Start Date

  • Changing Data in a Combined Project

  • Saving and Closing a Combined Project

  • Using Only the Combined Project File

  • Using Only Subproject Files

  • Inserting Subprojects

  • Breaking Subproject Links

  • Creating a Read Only Subproject

  • Inserting Task Links

  • Creating a Summary Milestone

Shared Resources

  • Understanding Resource Sharing

  • Creating a Common Resource Pool

  • Linking to an External Pool

  • Linking a New Project File to the Pool

  • Assigning Resources from the Pool

  • Working with Shared Resources

  • Checking for Resource Links

  • Managing Shared Resources

  • Opening Shared Resource Projects

  • Opening the Resource Pool Only

  • Assembling a Resource Master

  • Working with a Resource Master

Downsizing Larger Projects

  • Understanding Project Downsizing

  • Creating the Resource File

  • Creating Smaller Projects

  • Linking Subprojects to Resources

  • Preparing for the Master Project

  • Creating the Downsized Master File

  • Setting Project Links

  • Finalising the Master

Other Applications

  • Understanding Working with Applications

  • Copying a Gantt Chart Image

  • Copying Table Data

  • Copying to Microsoft Excel

  • Linking to Microsoft Excel

  • Exporting to Microsoft Excel

  • Exporting to Excel Using a Map

Microsoft Project VBA

  • Understanding Microsoft Project VBA

  • Accessing the Developer Tab

  • Recording a Macro

  • Running a Macro

  • Editing a Macro

  • Running an Edited Macro

  • Localising a Macro

  • Running a Localised Macro


Prerequisites

This course assumes that you have completed or have an understanding of the topics covered in the Microsoft Project - Beginner and Intermediate courses.


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Select and book a course

May
July

Can't find a date you like?

Contact sales


Offers

  • Power Platform 7 Course Program
    Become Microsoft Certified with the PL-900 exam Access 7 courses in our Microsoft Power Platform Training package. Microsoft's Power Platform enables users to analyse data, build apps, automate processes and create virtual agents. Learn to use the Power Platform to solve business problems by pulling the capabilities of many apps together. Demonstrate your skill and capability with the PL-900 Power Platform Certification. Our Power Platform Certification Package brings together seven of Nexacu's highly successful courses, along with Microsoft's official exam and certification, to deliver exceptional value. For the same price as the seven courses, you'll also receive the official exam, a free re-sit, unlimited practice tests, unlimited study support and, upon successfully passing the exam, the official Microsoft certification: Power Platform Fundamentals. Certification: Microsoft Certified: Power Platform Fundamentals Exam: PL-900: Microsoft Power Platform Fundamentals Duration: 7 days of courses, plus 2-3 hours per week Inclusions: 7 x courses, Unlimited support, Practice exam, Exam plus 1 resit
  • Power Platform 4 Course Program
    Become Microsoft Certified with the PL-900 exam Access 4 courses in our Microsoft Power Platform Training package. Microsoft's Power Platform enables users to analyse data, build apps, automate processes and create virtual agents. Learn to use the Power Platform to solve business problems by pulling the capabilities of many apps together. Demonstrate your skill and capability with the PL-900 Power Platform Certification. Our Power Platform Certification Package brings together seven of Nexacu's highly successful courses, along with Microsoft's official exam and certification, to deliver exceptional value. For the same price as the seven courses, you'll also receive the official exam, a free re-sit, unlimited practice tests, unlimited study support and, upon successfully passing the exam, the official Microsoft certification: Power Platform Fundamentals. Certification: Microsoft Certified: Power Platform Fundamentals Exam: PL-900: Microsoft Power Platform Fundamentals Cost: $3,114.00 incl GST Duration: 4 days of courses, plus 2-3 hours per week Inclusions: 4 x courses, Unlimited support, Practice exam, Exam plus 1 resit
  • Microsoft Word 3 Course Program
    Certification: Microsoft Certified: Word Specialist or Word Expert Explore the package for 3 Microsoft Word Training Courses. Demonstrate your Word knowledge with a Microsoft Certified achievement. Word skills are highly sought after. Be confident in your knowledge and skill level. Gain an upper hand in a competitive workforce with specialised skills and expertise in Word. Our flexible packages allow you to choose your level of certification between associate or expert. The MO-100 and MO-101 exams and their respective credentials demonstrate to employers your extensive knowledge of Word. Our successful courses, combined with Microsoft's official exams and certifications, deliver exceptional value. For the same price, our bundle courses will provide you with all of the perks of our Word package, including a Microsoft practice exam, the official exam, a free re-sit, and, upon successfully passing the exam, the official Microsoft certification. Exam: MO-100 or MO-101 Duration: 3 days of courses Plus home practice Inclusions: 3 x courses + Practice exam
  • Microsoft Word 2 Course Program
    Certification: Microsoft Certified: Word Specialist or Word Expert Explore the package for 2 Microsoft Word Courses. Demonstrate your Word knowledge with a Microsoft Certified achievement. Word skills are highly sought after. Be confident in your knowledge and skill level. Gain an upper hand in a competitive workforce with specialised skills and expertise in Word. Our flexible packages allow you to choose your level of certification between associate or expert. The MO-100 and MO-101 exams and their respective credentials demonstrate to employers your extensive knowledge of Word. Our successful courses, combined with Microsoft's official exams and certifications, deliver exceptional value. For the same price, our bundle courses will provide you with all of the perks of our Word package, including a Microsoft practice exam, the official exam, a free re-sit, and, upon successfully passing the exam, the official Microsoft certification. Exam: MO-100 or MO-101 Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • Digital Literacy Certification
    Earn your Digital Literacy Certification Access the Microsoft Office 365 Training Package. Elevate your core competencies from Word to PowerPoint, Excel and Power BI. Attend our instructor-led courses in-person or join remotely and learn from our team of experienced Microsoft Certified Trainers. Digital literacy training builds confidence across a range of areas. The courses provide foundational to intermediate knowledge of the most widely used applications in today’s workplace. Showcase your achievements and build your professional profile with this verifiable digital credential. Certification: Nexacu Digital Literacy Exam: Course Attendance Duration: 4 - 6 weeks Inclusions: 6 Instructor-led courses
  • PowerPoint 2 Course Program
    Become Microsoft PowerPoint certified and stand out from the crowd Validate your specialised skills with PowerPoint Level 1 and 2. Our two courses are jam-packed with tips and tricks that will revolutionise how you create presentations. The MO-300 exam and PowerPoint Associate certification will demonstration to employers your extensive knowledge of PowerPoint. We deliver great value by combining our two PowerPoint courses and the Microsoft certification into one package. In your certification package you will receive a Microsoft practice exam, the official exam, a free re-sit, and upon successfully passing the exam, the official Microsoft certification. Certification: Microsoft Certified: PowerPoint Associate Exam: MO-300 Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • Excel 2 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Duration: 2 days of courses Plus 2-3 hours per week Inclusions: 2 x courses + Practice exam
  • Excel 3 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Duration: 3 days of courses Plus 2-3 hours per week Inclusions: 3 x courses + Practice exam
  • Excel 4 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Beginner, Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Duration: 4 days of courses Plus 2-3 hours per week Inclusions: 4 x courses + Practice exam
  • Power BI 3 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Duration: 3 days of courses + Plus 2-3 hours per week Inclusions: 3 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Power BI 4 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Beginner, Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Duration: 3 days of courses + Plus 2-3 hours per week Inclusions: 3 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Power BI 2 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit the Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Duration: 2 days of courses + Plus 2-3 hours per week Inclusions: 2 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
  • Microsoft Bundles
    Master Microsoft skills, from fundamentals to advanced levels. Choose from bundles or private class options and SAVE up to 35% on training costs.