I'm finishing up my senior year of undergrad and will be beginning an MSF program this summer.
As I work on a project for my final undergraduate modeling class, I realize I have no idea what kind of excel plug-ins (if any) everyone uses on the Street. I had a boutique internship where I experimented with a few different ones, namely Macabacus and ASAP utilities. I figure it couldn't hurt to get used to whatever is most commonly used.
What excel plug-ins (free and paid) do you guys prefer/are required to use for work?
Thanks in advance.
EDIT: I'm mainly asking about productivity plug-ins involving macros, CapIQ is a given for data.
CapIQ
I guess I didn't clarify ... besides CapIQ. I meant more of a productivity plugin.
You could take a look at Macabacus. Aside from having a great site full of useful information, they also make a plugin geared towards financial modeling. The free version is pretty good in my opinion.
http://www3.wabash.edu/econometrics/EconometricsBook/Basic%20Tools/Exce…
Nice! I really like the Monte Carlo Add-In. Not too helpful in my current job, but would have been great during the MSF
I'm buying new notebook PC. Need to run MATLAB and Excel. Which OS - Windows 7 or 8?
glad to see the name of Wabash pops up on WSO...
Hi, I am a long-time reader but it’s the first time I post here. I know of the following add-ins:
Veodin KeyRocket: it monitors your mouse actions and then suggest possible shortcuts. I paid $20 but they recently increased the price a lot. It analyses your progress
Macabacus Lite. Free and convenient
Boost: I used until the free trial expired and found it very good, similar to Macabacus. Both Macabacus Pro and Boost retain CTRL Z functionality. Both are expensive if you are an individual, IMO.
AMT Add-in for Investment Banking: Shortcuts and other actions for Investment Banking modeling. Free but I haven’t tried it
Spreadsheet studio: Add-in for audit. Free and very convenient to analyse the spreadsheet’s structure. Works with Excel 2007 and 2010. An update for 2013 will come according to the website
I know that F1F9 has another Add-in for shortcuts and modeling but I couldn’t find it and I haven’t tried it either. If you take their 31-days online course I’m sure you will find it among the lessons.
Wall Street training has another one.
To sum it up, for me the most attractive are Boost and Macabacus but as I said before, those are the only ones I have used, besides KeyRocket
I use the PitchBook add-in that I got through business school. If your business school doesn't offer it, then I would think it is very expensive. But they may have a free version. A couple of things I like about it.
These are just a few of the things that come to mind. It can be as high level and detailed as you want.
Cheers,
MB
Similique autem omnis consequatur quia voluptas cupiditate. Beatae praesentium omnis est est voluptate dolorum. Et dolorem consequatur et nostrum aliquid labore vitae qui.
Repellendus ut maiores mollitia consectetur. Architecto quis saepe ducimus cum est occaecati sit. Aut repudiandae aperiam consequatur provident. Nemo esse ea voluptate totam adipisci illum.
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...