Wanna learn VBA to use in Excel - Microsoft Course 2559B or 2373B?

[ORoxo]

Hey, Guys
I'm graduating in 1,5 years from an MSc Finance and I'm really looking forward to learn how to write code in VBA in order to be as productive as possible when I start working with excel on a daily basis.
I have been looking for courses where I can get this knowledge and, to be honest, it has not been easy. However, a company I approached suggested me the two courses below:

https://www.microsoft.com/pt-br/learning/course.aspx?cid=2559
https://www.microsoft.com/pt-br/learning/course.aspx?cid=2373

The thing is, I have no idea which one to choose or even if any of them make sense for the purpose I'm trying to reach.

I had a Basic VBA course last semester at uni but I just know the basics.
Considering this scenario, what's your advice?


Thanks for your time.
I really hope you can provide some insights because, to be honest, I feel completely lost.

Kind regards,
ORoxo

 

[Kyle123]

Neither of those are for VBA, they're for VB.Net which is a completely different language and nothing to do with Excel

 

[ORoxo]

Neither of those are for VBA, they're for VB.Net which is a completely different language and nothing to do with Excel

Kyle, first of all, thank you so much for your reply!

Is there any specific Microsoft Course that you would suggest for someone in my position? This way I could counter-argument with the company and ask for a specific product. If they provide these programs maybe they willing to provide others.


Thanks,
ORoxo

 

[Kyle123]

Sorry, I really wouldn't know. I've never done any formal courses or qualifications in VBA

 

[shg]

I think you'd find that only a tiny fraction of people who are regarded as competent in VBA have ever taken a class; mostly they learn by doing.

Unless you have absolutely no knowledge of the concept of computer programming, VBA is an easy language to learn. The much larger part is the Excel object model, which is just ... big.

 

[ORoxo]

I think you'd find that only a tiny fraction of people who are regarded as competent in VBA have ever taken a class; mostly they learn by doing.

Unless you have absolutely no knowledge of the concept of computer programming, VBA is an easy language to learn. The much larger part is the Excel object model, which is just ... big.

What is your suggestion then, shg? That I just learn as I get the awareness that something can be automatized?

 

[shg]

My advice is to start with a problem you want to solve (that is critically important -- IMO it's impossible to learn something that you have no idea how you want to apply), learn to use the macro recorder, read and understand the code it generates, learn to clean up the results, and ask a thousand questions. Look at the questions other people ask, look at the answers, see if they make sense, add to your knowledge base.

Lather, rinse, repeat.

 

[RoryA]

Buy some books and then use forums like this one as a source of problems to solve, and compare what you come up with to what others do. It's a great way to learn as it's part trial and error, part teaching, and a lot of reinforcement.

 

[Rick Rothstein]

One of our contributors here (hiker95) has assembled a massive list of materials related to learning VBA... there should be a bunch of links in here that you can make use of...

https://www.mrexcel.com/forum/gener...ions/1026346-vba-post4926066.html#post4926066

 

[ORoxo]

Thanks, guys. Your help really means a lot.

I will have a look at the links you provided and decide whether makes sense to have actual classes or just learn by myself.