• Book on Excel (Excel 2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Book on Excel (Excel 2003)

    Author
    Topic
    WSpatt
    AskWoody Lounger
    March 26, 2007 at 11:59 pm #441019

    What is a good book i can read to get a better appreciation of excel? i don’t want a total beginners book although I will be guided by you. i am a beginner at Excel and very experienced at Access and VBA.

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      March 27, 2007 at 7:02 am #1057857

      I like Excel Books by John Walkenbach – he has written several for each version.

      Reply | Quote
      • WSpatt
        AskWoody Lounger
        March 28, 2007 at 1:20 am #1058065

        Thanks Hans, i will check them out.

        Reply | Quote
        • WScapri
          AskWoody Lounger
          March 28, 2007 at 4:53 am #1058081

          I found Pivot Table Data Crunching by Bill Jelen and Michael Alexander to be very useful.
          It really helped me improve my pivot tables by showing a lot of features that I was unaware of.

          Yesterday I found a link to a book called “Excel Best Practices for Business” by Loren Abdulezer. I usually like to have a quick flip through a book in the store before buying. Look up an area I’ve had a recent problem with and see how helpful the information is. If the book explains things in a manner that I can understand then I am more inclined to buy it. I will be looking for the above book, next time I am in a book store to see how useful it may be.

          Reading the table of contents, to see what the book covers, then relating it to things you want to learn is also helpful. Not much point getting a book that mainly covers topics you are already proficient in.

          Reply | Quote
          • WSpatt
            AskWoody Lounger
            March 28, 2007 at 6:17 am #1058088

            Thanks for the info, but as i’m a beginner in Excel i guess any book will do to start with, as long as it describes VBA, formulas, lookups etc.

            Reply | Quote
      • WSpatt
        AskWoody Lounger
        March 28, 2007 at 6:51 am #1058099

        Hi Hans,
        i am a complete beginner to Excel, what would you recommend for a start?

        Others recommendations are just as welcome.

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          March 28, 2007 at 7:21 am #1058101

          I’ve been using Excel since version 1.00 in 1985 (for Apple Macintosh). It came with an extensive two-volume paper manual grin
          But this means that I hardly know what currently the best beginner book is. I’m sure others can help.

          Reply | Quote
          • WSpatt
            AskWoody Lounger
            March 28, 2007 at 7:52 am #1058104

            Thanks anyway.

            Reply | Quote
            • WSHansV
              AskWoody Lounger
              March 28, 2007 at 8:05 am #1058106

              BTW, in general the “Step by Step” books from Microsoft Press provide an adequate introduction to the various Office programs; for Excel 2003 it would be “Microsoft Office Excel 2003 Step by Step”.
              They don’t go very deep, though, and they hardly cover VBA, if at all.

              Reply | Quote
            • WSHenrik Ryberg
              AskWoody Lounger
              March 28, 2007 at 8:20 am #1058108

              Hi Patt,

              I’ve found John Walkenbachs ‘Excel bible’ (IDG press) very useful both for starters as well as the more advanced topics.

              Bests

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 28, 2007 at 9:44 am #1058121

              Thanks i think i will start with this, see response to Hans.

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 28, 2007 at 9:43 am #1058120

              I think i will go for one of the more advanced books, maybe the Excel 2003 Bible. If i struggle too much with that i will go with a beginners after that.

              Reply | Quote
            • WSpieterse
              AskWoody Lounger
              March 28, 2007 at 12:52 pm #1058175

              Since you’re good at Access VBA, all you probably need to get up to speed with Excel VBA is getting to grips with the object model.

              This requires two things:

              1. Get to know Excel (for which the excel bible of JW is perfect)
              2. Get a VBA book. A good one is:

              http://www.oaltd.co.uk/ExcelProgRef/Default.htm%5B/url%5D

              If you’re thinking of doing more serious Excel dev work, then this is the ultimate book:

              http://www.oaltd.co.uk/ProExcelDev/Default.htm%5B/url%5D

              Reply | Quote
            • WSrory
              AskWoody Lounger
              March 28, 2007 at 1:04 pm #1058179

              I would wholeheartedly recommend both of those – mine are quite dog-eared from constant use now! grin

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 28, 2007 at 9:44 pm #1058301

              Do you mean the 2 he mentions aside from the bible.

              Thanks for your input Rory.

              Reply | Quote
            • WSrory
              AskWoody Lounger
              March 28, 2007 at 10:53 pm #1058312

              Yes – the last one is a serious piece of work; the VBA programmer’s reference is so good I ended up buying the 2003 version after my 2000 version fell to bits. Probably the most frequently used of the 10 or so Excel books I have.

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 28, 2007 at 11:01 pm #1058313

              Thanks Rory

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 28, 2007 at 9:46 pm #1058300

              Thanks Jan
              i will go with the first two you mention initially (the bible and the vba book).

              When i become that good i will purchase the third one you mention, of course that may never happen.

              Is it worth going for the 2002 version or maybe the 2003 version for all these books?

              Reply | Quote
            • WSpieterse
              AskWoody Lounger
              March 29, 2007 at 7:46 am #1058363

              I’d pickup the version that is closest to your Office version. 2003 should do just as well as 2002 though.
              Just don’t do the 2007 versions unless you have a need to work with Excel 2007.

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 29, 2007 at 8:24 am #1058365

              Thanks for that, i have just ordered the 2003 versions.

              Reply | Quote
            • WSHenrik Ryberg
              AskWoody Lounger
              March 30, 2007 at 8:26 pm #1058642

              Hi Patt

              An additional superb book that offers a good VBA angle and that you may find very useful later, is one I was recommended in here as well.

              VBA Developers Handbook (2nd ed.) by Getz & Gilbert ISBN 0-7821-2978-1 (SYBEX)

              Good hunting… / ;o)

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              March 30, 2007 at 9:42 pm #1058659

              Thanks, I’ll keep that one in mind for later.

              Reply | Quote
            • WSHansV
              AskWoody Lounger
              April 2, 2007 at 7:03 am #1058873

              fanfare

              Somewhere in this thread you’ve become a PlatinumLounger (3,500 posts). Congratulations!

              fanfare

              Reply | Quote
            • WSpatt
              AskWoody Lounger
              April 2, 2007 at 7:07 am #1058874

              I reckon at this rate i may catch you in about 200 years, with the help of 100 others. doh

              Reply | Quote
    • WSledunch
      AskWoody Lounger
      March 28, 2007 at 12:34 pm #1058168

      I found that “Using Microsoft Excel 2000” by Blattner & Ulrich (published by QUE in 1999) a good mix of introductory and advanced topics and clear explanations. It has a 30 page chapter on VBA.

      Paul

      Reply | Quote
      • WSpatt
        AskWoody Lounger
        March 28, 2007 at 9:34 pm #1058296

        I will go to my local store and check this out, thank you.

        Reply | Quote
        • WSledunch
          AskWoody Lounger
          April 2, 2007 at 12:23 pm #1058400

          You know I have to say it is somewhat comforting to hear that our Lounge experts still use, and perhaps occasionally need, a good book on Excel and/or VBA. It makes me feel slightly less inept.

          Paul

          Reply | Quote
    Viewing 1 reply thread
    Reply To: Book on Excel (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    June 2025
    S M T W T F S
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.