Quote: (05-08-2014 01:51 PM)3extra Wrote:
Dayyuum.
Could you pick up VBA skills through online (youtube etc) demonstrations?
Or is it more advanced - needing to do a course?
It's a scripting language that at its most basic allows you to automate behavior in Excel and in a more complicated function, do much more. I've written VBA scripts that hook into databases and run dynamic SQL queries to pull values out based on something in the Excel file, and even threw a control file together to automate distributing reports (other Excel files) to the field via email when our vendor quoted us an outrageous price for the same task.
With any computer programming language, VBA being a more simple example, having a fundamental understanding of basic computer science is good and the rest you should be able to pick up by practicing and writing code. Crack open Excel, record a Macro, hit Alt-F11, and start understanding how the behavior you recorded on-screen is being translated into the VBA code behind the scenes.
But that said, nobody is paying 80-100/hr in the financial district for a guy who's watched a couple Youtube videos. Chances are not only do they want a solid tech background but they also want someone with some finance background too, who can speak the language with whatever analysts will be requesting the work.