课程: Financial Modeling Foundations

今天就学习课程吧！

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

Hiding tabs and making models readable

Hiding tabs and making models readable - Microsoft Excel教程

课程: Financial Modeling Foundations

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

Hiding tabs and making models readable

“

- [Instructor] Often, financial models can get to be large and overwhelming. But remember, the goal of model, any model, be it a map or a financial model, is to be a simplified version of reality. To that end, it often pays to disguise some of the behind-the-scenes details that make a financial model run, but are not necessary for most users to see. Now, this is our basic LBO model. There's a few things you wanna be aware of here. We have the ACME Statements tab and the DCF tab. Those tabs, while they contain useful and important information, are also very complex and they add a lot of detail to the model that maybe we're not necessarily interested in at this point. If we wanted to hide these tabs, that might help the ultimate user to be able to focus more on the basic LBO tab. To hide these tabs, you'll wanna click on the tab and then click Hide. You can do the same thing with ACME 3 Statements. If we wanted to unhide these tabs, we could either right-click in the bottom on the Basic…

内容