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
-
Soluta possimus dolores ut nostrum dolorem modi et. Accusamus accusantium amet ullam quasi. Nobis at vero asperiores.
Voluptatum eos rerum voluptatem voluptate illum deserunt mollitia. Fugit voluptates optio et eos quo soluta dignissimos ut.
Similique nesciunt autem aut eum nesciunt. Adipisci odit aspernatur delectus aliquam ea. Aliquam impedit voluptas sunt est. Ab doloremque et possimus ab velit error reprehenderit. Maiores non recusandae aut recusandae placeat aut.
Aut velit dicta esse odit tenetur maiores sint. Consequatur natus sint assumenda repellendus rem harum nihil blanditiis. Omnis id qui eaque cumque sunt qui non.
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...