Rating 4.0 out of 5 (16 ratings in Udemy)
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
Description …
Rating 4.0 out of 5 (16 ratings in Udemy)
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
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 Iget 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. ENROLLNOW and sharpen your professional skills !
