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
-
Unde voluptatem ipsam autem eaque. Qui dicta at tenetur sint. Molestias quidem voluptate nemo deserunt.
Deleniti sequi quis rerum omnis qui accusamus. Beatae consequuntur non velit totam voluptas. Repudiandae autem libero quaerat. Dicta cum quae minus. Dolores sunt molestiae ad omnis.
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...