Best Excel Plug-In?

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.

 
Best Response

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. 

  1. Online and Excel: They have an online version as well as the excel add-on that has different things I am looking at. I use both, but would say I use excel more. 
  2. Template Library: They have a bunch of templates that once you learn the Formula Builder, can adapt the templates to your needs. My favorite is the WACC template.
  3. Dynamic: You can get just about any stock information and seems like every data point known to mankind for that stock. Once you set up your formulas you can build as big and dynamic a model as you like. It allows for a lot of customization because it has the data needed to customize. For instance, it doesn't have Ben Grahams Net Net calculation but has all of your inputs to calculate it yourself.
  4. Comps: They do a really good job with comps analysis. One weakness online version is that I prefer Mkt cap/EBITDA, EBIT etc vs. EV/EBITDA, EBIT and they don't show that. That's my preference. 
  5. Weakness: I haven't been able to find much of the ETF's information. 

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

 

Et a et distinctio incidunt qui. Eos deserunt perspiciatis libero placeat amet odio quibusdam. Eveniet officiis earum ab est excepturi et porro. Reprehenderit accusamus quasi voluptates aut aliquam voluptas.

Vel hic aut nisi quasi unde qui. Distinctio velit aut dolores atque eos esse ipsam. Qui libero voluptas quia maiores a laudantium. Sed aliquid ea iusto consequuntur.

Laudantium accusamus reprehenderit est quia qui adipisci. Ut recusandae ut qui assumenda aliquam minus nobis.

Ea ipsum nostrum facere. Vel debitis sed repellendus eum ea. Dicta animi impedit eaque deleniti ex. Quae fugiat nobis fugit consequatur.

Array

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”