We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Setting up a Spreadsheet in Excel...
Money_Saver
Posts: 364 Forumite
in Techie Stuff
for banking and stuff etc figures.
I'd like to set up a spread sheet so I can enter income on say 01st Each month, then enter my bills due on a particular date. A cell to show a balance once the amount has been deducted or a credit has been received on a particular date. I think this will help me enormously to budget so i can tell on any given day what my balance will be if xyz bills have been taken.
It too would be helpful if the cell could change colour once I enter my overdraft.
My knowledge of excel 2007 is somewhat limited.
I hope that makes sense.
Thanks for any info on how to achieve this best.
Asked in Bank Section also.
I'd like to set up a spread sheet so I can enter income on say 01st Each month, then enter my bills due on a particular date. A cell to show a balance once the amount has been deducted or a credit has been received on a particular date. I think this will help me enormously to budget so i can tell on any given day what my balance will be if xyz bills have been taken.
It too would be helpful if the cell could change colour once I enter my overdraft.
My knowledge of excel 2007 is somewhat limited.
I hope that makes sense.
Thanks for any info on how to achieve this best.
Asked in Bank Section also.
Regards,
Money Saver
Money Saver
0
Comments
-
It's easy enough to put one together yourself, but have you tried the spreadsheet version in the budget planning tools section of this site?
http://www.moneysavingexpert.com/banking/Budget-planning
If that doesn't do what you want, put "excel budget planning template" into your favourite search site - just beware the ones that appear to be free but don't work properly unless you pay for them!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards