I had a lot of fun putting together my recent list of Top Excel Help Resources on the web. It started out as a Top 10 list… but then I started getting a lot of comments about other great sites all over the web, and the list ballooned. Its a great resource, you can find it out here – Excel Help Resources and Tutorials. Also check out my Excel Training Course & Tutorials section, which has garnered a lot of traction recently.
Anyways, as I was putting it together – I couldn’t help but notice that most of the top websites were owned by the biggest Excel authors walking the planet. John Walkenbach, Bill Jelen (Mr. Excel), Debra Dalgleish, etc. There is a lot of great content out there for Excel users. So here is my starter list of the best Excel Books (UPDATE: The list has grown to over 100 and is still growing – the largest on the internet that I am aware of 🙂 ). I am further segmenting the list to make it more digestible – everyday. I encourage you to leave your comments below if you think I missed a book that you have found valuable. Unless you are some troll trying to sell life insurance to my readers — I WILL approve your comments. And if the book is good — it will be added.
Also, I am not a good judge of books that are not in English. So if you have non-English Excel/VBA Books that have been useful to you, let me know in the comments section and I will add them and let our international readers decide if the book should stay on the list.
Lastly, as a point of full-disclosure. Many of these links go to Amazon. As I am writing this, they don’t go to any affiliate links. But they may eventually be affiliate links that buy me a bagel or some coffee if you buy a book. I don’t think that’s a big deal, but as a fellow Excel user I wanted you to know in advance — because I value honesty and transparency. You know — because my name is all over this website :). Also, this is for users of Excel. Excel… Not Word, or Powerpoint. Separated by function and version. So dive in.
Topics – Recommended By Role/Job Function
Scientists and Engineers
Finance and Accounting
Statistics and Prediction
- Excel Basics to Blackbelt – 2nd Edition – Dr Elliot Bendoly
- NOTE: I exchanged messages with Dr. Bendoly on LinkedIN and he mentions that this book is highly relevant and in use for most consulting firms.
Excel Books: By Version
Power BI / Power Pivot / Power Query
- Excel 2007 Charts – Bill Jelen
- Excel 2007 Bible – John Walkenbach
- Excel 2007 Charts – John Walkenbach
- Excel 2007 For Dummies Quick Reference – John Walkenbach
- Excel 2007 Formulas – John Walkenbach
- Excel 2007 Power Programming with VBA – John Walkenbach
- Excel 2007 VBA Programming For Dummies – John Walkenbach
- John Walkenbach’s Favorite Excel 2007 Tips & Tricks – John Walkenbach
- Microsoft Office 2007 Library – John Walkenbach
- Mr. Spreadsheet’s Excel 2007 Library – John Walkenbach
- Beginning Pivot Tables in Excel 2007 – Debra Dalgleish
- Excel Pivot Tables Recipe Book 2007 – Debra Dalgleish
- Excel 2007 VBA and Macros – Bill Jelen & Tracy Syrstad
- Excel 2007 All-In-One for Dummies – Greg Harvey
- Excel Gurus Gone Wild – Bill Jelen
- Excel 2007 Miracles Made Easy – Bill Jelen
- Excel 2007 Pivot Table Data Crunching – Bill Jelen, Michael Alexander
- Excel 2007 VBA Programmer’s Reference – John Green, Stephen Bullen, Rob Bovey, Michael Alexander
- Excel 2007 Advanced Report Development – Timothy Zapawa
- RibbonX: Customizing the Office 2007 Ribbon – Robert Martin, Ken Puls, Teresa Hennig
- This Isn’t Excel: Its Magic – Bob Umlas
- Microsoft® Office Excel® 2007 Visual Basic® for Applications Step by Step – Reed Jacobson
- Excel Hacks:Tips & Tricks for Streamlining your Spreadsheets – David Hawley, Raina Hawley
- Microsoft® Excel® 2007: Data Analysis and Business Modeling – Wayne L Winston PhD.
- Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) – Rob Bovey, Dennis Wallentin, Stephen Bullen, John Green
- NOTE: In the comments section of this blog post, Jordan Goldmeier of http://optionexplicitvba.com calls this book the “finest book on Excel development ever written. I still use the 2003 version because I think it’s timeless.”
Excel (General – No Version #)
Books – Excel For a Mac
In Many Languages
- Ya sé Excel, pero necesito más – Translated – I already know Excel, But I need more – Francisco Megia Morales
- NOTE: See the authors notes in the comments section. It’s for those people who are sceptic because they think they know everything about Excel. And as they go reading they discover a new world. For people who want to go from current basic/intermediate level to actual advanced level.
So… Where are the GAPS???
Because, I know some of you that may be reading this right now are authors… and you’re thinking…
Where the HELL is my book? Because…
- Its a masterpiece.
- Has plot twists.
- A devious villain.
- Damsel in distress.
- VBA Code 🙂
Well… Then leave a comment and let me know about it. I am honestly adding to this page daily.
If you are reading this then you made it all the way to the bottom of the page — whew — that was a workout. Might as well leave a comment and hit one of those social sharing buttons so that your Mom on Facebook knows how cool you are (visiting an Excel website and all :))