|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-project-management-toolbox-2021-top-25-excel-pm-tools/
课程评论：没有评论
课程名称：2022年Excel项目管理工具箱 - 前25大Excel项目管理工具 课程概述： 本课程旨在帮助学员通过Excel掌握各种项目管理概念。具体内容包括： 1. 条件格式化的应用：满足项目需求的条件格式设置。 2. 项目可视化：使用火花图和其他工具提升项目视觉效果。 3. 质量管理：利用直方图、散点图等图表进行质量分析。 4. 甘特图制作：使用不同模板创建传统甘特图。 5. 敏捷项目管理工具：掌握敏捷甘特图、消耗图及其他工具的使用。 6. 项目调查模板：制作项目调查问卷的模板。 7. 根本原因分析工具：使用鱼骨图、5个为什么分析、帕累托图等工具。 8. 风险分析：如何使用Excel进行风险分析。 9. 利益相关者分析：分析项目相关方情况。 10. 项目需求预测：使用不同工具进行需求预测。 11. 项目优先级排序：合理安排项目优先级。 12. 项目成员管理：有效管理项目团队成员。 13. 流程映射：利用Excel进行流程映射。 14. Earned Value Management：掌握赚取价值管理、进度和成本预测。 15. 统计干预：使用控制图对流程进行可视化控制。 16. 项目章程设计：设计项目章程的技巧。 17. A3分析表设计：A3分析表的创建方法。 课程结束前，你将能够使用提供的多种模板进行实操，并学习如何自制Excel项目管理模板。课程中包含的一些模板和练习包括： - 条件格式化练习 - 甘特图模板（传统与敏捷） - 各类图表模板（消耗图、散点图、直方图等） - 根本原因分析工具模板（鱼骨图、5为什么分析、帕累托分析） - 流程映射模板（价值流图、部署图、流程图） - A3分析模板 - 项目章程模板 - 利益相关者分析模板及客户声音理解 常见问题解答： - 可以在购买后随时开始课程吗？可以，购买后没有时间限制。 - 如果学习过程中遇到问题，可以获得帮助吗？可以，课程提供Q&A功能和与讲师的直接消息联系（通常会在2个工作日内回复）。 - 完成后可以获得证书吗？可以，完成全部课程后可以下载证书。 - 如果对课程的价值不满意，可以退款吗？可以，提供30天全额退款保证。 感谢您的关注，期待在课程中与您进行精彩的团队合作。立即报名，提升您的专业技能！
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 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 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. ENROLL NOW and sharpen your professional skills!
