Welcome to Excel and
Finance video number 7. Hey, if you want to download
this workbook and follow along, click on my YouTube channel,
then click on my college website link, and you can
download the workbook Finance and Excel chapter 00. Hey, this is our last
video for chapter 00, which is just our introduction
to excel and math. We want to talk about
stylistic formatting. We talked about number
formatting, even more important than stylistic formatting. But we do want to talk
about stylistic formatting just briefly. We want to see how to add
borders, fill color, font color. And we’ll do some
number formatting also. Now I want to highlight this
little table right here. One way to do it is to take
your cursor and click and drag, right? Another way is if the
table has data everywhere, you can hit Control asterisk. And I’m going to use the
asterisk on the number pad. Control asterisk means
highlight the current table. Now I want to show
this Home ribbon, because it’s got
some good formatting. I’m going to right
click and unminimize. I want to add some borders. That’s borders. There’s other types of borders. In this class, we
will have to use top, single top, double bottom
border for some of our totals, especially on
financial statements. Borders are right there. They’re also in Control 1. You could do borders this way. And we’ll see how
to do this later in the class when we’re
doing financial statements. Now I want to add some color. So right here, I want
to add some fill color. So I come to the bucket. And this is based on themes. Here’s some of the colors,
but here’s more colors. And I usually like to come here. Some of my favorite colors here,
like that yellow and that blue. But whatever you
use, that’s fine. I’m going to click Cancel. I’m going to use
this one right here. Font color, same thing. More down here. Colors here. I’m going to select
a light font color. Now the rule is, when you
use a dark back color– including red, which most
people think is a light color, it’s not really. If you use a dark black font
on red, when you print it out, you can’t read it. So the rule of thumb is if
it’s even a little bit dark, like red or dark blue,
like I was going to use, then you want to use a
very light font color. And white is
usually pretty good. Now, that number
right there is $1. I’m going to use the keyboard
shortcut Control Shift 4. Or you could, to apply
currency, you could Control 1. And then go to the
number pad for currency. All right. Now I need to highlight this,
this, and this as percents showing three decimals. So I’m going to
click in this cell. And now I’m going to
hold the Control key. Because I want to highlight
cells that are not contiguous. It just means they’re
not next to each other. Highlight cells,
hold Control, click. You highlight cells
not next to each other, called non-contiguous. Control 1. I’m going to click
percent, and I’m going to show three decimals. And then click OK. And so it did it to
both of those cells. All right. That’s just a little bit
about stylistic formatting. That’s about all of the
formatting we’ll do. Actually, if we have a formula– these are formulas– like I
said in a couple videos ago, I’m going to color
them green, just so you know that
these are inputs, and these are formula results. All right. That’s the last
video for chapter 00. We’ll start chapter 1 talking
about finance next video. See you then.