+ Reply to Thread
Results 1 to 3 of 3

Reading Recommendation for Excel and VBA

  1. #1
    Registered User
    Join Date
    01-21-2016
    Location
    MA
    MS-Off Ver
    2016
    Posts
    20

    Reading Recommendation for Excel and VBA

    I know there are uncountable sources of information on the internet for excel. I've used them, including this forum. (Thank you, by the way, for taking time to help). Problem is, the easy access to all information at once doesn't make for a good learning structure, for me anyway. It's like leaving an 8-year-old at the buffet table, which includes dessert. I've gone right for the ice cream and skipped the broccoli.

    I'm looking for recommendations for a good book. Given my schedule, I spend a lot of time without access to a computer and enjoy reading. Also, I just like the "feel" of a book in my hand. To give an idea of my level:

    I think I'd classify myself as beginner/ intermediate. I'm self-taught over the past 10 years and learned most of what I know from forums, youtube, and online resources. I've worked with VBA, macros, and formulas. I have a pretty good book for Access VBA that I've read.

    I've developed a strange skill set. I can do way more than I should be able to do. I'm advanced but with huge holes in my game given the way I learned, jumping around without getting a solid base of fundamentals. I've reverse engineered a lot of the code I've written. I've worked with nested loops, arrays and formulas. I've also done this in Access. But the way I've done it sometimes has been pretty sketchy. I've written some pretty complex VBA code but I know it's not efficient. I would find the code on the internet, copy, paste and tweak it. It would work but I didn't necessarily have a full understanding why.

    So I guess my weaknesses would be fundamentals, including some of the front end stuff like charts and graphs. I recently started with an online course and am learning a lot of the fundamentals but as I said above, I'd really like something in a book format. I've checked Amazon for Excel books that include VBA but the ones with good reviews often return a poor score from Fakespot. For those who don't know what that is, it's a site for determining the validity of reviews on Amazon and a couple of other sites. Meaning the reviews were bogus.

    I searched the forum and found a recommendation from 2008 but nothing in the past year. I'm using the latest(i think) version of Excel from Office 365 Version 1808

    Thanks
    Lefty

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,274

    Re: Reading Recommendation for Excel and VBA

    For pure VBA (without reference to a specific object model like Excel or Word) there is no better book than the VBA Developers Handbook by Getz and Gilbert.

    For Excel specific things, anything by John Walkenbach or Bill Jelen/Tracy Syrstad is worth reading, regardless of version it's aimed at. The Wrox press Excel VBA books were good for 2003 and prior but the next one was not great. Professional Excel Development is also well worth having.

    If you are interested in the BI stuff, look for Ken Puls' book, Rob Collie's stuff, Bill J's (again) or anything by Russo and Ferrari (more intense level)

    All purely my opinions.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    01-21-2016
    Location
    MA
    MS-Off Ver
    2016
    Posts
    20

    Re: Reading Recommendation for Excel and VBA

    Perfect. Thank you. I'll take a look at those.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Training Courses - Recommendation
    By CallumWebley in forum Excel General
    Replies: 2
    Last Post: 05-25-2016, 02:04 PM
  2. Need a recommendation please :)
    By DanielleCHI in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-04-2011, 01:29 PM
  3. Replies: 13
    Last Post: 10-06-2009, 07:50 PM
  4. Excel/vba book recommendation?
    By ArvelAric in forum Excel General
    Replies: 1
    Last Post: 08-10-2009, 04:45 AM
  5. Laptop recommendation to run Excel
    By erickguz in forum Excel General
    Replies: 6
    Last Post: 10-05-2007, 01:53 PM
  6. any recommendation for a good excel VBA reference book?
    By littlesweet in forum Excel General
    Replies: 1
    Last Post: 01-16-2007, 04:38 PM
  7. [SOLVED] Help / Recommendation
    By Pat J Maine in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2005, 04:06 PM

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