The Ultimate Excel Programmer Course

I would recommend this one on udemy. It is perpetually on sale for $15. It does come with a certificate as well.

https://www.udemy.com/course/ultimate-excel-programmer/

VBA

1. Language is pretty clunky as compared to Python
2. VBA can be implemented pretty quickly in a workplace environment. You can also see how your code interacts with excel so it helps you to better understand concepts like conditional statements, try / except, loops, functions / classes etc.
3. Can be used pretty easily and doesn't need external libraries. You can create forms, functions, macros etc. without having to create a gui or interface. This is all integrated into excel already so its pretty quick and easy to implement

Python

1. Python is a readable language i.e. very easy to understand and write code
2. Can be implemented quickly for large data analysis. However, it does not interact well with excel workbooks with specific formatting.
3. Can be used for advanced automation i.e. creating web scrapers, bots, improving process workflow and has a ton of libraries that do almost every imaginable thing possible
4. needs a gui if you want to create userform and visualizing advanced concepts like classes / decorators etc. can be a bit more difficult

It obviously depends on what you want to do but i would start with VBA as it is much easier to visualize how your code interacts with the workbook. Once you're comfortable enough, you can supplement that with Python. There's a pretty great udemy course on VBA which is like $10 so do look into that. I used this:

https://www.udemy.com/course/ultimate-excel-programmer/

There are a lot of good courses on Udemy. Some may look expensive but they have frequent "sales" where you can get +$200 courses for less than $20. I've listed a few I've taken myself below.

The Ultimate Excel Programmer Course

The Complete SQL Bootcamp

Maven Analytics