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
- Excel for Marketing Managers – Ivana Taylor, Bill Jelen
- Basic Marketing Research with Excel – Alvin C. Burns, Ronald C. Bush
- Excel Secrets for Highly Effective Marketers – Jason Khoo
- Marketing Analytics: Data Driven Techniques with Excel – Wayne L. Winston
- Excel 2007 for Scientists and Engineers – Dr. Gerard Verschuuren
- Excel 2013 for Scientists – Dr. Gerard Verschuuren
- Excel for Scientists and Engineers: Numerical Methods – E. Joseph Billo
- A Guide to Microsoft Excel 2007 for Scientists and Engineers – Bernard Liengme
- Advanced Excel for Scientific Data Analysis – Robert de Levie
- Engineering with Excel (4th Edition) – Ronald W. Larsen
Finance and Accounting
- Excel University – Training for CPAs and Accounting Professionals – Volume 1 – Jeff Lenning, CPA
- Excel University – Training for CPAs and Accounting Professionals – Volume 2 – Jeff Lenning, CPA
- Excel for Accountants – Conrad Carlberg
- Next Generation Excel: Modeling in Excel for Analysts and MBAs – 2nd Edition – Isaac Gottlieb
- Financial Modeling – Simon Benninga
- Financial Modelling for Project Finance – Dr Penelope Lynch
- NOTE: The author – Dr Penelope Lynch mentioned on LinkedIN that this is specifically about cashflow modelling in Excel (2nd edition considers versions 2003 and 2007)
Statistics and Prediction
- Statistical Analysis: Microsoft Excel 2010 – Conrad Carlberg
- Statistics with Microsoft Excel (5th Edition) – Beverly Dretzke
- Predictive Analytics: Microsoft Excel – Conrad Carlberg
- Decision Analytics: Microsoft Excel – Conrad Carlberg
- 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 for the CEO – P.K. Hari
- Excel for the CFO – P.K. Hari
- Excel for Auditors – (Excel 97 through 2007) – Bill Jelen, Dwayne K. Dowell
- Excel for Chemists – E. Joseph Billo
- Construction Estimating Using Excel (2nd Edition) – Steven Peterson, MBA, PE
- Excel for Teachers – Colleen Conm, Bill Hazlett, Bill Jelen, Adrienne Soucy
- Excel for the Math Classroom – Bill Hazlett, Bill Jelen
- Decision Modeling with Microsoft Excel – 6th Edition – Jeffrey H. Moore, Larry H. Weatherford
- NOTE: For undergraduate/MBA-level courses in Management Science and Decision Modeling
- Excel 2010: Business Basics and Beyond – Chris “Smitty” Smith
- NOTE: I am a BIG fan of books designed for Business people — so check this one out.
Excel Books: By Version
Power BI / Power Pivot / Power Query
- M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query – Ken Puls & Miguel Escobar
- DAX Patterns 2015 – Alberto Ferrari & Marco Russo
- Microsoft Excel 2013 Building Data Models with PowerPivot – Alberto Ferrari & Marco Russo
- Learn to Write DAX – Matt Allington
- Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 – Rob Collie & Avi Singh
- Mr Excel XL: 40 Greatest Excel Tips of All Time – Szilvia Juhasz & Bill Jelen
- Guerilla Data Analysis 2nd Edition – Oz du Soleil & Bill Jelen
- Dashboards for Excel – Jordan Goldmeier & Chandoo
- Advanced Excel Essentials – Jordan Goldmeier
- NOTE: There are plenty of books that show you HOW to do things, but not very many that tell you WHY to do things. Want to better understand good ways to develop in Excel? Then grab this book by Excel MVP Jordan Goldmeier. The book covers it all.
- Microsoft® Excel® 2013: Data Analysis and Business Modeling – Wayne L Winston PhD.
- Excel 2013 Charts and Graphs – Bill Jelen
- 101 Excel 2013 Tips, Tricks & Timesavers – John Walkenbach
- Excel 2013 Bible – John Walkenbach
- Excel 2013 Formulas – John Walkenbach
- Excel 2013 Power Programming With VBA – John Walkenbach
- Excel VBA Programming For Dummies, 3rd Ed. – John Walkenbach
- Excel 2013 in Depth – Bill Jelen
- Excel 2013 VBA and Macros – Bill Jelen & Tracy Syrstad
- Excel 2013 for Dummies – Greg Harvey
- Excel 2013 Formulas and Functions – Paul McFedries
- Excel 2013 Dashboards and Reports – Michael Alexander, John Walkenbach
- Excel 2013 Pivot Table Data Crunching – Bill Jelen, Michael Alexander
- NOTE: See authors notes in the comments section of this BLOG. This is the first book to cover regular pivot tables, Power Pivot, Power View and Power Map.
- Excel 2013 Building Data Models with Power Pivot – Alberto Ferrari, Marco Russo
- The VLOOKUP Book – Chandoo
- Ctrl+shift+enter: Mastering Excel Array Formulas – Mike ExcelIsFun Girvin
- PDF Verson from Holy Macro Books – Mike ExcelIsFunGirvin
- Get the Book from Amazon – Mike ExcelIsFun Girvin
- NOTE: See notes about this book from Mr. Excel Bill Jelen in the comments section of this BLOG. This book fills in a gap, thoroughly explaining Excel array formulas with plenty of examples. Mike Girvin has a wildly popular Youtube Channel ExcelIsFun
- Excel 2010 Charts and Graphs – Bill Jelen
- Excel 2010 Bible – John Walkenbach
- Excel 2010 For Dummies Quick Reference – John Walkenbach
- Excel 2010 Formulas – John Walkenbach
- Excel 2010 Power Programming With VBA – John Walkenbach
- Excel Dashboards and Reports – John Walkenbach
- Excel VBA Programming For Dummies – John Walkenbach
- John Walkenbach’s Favorite Excel 2010 Tips & Tricks – John Walkenbach
- DAX Formulas for PowerPivot – Rob Collie
- Excel in Depth 2010 – Bill Jelen
- Excel 2010 VBA and Macros – Bill Jelen & Tracy Syrstad
- Don’t Fear the Spreadsheets – Tyler Nash, Bill Jelen, Kevin Jones, Tom Urtis
- Learn Excel 2010 Essential Skills with the SMART Method – Mike Smart
- Excel 2010 All-In-One for Dummies – Greg Harvey
- Excel 2010 Formulas and Functions – Paul McFedries
- Slaying Excel Dragons – Mike ExcelIsFun Girvin, Bill Jelen
- Excel Outside the Box – Bob Umlas
- Excel 2010 Dashboards and Reports – Michael Alexander, John Walkenbach
- Excel 2010 Pivot Table Data Crunching – Bill Jelen, Michael Alexander
- Power Pivot for the Data Analyst 2010 – Bill Jelen
- Predictive Analytics: Microsoft Excel – Conrad Carlberg
- Excel Pivot Tables and Pivot Charts – Paul McFedries
- Microsoft® Excel® 2010: Data Analysis and Business Modeling – Wayne L Winston PhD.
- 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.”
- Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA – Stephen Bullen, Rob Bovey & John Green
- A Complete Guide to Pivot Tables: A Visual Approach – Paul Cornell
- Excel 2003 Bible – John Walkenbach
- Excel 2003 Formulas – John Walkenbach
- Excel 2003 Power Programming With VBA – John Walkenbach
- Excel VBA Programming For Dummies – John Walkenbach
- John Walkenbach’s Favorite Excel Tips & Tricks – John Walkenbach
Excel (General – No Version #)
- Excel Tables: A Complete Guide for Creating, Using and Automating Lists – Zack Barresse
- PDF Verson from Holy Macro Books – Zack Barresse
- Get the Book from Amazon – Zack Barresse
- Excel Pivot Tables Recipe Book – Debra Dalgleish
- Head First Data Analysis: A Learner’s Guide to Big Numbers, Statistics, and Good Decisions – Michael Milton
- Spreadsheet Check and Control – Patrick R O’Beirne
- NOTE: In the comments section of this BLOG post (scroll down) — Bob Phillips of xldynamic.com calls this book “mandatory of you take spreadsheet quality seriously.
- Elements of Spreadsheet Style: How to build a model you can use – John M. Nevison
- NOTE: I was tipped to this book by Joe Armstrong in one of the LinkedIN excel groups. Found it on Amazon (published in 1987) and saw there was a review from Mike “ExcelIsFun” Girvin, who called it “one of the best excel books ever written”. Which means I have to get this book before you buy the last copy.
Books – Excel For a Mac
- Office 2011 for MacIntosh: The Missing Manual – Chris Grover
- Office 2011 for Mac All-in-One for Dummies – Geetesh Bajaj, James Gordon
- Learn Excel 2011 for Mac – Guy Hart-Davis
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 :))