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.
 Excel 2016 Bible
2013 version: Excel 2013 Bible
2010 version: Excel 2010 Bible
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.
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.
2013 version: Excel 2013 Power Programming with VBA
2010 version: Excel 2010 Power Programming with VBA
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 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.
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.