- My Forums
- Tiger Rant
- LSU Score Board
- LSU Recruiting
- SEC Rant
- SEC Score Board
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Financial modeling -- what to learn first
Posted on 6/16/13 at 11:17 am
Posted on 6/16/13 at 11:17 am
So I am looking to pickup some sort of programming skill and am trying to figure out what to learn first. My options seem to be java, c++ or become a master of excel. What do y'all think the best language would be to make me as marketable as possible in the financial and accounting world?
Posted on 6/16/13 at 11:31 am to reb13
quote:
What do y'all think the best language would be to make me as marketable as possible in the financial and accounting world?
If you plan on going into the O&G industry and doing modeling, learn the two you mentioned, Java and C++, but become an excel guru, especially with VBA.
Posted on 6/16/13 at 11:54 am to reb13
You really don't need to learn a programming language to become good w/ excel. I know enough VBA to write some macros but rarely use it.
Posted on 6/16/13 at 12:06 pm to Athanatos
I think my goal is to learn a language so that I can be familiar with it probably not even use it. I have just seen a lot of financial jobs that want someone who can at least understand what they are looking at. But they are vague about what exactly they want you to know.
Posted on 6/16/13 at 2:03 pm to reb13
Being a master in excel is first and foremost.
My list would be:
1) Excel
2) Access
3) SQL
I think an argument can be made to put SQL above Access...if you know SQL you probably don't need to use Access very often.
My list would be:
1) Excel
2) Access
3) SQL
I think an argument can be made to put SQL above Access...if you know SQL you probably don't need to use Access very often.
Posted on 6/16/13 at 2:11 pm to lynxcat
quote:
Being a master in excel is first and foremost.
My list would be:
1) Excel
2) Access
3) SQL
I would agree with this. And to be honest, I'd be willing to say you could along entirely with Excel in nearly all cases.
Posted on 6/16/13 at 2:12 pm to Athanatos
quote:
You really don't need to learn a programming language to become good w/ excel. I know enough VBA to write some macros but rarely use it.
Most of the people I know that use VBA in excel just create exceedingly complicated spreadsheets that serve no function and could have easily been created with some clever ingenuity within the basic framework of excel.
Posted on 6/16/13 at 2:17 pm to HurricaneDunc
quote:
I would agree with this. And to be honest, I'd be willing to say you could along entirely with Excel in nearly all cases.
Excel works for 95% of cases for someone doing financial analysis. Things like SQL are for database management which should be a precursor to actually doing financial analysis.
One thing that comes to mind that could be too much for excel is if you are doing transactional analyses for a major company. If you have 100 million transactions in a year...well, I don't think Excel is what you want to use to start that analysis.
Posted on 6/16/13 at 2:37 pm to lynxcat
Thanks for all of the input guys, looks like I will be looking harder in to excel. What piqued my interest was this it is a puzzle of sorts where you have to create a program to identify arbitrage opportunities. I thought it was very interesting and thought about giving it a shot.
Posted on 6/16/13 at 2:41 pm to lynxcat
quote:
One thing that comes to mind that could be too much for excel is if you are doing transactional analyses for a major company. If you have 100 million transactions in a year...well, I don't think Excel is what you want to use to start that analysis.
Well sure, but that's where SAP and business warehouse come in to play. For the analysis I do every day, I use Excel and Tableau (and Access only to union data sets occasionally). PowerPivot is starting to gain some traction, but I'm not a fan. I'd much rather Tableau.
Posted on 6/16/13 at 4:28 pm to lynxcat
quote:FileMaker Pro whoop whoop
database management
Posted on 6/16/13 at 4:52 pm to reb13
ExcelIsFun
Subscribe to this guy's youtube channel. Hands down the best Excel resource I've found on youtube. He has tons of finance related excel videos too.
Subscribe to this guy's youtube channel. Hands down the best Excel resource I've found on youtube. He has tons of finance related excel videos too.
Posted on 6/16/13 at 5:52 pm to rickgrimes
I am very interested in learning Tableau...it is the king for data visualization.
Ill be honest...I love getting back into Excel. I spend so much time in PPT that it is a breath of fresh air.
Ill be honest...I love getting back into Excel. I spend so much time in PPT that it is a breath of fresh air.
Posted on 6/17/13 at 10:43 am to reb13
I will ditto the sentiment that the solid base Excel foundation is the prerequisite for models and bottles moreso than a language.
The macros and advanced stuff we write/use are usually time-saver oriented or pure bells and whistles as opposed to critical model components.
A language is lagniappe, and parsimony can be a beautiful thing. It can be very frustrating to create a monstrosity and it not work or have to spend hours correcting a screwup in your build design because you wanted to overcomplicate things.
The macros and advanced stuff we write/use are usually time-saver oriented or pure bells and whistles as opposed to critical model components.
A language is lagniappe, and parsimony can be a beautiful thing. It can be very frustrating to create a monstrosity and it not work or have to spend hours correcting a screwup in your build design because you wanted to overcomplicate things.
This post was edited on 6/17/13 at 10:53 am
Posted on 6/19/13 at 7:54 pm to reb13
Has anyone taken a wall street prep course?
Posted on 6/20/13 at 6:13 pm to reb13
quote:
Has anyone taken a wall street prep course?
Tell me more about this....
...also, I learned as much as possible about excel. That has helped propel my work career.
I am the excel go to guy for the company I work for......that knowledge has paid significant dividends.
I have dipped my toes in SQL and gotten knee deep in access - excel is what I have needed.
Posted on 6/20/13 at 8:36 pm to reb13
I do financial modeling and agree with excel , access and SQL. Vba is very useful sometimes. Learn how to use excel PowerPivot and you can work with large data sets in Excel, but there are times when Access or t-SQL are a must.
Popular
Back to top
Follow TigerDroppings for LSU Football News