课程: Excel Modeling Tips and Tricks

免费学习该课程！

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

Steps in building the multi-sheet model

Steps in building the multi-sheet model - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

Steps in building the multi-sheet model

“

- [Instructor] Multi-sheet financial models in Excel often feel fairly intimidating, but they don't have to be. Once you start working with them and using some simple tips and tricks, they can actually become a lot easier to work with. Let's take a look at an example. I'm in the 0303 Begin Excel file. Now, we have here our multi-sheet financial model for RedTech 30, and we're making a forecast. And we've got different scenarios: a GreySky scenario, a BlueSky scenario, and a Base scenario. And we've used our indirect function to simplify things so we don't even have to look at the GreySky, BlueSky, and Base scenario. We just use our dropdown that lets us go through and switch our assumptions. So I want to go through next and start building out the actual forecast. So what's my average price for the phone going to be? Well, thanks to the power of Excel's fill cell handle, I can just carry this right down. And all I have to do is make sure that I'm updating to the appropriate…

内容