July 2012
Beginner
320 pages
9h 29m
English
book
Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website
by Danielle Stein Fairhurst
Content preview from Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
CHAPTER 7
Tools for Model Display
Leaving aside the formulas and calculations of a model, in this chapter we will focus on the look and feel of a model. There are many Excel tools that can be used to make the model more attractive and friendly to the user. We’ll look at the basic formatting, and then more complex custom formatting, conditional formatting, and then form controls, which can be built to help the user interact with the model more easily.
BASIC FORMATTING
Believe it or not, as simple as it may sound, good formatting is an important part of building a financial model. While it’s critical of course to get the numbers right, making your model look good is the next step! A model that is well formatted will be more readable, user-friendly, and easy to navigate. Additionally you, the modeller, will find it easier to work with the model if it is clearly formatted.
In the latest version of Excel, all the formatting options for colour, font, and alignment are clearly displayed on the Home tab. A shortcut exists on the Home tab where you can very quickly change the number format on any cell from the Number ribbon, as shown in Figure 7.1.
FIGURE 7.1 Formatting from the Ribbon in Excel 2010
For detailed instructions on the more basic formatting tools, including changing number formats, percentage and currency formatting, number alignment, cell attributes, and styles, please see ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.