|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/essential-excel-modelling/
课程评论：没有评论
**课程名称：Essential Excel Modelling** **课程概述：** 本课程是关于Microsoft Excel在金融建模领域的应用，旨在帮助学员掌握高效的建模实践，从而节省时间和精力。课程内容全面，从Excel基础概念到解决金融建模中常见的实际问题。 **课程内容亮点：** * **金融模型：** 探讨不同类型的金融模型及其用途，重点介绍那些对财务信息要求不高的模型。 * **Excel函数：** 涵盖基础函数、逻辑函数、单元格引用和命名区域。 * **数据透视表：** 讲解数据透视表的优势，并与SUMIF函数进行对比，讨论其局限性。 * **金融建模函数：** 深入讲解聚合函数、查找函数（包括INDEX和MATCH嵌套）、以及OFFSET函数。 * **金融模型与概念：** 介绍回归分析、金融项目评估函数以及摊销表等核心概念。 **目标学员：** 本课程主要面向需要对Excel建模有基本了解的分析师和专业人士，帮助他们掌握Excel在解决金融问题中的应用。 **学习收获：** 通过本课程的学习，学员将能够： * 理解良好的建模实践，提高工作效率。 * 掌握Excel中常用的函数和工具。 * 能够运用Excel解决金融建模领域的实际问题。 * 对金融模型类型、目的及相关概念有深入认识。
Financial Modelling has come a long way in Office Productivity and has gained a lot of following in its own right especially in the large and complex Office Productivity landscape.After taking this course, the student understands good modelling practices that saves time, money and efforts that is usually needed in putting together a financial model.The comprehensive nature of this course lets the student understand the basic concepts in Microsoft Excel and the day to day problems that it strives to solve in the toughest landscape of Financial Modelling exercises.It addresses technical model of Financial topics such as tools selection, best practices and model selection.It gives a practical hands-on approach to all forms of problem solving and does cover some of the most interesting topics under the Excel Landscape.This is mostly a basic level course on Excel Modelling and helps Analysts and Professional achieve a basic understanding on Excel and the problems that it is supposed to solve in the Financial World.In this course the following topics are covered, namely, Financial Model-Types and Purposes, Excel Functions, Pivot Tables, Financial Modelling Functions and Financial Models and Concepts.In Financial Model-Types and Purposes, Financial Models are explained that does not require a lot of Financial Information in its model.In Excel Functions, Basic Functions, Logical Functions, Cell References and Named Ranges are covered.In Pivot Tables, advantages of Pivot Tables are explained and disadvantages are discussed with respect to SUMIF functions.In Financial Modelling Functions, Aggregate Functions, Lookup functions, Nesting Index and Match and Offset functions are explained.In Financial Models and Concepts, Regression Analysis, Financial Project Evaluation functions as well as Amortization Schedules are explained.
