From the course: Financial Modeling Foundations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Hiding tabs and making models readable

Hiding tabs and making models readable - Microsoft Excel Tutorial

From the course: Financial Modeling Foundations

Start my 1-month free trial

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…

Contents