How do I create construction WBS codes and milestones in Microsoft Project?

Create summary tasks and subtasks for the WBS, then customize WBS codes through Project settings. Milestones are typically zero-duration tasks shown as diamond symbols on the Gantt chart.

How does Microsoft Project calculate CPI, SPI, and Schedule Variance for construction projects?

Microsoft Project uses Earned Value Management data after a baseline and progress updates are set. CPI compares earned value with actual cost, SPI compares earned value with planned value, and SV is EV minus PV.

How can I fix overallocated labor and equipment resources in Microsoft Project?

Use Resource Usage or Resource Sheet views to identify conflicts, then replace resources, adjust assignments or working time, or apply resource leveling to resolve overallocations.

Free Course Image Microsoft Project for Construction Scheduling, Resources and EVM (MSP)

Free online course Microsoft Project for Construction Scheduling, Resources and EVM (MSP)

Duration of the online course: 6 hours and 43 minutes

New

Master construction scheduling with Microsoft Project—build Gantt charts, manage resources and EVM, and boost project control in this free online course.

In this free course, learn about

MS Project construction scheduling workflow: tasks, milestones, WBS, and auto-scheduling basics
How to define milestones on the Gantt chart and structure plans using summary tasks (WBS)
Linking tasks with predecessors/successors and lag/lead notation (e.g., 7FS+10 days) via Network Diagram
Creating/customizing WBS codes (prefix, levels, separators) and applying them to the schedule
Building project/task calendars, exceptions, work weeks; why finish dates may not change until applied
Creating resources: work, material, cost, and plant/equipment; setting rates, max units, and accrue methods
Task types (Fixed Duration/Units/Work) and effort-driven behavior when adding resources
Assigning resources effectively, including assigning shared roles to summary tasks to avoid double-counting
Managing costs: resource costs, cost accrual (start/end/prorated), and cost impacts of working-time changes
Detecting and resolving overallocation: replacement, leveling, and leveling options
Baselines and tracking: set baseline, update progress using correct fields so dates/forecasts recalculate
Earned Value Management in MSP: CPI/SPI indicators, SV formula, and % Complete vs Physical % Complete
Using views and analysis tools: Tracking Gantt, Resource/Task Usage, filters, groups, highlighting
Import/export and reporting: move data between Excel/MSP and export to PDF/CSV/XLS formats

About the free online course

Take control of construction timelines and costs with practical Microsoft Project skills built for real jobsite demands. This free online course guides you through setting up a schedule the way contractors and project teams actually need it: with clear work breakdown structures, dependable logic links, and milestones that make progress easy to track on a Gantt chart and in network views. You will learn to create schedules that reflect how work happens in the field, not just how it looks on paper, so your plan is easier to communicate, defend, and update.

A strong schedule is more than dates, so you will also focus on resource and cost planning. You will work with different resource types, configure rates, cost accruals, calendars, and working time, and understand what happens when units, work, or duration changes under different task types. That means you can forecast staffing needs, spot overallocations, and apply practical leveling approaches to reduce clashes without losing visibility. The course emphasizes decision-making, helping you understand why Microsoft Project behaves the way it does when you adjust settings or add resources.

As the project moves forward, updating progress accurately is critical for trustworthy forecasts. You will learn how to report progress in a way that allows Microsoft Project to recalculate dates and projections correctly, and how baselines support meaningful comparisons. From there, the course connects scheduling to performance measurement through Earned Value Management, explaining key indicators such as CPI, SPI, schedule variance, and the role of percent complete versus physical percent complete for construction realities.

To help you work efficiently, you will also practice filtering, grouping, and switching between essential views for planning, tracking, and analysis, plus moving data in and out of Microsoft Project using common formats like Excel and PDF. By the end, you will be able to produce schedules that are easier to maintain, resource plans that are more realistic, and reports that support clear decisions with stakeholders.

Course content

