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.

This is a list of tools I use for my Online Video Training Tutorials:

Buy Now!

CAMTASIA is great screen recording software.  It allows you to capture and record your screen activity. I use it to record my Excel Tutorials. It’s relatively easy to learn – you’ll find lots of free tutorials on YouTube and on the TechSmith website. You can also find affordable courses online.

Canon EOS 70D Digital SLR Camera  : I use this to record head-shots. It’s quite easy to get the hang of it. I did take a Udemy course though on how to use it properly. I use it together with this memory card, this lens and this tripod.

Studio Lights: I use a similar set to the ones here. Good lighting is not an easy task. You do need a good set of lights specially if you’re filming in a naturally darker environment.

Lavalier Microphone: I use the Edutige Lavalier Microphone which I plug in to my phone. I tried different microphones and found this one to be the best and the easiest-to-manage lavalier microphone. I use it together with a free app on my phone for the sound recordings.

Share This