Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

Excel Project Management Toolbox 2022 Top 25 Excel PM Tools

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:

1. 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

   
   

2. 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)

   
   

3. 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

   
   

4. 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 !

Over 25 practical excel tools and templates for managing your projects

Url: View Details

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

Rating: 4.2

Level: Beginner Level

Duration: 2.5 hours

Instructor: Gunjan Subedi