Reddit reviews Financial Modeling
We found 8 Reddit comments about Financial Modeling. Here are the top ones, ranked by their Reddit score.
The CD is included and has never been used.
Reddit reviews Financial ModelingWe found 8 Reddit comments about Financial Modeling. Here are the top ones, ranked by their Reddit score.
Though it depends on the area of finance you are in, VBA is a very good place to start out. You already know Excel and I bet it would be an easier sell at work to start using some homebrew macro rather than something else.
If I where you, I would pick up Financial Modelling by Simon Benninga. It's not focused heavily on VBA but does use it where relevant - this just shows that you really don't need VBA for a lot of finance applications anyway (you can do a lot with functions only!). Pick up any Excel/VBA book for the things that Benninga does not cover. A book similar to Benninga is Advanced Modelling in Finance
using Excel and VBA, which I'm not as familiar with as Benninga but it does seem more focused on VBA, if only slightly.
You mention databases, which would be another direction you could go in. Your biggest hurdle will probably be to convince someone to give you access to a database with relevant data - at least while you are still learning. Not to mention that on top of having to learn something like VBA to access the database, you will also have to learn SQL to query the database for data. It's not out of reach but perhaps a bit of a learning curve. I would suggest you find out if your company has something like a Enterprise Data Warehouse or any other databases where you are allowed to hook up and get data from.
Check out Financial Modeling by Simon Benninga. Great book that teaches you how to build financial modeling in Excel AND learn financial analysis.
Edit: I also suggest you ask /r/finance for more recommendations.
This isn't just corp. finance exclusively but is a good resource:
http://www.amazon.com/Financial-Modeling-Simon-Benninga/dp/0262026287/ref=sr_1_1?ie=UTF8&qid=1341272476&sr=8-1&keywords=financial+modeling
The absolute best resources that I have found for integrating finance with Excel are the books by Simon Benninga. I really wish that they would have taught using his books in school (nearly all of the work I do is Excel based). They can be a little pricey, but I have found that they are more than worth the cost. If you are an absolute beginner and not completely comfortable with beginner financial concepts (or how to implement them in Excel), start out with his Principles of Finance with Excel. If you have a fairly solid grasp of basic financial concepts his book Financial Modeling is a probably the best resource that I have found for building a solid foundation in Excel. One caveat is that the Financial Modeling book is that it is written for pre-Office 2007, so you may have to make some minor adjustments to some of his formulas in newer version of Office.
For more advanced concepts, I have really found the Bionic Turtle channel on YouTube pretty usefull.
Good Luck!
I highly suggest this book: http://www.amazon.com/Financial-Modeling-Simon-Benninga/dp/0262026287
It's my current textbook for my Financial Modelling course...actually have a huge project due tomorrow....should be doing that but here I am on reddit....
It's not online so I apologize, but it comes with a CD with preset Excel Models on it to get you started so you can learn some good excel tips and stuff.
Check out Simon Benningas book....Financial Modelling
https://www.amazon.co.uk/Financial-Modeling-Simon-Benninga/dp/0262026287
One of the best books around for this topic for sure.
This one?
https://www.amazon.com/Financial-Modeling-Simon-Benninga/dp/0262026287
Go ahead and save yourself from future ribbing in here:
https://www.amazon.com/dp/0262026287/ref=cm_sw_r_cp_apa_PI2YAbGKRJSHG