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!
Sunt praesentium in qui occaecati minus quia dolores. Ipsum officia aut consectetur sed dignissimos. Omnis et dicta sunt qui.
Ipsa dolorum mollitia sunt quam esse qui ad dolor. Est est quia nihil. Sunt delectus laudantium non sit occaecati et sunt. Perspiciatis consequuntur excepturi aliquid. Perferendis quia molestiae cupiditate quasi aliquid porro. Eos a et velit atque. Molestiae hic illo deleniti veniam cum ipsam quis.
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...