Book Resources

There are a ton of books on Microsoft Excel and I’ve read my fair share of them.  These are the ones I’d recommend.

Beginner

Excel 2013 For Dummies by Greg HarveyThe Dummies books are usually a great starter resource if you are new to Excel and also a nice refresher if you already have some knowledge of a previous Excel versions but want to be up-to-date on the latest.

Excel 2013 Bible by John Walkenbach. John Walkenbach (aka Mr. Spreadsheet) is considered one of the original gurus on Excel. He’s written a LOT of books on Excel and Excel programming. He usually comes up with a Excel Bible for each version release.

Teach Yourself VISUALLY Excel 2013 Paperback by Paul McFedriesThe Teach Yourself Visually books are another nice series by the publishers at Visual. Usually full of a lot of colorful screenshots and images, the VISUALLY books give a nice picture based view of how to do stuff… in this case learning Excel.

Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun by Mike Girvin and Bill JelenMike Girvin and Bill Jelen teamed up to write this great introduction to Excel. Mike has a popular YouTube channel (ExcelisFun) that has over 2,400 training videos and Bill Jelen is not too shabby with his YouTube channel (bjele123) with over 1600 videos.

Excel for the New Project Manager: A Primer on Microsoft Excel 2010 by Doug Hong.  Yes I finally have my own book! It’s an introductory book that’s available only on Kindle enabled readers but it’s reasonably price (It’s equivalent to a Starbucks Frappuccino).

Intermediate

Excel Dashboards and Reports For Dummies by Michael AlexanderAt this stage turning data into information and sharing it becomes more common. If you are putting together charts and reports, this Dummies book is a great source of tips.

Excel 2013 Charts and Graphs by Bill JelenBill Jelen (aka MrExcel) has a great YouTube channel, website and forum where he dispenses tons of Excel knowledge. If you’re creating charts and graphs this book is also a great resource.

Excel 2013 Pivot Table Data Crunching by Bill Jelen and Michael AlexanderYou may be doing more data analysis and one of the most useful tools to do that is the Pivot Table. Learn from two masters about how to effectively use the Pivot Table feature in Excel.

Advanced

Excel VBA Programming For Dummies by John WalkenbachOne of the most powerful features in (or available to) Excel is the ability to create customized “programming” to automate steps or add new features into your spreadsheet. This is done with Visual Basic for Applications. Here is another Dummies book to give you the introduction to this programming language.

Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map by Dan ClarkThe Data Model concept ( a collection of tables with relationships) in Excel is bringing some of the power of a database to a spreadsheet. Learn how to use the Data Model to really do data crunching with multiple tables and large datasets.

Comments are closed.