Get 10% discount

Microsoft Excel for Professional Project Managers

Introduction

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

Methodology

The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:


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

Related Courses

Mohammed Zafor Ullah Nizam
  • 28 - 29 Apr 2017 (2 Days)

This training is designed for practitioners who are or ...

Project Management
Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 2 May - 11 Jun 2017

Project Management
Price 5,000 Tk + VAT
Dr. Sakil Ahammed
  • 5 - 6 May 2017 (2 Days)

A project usually deemed to be a success, if it achieves ...

Project Management

Contact

9140345, 9117179

workshop@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

Project management professionals who should be experienced users of Microsoft Excel. Finance skills, Logical reasoning and fundamental IT skills are essential to successfully achieve the outcomes of the course.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.