课程: Excel Modeling Tips and Tricks

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Linking sheets in financial models

Linking sheets in financial models - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

开始一个月试用 购买团队方案

Linking sheets in financial models

“

- [Narrator] One of the best functions in Excel when you're building models is the indirect function. Let's take a look at an example of how you can use this. I'm in the 0302 Begin Excel file. Now we have here our multi-sheet model, using an income statement and a balance sheet for this fictional company, RedTech 30, and we're doing a forecast going forward for what we think the income is going to be for the firm. Now, we've started with these assumptions and we have base assumptions in our model as well as blue sky assumptions, right? And as you might expect, or as the name implies, the blue sky assumptions are generally more optimistic, higher unit growth, higher price growth, et cetera, than those base assumptions. But what I want to do is I want to have these assumptions pull into my forecast sheet, based on whether I'm using the base case or the blue sky case. So to do that, I'm going to use the indirect function, and specifically the indirect function is going to look like this.…

内容