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!

Anyone else addicted to Excel spreadsheets?

135

Comments

  • ZTD
    ZTD Posts: 24,327 Forumite
    You should be careful and take backups. If you have more items of data than you can count on your fingers, then both Excel and Access can break without warning.

    Here speaks the voice of DOOM...
    "Follow the money!" - Deepthroat (AKA William Mark Felt Sr - Associate Director of the FBI)
    "We were born and raised in a summer haze." Adele 'Someone like you.'
    "Blowing your mind, 'cause you know what you'll find, when you're looking for things in the sky."     OMD 'Julia's Song'
  • immoral_angeluk
    immoral_angeluk Posts: 24,506 Forumite
    10,000 Posts Combo Breaker
    Pivots? Structural Analysis? button? you guys have lost me now.
    Total 'Failed Business' Debt £29,043
    Que sera, sera. <3
  • immoral_angeluk
    immoral_angeluk Posts: 24,506 Forumite
    10,000 Posts Combo Breaker
    lennymfo wrote: »
    Nope, just you, you saddo!

    Shut it you.... ;)
    Total 'Failed Business' Debt £29,043
    Que sera, sera. <3
  • Ytaya
    Ytaya Posts: 326 Forumite
    immoral_angeluk wrote: »
    How do you work out the interest then? Was trying to do a snowball calculator but it was never working it out right!

    The quick answer is it doesn't always work out - I inevitably have to update it by a few pennies either way when I get my statement. But it's close enough!

    I calculate the monthly interest like this:

    (APR/12) x balance

    If you want to be more specific, you could divide the APR by 365 and then multiply by the number of days in that month, but that never seemed to work out much more accurately anyways.
  • System
    System Posts: 178,377 Community Admin
    10,000 Posts Photogenic Name Dropper
    immoral_angeluk wrote: »
    Shut it you.... ;)

    :silenced:
    This is a system account and does not represent a real person. To contact the Forum Team email forumteam@moneysavingexpert.com
  • ZTD
    ZTD Posts: 24,327 Forumite
    Ytaya wrote: »
    I calculate the monthly interest like this:

    (APR/12) x balance

    Doesn't work for compound interest - what you need to do is express the percentage as number - i.e. 5% is 1.05 then raise it to the power of one twelfth.

    Or in short ((<percentage>+1)^(1/12))-1
    "Follow the money!" - Deepthroat (AKA William Mark Felt Sr - Associate Director of the FBI)
    "We were born and raised in a summer haze." Adele 'Someone like you.'
    "Blowing your mind, 'cause you know what you'll find, when you're looking for things in the sky."     OMD 'Julia's Song'
  • GingerSte
    GingerSte Posts: 2,486 Forumite
    immoral_angeluk wrote: »
    Pivots? Structural Analysis? button? you guys have lost me now.

    I lose myself half the time. I find it's more fun that way.
  • jessicamb
    jessicamb Posts: 10,446 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker
    GingerSte wrote: »
    I lose myself half the time. I find it's more fun that way.

    me too - and probably best not get me started on the virtues of pivot tables in data analysis

    mrexcel.com is a fab site for the true [STRIKE]geek[/STRIKE] enthusiast :D
    The early bird gets the worm but the second mouse gets the cheese :cool:
  • 4maxine
    4maxine Posts: 440 Forumite
    immoral_angeluk wrote: »
    How do you link them? i've been trying to do a debt one but can't get my head around it.. any tips?

    Open the sheets you want to link.
    Click on the cell you want the data to appear in and type =
    Go the other sheet and click on the cell with the original data and hit "ENTER"

    and voila.....

    don't forget to save it afterwards
    2009: Headphones, Nintendo DSi , Baking Kit
    2010: Jan:T-shirt, 2xBooks, Headphones, Elvis CD, Buffera, Scarf Feb:CD, 2xBooks, Mascara, 3xT-shirts Mar: Lip balm, 2xBooks, 2xCD, mask, Koala, 6xCinema tickets, Chocolate box, Drive Backup Pro Apr: Elemis cream, Elemis Skin Buff
  • Ytaya
    Ytaya Posts: 326 Forumite
    ZTD wrote: »
    Doesn't work for compound interest - what you need to do is express the percentage as number - i.e. 5% is 1.05 then raise it to the power of one twelfth.

    Or in short ((<percentage>+1)^(1/12))-1

    See? I said it didn't work properly ;) Thanks, I'll go fix it!
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.3K Banking & Borrowing
  • 253.6K Reduce Debt & Boost Income
  • 454.3K Spending & Discounts
  • 245.3K Work, Benefits & Business
  • 601.1K Mortgages, Homes & Bills
  • 177.5K Life & Family
  • 259.2K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture