Resources I Recommend

My students often ask me what books and resources I use to improve my knowledge and the tools I use to create my courses and tutorials.

I put together this page as a handy reference. I’ll keep updating it as I come across new resources.

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. Thank you for your support. Please only purchase the products if you believe they will add value for you.

Excel Books
Power Excel
Visualization
Data Science
Gear

Excel 2016 Bible

Without doubt, this is a great book for beginners. It’s a complete guide to all aspects of Excel. This is a great resource book that will take you from beginner to advanced.

Start Learning

Microsoft Excel Data Analysis and Business Modeling

This book will teach you how to create models with Excel. It includes many examples and exercises to enforce learning. It’s a great Excel manual to have on hand for data modeling projects.

Start Learning

Excel 2016 All-in-One For Dummies

This book is clear, easy-to-follow and makes Excel very approachable. I’m a fan of the Dummies series. They’ve helped me get started with many technical topics in the past.

Start Learning

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!

Start Learning

Excel Dashboards and Reports

This book is a good start to learn how to design Excel dashboards from scratch. It covers data modeling, Pivot Tables, charts and dashboard design.

Start Learning

Power Programming with VBA

If you want to master VBA & Macros, you need this book! I first learnt VBA through Google but the pieces only came together after I bought this book (…well originally Excel 2000 version).

Start Learning

Power Query, Power Pivot, DAX & Power BI

Power Pivot and Power BI

This book is truly the Excel user’s guide to Power Pivot, Power Query, DAX & Power BI. It’s informative. It’s entertaining. It’s a book I gladly take with me on holidays. It’s a great starting point to learn Excel’s Power Tools.

Start Learning

excel maven powerpivot referral course

Intro to Power Query, Power Pivot & DAX

This is an online course by Chris Dutton from ExcelMaven.com. His style is easy going and to the point. He uses a lot of examples and exercises which I love. His other courses are  great too!

Start Learning

Power query get and transform course

Excel 2016: Power Query (Get & Transform)

This course is available on LinkedIn Learning. Oz takes you through the different aspects of Get & Transform. His style is unique & super fun. One thing’s for sure: You’re not going to get bored!

Start Learning

Mike Girvin Excel Power Query Power Pivot Playlist referral

Power Query Playlist

Mike Girvin from  ExcelIsFun has one of the most comprehensive Excel YouTube channels. His Power Query playlist has over 100 videos! Also check out his Microsoft Power Tools for Data Analysis Playlist.

Start Learning

Learn to write DAX

This is great guide for starting your Advanced Power Pivot & Power BI journey. Teaching yourself DAX is not easy. Matt Allington has done a great job in simplifying complex concepts in his book.

Start Learning

PowerBI course

Up & Running with POWER BI Desktop

This course is a comprehensive, hands-on guide to learning Microsoft Power BI Desktop. It’s super easy to follow. You’ll learn the ins-and-outs of Power BI and some powerful tips along the way.

Start Learning

Data Visualization

Show me the Numbers

What type of charts work well and what to avoid? How should you structure your data tables? How can you bring attention to certain elements without confusing your readers? This books answers it all.

Start Learning

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.

Start Learning

Storytelling with Data

It’s more than a data visualization book. This book shows you how to present your data in a way that resonates with your audience.

Start Learning

Data Science, Python, SQL courses & more

icon
icon

Complete Python Bootcamp: Go from zero to hero in Python 3

This course will make you a Python Programmer. It’s a comprehensive course with over 20 hours of video, tests and assignments which teach you Python in a practical manner

Start Learning

icon
icon

Machine Learning A-Z™: Hands-On Python & R In Data Science

If you’re interested to learn about Machine Learning, then this course is for you. You’ll build Machine Learning models and learn to combine them to solve any problem and make accurate predictions

Start Learning

icon
icon

The Ultimate MySQL Bootcamp

This course will take you from SQL beginner to advanced. You’ll learn to create your own database, how to build a web app and how to interact with existing databases which can include writing complex SQL queries across multiple tables.

Start Learning

This is a list of tools I use for my business & tutorials

Camtasia

Camtasia from TechSmith is a great screen recording software.  It allows you to capture and record your screen activity. I use it to record my Excel Tutorials. In addition to English, you can also get it in German or in French.

Create Tutorials

ConvertKit

ConvertKit

ConvertKit makes it really easy to manage your email list. I switched to ConvertKit in 2018 and I’m really happy I did. There’s an amazing team behind ConvertKit that genuinely wants to create the best email marketing tool out there to help creators like us.

Try it out

Web Hosting

SiteGround WordPress Host

SiteGround is the perfect hosting company for WordPress sites. I’m really grateful for their immediate availability and helpful assistance. Their customer support is outstanding. I’m really happy since I switched to them.

Try it out

Canon EOS 70D

I use the Canon EOS 70D Digital SLR Camera to record my head-shots. It’s quite easy to get the hang of. 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.

Check it out

Studio Lights

Good lighting is an integral part of every video. I use a similar set to the ones here. You certainly need a good set of lights specially if you’re filming in a naturally darker environment.

Check them out

Edutige Lavalier Microphone

This lavalier microphone is super easy to use. I just plug it in to my phone. I tried different microphones and found this to be the easiest-to-manage lavalier microphone. I use it together with a free app on my phone.

Check it out

116 Excel Tutorials in 1

This blog post gives a good overview of all my videos and posts. Also, it’s a channel for collecting ideas from you all! NOTE: The links in this file are updated on a monthly basis so check back to get the latest file.

Share This