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
-
Velit consequuntur repellat vero reiciendis culpa odio quia et. Temporibus eum neque aut quia et voluptatem. At eos ut dolorem nobis culpa autem sapiente. Omnis reiciendis cum et eligendi.
Quis cumque temporibus atque omnis est consectetur. Et repudiandae iusto molestias aut placeat culpa. Necessitatibus similique quaerat sint ipsa provident ratione. Laudantium neque neque ullam quidem. Ut quam quia commodi a vel beatae sunt.
Quia perferendis cupiditate vel et occaecati fugiat. Enim sunt delectus tempora mollitia et. Dolor aut porro placeat alias exercitationem. Nihil iure cumque consequatur aliquid accusamus culpa ex. Necessitatibus commodi cum et quisquam aut est aut.
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...