Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

Name: Excel Project Management Toolbox 2022 Top 25 Excel PM Tools
Rating: 4.0 (27 reviews)

Over 25 practical excel tools and templates for managing your projects

Created byGunjan Subedi

Last updated 10/2022

English

What you'll 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

Course content

12 sections • 44 lectures • 2h 41m total length

Introduction and Course Preview (Can skip if watched)3:34

Using Sparklines3:12
Using Conditions for Probability Impact Matrix5:58
Gradient Probability Impact Matrix4:15
Conditional Formatting I2:20
Conditional Formatting II1:57
Conditional Formatting III1:15
Using Data Bars1:04
Learn how to use data bars in Excel through conditional formatting to visualize December sales within cells, with gradient or solid fills, enabling quick insights for dashboards and business management.
Message from the instructor3:39
Learn to add value through improvement tools and quality management in the excel project management toolbox, overcome confusions, and engage with the instructor via accessible contact options and timely feedback.

Histogram0:57
Working 80-201:34
Use a paretta analysis in an Excel template to auto-rank items by frequency, identify the 80 percent cumulative frequency, and practice data-entry rules in the green boxes.
Working with Fishbone Template2:09
Use the fishbone template to define the problem, brainstorm major causes, and ask why to reveal deeper causal relationships, mapping factors and process flow inputs to the problem in Excel.
5 Why Excel0:43

Earned Value Analysis II7:05
Earned Value Management10:53
Explore earned value management concepts, including planned value, actual cost, and earned value, and learn to compute budget at completion and estimated cost at completion to monitor cost performance.
Earned Value Analysis III3:30
Earned Value Analysis IV2:54
Explains earned value analysis iv and how to use the cost performance index and to complete performance index to forecast remaining work with the estimate at completion and remaining resources.
Building an excel template !

Prioritizing the project5:02
Learn to use a prioritization matrix and weighted factors to rank projects, assign weights to duration, cost, ROI, and resources, and determine where to invest resources for maximum opportunity.
Introduction of Project Charter0:23
Project Charter Intro4:48
Project Details I3:16
Project Charter II3:06
Use is and is not analysis to define project scope and prioritize what belongs inside or outside, then apply root cause analysis to fix low output in the powder department.
Project Charter III1:28
Project Charter IV2:17
Craft a clear problem statement using the five wh questions and build a business case, with smart Six Sigma and lean goals to improve output.
Last of Project Charter1:52

Requirements

No. This is a basic project management with Excel course.

Description

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 !

Who this course is for:

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

Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Voice of Customers and Stakeholder Analysis5 lectures • 21min

Project Planning-Using Forms4 lectures • 27min

Conditional Formatting and Risk Analysis8 lectures • 24min

Using Quality Tools4 lectures • 5min

Process Mapping2 lectures • 7min

Forecasting Demand4 lectures • 16min

Earned Value Analysis4 lectures • 24min

Using Project Charter8 lectures • 22min

Using A3 Analysis1 lecture • 9min

Requirements

Description

Who this course is for: