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.
You can also check out my Amazon page here for a complete list of my recording gear and book recommendations.
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 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.
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.
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.
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!
Advanced Excel Essentials
This is the book you need after you cover the essentials. This builds on your existing knowledge and takes it to a new, advanced level. It’s a book that will help you think outside the box.
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.
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).
MOS 2016 Study Guide for Excel
If you’d like to get the Excel Specialist certification then this book will be of great help. You will get to improve your Excel skills and practice and prepare for the exam.
MOS 2016 Study Guide for Microsoft Excel Expert
I used the MOS book series to prepare for Microsoft Office Specialist (MOS) Expert exams. I found them helpful and learnt a few tricks along the way.
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.
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!
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!
Collect, Combine and Transform Data
Gil Raviv is a Microsoft MVP and a Power BI blogger. This book opened my eyes to the potential of Power Query. Highly recommended!
M Is for (Data) Monkey
This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.
Power Query Playlist
Mike Girvin from ExcelIsFun has one of the most comprehensive Excel YouTube channels.
His Power Query playlist has over 150 videos!
Also check out his Microsoft Power Tools for Data Analysis Playlist.
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.
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.
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.
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.
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.
Data at Work
Best practices for creating effective charts and information graphics in Microsoft Excel. It comes with downloadable workbooks and templates you can use with your own data.
Visual Explanations
Images and Quantities, Evidence and Narrative. This books has it all. Maps, historical drawings and scientific charts. It will give you insight on different methods you can use to get your point across visually.
Envisioning Information
This book takes you through the various methods you can use to display complex data. It covers statistical graphs, maps, statistical presentations, courtroom exhibits and much more.
Data Science, Python, SQL courses & more
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
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
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.
This is a list of tools I use for my business & tutorials
Camtasia
Camtasia from TechSmith makes it simple to record and create professional-looking videos on Windows and Mac.
I use it to record all my tutorials.
If you need to share information with video, you need Camtasia.
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.
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.
Simple Slides
Simple Slides offer the largest library of Infographics and Slides Online. With 10,000+ PowerPoint Slides and Infographics you have endless possible presentations.
If you create presentations, you need Simple Slides.
Snagit
Snagit lets you quickly capture a process, add your explanation, and create visual instructions.
We use Snagit to add visuals for all our blog posts.
Canon EOS 5D Mark IV
Canon EOS 70D
It’s quite easy to get the hang of.
I use it together with this memory card, this lens and this tripod.
Sound Devices MixPre-3 II
Good audio is important for my tutorials. I use this audio recorder with its ultra-low-noise preamps.
It’s super easy to use and the audio is crisp and clean.
When I’m in the field I use it with the Anker Powerbank.
DPA 6060 CORE Microphone
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.
Dimmable LED Ring Light
I use a good ring light for portraits to bring out natural skin tones.
It offers modern Bi Color technology and the color temperature can be adjusted from 3,200 to 5,600 Kelvin.
Bose QuietComfort
This is the best set of wireless headphones I’ve ever owned. It clears away the noisy distractions of the world so you can get deeper into your music, your work, or whatever you want to focus on.
Blue Yeti USB Microphone
This is the easiest Microphone to set up. It has zero setup up time.
You plug it in to the USB port of your computer and you’re done.
I’ve tested a few microphones. This is the best I’ve come across, especially for screencasts.
Edutige Lavalier Microphone
When I’m on the go and I need a quick recording I use this microphone.
I just plug it into my phone and use it together with a free app.
Super easy to use with decent sound quality.
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.