Self study VBA
Any good sources to bring up my proficient quickly. My intern boss told me that there will be a programming aspect, specifically vba, and that I will be working heavily in creating client friendly financial models with macros. I have advanced modeling in finance with excel and vba by mary stauton and financial modeling with excel by simon benninga. I don't have a CS background, but am strong in all the other areas, math, stat, finance. Just for reference, I didn't lie and say I was a programming expert, they understand my level of understanding but I still want to outperform once I show up.
just pick up any book from the library that focuses just on VBA (benninga's might not be the best, then) VBA is a clumsy but straightforward language
....
from what i've heard, its kind of hard to just learn it out of a book. usually its just doing shit that isn't useful like making the wings on the MSN butterfly flitter or something. you should try to take some process that you do over and over again in excel and try to figure out how to automate it. VBA is just programming, so you can bet your ass that some computer geek somewhere put code to do just about everything under the sun out there. so i mean, you can just go to google and type in, "VBA code to insert a column," and shit like that, and just build processes like that.
also, if you can get ahold of any models and look at the code and see the syntax and how everything relates to everything else on the spreadsheet, that helped me.
but yea, from what i've seen / heard, learning by doing works best.
Best self study VBA-Excel material? (Originally Posted: 11/01/2014)
Anyone recommend a good self study VBA excel course?
I am also wondering the same thing, bump
-
Eaque qui quo dolorem quis ea. Quam neque in quia facilis. Dolores fugit amet explicabo sunt ut totam. Distinctio aperiam qui explicabo.
Quidem aliquid eos ab incidunt est et. Blanditiis repudiandae aut qui. Saepe dolorum provident quod reprehenderit temporibus ratione aut velit. Nihil possimus et alias voluptatem molestias cumque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...