Excel+-+Budget+Project+Completion

Now, the way this project is currently set up, with positive and negative numbers, you will not be able to make a proper graph. Copy your information and paste it on to sheet two of your Excel sheet. If you have forgotten where sheet two is, look at the very bottom of your Excel page, and you will probably find tabs for sheet one, two and three.

After you have pasted the information into sheet two, stay in sheet two. Change your table around by taking out the positive numbers (like your salary) and making all the debits (negative numbers) into positives. This way you should only have the amounts that you have to pay left. From there, you can do one of two things. The first is to create graphs using just this information. There will be a lot of information to put into one graph! The second option is to combine some of the lines. Maybe instead of a line for car payments, car insurance and gas money for your car, you create a new table that has a section labeled “Car” where you have added all the items that involve your car into one place. You could do the same for your rent payment and utility bills by combining them into a new section named “Home.”

When you feel like you have a table that will look good in a graph, create a bar and a pie graph for your data. Format the graphs the way you think they should look, then save the file. The last step is to copy your graphs over to your document that you typed all of your information for your budget in. Make sure it looks nice and clean before you hand it in to the dropbox as finished.

After you have handed in your final project in your dropbox, please take this survey and give me some feedback on this unit. Soon we will begin a section on Powerpoint!