Here is a guide on how to make a budget in Excel
. Making a budget is a useful aid to get a solid overview of your personal finances, or the finances of a company.
A budget consists mainly of the quite simple arithmetic operations addition and subtraction. This is something a spreadsheet can do for you with ease.
Excel
Instruction
Example 1
Erica Clementine is making an overview of all the income and expenses she expects in a certain month. She needs your help to use Excel
to create a budget.
Income  Amount  Expenses  Amount 
Bookstore (part time)  $$240$  Bus card  $$68$ 
Dog sitting  $$80$  Phone subscription  $$39.90$ 
Monthly allowance  $$50$  Food and snacks  $$100$ 

 Clothes and shoes  $$50$ 

 Entertainment  $$35$ 

 Other  $$50$ 
Excel
:
Here are the formulas used for each cell.
Note! Notice that Erica Clementine’s budget had a surplus because the number in cell B11
is positive. You should always set up budgets with a surplus.