Formulas Used in Microsoft Excel

Video Transcript

"Hi, I’m Gary for Expert Village. Now that we know what the, the program looks like when we open up I just want to show you some basic functionality of what the program does. Now we also know that these cells as we mentioned are called by the intersection between the columns and the rows and it’s also important to know how we can maneuver through the cells. We can either use our arrow keys to go up, down and over and we can also use tab keys on the same row to bring up to the next column. So I’m going to go back to the first spreadsheet where I just put in the little formula here to give an idea of what Excel does. Let’s say we were to have a, some type of a running tally sheet of a number of students so I would put here, I can put text into one of the cells and be, next to it, this column would be the number of students. So let’s say I also wanted to put it numbers, names of days, let’s say this would be Monday and I would click the arrow down and put in Tuesday and so forth. And what I would do now, is you would see here, there is zero in this cell, this cell is B9, if I click on it, we see that in here is some funny text which we’ll see later on what this text means, it’s a formula. Basically it’s saying the sum of B1 and then the symbol next to it is the colon which is telling it to go through to cell B8, so it’s adding up the numbers in B1 through B8. This being B1 and this being B8, and as I enter numbers in here we can see that, that formula is telling the, this cell to keep a tally, keep a sum of the numbers that I enter, so let’s say that on Monday there were eight students and let’s say that on Tuesday there were nine students. So we see already it’s keeping a tally and we see down here that we are up to the number seventeen so that’s basically the uh, the real special aspect of the worksheet program because it’s keeping a tally and we don’t have to go and constantly change and erase data. We can always just keep a running, running tallies of different amounts and if we want to change expenses or any kind of calculation and I’ve used them a lot for projections in new companies and we are trying to figure out exactly how much funding for a, for different projects. We can actually put these formulas into the spreadsheet and then change the information, kind of like on the fly and we can see our numbers, the results right away because of the formulas that are integrated into the spreadsheets so it’s a really handy tool. We’re going to go through all of that in the following steps. "