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.
Formatting guide - Microsoft Excel Tutorial
From the course: Excel for Finance: Building a Three-Statement Operating Model
Formatting guide
- [Instructor] Okay, so to keep going with some of our control panel and the best practices, the other thing we want to include here is a formatting guide, right? If I look around, we have a bunch of stuff going on. We've got blue font, we've got black font, we've got yellow shading, and we even have some red font. And you know, we know what we have, we built it but somebody who's new to this file isn't going to know. And so we just want to create a quick formatting guide for them to help them if they are new to the file. Like I said earlier, everything you buy at the store comes within instruction manual but for some reason, financial models don't. So we're going to change that. Let's just copy any old cell here to just grab the formatting. I'm going to press control C to copy it, and then I can press control page up to go to my control panel here. And I'm just going to paste this again I'm just looking for the formatting.…
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
-
-
-
-
-
-
-
-
-