|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/xcel-project-manger/
课程评论：没有评论
课程名称：Xcel项目经理 - 一款出色的项目管理工具！ 课程概述： 在当今这个预算有限与风险规避型组织盛行的时代，项目经理面临着日益严峻的挑战。项目经理需要在管理多个复杂项目和员工的同时，能够有效降低成本，并适应不断变化的商业环境。如果您能产生共鸣，那么Xcel项目经理（XPM）就是为您而设计的。虽然市场上有许多软件系统试图实现XPM的功能，但往往价格昂贵且工具众多，难以适用于普通项目经理。XPM以其简单结构和高度适应性著称，能够满足新员工、薪资变动和资源分配的变化。在本课程中，您将创建一款复杂而简便的工具，并可以根据需要不断完善。如果您现在没有时间上课，也可以在最后一节中下载完成的项目，并利用视频作为使用教程！ XPM的功能包括： - 每周跟踪项目进度 - 每周根据分配的员工资源测算任务和项目成本 - 将多个项目的成本汇总到每个项目的资源摘要行中，便于PM进行调整 - 可以进行长期的资源需求预测 - 根据预测的资源需求为新招聘或裁员提供依据 - 便捷添加新项目并撰写新提案，立即识别对员工资源的影响 - 建立灵活应对周度资源分配或薪资变动的机制 - 一旦掌握连接不同电子表格的基本方法，可完全适应您的需求 课程大纲： 第1部分：欢迎！ 第2部分：创建每周项目跟踪电子表格 第3部分：创建员工资源会计电子表格 第4部分：将每周项目跟踪表与会计（员工成本表）结合 第5部分：建立项目和员工资源的摘要电子表格 第6部分：添加新项目 第7部分：提高电子表格的可读性和吸引力，同时管理员工资源和项目预算，学习如何管理项目提案 参加此课程只需具备学习的意愿及对Microsoft Excel（我使用的是2016版，2013版相似）的访问权限。感谢您参加本课程！我将随时回答问题并跟踪学生可能遇到的任何问题。这门课程将帮助所有领域的项目经理建立可立即使用的技能。 主讲人：Ian Dowdy, MBA
Introduction: Project managers today are asked to take on increasingly challenging responsibilities. In an era of limited budgets and risk averse organizations, project managers (PMs) must be able to cut costs while managing many complex projects and multiple staff members while adapting on the fly to challenging business conditions. If you can relate, Xcel Project Manager (XPM) is for you. There are software systems that attempt to do what XPM can do. Unfortunately they are often expensive and have too many varied tools to be practical for the average PM. XPM is is perfect because it is simple in its construction and is highly adaptable to new staff, changes in salary and cost, and changing resource assignments. Through this course you will make a complex yet simple tool that you can refine to your needs over time. If you don't have time to take the course right now, you may download the finished product in the last section and use the videos as a tutorial for how to use it! What XPM can do: XPM tracks projects on a weekly basisMeasures task and project costs weekly based upon staff resources assigned to themTabulates costs for multiple projects into resource summary rows in each project sheet. This allows for the PM to make changes while keeping track of overall allocation.Can be used to project far into the futureAllows for justification for new hiring (or force reduction) based upon projected resource needsPresents an easy mechanism to add new projects and write new proposals with immediate recognition of impacts to staff resourcesAllows for immediate response to changes in allocation on a weekly basis or for changes in salary or costIt is completely adaptable to your needs once you learn the simple mechanisms of connecting separate spreadsheets through formulas The following is a course outline: Section 1: Welcome! Section 2: Create a weekly project tracking spreadsheet Section 3: Create a staff resources accounting spreadsheet Section 4: Tie weekly project tracking spreadsheet to accounting (staff cost sheet) Section 5: Establish summary project and staff resources spreadsheets Section 6: Add new projects Section 7: Improve readability (and attractiveness of sheets). Also manage staff resources and project budgets. Learn to manage a project proposal. To take this course you only need a willingness to learn and access to Microsoft Excel (I use 2016 but 2013 is very similar). Thank you for taking the course! I will be responding to questions and keeping track of any issues that students may have. This course should establish skills that will be immediately usable for all project managers in any field. Ian Dowdy, MBA
