Excel copies the function and border to the other cells so that you can see all the month’s total expenses. Press Enter, so the result will be as shown below.ĭrag it across to cell M3. Now, select cell B3 and enter “ =E19” as a cell reference. Excel copies the function and border to the other cells. select cell E19, click the cell’s lower right corner, and drag it across to cell P19. Now, simultaneously apply for other months, i.e.
Press Enter so that it will result or gives you a total expense for that month. Simultaneously add total income and expense in cell A2 & A3 and net income OR savings in column A4. Now, enter all the income & expense data in the respective cells.Īddition of Expenses by using Sum FunctionĮnter the SUM function into cell E19, select cell E19, type an equal sign (=), enter SUM (select the expense range for the month of Jan, i.e. Excel automatically adds the other months. Then, select cell B1, click the cell’s lower right corner and drag it across to cell M1. We can all add these categories in excel you can enter the different types of income and expenses category in column B. A health club (Annual or monthly memberships & spendings).Study Loan (Taken during graduation or postgraduation studies).Gifts are given on any wedding or other occasions.Investments & super contributions (Stock market or mutual funds).Paying off debt if you have taken from someone.You should know or be aware of your monthly expenses or spending, which is categorized into various sections. Family benefit payments you have received prior (monthly or annual).Income from savings and investments made (monthly or annual).Bonuses/overtime worked & payout from the company (monthly).Your partner’s or spouse take-home pay (monthly).You Should Know or Be Aware of Your Monthly Income or Earnings
How to use microsoft excel for budgeting how to#
Let’s check out some of the examples on how to create a family budget planner in excel. How to Create a Family Budget Planner in Excel?
Goal Settings: We can set a short or long-term goal with budget planning in Excel. Variable Expenses: Groceries, Home & utilities, personal, medical expense & entertainment fluctuate month on month & variation will be there based on your spending’s.