Microsoft Excel

Question

We kindly request that you confirm whether the Microsoft Excel application can be considered a specialized program/software for project management, in accordance with professional standards in the field, and whether we may use Microsoft Excel to create a Gantt chart in compliance with the requirements below:

1. The Gantt chart for contract execution, which must highlight:

• The activities, sub-activities, and stages proposed by the bidder;
• Their sequence, duration, and interdependencies;
• The significant moments of the project / reference points / associated milestones;
• The use of resources (human and material) for each stage;
• Extracts from the same Gantt chart presenting:
  • The critical path;
    • The significant moments and milestones;
      • The allocation of human resources for each stage, activity, and sub-activity (including the effort allocated to each expert and the entity to which they belong).

2. The critical path diagram, which must reflect:

• The activities, sub-activities, and stages that definitively influence the total duration of the contract;
• Full correlation with the information in the Gantt chart.

3. The “S-curve” of physical progress, which must:

• Estimate the physical progress during contract implementation;
• Serve as a performance indicator for anticipating potential delays;
• Allow comparison between estimated values and actual values at contractual intervals (e.g., quarterly).

4. The service delivery schedule must be presented using a specialized project management program/software, in order to allow verification in the files requested under points 1, 2, and 3 of the following elements:

• The names of activities, sub-activities, and stages;
• Their durations (including start and end dates);
• The allocated human resources;
• Identification of the critical path;
• Allocation of resources among consortium members/subcontractors;
• The effort allocated to each expert (in hours or days);
• Significant moments / reference points / milestones;
• The “S-curve” of estimated physical progress.

We thank you in advance for your support and remain at your disposal for any further information. we kindly request that you confirm whether the Microsoft Excel application can be considered a specialized program/software for project management, in accordance with professional standards in the field, and whether we may use Microsoft Excel to create a Gantt chart in compliance with the requirements below:

1. The Gantt chart for contract execution, which must highlight:

• The activities, sub-activities, and stages proposed by the bidder;
• Their sequence, duration, and interdependencies;
• The significant moments of the project / reference points / associated milestones;
• The use of resources (human and material) for each stage;
• Extracts from the same Gantt chart presenting:
  • The critical path;
    • The significant moments and milestones;
      • The allocation of human resources for each stage, activity, and sub-activity (including the effort allocated to each expert and the entity to which they belong).

2. The critical path diagram, which must reflect:

• The activities, sub-activities, and stages that definitively influence the total duration of the contract;
• Full correlation with the information in the Gantt chart.

3. The “S-curve” of physical progress, which must:

• Estimate the physical progress during contract implementation;
• Serve as a performance indicator for anticipating potential delays;
• Allow comparison between estimated values and actual values at contractual intervals (e.g., quarterly).

4. The service delivery schedule must be presented using a specialized project management program/software, in order to allow verification in the files requested under points 1, 2, and 3 of the following elements:

• The names of activities, sub-activities, and stages;
• Their durations (including start and end dates);
• The allocated human resources;
• Identification of the critical path;
• Allocation of resources among consortium members/subcontractors;
• The effort allocated to each expert (in hours or days);
• Significant moments / reference points / milestones;
• The “S-curve” of estimated physical progress.

We thank you in advance for your support and remain at your disposal for any further information.

Answer 1

Hi @EPMC,

Thank you very much for the detailed and well-structured question.

Just to set expectations clearly and transparently, this is a user‑to‑user support forum. I’m not affiliated with any Microsoft product team, and moderators like myself don’t have insight into internal product classifications or official compliance determinations. What I can offer is an informed perspective based on professional project management standards, publicly available documentation, similar questions I’ve seen in this community, and hands‑on experience. Hopefully, this can serve as a helpful reference point while you weigh your options.

Addressing your core question directly: Microsoft Excel is generally not considered a specialized project management program under professional project management standards. Dedicated tools such as Microsoft Project are designed specifically for this purpose and natively support the full lifecycle of project scheduling and control. They automatically manage task dependencies, calculate and update the critical path, handle resource allocation and leveling, and maintain consistency across schedules, diagrams, and progress tracking outputs.

That said, Excel is undeniably versatile, and it can be used to model several of the elements you’ve listed, particularly when the aim is presentation or high‑level planning. With Excel, you can create a Gantt chart that shows activities, sub‑activities, stages, durations, start and end dates, and milestones, typically by using stacked bar charts. You can represent task sequencing and interdependencies by introducing predecessor columns, and resource usage can be illustrated through tables or conditional formatting. With enough effort, you can also extract views from the same data set that highlight milestones, summarize human resource allocation by activity, or even approximate the critical path using formulas.

However, this is where the practical limitation becomes important in the context of your requirements. In Excel, all correlations are manual. Critical path identification requires custom logic through formulas or VBA, and it does not automatically stay synchronized with the Gantt chart if changes occur. Ensuring full and ongoing correlation between the Gantt chart, a standalone critical path diagram, and resource allocation views demands constant manual maintenance.

The same applies to the “S‑curve” of physical progress. Excel can certainly generate S‑curves using cumulative progress calculations and line or scatter charts, allowing comparisons between planned and actual values at contractual intervals such as quarterly checkpoints. While this is feasible, validating that the S‑curve, schedule, resource effort by expert, consortium allocation, and milestones all remain consistent within a single file becomes increasingly complex and error‑prone as the project grows. 

Because point 4 of your requirements explicitly states that the service delivery schedule must be presented using a specialized project management program/software to allow verification of all elements listed under points 1, 2, and 3, Excel is usually seen as falling short in a formal or audit‑driven context. Tools like Microsoft Project are built precisely to address this need. They natively support activity naming and structuring, durations with start and end dates, human resource assignment down to the individual expert, effort tracking in hours or days, consortium or subcontractor allocation, automatic identification of the critical path, milestone management, and S‑curve generation through earned value and progress reporting, all within one internally consistent model.

In short, Excel can be suitable for simpler schedules or illustrative Gantt charts, and it can technically model many of the elements you’ve outlined. However, when professional standards and formal verification requirements explicitly call for a specialized project management application, Microsoft Project (or a similar dedicated tool) is generally the more compliant and defensible choice.

---

Thank you very much for taking the time to read through this response. I sincerely hope it provides a helpful perspective for you to consider as you move forward.

If you feel the answer has been useful for your reference, you may consider clicking “Accept Answer” for this post. This helps automatically bring the discussion to the top, making it easier for other users searching for this topic to find it. It also encourages the wider community to contribute additional ideas or share their own experiences, which may further support your assessment.

Thank you once again for your time and engagement.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.