Introduction
MS Excel offers robust capabilities for data analysis, financial modelling, and reporting, enabling detailed data analysis and comprehensive report creation for informed decision making. In contrast, MS Project specializes in project scheduling, resource allocation, and progress tracking, making it a dedicated tool for effective project management. This course designed to equip project managers with the essential skills to effectively plan, execute, monitor, and close projects using MS Excel and MS Project. By mastering these tools, project managers can enhance their ability to manage complex projects, optimize processes, and improve overall project outcomes.
Course Outline
- Module 1
- Module 2
- Module 3
- Module 4
- Module 5
- Course Objectives
- Target Audience
MS Excel for Project Management
- MS Excel interface and functionalities.
- Essential formulas and functions.
- Sorting, filtering, and data validation techniques.
- Creating and modifying Pivot Tables.
- Analysing project data with Pivot Tables.
Advanced MS Excel Techniques
- Advanced formulas and functions.
- Using PivotCharts for data visualization.
- Building a simple financial model.
- Creating impactful charts and graphs.
- Presenting project data effectively.
Fundamentals of MS Project
- MS Project interface and features.
- Creating project plan and schedules.
- Assigning and levelling resources.
- Setting and managing project baselines.
- Techniques for tracking project progress.
Advanced MS Project Techniques
- Critical path method and task dependencies.
- Customizing Gantt charts, timeline views.
- Creating and customizing project reports.
- Earned value management (EVM).
- Importing and exporting data from Excel.
Integrating MS Excel and MS Project
- Importing and exporting data between Excel and Project.
- Budgeting techniques using Excel and Project.
- Monitoring project performance with KPIs.
- Generating comprehensive reports.
By the end of this course, participants will be able to:
- Learn data analysis, financial modelling, and reporting of MS Excel for project management.
- Master the using of MS Project for scheduling, managing resources, and reporting.
- Optimise project management processes with MS Excel and MS Project.
- Make informed project management decisions using MS Excel and MS Project.
- Explore practices in project management using these tools to ensure successful project delivery.
This course is ideal for:
- Project Managers.
- Project Coordinators.
- Team Leaders.
- Business Analysts.
- Operational Managers
- Individuals looking to develop project management skills.
Course Schedule & Fees
- Kuala Lumpur
- Singapore
- Amsterdam
- Online
- Course Fees
This course will take place in Kuala Lumpur on the following dates:
| 05/05/2025 | 19/05/2025 | 02/06/2025 | 16/06/2025 |
| 30/06/2025 | 14/07/2025 | 28/07/2025 | 11/08/2025 |
| 25/08/2025 | 08/09/2025 | 22/09/2025 | 06/10/2025 |
| 27/10/2025 | 10/11/2025 | 24/11/2025 | 08/12/2025 |
| 22/12/2025 | 05/01/2026 | 19/01/2026 | 02/02/2026 |
This course will take place in Singapore on the following dates:
| 26/05/2025 | 16/06/2025 | 07/07/2025 | 28/07/2025 |
| 18/08/2025 | 08/09/2025 | 29/09/2025 | 20/10/2025 |
| 10/11/2025 | 01/12/2025 | 22/12/2025 | 12/01/2026 |
| 02/02/2026 | 23/02/2026 |
This course will take place in Amsterdam on the following dates:
| 12/05/2025 | 02/06/2025 | 23/06/2025 | 14/07/2025 |
| 04/08/2025 | 25/08/2025 | 15/09/2025 | 06/10/2025 |
| 27/10/2025 | 17/11/2025 | 08/12/2025 | 29/12/2025 |
| 19/01/2026 | 19/01/2026 |
This course will take place Online the following dates:
| 13/05/2025 | 10/06/2025 | 08/07/2025 | 05/08/2025 |
| 02/09/2025 | 30/09/2025 | 28/10/2025 | 25/11/2025 |
| 23/12/2025 | 20/01/2026 | 17/02/2026 |
| Kuala Lumpur | Singapore | Amsterdam | Online |
| USD$ 3,580 | USD$ 5,600 | USD$ 5,600 | USD$ 1,920 |
