Hello, everybody. Welcome to Course 1, Week 2. This is going to be your activity. Actually, it's going to be a mini Excel tutorial. I'm going to teach you a couple of things in Excel. First, I'm going to show you how to use the sum function, then we're going to be talking about formatting, whether it's formatting numbers, dates, using color, adjusting columns, widths, and row heights. Let's take a look first at the sum function. I'm just going to go ahead and put some numbers in here, so we'll have 1500, and I'm going to have $75, and I'm going to have 86. Let's say we want to sum all of those numbers up. There're several ways we can go about doing that. First, we can take this AutoSum function here where my arrow is, and it assumes that it knows exactly what you're talking about for summing. Another way to go about doing this, I'm going to hit the delete button, I'm going to hit the equal sign. I'm going to put sum, parentheses, and then I'm just going to drag my cursor up to see exactly what I want to sum. I will hit the end parentheses and hit equals. But let's say instead of summing all of those numbers, we actually just want to sum the last two or the first and the third. I'm going to go ahead and delete this sum. I will go ahead and hit the equal sign. I will scroll up to the 1,500. I will hit the plus sign and then I will just go to the $86. If you're ever curious as to what function is in a particular cell, if you don't want to look up here in the bar, what you can do is hit the F2 function and it will show you what it is summing. It will highlight the cells. Notice it's summing D7 and D9. Let's go ahead and go back to using the AutoSum function and we'll have 1,661, so there's the sum function. Something else I want to show you is with regards to formatting. Let's say these are all dollars. We are going to go ahead and highlight, you take your mouse and you drag all the way from cell D7 to D10, these are all the columns up above and then the rows are going down the side. If you take a look up here in the number formatting section along the ribbon, we have a dollar sign. We can just go ahead and hit the dollar sign and it formats them in what we call accounting. Notice that the dollar is on the left-hand side and it automatically goes out to two decimal points. But let's say we don't want to have two decimal points, so you see here we have increase decimal and here, we have decrease decimal. If I want to get rid of those two decimal points, I will hit this button, we're down to one, and then I will hit it again, and we have zero decimal points. Now, let's move on to how we would go about having an underline under $86 to show the user of your spreadsheet that it is summing the first three. There are two ways to go about doing that. Take a look here, in the font area of this ribbon, in the home area, it defaults to bottom border. We can go ahead and hit that bottom border, and now, we have a border that shows that 1,661 is summing all of the above three numbers. Let's say we wanted to do the top and double bottom border, which is very common in accounting. We'd be able to do that. Notice we have a top single and then we have a bottom double underline.
