Crashing a Project using Microsoft Excel

4.8
29 个评分
提供方
Coursera 社区项目网络
在此指导 项目中,您将:

Schedule a project using Microsoft Excel.

Learn about crashing a project.

Crash a project using Solver.

Clock1 hour
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

Project Scheduling is an essential aspect of Project Management. In most case, after the Project Schedule has been prepared or during the Project execution, the Project Schedule needs to be crashed. Crashing a Project means to reduce the total duration of the Project. Crashing a Project involves a cost called the Crash Cost. So, while Crashing a Project, we need ensuring that we increase the Project Cost by the least amount. Crashing a Project optimally can be conducted using Linear Programming. As Microsoft Excel has support for Linear Programming, we can use Microsoft Excel to Crash a Project. Using Microsoft Excel for Project Scheduling has 2 more advantages. The first advantage is that the nuances involved in Project Scheduling becomes clear (This is hidden by tools like Microsoft Project). The second advantage is that we do not need additional license for tools like Microsoft Project. Most importantly, we will discuss aspects of Project Scheduling which cannot be conducted using tools like Microsoft Project and Primavera. In this Project, we will use Microsoft Excel to prepare a Project Schedule and then we will see how we can Crash the Project Schedule. This Guided Project was created by a Coursera community member.

您要培养的技能

Microsoft ExcelSolverProject Scheduling

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Create the Project Schedule Network

  2. Create a Project Schedule Network Yourself

  3. Calculate the Project Duration

  4. Prepare for Crashing the Project

  5. Set up Solver to Crash the Project

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

讲师

审阅

来自CRASHING A PROJECT USING MICROSOFT EXCEL的热门评论

查看所有评论

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心