+ Reply to Thread
Results 1 to 7 of 7

Suggestions on Training Course or Books

  1. #1
    Registered User
    Join Date
    10-27-2006
    Posts
    12

    Suggestions on Training Course or Books

    Hello,

    While I have been using Excel for various reasons for the past 10+ years, I have a lot to learn, particularly in using Visual Basic and writing Macros.

    I have found that my knowledge surpasses most Computer-Based Training I have seen, but maybe I have only seen low quality CBT courses.

    With my goal of being able to tackle all that Excel has available, what books or training courses (I am in Chicago) would you suggest? I want to be able to save time for myself by creating macros, as well as develop files with drop-down menus and other perks for client-ready offerings.

    I am a statistician who does much of his work in SAS, so I think I have the ability to absorb this information from a book, but please advise if you think otherwise.

    Thanks in advance!

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    This link might be a good start

    http://www.excelforum.com/showthread.php?t=584092

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening tayto

    My bible is John Walkenbach's "Excel 2003 Power Programming with VBA". It takes you from relative beginner right up to pretty advanced very quickly. It deals with all the aspects you've mentioned above, and comes with a CD with lots of examples, .pdf of the book and a copy of the PUPv5 add-in - upgrade to PUPv6 for $5.

    http://www.j-walk.com/ss/books/xlbook25.htm

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  4. #4
    Registered User
    Join Date
    10-27-2006
    Posts
    12

    Thank you Both

    Thank you very much for your recommendations. Would you say that any formal training is a waste of time if I can just go through these materials on my own?

  5. #5
    Forum Contributor
    Join Date
    11-29-2003
    Posts
    1,203
    Would you say that any formal training is a waste of time if I can just go through these materials on my own?
    It depends on 2 things: the trainer and the trainee. It is well worth a small fee to spend some quality time with a true expert. But, if you have the initiative to read Walkenback's book cover-to-cover and to try out all of the examples on your own, then you won't find a better way to get started.

    My own experience is that having an immediate need is always helpful when learning a new language. Then, practicing that language over and over again is necessary in order to become fluent in the language.

    Can't recall whose website I read this on, but the idea really stuck with me ... VBA itself is not difficult. The difficulty comes from the vast array of Objects, Properties, Methods, and Events which are embedded in Excel.

  6. #6
    Registered User
    Join Date
    01-04-2007
    Posts
    9
    Quote Originally Posted by VBA Noob
    Hi,

    This link might be a good start

    http://www.excelforum.com/showthread.php?t=584092

    VBA Noob
    What an amazing link.... thanks for posting this in response to tayto's question. This has helped me as well.

    ***Dominicb - agreed John Walkenbach's books are great. I have "Excel 2003 Formulas"...one of my first books and I still use it....

    thanks

  7. #7
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Glad you found it useful.

    Need to keep this link alive so please add it to your autosignature

    VBA Noob
    Last edited by VBA Noob; 10-31-2007 at 06:45 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1