Skip to content

Resources

My favourite resources to learn Python & VBA

Learning_Resources

How To learn VBA

These videos will help you through your first steps on the way to becoming a programmer in Excel. You don’t need any prior programming knowledge as we’ll take things from first principles and hopefully give you a flavor of the cool things you can do with a little bit of effort!

  •  Free
  •  Step-by-step in-depth tutorial
  •  Lack of real-world examples
  •  Very long videos/course

This Excel® VBA Notes for Professionals book is compiled from Stack Overflow Documentation. The readers will learn how to work with Excel, why they should use VBA and how to debug their code. If you’re looking to learn more about programming in Excel, this book is for you!

  •  Free
  •  Ready-to-use code snippets
  •  Lack of explanations
  •  Not for absolute beginners

In this Excel VBA course, complex topics are taught in a simple way by an instructor with 17 years of experience. The content has been carefully crafted and clearly organized. The videos are high quality and include animations to emphasize points. Most importantly you learn VBA by doing.

  •  Over 50 macro examples
  •  Real-World projects
  •  Not free
  •  Lack of some foundational concepts

This easy-to-follow book makes it easier than ever to excel at Excel VBA! The text is well laid out, well thought out, and well organized. Each chapter introduces new topics that builds on previous chapters. The technical details are accurate, and the code works!

  •  Well written
  •  Good for quick reference
  •  Not free
  •  Lack of code examples

How To learn Python

I was looking for a good Python tutorial on how to code for beginners, and I ended up stumbling across Corey Schaefer. His videos are so easy to understand and he offers a ton of information on what you can do with Python. If you want to learn how to code in Python, then this is the channel for you! He has been a great help to me and has been one of the best tutorials I have come across.

  •  Free
  •  Simple explanations for complex concepts
  •  Lack of real-world examples

In Automate the Boring Stuff with Python, you’ll learn how to use Python to write programs that do in minutes what would take you hours to do by hand – no prior programming experience required. Once you’ve mastered the basics of programming, you’ll create Python programs that effortlessly perform very useful and impressive feats of automation.

  •  Free
  •  Very (very) practical
  •  Some of the code examples are outdated

Master Python by building 100 projects in 100 days. Learn to build websites, games, apps, plus scraping and data science. In the course, you will learn how to use modern frameworks like Selenium, Beautiful Soup, Request, Flask, Pandas, NumPy, Scikit Learn, Plotly, Matplotlib, Seaborn.

  •  Angela is a fabulous teacher
  •  The only course you need
  •  Not free

By the end of this course, you’ll be able to write code that dramatically increases your productivity. What I like about this course, that you are not spending hours on the basics. Instead, you will learn how to automate real-world office tasks by writing simple Python programs.

  •  Short & sweet course (9.5 h)
  •  Very (very) practical
  •  Not free