Video class: 1 Introduction to Microsoft Project in Construction | Course Outline | 16m
Exercise: In Microsoft Project, which feature is used to calculate indicators like CPI and SPI to assess the health of a project?
Video class: 2 Add Activities, Milestones, WBS (Summary Task) in MS Project | Auto Scheduled 15m
Exercise: In Microsoft Project, how can you identify a milestone on the Gantt chart?
Video class: 3 Assign Activity Relationships (Predecessors, Successors) in MS Project | Network Diagram | 12m
Exercise: In Microsoft Project, what does adding a predecessor like “7FS+10 days” to an activity mean?
Video class: 4 Creating WBS (Work Breakdown Structure) Codes in Microsoft Project 04m
Exercise: In Microsoft Project, where do you go to customize the WBS code format (prefix, levels, separators)?

Video class: 5 Creating Calendars in Microsoft Project | Exceptions, Work Week Modification, Time Adjustments | 12m
Exercise: After creating a custom calendar in Microsoft Project, why might the project finish date not change immediately?
Video class: 6 Assigning Calendars to Tasks in Microsoft Project 13m
Video class: 7 Assigning Task 12m

Video class: 8 Adding Resources in Microsoft Project | Standard Rates, Cost Accrue, Initials, Group, Max Units | 20m
Exercise: In Microsoft Project, which resource type is typically used for people like a Project Manager or Mason who charge based on time (hour/day/week)?
Video class: 9 Creating Material Resources in Microsoft Project 04m
Video class: 10 Creating Cost Resources in Microsoft Project 02m
Video class: 11 Creating Plant 04m
Exercise: In Microsoft Project, which resource type should plant and machinery (equipment) typically be created under for construction scheduling?

Video class: 12 Task Types in MSP - Fixed Duration, Fixed Units, Fixed Work | Examples and All Cases | 18m
Exercise: In Microsoft Project, when a task is set to Fixed Work and you add an additional resource, what typically happens?
Video class: 13 Effort Driven Scheduling in Microsoft Project 08m
Video class: 14 Cost Accrue Types of Resources - Prorated, Start, End | Examples | 07m
Video class: 15 Assignment of Resources (Work, Cost, Material) to Tasks in MS Project 14m
Exercise: Why should common resources like the Project Manager and Construction Manager be assigned to the main summary task instead of each individual activity?
Video class: 16 Cost of Resources in Microsoft Project 10m

Video class: 17 Overallocation of Resources in Microsoft Project | Using Examples | 10m
Video class: 18 Replacement of Overallocated Resources in Microsoft Project | Examples | 06m
Video class: 19 Resource Levelling in Microsoft Project | Level Resource 14m
Video class: 20 Resource Levelling Options in Microsoft Project 05m
Video class: 21 Changing Resource Working Time 13m
Exercise: When a resource’s working time is changed (e.g., plumber from 10 hours/day to 15 hours/day) while total work remains 70 hours, what typically happens to the task cost in Microsoft Project?

Video class: 22 Creating, Assigning the Baseline to Project, Tasks in Microsoft Project 12m
Video class: 23 Progress Update of Project | Schedule 26m
Exercise: When updating project progress in Microsoft Project, which fields should you primarily edit so MSP can automatically recalculate Start/Finish dates and forecasts?
Video class: 24 Earned Value Management (EVM) in Microsoft Project - Theory 28m
Exercise: In Earned Value Management (EVM), which formula is used to calculate Schedule Variance (SV)?
Video class: 25 Percent Complete v/s Physical Percent Complete for Earned Value Calculations 09m

Video class: 26 Highlighting, Filtering, Grouping of Tasks and Resources in MS Project 20m
Video class: 27 All Views in Microsoft Project - Tracking Gantt Chart, Resource Usage, Task Usage, Calendar, etc. 28m
Video class: 28 Creating 10m
Video class: 29 Importing Excel File to MS Project 04m
Video class: 30 Exporting MS Project File to Various Formats - Excel, PDF, XLS, CSV, etc. 07m
Video class: Learn Microsoft Project (MSP) in only 25 Minutes !! 25m

Free online courses on Microsoft Project

Learn aboutMicrosoft Project

Explore free online Microsoft Project courses and learn to plan, schedule, track, and deliver projects with confidence. Build practical skills in task management, resource allocation, budgeting, timelines, and reporting at your own pace. Enroll today, earn a certificate, and strengthen your project management career.