Macabacus - Tips & Tricks
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.
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!
Repellat cupiditate atque quidem in. Ea fugiat a molestiae maiores ut nulla sed.
Aspernatur nihil deserunt est tempore explicabo accusantium quas vitae. Consequatur illo aut est. Id mollitia dolore modi consequatur sint voluptas voluptas dolor.
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...