Construction Scheduling using MS Excel (Webinar | Apr. 10-11, 2026)

Speaker(s)

Professional Certifications
Licensed Civil Engineer
ASEAN Engineer
Project Management Professional (PMP®) – Project Management Institute
Scheduling Professional (PMI-SP®) – Project Management Institute
Certified Cost Professional (CCP®) – AACE International

Education
Master in Business Administration (MBA) from Philippine Christian University
Master in Construction Management from Technological Institute of the Philippines

Our Resource Person is a seasoned Project Management Professional (PMP®) with over 20 years of extensive hands-on experience in project management, planning, scheduling, and cost control across complex, high-value projects. His career spans the full project life cycle—from initiation and planning to execution, monitoring and control, and closeout—with a strong focus on value delivery, governance, and performance management.

He has been directly involved in multimillion-dollar multi-national company projects, applying globally recognized project management practices grounded in the PMBOK® framework and international best practices. His expertise bridges theory and real-world execution, making complex project management concepts practical, actionable, and relevant across industries.

Currently, our Resource Person serves as a Senior Planning Manager for a AAAA contractor in Manila, Philippines, supporting major government infrastructure projects such as the NLEX–SLEX Connector Road Project, North–South Commuter Railway (NSCR) Project, and C5 South Link Expressway Project. His role involves integrating planning, scheduling, cost control, risk management, and stakeholder coordination to ensure successful project delivery.

A long-time expert user of Primavera P6, our speaker has been utilizing Primavera since 2000 (starting with P3) for developing, managing, and controlling complex project schedules. As a PMP®, PMI-SP®, and CCP®, he brings a unique, integrated perspective on time, cost, risk, and value management, fully aligned with the principles-based approach of PMBOK® 7th Edition.

As a trainer and resource person, he is known for delivering highly practical, industry-tested insights, enriched with real project examples from construction, infrastructure, oil & gas, and public sector projects, enabling participants to confidently apply modern project management practices in their own organizations.

Current Status

Not Enrolled

Price

PHP 3,000 | Available

Get Started

Construction Project Planning, Scheduling and Control using MS Excel

This one (1) day course is designed for construction professionals, engineers, project managers, and students who want to master project planning and monitoring without relying on expensive software like Primavera P6 or MS Project.

This course walks participants step-by-step through the process of creating a Work Breakdown Structure (WBS), developing activity schedules, generating automated Gantt charts, and tracking project progress. It also introduces advanced but practical tools such as manpower loading, cost management, and S-Curve analysis (Planned vs. Actual).

By the end of the course, learners will be able to build a complete Excel-based project control system for real construction projects — useful for progress reporting, monitoring, and decision-making.

After the training, the participants should be able to:

  • Understand the fundamentals of project planning, scheduling, and control in the construction industry.
  • Develop a Work Breakdown Structure (WBS) and activity list for construction projects.
  • Build automated Gantt charts in Excel to visualize project schedules.
  • Track and update progress using % complete and actual vs. planned data.
  • Prepare manpower loading charts to manage workforce demand effectively.
  • Apply cost management techniques in Excel using Planned Value (PV), Earned Value (EV), and Actual Cost (AC).
  • Generate and interpret Progress S-Curves (Planned vs. Actual) for reporting and control.
  • Produce professional one-page progress reports ready for submission to clients or management.
  • Integrate all tools into a complete Excel-based monitoring system for a sample construction project.

Course Duration: 1 day @ 8 hours per day

Course Outline

Introduction to Planning & Scheduling in Construction

  • Planning vs. Scheduling: difference and importance
  • Why Excel is still widely used in construction projects
  • Key terms: Activity, Duration, Dependencies, Critical Path

Quick Review of Project Schedule Management based on PMBOK

  • Plan Schedule Management
  • Define Activities
  • Sequence Activities
  • Estimate Activity Resources
  • Estimate Duration
  • Develop Schedule
  • Control Schedule

Creating the Work Breakdown Structure (WBS)

  • WBS hierarchy and numbering system
  • Linking WBS to cost and resource codes

Developing the Activity Schedule

  • Listing activities with durations
  • Logical sequence of works
  • Adding start/finish dates
  • Constraints and float basics

Creating a Gantt Chart in Excel

  • Manual vs. automated Gantt charts
  • Conditional formatting for schedules
  • Adding milestones and dependencies

Progress Tracking & Updating

  • Adding % complete per activity
  • Comparing Actual vs. Planned
  • Highlighting delayed tasks

Reporting & Exporting

  • Formatting schedules for management reports
  • Creating one-page schedule summaries
  • Exporting Gantt charts & tables to PDF

Manpower Loading in Excel

  • Estimating manpower per activity
  • Building a manpower histogram
  • Resource leveling basics

Cost & Budget Loading in Excel

  • Assigning Costs to Activities
  • Distributing Costs Over Time
  • Creating a Cost Loading Chart
  • Interpreting the Chart
  • Creating Project Dashboard

Workshops

  • Workshop-1: Creating Project, Adding Activities, Relationships
  • Workshop-2: Adding Resources
  • Workshop-3: Progress Reporting

 

[rrf_course_review]
Your subscription could not be saved. Please try again.
Confirm Your Email to Reserve Your Slot

Reservation Form

Please fill out the information below to reserve your slot for the course:

We use Brevo as our marketing platform. By submitting this form you agree that the personal data you provided will be transferred to Brevo for processing in accordance with Brevo's Privacy Policy.

Reservation for EMCC

Please fill out the information below to reserve your slot for the course Energy Manager Certification Course (EMCC).

Personal Information