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 toolsHow to use excel for quality management using Histogram, Scatterplots and other graphsHow 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 managementLet’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 FormattingTemplates 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 AnalysisTemplates for Process Mapping (Visual Process Mapping Tools such as Value Stream Mapping (VSM), Deployment Maps, FlowchartsTemplate for A3 AnalysisTemplate for Project CharterTemplate for Stakeholder Analysis and Understanding the voice of customersThese 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 convenienceWill 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 lecturesWhat if I am not convinced with the value provided by the course? You can get a 30 day full money back guaranteeThank you so much. Waiting for a wonderful teamwork inside the course. ENROLLNOW and sharpen your professional skills!
