I need to learn advanced Excel (especially VBA) which books should I look for?

Discussion in 'General Chat' started by The Swede, Jun 15, 2010.

  1. The Swede

    The Swede Senior member

    Messages:
    173
    Likes Received:
    1
    Joined:
    Sep 30, 2006
    Location:
    Stockholm
    I am starting a new job within Finance in a few weeks where they have hinted that I need some VBA skills. I will be creating some models for them which need to be robust, secure and so on. My knowledge of Excel is intermediate but I have never used VBA.

    Can anyone recommend some good books I can pick up? I was looking in a bookstore today but there are tons of books which all look the same (huge and expensive). Online resources would also be great, or tips in general.
     


  2. Valor

    Valor Senior member

    Messages:
    836
    Likes Received:
    0
    Joined:
    Mar 24, 2010
    Location:
    NYC
    Do you know how to code in a real language?
     


  3. dusty

    dusty Senior member

    Messages:
    4,859
    Likes Received:
    20
    Joined:
    Feb 8, 2005
    Location:
    ohio
    I don't know if this will help you, but when I needed to learn some VBA I started by recording macros and then examining/editing the code they created.
     


  4. The Swede

    The Swede Senior member

    Messages:
    173
    Likes Received:
    1
    Joined:
    Sep 30, 2006
    Location:
    Stockholm
    Do you know how to code in a real language?
    No, my coding skills are pretty weak. I have done some work in Stata but would not consider myself proficient in any way.
     


  5. TieMyShoe

    TieMyShoe Senior member

    Messages:
    145
    Likes Received:
    0
    Joined:
    May 25, 2010
    google searching is a great way to start...
     


  6. dragon8

    dragon8 Senior member

    Messages:
    4,617
    Likes Received:
    52
    Joined:
    Feb 19, 2007
    Location:
    San Francisco
    Try Video Professor
     


  7. Blackhood

    Blackhood Senior member

    Messages:
    2,904
    Likes Received:
    364
    Joined:
    Feb 5, 2010
    Location:
    Cambridge, UK
    VBA for dummies is useless, but I found VBA In Easy Steps got me through my A Levels with good enough grades.
     


Share This Page

Styleforum is proudly sponsored by