About Workshop
Most of the business organisations have started working based on projects. As a result project management has become a significantly demanding profession. However, as project management is a relatively new knowledge area, most of the project managers lack sound project management skills as well as know-how on managing projects using technology. This course will provide both the fundamental concepts of project management as well as sound skills on Microsoft Excel for project management.
Learning Outcomes
1. Understand fundamental project management concepts and philosophies
2. Analyse Financial Viability of a Project
3. Prepare project quality plan using work break down (WBS) structure in Excel
4. Prepare project implementation schedule using Microsoft Excel
5. Prepare project costing and budgets using Microsoft Excel
6. Identify and manage project risk using Microsoft Excel
7. Prepare complete project Plan
8. Track, monitor project, report project performance and comparison using Excel
Workshop topics to be covered:
Session 1: Fundamental Concepts of Project Management
Understand projects and distinguish between project and business
Define a project and its objectives
Project Performance Parameters – quality, cost, schedule
Apply fundamental concept in real life projects (ex. Construction)
Session 2: Measuring Financial Viability of a Project using Excel
Understand project cost and benefit
Determine project cash flow
Determine project payback period
Determine project IRR and NPV
Session 3: Project Quality Planning using Excel
Work-break-down structure in Excel
Project Specification and team database
Share project specification information
Develop specification monitoring system
Session 4: Project Scheduling using Excel
Identify overall planned project completion period
Dividing project in phases and determine phase times
Prepare GANTT Chart and Milestone Chart
Share Scheduling information with Management
Session 5: Project Costing and Budgeting using Excel
Identify phase-by-phase cost of projects
Identify overall cost of projects
Prepare project cash flow over time
Prepare project budget over resources and tasks
Session 6: Project Risk Management using Excel
Identify potential project risks
Assess impact of each risk on quality, time and cost
Conduct risky scenario analysis
Manage risk using Excel features
Session 7: Plan, Monitor and Track Project Progress using Excel
Prepare a complete project plan
Monitor project implementation
Enter actual project data and track progress
Conduct Earned value Analysis
Session 8: Report Project Performance using Excel
Compare actual versus planned performance
Compare performance of different projects
Share comparative information with project parties
Develop multiple project management system
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
