Resources I Recommend

This is a list of some of my favorite Excel books & products. I only recommend what I’ve read and what helped me improve my knowledge.

Disclosure: Some of the links are affiliate links, which means at no additional cost to you I will receive a small commission if you make a purchase using the links. Please only purchase the products if you believe they will add value for you.

Control Shift Enter Book Recommendation by Leila Gharani

Ctrl Shift Enter: My absolute favorite Excel Advanced Book. No matter how advanced you are in Excel, there is gold in this book. I’ve learnt so much from it. It opened my eyes to so many different possibilities! It’s not a book you read once and forget about. It’s a book you can refer to anytime you need to solve a complex Excel (formula) problem. Even though it doesn’t include your exact problem, you will find ideas that help you find the right solution.

Power Programming with VBA (Excel 2013): If you want to master VBA, you need this book! I first learnt VBA through Google. Whenever I got stuck with stubborn error messages, Google helped me find the solution. Slowly VBA started to make sense but the pieces only came together with this book (…well originally the Excel 2000 VBA version).

Show me the Numbers: Do you want to create impressive reports? What is it that makes a report readable and impressive? What type of charts work well and what to avoid? This book is a great starting point! You’ll learn how to structure your tables; How to bring attention to certain elements without confusing your readers and which chart types to use when. I learnt a lot from this book!

The Visual Display of Quantitative Information: This is a classic! If you want to deepen your knowledge about the theory of data visualization and see some impressive graphics, this book is a must-have. It’s about graphical integrity, graphical excellence, chart-junk and data-ink. Each chapter is an eye-opener. You might be familiar with a lot of these topics, but if you haven’t read Edward Tufte’s version, I suggest you check it out.

Share This