|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/financial-model-basics-build-a-model-from-start-to-finish/
课程评论：没有评论
课程名称：财务模型基础：从头到尾构建一个模型 概述：本课程已有超过5000名学员注册！目标群体为需要预测企业财务的商业经理、财务专业人士及商科学生。财务模型基础课程将教您如何从头到尾创建一个基本的财务模型。 课程大纲：课程首先介绍建模的好处及应遵循的结构。接着，我们将分析历史数据，定义关键比率，并建立第一个输入表格。然后，我们将进行计算和输出表的构建。最后，我们将查看分析和敏感性表。在课程结束时，您将能够构建一个基本的财务模型。 课程形式和材料：所有课程以视频形式呈现，讲师将逐步指导您构建财务模型。此外，讲师提供Excel文件供您下载，以便在电子表格中进行实践。同时，您还将获得包含课程笔记的PDF或PowerPoint文件。 课程要求：- 使用Microsoft Excel - 基础Excel技能 - 对财务概念（如毛利、变动成本）有基本了解。 无相关课程大纲。
Over 5000 students enrolled! Aims and audience: Financial Model Basics teaches you how to create a basic financial model, from start to finish. The course is targeted at business managers, finance professionals or business students who need to forecast the finances of a business. Outline: We start with the benefits of modelling and the structure to be followed. I then take you through analysing historical data, defining key ratios and building the first sheet - the input sheet. Then we move on to calculations and the output sheets. Finally we look at analysis and sensitivity tables. By the end of the course, you will be able to build a basic financial model. Format and materials: All of the lessons are videos in which I talk you through each step of building the financial model. In addition, I give you Excel files in each lesson, so you can download the files and work on the spreadsheets yourself. I also give you PDF or PowerPoint files that contain lesson notes. Requirements: -Microsoft Excel -Basic Excel skills -Basic understanding of financial concepts (eg gross profit, variable costs)
