DISCOVER
×

Video transcription

Hi, my name is Dave Andrews. Today I'm going to show you some things you can do with Microsoft Excel. Let's open up Microsoft Excel by clicking on the start button. Let's go to all programs, and Microsoft Office and Excel. I have a spreadsheet that I'm going to open up that has some data in it. So I can kind of show you some things you can do with it. Those are the wrong files, let's try that again. Book one. There we go. Now here is basically a home budget in Excel. It's one example of what you can do with it, but I'm going to show you the very first that I think is interesting which is creating formulas. Let's say we want to automatically calculate the difference between these budget items, what we have budgeted and what we actually spent. We can do that in Excel with what's called a formula. To begin a formula, click where you want your answer to appear, type the equals key, and we're going to click on the budgeted amount in that row, do a minus, and then we're going to click on what we actually spent. Now this formula will subject C2 from B2. Just press enter. Now C2 or B2 minus C2 is zero so that's why we got a zero. Let's copy that, paste it to these other rows. As you can see, Excel is automatically creating the answers for us and telling us whether we went over or under our budget. Another thing you can do with Excel that's very interesting is you can create charts. Let's create a chart of this budgeted items, the amount we budgeted and what we actually spent. Just highlight your data in Excel, and go to the insert tab at the top, click on charts, let's just do a regular column chart. It has a lot of different templates you can select for what kind of chart you'd like to see, I'm just going to do the simplest one here, 2D column clustered. You click that and our chart has now appeared down here in the cell area. I can scroll down, see that here are my items that I had budgeted, and blue is the amount that was budgeted and then red is what was actually spent. So you can see quickly whether or not you went above or below your budget. My name is Dave Andrews and I just showed you some things you can do with Microsoft Excel.