Best Excel, Visualization & Video Resources

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.

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

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

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.

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

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.

Start Learning

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.

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

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

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

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!

Start Learning

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.

Start Learning

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.

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

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 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.

Start Learning

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.

Start Learning

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.

Start Learning

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

Start Learning

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

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 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.

Create Tutorials

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

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

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.

Improve Your 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.

Capture Your Screen

Canon EOS 5D Mark IV

This full frame camera offers stellar image quality for pics and phenomenal performance for video. It’s my main camera now and I absolutely love it. I use it together with this lens, and this memory card.

Check it out

Canon EOS 70D

I use the Canon EOS 70D Digital SLR as a second and backup Camera to record my head-shots.

It’s quite easy to get the hang of.

I use it together with this memory card, this lens and this tripod.

Check them out

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.

Check it out

DPA 6060 CORE Microphone

I tried several different microphones but this one has it all. It’s just 3 mm (0.12 in) in size but still offers a Max. SPL of 134 dB and a noise level of only 24 dB. It sure is the best omnidirectional lavalier microphone I ever owned.

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

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.

Check it out

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.

Check it out

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.

Check it out

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.

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.