Microsoft Excel can be used to calculate home budgets, to create formulas, to make tables and to form charts. Use Microsoft Excel to organize lists and numbers with IT help from a software developer in this free video on using computers.
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.
- Things You Can Do With Microsoft Excel
- How to Use Excel to Calculate APR
- How to Make Windows Media Player Your Default Player
- How to Partition a Laptop Hard Drive
- How to Use External Hard Drives
- How to Wipe a Hard Drive
- How to Make Frequency Tables
- How to Reboot a Laptop
- How to Use PowerPoint
- How to Reboot a Computer Hard Drive
- How to Make a Table in Excel