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.

Complete Excel Reference

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

[1] Excel 2016 Bible

2013 version: Excel 2013 Bible

2010 version: Excel 2010 Bible

 

[2] Advanced Excel Essentials

 

Formulas

This books 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 short cut 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)

 

[6]101 Ready-to-Use Excel Formulas

 

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 worth while.  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.

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

 

[8] Excel Dashboards and Reports

 

[9] Dashboards for Excel

 

Data Analysis

[10]Guerrilla Data Analysis Using Microsoft Excel: 2nd Edition Covering Excel 2010/2013


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.  The links in this post are affiliate links, which means, if you purchase through these links I will earn a small commission.

Save

Save

Save

Leave a Reply

Your email address will not be published. Required fields are marked *