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
Help with Excel spreadsheet planner so I don't go overdrawn
MicheH
Posts: 2,631 Forumite
Any, any help would be great, i've got microsoft excel up and now I have no clue what to do with it to make a planner.
Here's hoping someone can help me!
Here's hoping someone can help me!
0
Comments
-
To make things worse I appear to have 2007 version which i havn't a clue how to navigate0
-
Hi,
All I did was to have 15 columns. 1st name of debt - rent, gas, elec, water etc. Inc everything, dental, food, ins, car tax. 2nd col amount, 3 col date of direct debti or due date. The next 12 are Jan to Dec.
In excel there is a add sum button. Add up the coloumns for a total, then next row is salary last row is dif. I then change the colour as they are paid.BSC 289A life lived in fear is a life not living!Proud to have dealt with my debts.0 -
Name Payment Date Mthly Amount March
Rent 26th Mth 750 750
C Tax 1st Mth 80 80
G&E 28th Mth 91 91
Water 1st Mth 28 28
TVLC 1st Mth 11 12
Total 961
Salary 2700
Difference -1739
You can use the add sum button for calculations. Just change the symbol for the minus.BSC 289A life lived in fear is a life not living!Proud to have dealt with my debts.0 -
We all die. The goal isn't to live forever, the goal is to create something that will0
-
I use microsoft moneySealed Pot Number 018 🎄2009..£950.50 🎄2010..£256 🎄 2011..£526 🎄2012..£548.80 🎄2013...£758.88🎄2014...£510 🎄2015...£604.78 🎄2016...£704.50 🎄2017...£475 🎄2018...£1979.12 🎄2019...£408.88🎄2020...£1200.63...🎄2021…£588 🎄2022 £672… 🎄2023 £3,783.90 🎄2024…£3,882.57🎄2025…£4083.🎄20260
-
I've given up, I can't do it. All the one's I download from microsoft are either more complicated than I want, in Dollars or are for the whole year. Tried microsoft money but microsoft have said they've withdrawn the application.
So a sheet of paper on the fridge it i!0 -
sheet of paper works just as well!
(i've worked in IT for a while but I always prefer the simple approach to things!)We all die. The goal isn't to live forever, the goal is to create something that will0 -
Although......my OH is a demon on excel & would be happy to sort something for you if needed she's just shouted from the kitchen?We all die. The goal isn't to live forever, the goal is to create something that will0
-
Oh Miss Spooky - you're good! I've just started a spreadsheet after using pen and paper for years. I think I prefer the old fashioned method.
:j :j
0 -
philnicandamy wrote: »Although......my OH is a demon on excel & would be happy to sort something for you if needed?
How very kind of her
deffo take her up on that MicheH
:beer: to philnicandamy's OH :T what an :ALook down your nose at me and I thumb my nose back at you.
Bankrupt: 8th July 2009
Early Discharge: 19th Jan 2010
Proud BSC Member: 2780
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 354.4K Banking & Borrowing
- 254.4K Reduce Debt & Boost Income
- 455.4K Spending & Discounts
- 247.3K Work, Benefits & Business
- 604K Mortgages, Homes & Bills
- 178.4K Life & Family
- 261.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards