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.
Indenting and cleanup - Microsoft Excel Tutorial
From the course: Excel for Finance: Building a Three-Statement Operating Model
Indenting and cleanup
- [Instructor] Okay, so let's just do a little bit more formatting and final cleanup before we move on to the financial modeling exercise. And you might be saying to yourself, "This feels like a lot of formatting," and you know what? You are right. But one of the things that I learned early in my career is that formatting matters more than you think. And specifically when it comes to Excel, formatting and design. Like we've talked about files are very error-prone, and so the better that we can build the structure up front, the better we will be in the long run, even if it means a little bit more overkill of formatting early on. So, with that said, let's just go ahead and clean this up a little bit. We're going to narrow this column, we're going to do Alt H, O, W, all just make it to just to kind of clean this up a little. Let's expand this column, Alt H, O, I, so we can read it. And then let's bring our headers across…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
Call with the CFO3m 26s
-
(Locked)
Initial groundwork and freeze frames3m 8s
-
(Locked)
Identifying hardcoded data2m 19s
-
(Locked)
Applying the currency format3m 28s
-
(Locked)
The value of a placeholder row4m 7s
-
(Locked)
Initial error checking3m 2s
-
(Locked)
Expanding on error checking5m 50s
-
(Locked)
Formatting guide2m 42s
-
(Locked)
Indenting and cleanup3m 43s
-
-
-
-
-
-
-
-
-