课程
Financial Modeling in Excel
中级技能水平
更新时间 2026年4月
ExcelApplied Finance3小时9 视频28 道练习2,200 XP25,970成就证明
创建您的免费帐户
继续使用 Google显示更多选项或
继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。
深受数千家公司学习者的喜爱
需要团队培训？
企业版试用课程描述
Discover the Power of Cash Flows
Begin your journey by unraveling the intricacies of cash flows. You'll construct a financial model, calculate net income, and gain a solid understanding of what makes up an income statement. These skills will form the foundation of your financial modeling prowess.Master Scenario Analysis Techniques
Take your modeling skills to the next level by diving into scenario analysis. You'll learn how to forecast multiple outcomes, conduct sensitivity analysis, and effortlessly manipulate growth rates using Excel's versatile tools.Unlock the Secrets of Time Value of Money
Understand the critical concept of the time value of money and its pivotal role in decision-making. You'll calculate present and future values and apply these skills with precision.Becoming a Capital Budgeting Pro
Empower yourself with the ability to make data-driven decisions using metrics like net present value, internal rate of return. You'll compare results against benchmarks and provide actionable recommendations that drive success in financial scenarios.Upon completing this course, you'll be equipped with the expertise to excel in financial modeling using Excel. You'll have a deep understanding of financial concepts and the practical skills to apply them effectively. Join us on this journey and unlock your potential as a modeling master!
先决条件
Data Preparation in ExcelData Analysis in Excel1
Financial modeling
Use financial data from an income statement to create a financial model to forecast income, expenses, and net income and evaluate the purchase and sale price of the property using dynamic modeling features.
2
What-if Analysis in Financial Models
Use Excel’s What-If toolkit to enhance the power of financial modeling. Analyze and compare different hypothetical scenarios with the Scenario Manager, Goal Seek, and Data Table tools.
3
Time Value of Money
Time is money! Use the time value of money to analyze cash flows through the lens of an investor with return on investment, future value, and present value.
4
Capital Budgeting
Prioritize projects and make actionable investment recommendations using capital budgeting techniques. Calculate the net present value and the internal rate of return for the acquisition of West Ridge North.
Financial Modeling in Excel
课程完成 加入超过19百万学习者，今天就开始Financial Modeling in Excel！
创建您的免费帐户
继续使用 Google显示更多选项或
继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。
通过 DataCamp for Mobile 提升您的数据技能
随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。