How to make a budget on excel mac
Finally, type Jan in cell C2 and then continue with Feb , Mar and so on across the rest of that row until you get to N2 to create column headers for 12 months. Now to enter some figures for monthly outgoings and income, starting with the Jan column. Enter your income in cell C18 and now we can work out how much money is left at the end of the month. This is a much simpler formula that just subtracts the total outgoings from the income, so type the following into cell C20 :. Click cell C3 and drag the mouse down to cell C20 to select all of the figures. The selected range of cells will now be highlighted with a blinking dotted outline.
Now to select the range of cells to paste the Jan column to. Excel will apply a bit of intelligence here to paste the cells and update any formulas to keep them consistent. Select cell D20 and type:.
You can now copy cell D20 and paste it to cells E20 to N20 , using the same technique as Step 8. The final step is to format the spreadsheet to make it more understandable. Stay safe online with our broadband extras: Protect your computer from viruses and keep your files and photos safe. Not with us? Check out our broadband deals. New BT Plus.
Our best connection in and out of the home. Have you mastered it yet? Follow the right guidance and take the help of these apps. Read More back then and finding all of these templates filled with data that just made my head ache. The best way to organize a budget spreadsheet is by shading each summary section between your major groups. As you can see here, the first section of the budget pertains to bills, including household utilities and fixed bills, as well as another section devoted to only credit cards. As you can see, once you start shading rows, the entire spreadsheet becomes much more organized and easier to follow.
Set up your debt log in the same way — split and freeze the panes, but this time list each month along the left, and your credit card balances How to Save Thousands With a Credit Card Balance Transfer How to Save Thousands With a Credit Card Balance Transfer A credit card balance transfer can save you thousands of dollars if you go about it in the right way. Check out our advice and recommendations on balance transfer cards!
Read More and monthly payments to the right. That is your estimated monthly interest. Then you subtract your monthly payment from the balance and add the interest that you just calculated.
Excel Templates Budget
These apps and sites will help you set a budget, reduce spendings, and save money. Read More , take a look at these helpful apps and sites:. By playing around with this kind of spreadsheet, I uncovered the very simple, common-sense solution that a lot of scammers out there are charging people for. Here is how it works. This is also why I love Excel. By using the ability to autofill the monthly balance calculations, I tested different scenarios to pay off debts faster. Excel allows you to see that concept in a very cool graphical form by using the formula autofill feature. Make the decision to try a few out and at least make a commitment to regularly sit down and work on it a little at a time.
These five simple methods will help anyone set a budget that they can live comfortably with. Here are the best sites for news, investing, and more. Read More :.
Your email address will not be published. I know about just enough excel to do this. Have already used it for some things, but this information will help. Thank you. This was such a great tutorial and really helped me get organized. How can I carry over my balance from the credit card sheet to the balance on the budget sheet? I want it to change and reflect the current balance as I make payments every month.
Hi all So I just came across all of this on pinterest. I am not too keen on Excel and without going into a long drawn out explanation, is there a template out there? I've clicked on pretty much all the links but they're all gone, except for one that has a fee. I'm not saying I won't pay a fee but if one of you has a file that I could use for free that would be great. This looks so amazing, I have been wanting to take control over my life for a while and this is what I have been looking for.
Question if you don't mind, I have some outstanding bills as well, will this calculate if I am making payments to break down certain bills as well until they are payed off? If you have a template for your spreed sheet that I could change to suit my personal needs I would be forever grateful. So glad I found this! I've made April the month to get my life together and this is exactly what I needed.
I always get frustrated with finances, but I'll try my best to better understand the credit card debt. Have you ever thought about creating a video for this? You have composed an excellent tutorial! Kudos my friend. Your methodology is reaching hundreds or more people that truly need tbis advice I am getting ready to set up our budget and plan to financial freedom to be ready on the 1st.
Thank you for this amazing tutorial! My email is outrun17 hotmail. This was so helpful I loved following your instructions for the credit card debt and seeing the difference of what even an extra few dollars a month can make toward eliminated those balances. I bought a book from a well known "manage your finances" guy quite awhile back who uses the snowball payment theory and just couldn't get into the blah blah blah of it. You nut shelled it here and I thank you for that. You are right Excel really makes the goal clear and it was fun to play with the payment amounts and watch the timeline shorten for payoff!
So fulfilling. Praise Ryan and Jesus! I have created a website EasyBudgeting that makes using an Excel budget planner simple and straightforward. Excel is a great tool for budgeting but some people find it difficult or a bit overwhelming. If you kept your income, expenses, savings, etc.
Simply rename that sheet for a different month. At the end of the year, you can then create a new formula to add up your yearly savings, spending, and earnings. Excel can automatically do the math for you. I covered addition and subtraction, but here are the formulas for multiplication and division too:. Rather than type the formula in each cell, you can speed up the process by dragging the same formula across an entire row. To do this, enter the formula into one cell, click the cell after the total appears, and drag the green box across the area you want that formula to be applied.
Google offers a free version spreadsheet program called Sheets.
The two programs look and work similarly. Plus, Google Sheets works almost seamlessly with Excel, meaning you can easily import an Excel budget template that you created into Sheets.
Excel is highly customizable, and you can create a sheet to fit any area of your finances. Once you get it set up, the automatic formulas in an Excel budget template can even trump a pen and paper for budget — at least in terms of convenience. Just enter the info correctly, and everything will populate automatically for you. Plus, you can easily view several months or years of budgeting data with just a few clicks. Still not sure how to get started budgeting? Check it out using the link above. I hope this guide to creating a budget in Excel has been helpful.
Thanks so much for reading, and good luck! Grab our free budget spreadsheet here. Have you created your own budgeting spreadsheet in Excel? Let us know how it went in the comments below! Greg Johnson is a personal finance and frugal travel expert who leveraged his online business to quit his job, spend more time with his family, and travel the world.
Hi Greg, Kindly assist me with my B spread sheet my email njamda harmony. Thanks in advance if you have any ideas. Your email address will not be published.
Notify me of follow-up comments by email. Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed. This article may contain references to some of our advertising partners. Should you click on these links, we may be compensated. For more about our advertising policies, read our full disclosure statement here.
Enter Excel. So, what do you say?