Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Book on Excel (Excel 2003)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Book on Excel (Excel 2003)

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

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Book on Excel (Excel 2003)

    Thanks Hans, i will check them out.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Book on Excel (Excel 2003)

    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.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Book on Excel (Excel 2003)

    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.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Book on Excel (Excel 2003)

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

    Others recommendations are just as welcome.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Book on Excel (Excel 2003)

    I've been using Excel since version 1.00 in 1985 (for Apple Macintosh). It came with an extensive two-volume paper manual <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    But this means that I hardly know what currently the best beginner book is. I'm sure others can help.

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Book on Excel (Excel 2003)

    Thanks anyway.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Book on Excel (Excel 2003)

    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.

  10. #10
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book on Excel (Excel 2003)

    Hi Patt,

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

    Bests
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  11. #11
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Book on Excel (Excel 2003)

    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.

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Book on Excel (Excel 2003)

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

  13. #13
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book on Excel (Excel 2003)

    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

  14. #14
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Book on Excel (Excel 2003)

    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

    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
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  15. #15
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Book on Excel (Excel 2003)

    I would wholeheartedly recommend both of those - mine are quite dog-eared from constant use now! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

Page 1 of 2 12 LastLast

Posting Permissions

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