Tip:
Highlight text to annotate it
X
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.