|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-excel-for-project-managers/
课程评论：没有评论
课程名称：项目经理的MS Excel 课程概述：本课程包含约5小时的内容，是关于如何利用MS Excel开发项目文档以帮助管理项目的最全面课程。通过一步一步的指导，学习如何利用Excel创建各种项目管理文档，从行动项目文档到使用数据透视表生成项目财务分析。这不是理论课程，而是专注于传授具体的操作程序，帮助学员将Excel应用于项目管理中。课程中使用真实案例以增加学员的Excel知识，并通过实际文档来提升学员的能力。每个部分结束时都有一个项目来巩固所学知识，还附带逐步说明，帮助学员构建自己的项目文档。 课程还包括一个额外项目：在MS Excel中创建自己的甘特图跟踪器，逐步引导学员制作自己的甘特图，以便可视化跟踪项目任务的进展。 完成时间：本课程有40多个讲座，若每天花费30分钟，可以大约在3周内完成该课程。 适合人群：本课程适合希望逐步学习如何利用MS Excel管理日常项目管理任务的人员。所学技能可应用于真实项目中。 如果我不理解某个主题怎么办？在学习过程中，讲师会提供联系提示，学员可以在讲师的网站上提出问题或反馈。讲师会亲自回复学员的问题。 你将学习到的内容包括： - 如何在Excel中创建自己的甘特图项目任务跟踪器 - 将Excel数据链接到PowerPoint，制作有力的状态报告 - 数据透视表和项目财务数据的图表化 - 使用数学函数如Sum、Avg、IRR和NPV进行项目分析 - 跨多个工作表的单元格引用以整合数据 - 数据验证和条件格式设置，帮助用户避免输入无效数据 - 使用VLOOKUP和INDEX MATCH等查找函数在数据表中查找数据 - 快速输入数据的技巧 - 分析函数如SumIf、If、Or、IfError和CountIf，分析符合特定条件的数据 课程对象： - 想要利用MS Excel开发项目文档的项目经理 - 希望在Excel中开发强大分析工具以分析数据的人员 - 希望更好了解项目指标的高级管理人员 - 希望理解项目财务绩效的PMO分析师 - 想要了解如何利用文档更好完成工作“意外”项目或程序经理
With about 5 hours of content, this is the most comprehensive course on how to leverage MS Excel to develop project artifacts that can help you manage projects. Gain step-by-step instruction on how to develop various project management artifacts leveraging MS Excel - from the Action Item Document to leveraging pivot tables to generate project financial analysis.Information gathered is from specific past job experience - this is not a theory course but a course to teach you specific step-by-step procedures to leverage MS Excel to develop project management artifacts.Leverage real-world examples to increase your knowledge of MS Excel as we work through actual artifacts that you will leverage during your project management career. Each section ends with a project to help reinforce the knowledge attained. Step-by-step documentation is attached to help you build your own project artifact leveraging MS Excel.Bonus Project: Build your own Gantt Chart timeline tracker in MS Excel - You will be taken step-by-step to produce your own Gantt chart where you can track the progress of project tasks visually.How long will it take?With over 40 lectures and about 5 hours of content, if you budget just 30 minutes a day, you can complete this course in approximately 3 weeks. Is it for me?This course is for you if you want to learn step-by-step how to leverage MS Excel to help you manage your day to day project management tasks. The skills you learn here can be applied to real-world projects. What if I don't understand a topic?As you move through the course, I will provide prompts where you can reach out to me on my website with questions or feedback. I will PERSONALLY get back to you to answer any questions you may have. What you'll learnHow to create your own Gantt chart project task tracker in MS Excel.Linking MS Excel data to MS PowerPoint to develop robust status report presentations.Pivot Tables and Charting of Project financial data.Mathematical functions such as Sum, Avg, IRR, or NPV and how to use them to analyze which project to undertake.Cell Referencing across multiple worksheets to help you consolidate data into one sheet.Data validation and Conditional Formatting to help your users avoid entering invalid data into your sheets.Lookup functions such as VLOOKUP AND INDEX MATCH to find data nested within data tables.Techniques to help you enter data quickly into your spreadsheets.Font & Border alignment, cell merging, number formats, the format painter, and tab colors/themes.Analytical functions such as SumIf, If, Or, IfError, and CountIf to analyze data that only meets certain conditions.Who this course is for:Project Managers who want to leverage MS Excel to develop robust project artifactsAnyone who wants to develop robust analytical tools in MS Excel to analyze data.Senior Managers who want to better understand the project metrics. PMO Analysts who want to understand the financial performance of projects.The "accidental" project or program manager who wants to understand how to leverage artifacts to do their jobs better.
