|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-modelling-skills/
课程评论：没有评论
Coursera 上的《Excel 建模技能》课程旨在为初学者和有 Excel 使用经验但未接触过财务建模的用户提供基础。 本课程涵盖了财务建模的关键技能，包括： * **模型设计与布局**: 如何构建易于理解且格式一致的模型，以及日期时间线的应用。 * **单元格引用与命名范围**: 学习使用 `$` 锁定单元格引用，以及使用命名范围来提高公式的清晰度和逻辑性。 * **IF 函数应用**: 掌握 IF 函数进行关键决策，并学习如何处理包含 IF 函数的实际练习。 * **混合引用问题**: 解决包含多个变量但公式需要跨行保持一致的复杂问题。 * **嵌入式 IF 语句**: 运用嵌入式 IF 语句处理多个独立变量和多种可能结果的逻辑问题。 课程还强调了 Excel 快捷键的使用，以提高导航、菜单访问、速度和效率。完成此课程将为您继续学习完整的财务建模课程打下坚实的基础。
If you are self-taught Excel, or not used it at all before, where do you start? This foundation program will teach you essential skills for getting going with financial modelling. It covers the fundamentals you need - from model design and layout, using date timelines and efficient formatting through to the proper use of $, Named Ranges and the most frequently encountered Excel function: the IF statement. You will also look at logical problem solving where there are multiple outcomes: using embedded IF statements. When you are happy with this, you'll be able to quickly progress through our full Financial Modelling course. Course contentIntroduction and course content - an intro to model building in Excel Excel keystroke shortcuts - for navigation, menu access, speed and efficiencyModel design and layout, including date timelines - how to set up models and efficient, consistent formatting to make them easy to readUsing $ to anchor cell references, and using Named Ranges as an alternative to add clarity and logic to your formulaeUsing the IF statement for key decision making in models - and applying this to a downloadable exerciseApplying your skills to a typical mixed-reference problem - dealing with multiple variables but keeping formulae consistent across rowsLogical problem solving with embedded IF statements for independent variables - what to do when there are multiple outcomes to consider, each input being independent.
