Top 10: Excel, VBA and Dashboard books

If you want to take your Excel, VBA or Dashboard skills to the next level then these 10 books will provide you with the skills you need to become an expert.

This post may contain affiliate links. Please read my disclosure for more info.

Complete Excel Reference

Sometimes we just need something which is going to give us a really solid understanding of Excel as a whole.

[1] Excel 2016 Bible

2013 version: Excel 2013 Bible

2010 version: Excel 2010 Bible

[2] Advanced Excel Essentials

Not sure if this book is for you? Read my review



This book is quite niche, it is intended for more intermediate/advanced Excel users. If you want something about Formulas in general then the Excel 2016 Bible is probably more suited to your needs.

[3] Ctrl+Shift+Enter Mastering Excel Array Formulas


VBA Programming

Let me tell you a little secret – there is no shortcut to learning VBA. The best thing you can do is to sit down with one of these books and work through the examples one by one. Make sure you apply my golden rule, even when using examples from a book.

[4] Excel 2016 Power Programming with VBA

2013 version: Excel 2013 Power Programming with VBA

2010 version: Excel 2010 Power Programming with VBA

[5] Excel 2016 VBA and Macros

2013 version: Excel 2013 VBA and Macros (MrExcel Library)

2010 version: VBA and Macros: Microsoft Excel 2010 (MrExcel Library)


Dashboards & Charts

It seems that this is the hot topic at the moment, so learning the skills to create an effective dashboard has got to be worthwhile. There is often a knowledge/skill gap for most Excel users when creating good data visualizations. These books will set you on the right path.

[6] Effective Data Visualization: The Right Chart for the Right Data

Not sure if this book is for you? Read my review

[7] Excel Dashboards and Reports

[8] Dashboards for Excel


Data Analysis & PowerQuery

No matter what you need to do in Excel, it all starts with data analysis of some kind. If you can get clean data in right format it makes everything else much easier.

[9] M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

[10] Guerrilla Data Analysis Using Microsoft Excel: 2nd Edition

These books are purely my recommendations. There must be hundreds of Excel books available, so it is more about finding something which works for you.