How to Easily Budget with Microsoft Excel.

I am one of those people that has to be very organised.

My lifestyle is simply, BUDGET, BUDGET, BUDGET.

A couple years ago when I was in year 10, I had a computer class at school. Luckily I really paid attention and remembered the formula's and how to use excel to Budget.

Once you pick it up it is quite easy.

So make sure you obviously have Microsoft Excel first.

So I have quite simply just made a rough idea of how to do this.

Simply make a section of two columns for your pay. One with the date of your pay (so you don't get lost in your budget) and how much you get paid. Then go along and type in everything that need to be paid. From electricity, to payment plans, to school uniform. It really doesn't matter.

Then leave a column at the end to type your formula in at the end for the total amount you are left over with at the end, which is necessary in case you go into negative money so you know how much you will need to adjust the budget by.

Formula:

=B17-C17-D17-E17-F17-G17-H17

then hit enter.

You wont need to type in the formula. Just click on the box with your mouse that you need to subtract from your pay.

B17 is your pay, and C17 D17 E17 F17 G17 and H17 are the bills you need to pay.

Once you hit enter, the amount of money you have left over (or don't) will come up automatically like in the photo below. You can click on this to make it larger.

One thing I cannot stress enough is to make sure you have the = sign at the beginning of your formula otherwise it will not work.

That is basically how to budget with Excel. If you need to know more, simply just comment.

Cheers.