MS Project - Automation and Schedule checkup with VBA and AI

Name: MS Project - Automation and Schedule checkup with VBA and AI
Rating: 3.9 (7 reviews)

VBA Macros, Microsoft Project, schedules, planning, construction projects, automation, AI (Artificial Intelligence)

Created byBaselineplan Consultant

Last updated 8/2025

English

What you'll learn

Automation in MS Project using VBA Macros
Using AI for Smart Analysis to Support VBA Applications
Development of Custom Macros and Tools for MS Project
Best Practices and Scheduling Management Methodologies

Course content

9 sections • 33 lectures • 49m total length

Detailed Course Structure and Learning Objectives1:42
Video explaining the course structure, learning objectives, and requirements
Basic Introduction2:09
Basic overview of what the course will offer

Accessing the VBA Editor0:55
Lesson on how to access the VBA Editor
Setting up the VBA Editor for Your First Macro0:47
Lesson on how to configure the VBA Editor
Creating Your First Macro0:59
Lesson covering how to create your first Macro. The macro code is available in the class download materials
Running Your Macro0:52
Running your first Macro. The macro code is available in the class materials
Creating Tabs in MS Project to Include Your Macros0:42
Running Your First Macro. The macro code is included in the class material
Enabling and Accessing the VBA Editor in MS Project2:52
Activating and configuring the VBA Editor and creating your first Macro

Analysis of logical relationships between activities1:04
Practical Application of a Macro. The Macro code is included in the downloadable class material
Statistical analysis of activity relationships0:50
Practical Application of a Macro. The Macro code is included in the downloadable class material
Analysis of lags between activities1:01
Practical Application of a Macro. The Macro code is included in the downloadable class material
Mapping constraints1:29
Practical Application of a Macro. The Macro code is included in the downloadable class material
Slack verification0:57
Practical Application of a Macro. The Macro code is included in the downloadable class material
Analysis of summary activities1:15
Practical Application of a Macro. The Macro code is included in the downloadable class material
Analysis of tasks naming conventions1:09
Practical Application of a Macro. The Macro code is included in the downloadable class material

Analysis of Activities with Excessive Dependencies1:17
Practical Application of a Macro. The Macro code is included in the downloadable class material
Assessment of Excessive Activity Durations1:21
Practical Application of a Macro. The Macro code is included in the downloadable class material
Identification of Negative Floats0:55
Practical Application of a Macro. The Macro code is included in the downloadable class material
Resource Allocation Analysis1:04
Practical Application of a Macro. The Macro code is included in the downloadable class material
Critical Path Test1:33
Practical Application of a Macro. The Macro code is included in the downloadable class material
Critical Path Length Index - CPLI1:56
Practical Application of a Macro. The Macro code is included in the downloadable class material
Control of Saved Baselines0:57
Practical Application of a Macro. The Macro code is included in the downloadable class material

Identification and Correction of Invalid Dates2:05
Practical Application of a Macro. The Macro code is included in the downloadable class material
Calculation and Interpretation of BEI (Baseline Execution Index)1:44
Practical Application of a Macro. The Macro code is included in the downloadable class material
Baseline Monitoring1:17
Practical Application of a Macro. The Macro code is included in the downloadable class material

Requirements

Softwares: MS Project and Excel
Intermediate knowledge of MS Project and Excel
Basic understanding of project planning

Description

Do you want to make your work in MS Project much faster, more accurate, and professional?

In the course MS Project - Automation and Schedule Analysis with VBA and AI, you will learn how to create powerful macros that automate repetitive tasks, perform advanced analyses, and generate performance charts — all in a practical and straightforward way!

What you will learn:

How to activate and configure the VBA Editor in MS Project.
How to create your first simple macros from scratch — even if you’ve never programmed before!
How to use Artificial Intelligence to create, correct, and optimize your macros.
How to automate schedule formatting and identify the critical path with just one click.
How to perform schedule quality analyses: activity relationships, float, constraints, critical durations, and much more.
How to calculate and interpret indicators such as BEI (Baseline Efficiency Index).
How to generate performance charts like the S-Curve directly in MS Project using VBA.

Why learn VBA in MS Project?
Because tasks that would take hours to complete manually can be done in seconds with customized macros. Automating means saving time, reducing errors, and delivering more consistent, high-quality projects.

Even if you have little or no programming experience, this course will guide you step by step — in a practical, objective, and results-oriented approach.

Master MS Project like few in the market!
Save time, increase the accuracy of your schedules, and stand out as a high-performance professional.

Enroll now and start transforming the way you plan and manage projects!

Who this course is for:

Professionals working with project planning and control
Project managers who want to automate processes in MS Project
Project managers, engineers, architects, and planning professionals

MS Project - Automation and Schedule checkup with VBA and AI

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 4min

Enabling the Developer Tab (if not visible)6 lectures • 7min

General knowledge of VBA and Macros2 lectures • 5min

Use of Artificial Intelligence in Schedule Automation3 lectures • 8min

Schedule Formatting Automation2 lectures • 2min

Quality Indicators in the Schedule (Part 1)7 lectures • 8min

Quality Indicators in the Schedule (Part 2)7 lectures • 9min

Tracking Indicators3 lectures • 5min

Performance Charts and Indicators1 lecture • 2min

Requirements

Description

Who this course is for: