MS Excel: Project Management tools and techniques training centre in Bangladesh

New

MS Excel: Project Management tools and techniques

  • Date : 24 February - 08 March 2022
  • Duration : Evening(7:00 PM-10:00 PM)
  • No. of Classes/ Sessions : 5 Sessions
  • Class Schedule : Tuesday & Thursday
  • Total Hours : 15
  • Last Date of Registration : 23 February, 2022 ( within 5pm )
  • Venue : Online Virtual
  • (10% Off on Bkash or Online payment)

Introduction

Project Management is an exciting profession. Moving from one project to another, a Project manager constantly faces new businesses, new processes and systems, new people, and new situations. Such a dynamic environment helps you learn more all the time, and advances your skills much faster than traditional jobs do.

• Understand the fundamental project management theory, apply best practices and avoid common mistakes in your next project
• Learn how to use Gantt charts, Critical Path Method, Project Plan, Budget, and many other tools (GET 15+ project management templates). A brief tutorial on how to use MS Project is also included.
• MS Excel tutorial: learn how to create the 5 most important project management documents with MS Excel
• Waterfall or Agile? Learn the main differences, compare the Pros and Cons, and know which philosophy to apply in your next project

What you'll learn
• Design reports for your stakeholders
• Create a dashboard with some common project management requirements
• Improve project communications with charts
• Format, change, and edit charts
• Apply conditional formatting to save time and automate reporting
• Implement the Microsoft Excel Camera Tool
• All excel tools explained are useful for PMP. Six Sigma and Lean Project Management Certification Exam

Requirements
To take this course you only need a willingness to learn and access to Microsoft Excel

Methodology

PowerPoint Presentation, Live class via ZOOM, Brainstorming

Contents of Training:

The Epigram
1. Preface is complete in itself

Project Charter & Stakeholder Analysis
2. Prioritizing the project
3. Introduction of Project Charter
4. Project Details I
5. Theory-Understanding Voice of Customers
6. Working with Voice of Customers-The KANO model
7. Working with Stakeholder Matrix
8. Working with RACI Using Excel

Project Planning Using Forms
9. Using a form with conditions
10. Using Radio Buttons
11. Using Online forms

A3 and Risk Analysis
12. Using Sparkline
13. Using Conditions for Probability Impact Matrix
14. Gradient Probability Impact Matrix
15. A3 Charter Explanation

Conditional Formatting
16. Conditional Formatting
17. Using Data Bars
18. 3 Weeks look-ahead (live)

Earned Value Analysis
19. Concept of EVA/EVM
20. Formulas & Graph of EVM
21. Earned Value Analysis- Problem solving

Using Quality Tools
22. Histogram
23. Working 80-20
24. Working with Fishbone Template
25. 5 why Excel

Wrap up with extra gifts
26. Understanding Swim-lane
27. Understanding VSM
28. Forecasting demand with Excel
29. Understanding the difference
30. Déjà vu or a Move forward

Related Courses

Syed Saniat Ahmmad
  • 26 Jan - 7 Feb 2022

Practical examples, exercises & case studies with ...

IT
Md. Feroz Kibria
  • 28 - 29 Jan 2022 (2 Sessions)

Having good spreadsheet skills therefore gives you the ...

IT
Syed Saniat Ahmmad
  • 9 - 23 Feb 2022 (5 Sessions)

Practical examples, exercises & case studies with ...

IT
Md. Feroz Kibria
  • 11 - 12 Feb 2022 (2 Sessions)

Having good spreadsheet skills gives you the ability to ...

IT
Who this course is for- • Young professionals and university graduates interested in a project management career
• Students and professionals like PMP certified, six sigma yellow, green and black belt professionals, both agile and non-agile project professionals
• Project Managers, Planning Engineer, QA/QC Manager or Project team members responsible for reporting
• Anyone who wants to develop or enhance their project management knowledge and skills

Resource Person

Engr. Mohammad Hasibul Haque

Project Engineer (Civil Construction)

Engr. Mohammad Hasibul Haque is one of the widely known trainer on Construction & Infrastructure industry. His exploits are acclaimed. Ten-plus years of service. Five Int’l project with imperative role, 3 different learning institutes: numerous training session, the unexampled person who provides his every latest resource habitually. He's always been a bit of a maverick.

As an instructor, he is one of the finest facilitator this program has ever introduced. His exploits are renowned. What he will teach you, may very well mean the difference between Planning and Scheduling. Moreover, how you accelerate your capability to handle projects using technologies.

Engr. Hasibul is an inexhaustible source of kaizen. At present, he workout on miscellaneous training such as, Construction delay analysis, Claim management as per FIDIC etc. Neither It’s a mirage nor it's force-feed; Burgeoning local demand to spur this sort of training.

From the inception of his career he was attached with real estate Company like Safe Housing Limited, Holy Breeze Properties in early 2010 and also has working experience with Developers Company like Amicus Properties. After that, He worked with Italian-Thai Development Public Limited Company (ITD) to increase quality assurance for Dhaka Metro Rail Project (Line-6), financed by JICA. He has decent knowledge on Sub-structure as well Super-structure. He review and comment on drawing specification and any other documents that may require for the project. He also assist with the development of the inspection process for the site. Record accurate inspections carried out in line with the site documents. At the same time he is a Project Management System Specialist. He has received number of training from reputed national experts and institution.

Moreover Mr. Haque has started his nourishment two years earlier as a Lecturer but in short order he became Course Coordinator of Civil Technology Department, ISTT. He enjoy every bit of teaching profession. It has its ups and downs but on the whole, But it's fulfilling when He help youngsters to leave institute with decent grades and know they have a future. Personally Mr. Haque truly passionate about environment, disaster & vulnerability issues. He always try for using the principles of engineering, geotechnical knowledge and psychological attitude to create solutions to environmental problems—like improvements to structural and non-structural risk reduction.

Mr. Haque completed his B.Sc. in Civil Engineering; PGD (HRM); MDM (Disaster Management) from Dhaka University Furthermore M.Sc. from BUET ongoing.

PowerPoint Presentation, Live class via ZOOM, Brainstorming



social link fb social link fb social link fb