|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/scenario-analyses-concepts-and-tools-for-business-analytics/
课程评论：没有评论
课程名称：掌握情景分析与Excel（完整的假设分析）！ 课程概述：本课程追求三个目标：1- 学习情景分析及其技术，包括但不限于蒙特卡洛模拟；2- 学习 Microsoft Excel 的情景分析工具；3- 学习适用于所有商业环境的商业分析公式和参数，这对参与商业、经济和金融的人士至关重要。情景分析是一种强大的规划和管理技术，旨在应对各种可能的未来，确保在不同情景下实现可接受的结果。该技术广泛应用于商业、金融、经济、政治、谈判，甚至军事行动。其主要论点在于，在制定计划时，我们的假设可能会因不可预测的事件而发生变化，从而导致结果也随之变化。因此，我们需要考虑不同的情景（通过假设的变化）并研究其对结果的影响。基本上，情景分析是一种应对生活随机性的方式。应对随机性的高级技术称为蒙特卡洛模拟，该方法通过随机抽样预测和预测在多个随机情景下的未来结果。在本课程中，学生将学习这一强大的技术，并学习如何使用 Microsoft Excel 创造性地实施样本蒙特卡洛模拟。此外，Microsoft Excel 提供了多种强大的情景分析工具，包括目标求解、数据表、情景管理器和求解器。在学习情景分析的概念和应用后，学生首先学习如何分析和计算利润和成本（包括固定成本和变动成本），如何计算盈亏平衡量，并使用 Microsoft Excel 形成利润表。在计算这些重要商业指标的过程中，学生将学习如何设置 Excel 表格，以便为后续的情景分析做好准备。然后，使用 Excel 工具，例如目标求解、数据表和求解器，学生们实施一些情景分析，以实现特定的期望结果。蒙特卡洛模拟作为对好奇心强的学生的高级奖励，将在课程结束时提供。 关于讲师：我叫 Mohammad Habibi，拥有商业博士学位，曾在美国、加拿大、马来西亚和伊朗等地的本科和研究生（MBA）课程中授课。我的教学风格快速而简明，我相信实践是学习的关键。如果您有任何问题，请给我发送电子邮件或通过 LinkedIn 联系我。
In this course three goals are pursued: 1- Learning Scenario Analysis and it's technics including but limited to Monte Carlo Simulation 2- Learning Microsoft Excel's scenario Analysis tools 3- and learning business analytics formula and parameters that are applicable in all business contexts and are essential for anyone involved in business, economics, and finance. Scenario Analysis is a powerful planning and management technic to deal with various possible futures and make sure to achieve an acceptable outcome under different scenarios. This technic is used in business, finance, economics, politics, negotiations, and even military operations. The main argument of this technic is that when outlining a plan, our assumptions can change due to unpredicted events and therefore the outcomes can change. For this reasons, we need to count in different scenarios (through changes in assumptions) and study their impact on the outcomes. Essentially, scenario analysis is a method of dealing with randomness in life. An advance technic of dealing with randomness is called Monte Carlo Simulation, which uses random sampling to predict and forecast future outcomes under numerous random scenarios. In this course, students will learn this powerful technic and learn how to implement a sample Monte Carlo Simulation using Microsoft Excel creatively. Also, Microsoft Excel Provides various powerful tools for scenario analysis including Goal Seek, Data Tables, Scenario Manager, and Solver. In this course after learning the Scenario Analysis concept and applications, students first learn how to analyze and calculate profit and cost (including fixed and variable cost), how to calculate the Break Even volume, and how to form an Income Statement using Microsoft Excel. While calculating these important business metrics, students learn how to set up excel sheets to be ready for further scenario analyses. Then using excel tools such as Goal Seek, Data Table, and Solver, students implement some scenario analyses to achieve certain desired outcomes. Monte Carlo Simulation is offered at the end of the course as an advanced bonus for curious minds. About the Instructor:My name is Mohammad Habibi. I have a Ph.D. in business and have taught in various programs including undergrad and graduate (MBA) courses in different parts of the world such as US, Canada, Malaysia, and Iran. My teaching style is quick and to the point and I believe learning will occur while doing. If you have any questions please send me an email or connect with through LinkedIn.
