From the course: Excel for Finance: Building a Three-Statement Operating Model

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Expanding on error checking

Expanding on error checking - Microsoft Excel Tutorial

From the course: Excel for Finance: Building a Three-Statement Operating Model

Start my 1-month free trial Buy for my team

Expanding on error checking

“

- [Instructor] Okay, so like we said a few minutes ago, all Excel files are prone to error. So let's implement some best practices to make our model more error resistant. We're going to introduce a brand new tab called the control panel. This is a place where we're going to consolidate errors as well as provide some guidance on the formatting because if you quickly look around, we've already got a bunch of different formatting in this file. We've got blue font, we've got black font, we've got some yellow shading and we've even got some red font down here, right? If you buy something at the store, it comes with an instruction manual, but for some reason no financial models ever do except for this one. We're going to show that on the control panel. So let's add a new tab. You can do that by just clicking the plus sign here. You can also use the keyboard shortcut, alt HIS. That's what I'm going to do, "alt his" is what I…

Contents