For those of you that use Macabacus, what are some of the functions you find most useful? I’m trying to make sure I’m utilizing its full capabilities to become more efficient. And even more specifically I’m curious what is most useful in:
1) Excel 2) PowerPoint
Thanks ladies and gents.
| +43 | Lateraling at senior associate / VP level | 15 | 11h |
| +27 | Imposter Syndrome: PE to Publics | 4 | 3d |
| +26 | Ares buying LGP...now what? | 8 | 2d |
| +19 | Do PE VPs Always Have An Associate Under Them? | 12 | 2d |
| +17 | GTCR vs BDT MSD vs MDP | 16 | 1d |
| +16 | Hours at MF Infra Funds in London | 2 | 19h |
| +14 | Setting the right LBO entry multiple without information | 3 | 6d |
| MBA to EM Infra Investing? | 3 | 3d | |
| +11 | Committing to CD&R? | 6 | 8h |
| +11 | London Version: PE Check-in on Attrition, Promotions and State of Play | 6 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Auto colour code for hard codes etc. and trace cells.
Great for when you get a piece of sh*t model - which is common in MM PE.
Tracing dependents and precedents (Ctrl+shift+ [ or ])
Pasting in charts, tables and graphs using the plug in for PowerPoint is clutch when refreshing numbers
If your shop still does IC memo's in word, text linking all your model numbers/assumptions to your excel into word saves me so much time.
I dont really use macabacus for PPT, besides the refresh button for excel paste ins.
for excel, Ctrl Shift 1 for number format, auto color like someone said, file size reducer sometimes, trace dependents / precedents are the main ones.
sometimes I'll use the error wrap function also.
Ctrl shift R for fast fill right (although this might be Cap IQ hot key?)
3 key functions for me are :
Tracing dependents in a a detailed manner
Export charts/tables etc from excel to PowerPoint and refreshing everything quickly without having to 3x chec everything
Flattening the excel files to share with external parties
I wish there was a versioning functionality with logs (who did what, were and when) for some files that we have more than 1 guy working on
I agree with pretty much everything already mentioned here, so I'll only add a few new ones I like.
Excel:
PPT:
Nice, very helpful. Thanks all!
Simply formula function - index match to raw data, simplify formula which converts index match to direct links
This is huge actually. This will help when handing models off to someone who doesn’t know the ins and outs. Thanks!
Id dolor consequatur aliquam sapiente. Fugit rerum voluptatem minus voluptatem dolor. Non suscipit et quasi ab ex.
Ipsam delectus rerum fugiat magni ut veniam facere recusandae. Maxime esse qui assumenda ullam maxime. Explicabo nihil cum unde neque quia. Labore commodi est nulla aliquam.
Vel illum perferendis alias voluptas omnis. Velit vel illum quo voluptatem quaerat neque dolores. Suscipit vel velit aut iste quis dolor aut. Dolor repellat est id et necessitatibus labore omnis. Beatae numquam qui eveniet corrupti ut. Magnam voluptatibus libero eius mollitia impedit eos. Ipsum consequatur reiciendis quia autem asperiores aut.
Iusto sunt non consectetur ipsum minima. Fugiat quo aut harum est.
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...