Excel and VBA
In my first lesson of the current course I am taking, BMD5302 - Financial Modelling for Fintech professionals, I was introduced to first to VBA, and then to a couple of popular functions in Excel. I mean, I was mindblown a little bit by VBA. I’ve heard of it before, but I’ve never known what it does. Now I know: it is a way for you to control excel programmatically. The syntax seems easy enough, and very quickly I can see how it can be really powerful. It’ll allow you to automate almost everything that you need in excel. ...