Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

Excel Project Management Toolbox 2022 Top 25 Excel PM Tools, available at $44.99, has an average rating of 3.55, with 44 lectures, based on 25 reviews, and has 252 subscribers.

You will learn about Right from building project dashboards to formatting projects with excel, Visual and Quality management tools, Root Cause Analysis tools, conditional formatting and all…(please do through the course description for more) All excel tools explained are useful for PMP. Six Sigma and Lean Project Management Certification Exam You can download over 25 excel templates and edit them all according to your own project needs This course is ideal for individuals who are Interested students and professionals in Project Management or Students and professionals like PMP certified, six sigma yellow, green and black belt professionals, both agile and non agile project professionals or Project Managers or interested students or Quality managers or interested students It is particularly useful for Interested students and professionals in Project Management or Students and professionals like PMP certified, six sigma yellow, green and black belt professionals, both agile and non agile project professionals or Project Managers or interested students or Quality managers or interested students.

Enroll now: Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

Summary

Title: Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

Price: $44.99

Average Rating: 3.55

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 45

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Right from building project dashboards to formatting projects with excel, Visual and Quality management tools, Root Cause Analysis tools, conditional formatting and all…(please do through the course description for more)
All excel tools explained are useful for PMP. Six Sigma and Lean Project Management Certification Exam
You can download over 25 excel templates and edit them all according to your own project needs

Who Should Attend

Interested students and professionals in Project Management
Students and professionals like PMP certified, six sigma yellow, green and black belt professionals, both agile and non agile project professionals
Project Managers or interested students
Quality managers or interested students

Target Audiences

Interested students and professionals in Project Management
Students and professionals like PMP certified, six sigma yellow, green and black belt professionals, both agile and non agile project professionals
Project Managers or interested students
Quality managers or interested students

Some of the project management concepts which we will learn in this course practically with excel are:

How to use the conditional formatting for your project needs ?
How to make the project more visually appealing with spark lines and other tools
How to use excel for quality management using Histogram, Scatterplots and other graphs
How to use the conventional Gantt charts with different templates ?
How to use the Agile Project management tools like Agile Gantt Chart, Burn up and Burn Down Chart ?
How to make template for Project surveys ?
How to use the Root Cause Analysis tools such as Fishbone, 5 Whys, Pareto Chart etc.
How to carry out the Risk Analysis with Excel ?
How to carry out Stakeholder Analysis ?
How to Forecast the demand of the projects with different tools?
How to Prioritize the projects ?
How to manage the project members?
How to use excel for process mapping ?
How to use excel for earned value management and forecasting schedule and cost?
How to use statistical intervention and see visually the control of process through control charts?
How to design a Project Charter?
How to design the A3 Analysis table ?

Before downloading the certificate at the end of the course you will be able to work out with different templates provided for you and learn how to build your own excel templates for project management

Let’s see some important Excel Templates/ Exercises provided in this course for student’s practice (Note: All templates are not listed here- see the course curriculum to see what you can expect more)

Exercises for Conditional Formatting
Templates for Gantt Chart (Both Conventional and Agile)
Templates for different graphs and charts (burn up/down/ scatterplot/Histogram and more)
Templates for Root Cause Analysis (RCA tools)- Fishbone diagrams (4s, 8P, 6M, 8M), 5 Why Analysis, Pareto Analysis
Templates for Process Mapping (Visual Process Mapping Tools such as Value Stream Mapping (VSM), Deployment Maps, Flowcharts
Template for A3 Analysis
Template for Project Charter
Template for Stakeholder Analysis and Understanding the voice of customers
These are just some examples of templates out of many….

FAQ:

Can I start the course anytime after I buy?

Once you purchase the course, there is no time limit and you can go through the course at your own convenience
Will I be helped if I am stuck over anything ?

Yes, the course comes with Q & A features and direct messaging to the instructor (you get a reply within 2 working days or as soon as possible)
Can I get the certificate after completion ?

Yes, like other courses in udemy, you can download the certificate at the end of the course after completing all the lectures
What if I am not convinced with the value provided by the course ?

You can get a 30 day full money back guarantee

Thank you so much. Waiting for a wonderful teamwork inside the course. ENROLL NOW and sharpen your professional skills !

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction and Course Preview (Can skip if watched)

Chapter 2: Voice of Customers and Stakeholder Analysis

Lecture 1: Theory-Understanding Voice of Customers

Lecture 2: Working with Voice of Customers-The KANO model

Lecture 3: Working with Stakeholder Matrix

Lecture 4: Working with RACI

Lecture 5: Using Excel

Chapter 3: Project Planning-Using Forms

Lecture 1: Using a form

Lecture 2: Using conditions in a form

Lecture 3: Using Radio Buttons

Lecture 4: Using Online forms

Chapter 4: Conditional Formatting and Risk Analysis

Lecture 1: Using Sparklines

Lecture 2: Using Conditions for Probability Impact Matrix

Lecture 3: Gradient Probability Impact Matrix

Lecture 4: Conditional Formatting I

Lecture 5: Conditional Formatting II

Lecture 6: Conditional Formatting III

Lecture 7: Using Data Bars

Lecture 8: Message from the instructor

Chapter 5: Using Quality Tools

Lecture 1: Histogram

Lecture 2: Working 80-20

Lecture 3: Working with Fishbone Template

Lecture 4: 5 Why Excel

Chapter 6: Process Mapping

Lecture 1: Understanding Swimlane

Lecture 2: Understanding VSM

Chapter 7: Forecasting Demand

Lecture 1: Forecasting demand with Excel I

Lecture 2: Forecasting demand with Excel II

Lecture 3: Understanding the difference

Lecture 4: Forecasting demand with Excel III

Chapter 8: Earned Value Analysis

Lecture 1: Earned Value Analysis II

Lecture 2: Earned Value Management

Lecture 3: Earned Value Analysis III

Lecture 4: Earned Value Analysis IV

Chapter 9: Using Project Charter

Lecture 1: Prioritizing the project

Lecture 2: Introduction of Project Charter

Lecture 3: Project Charter Intro

Lecture 4: Project Details I

Lecture 5: Project Charter II

Lecture 6: Project Charter III

Lecture 7: Project Charter IV

Lecture 8: Last of Project Charter

Chapter 10: Using A3 Analysis

Lecture 1: A3 Charter Explanation Full

Chapter 11: Conclusion

Lecture 1: Conclusion

Lecture 2: How to download the udemy certificate ?

Chapter 12: Bonus

Lecture 1: Bonus

Instructors

Gunjan Subedi
Lean Six Sigma and Quality Assurance Specialist

Rating Distribution

1 stars: 5 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 7 votes
5 stars: 11 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu