Serious question. When you output your valuation into ppt decks, how do you do it? Paste as image, paste as text with formatting, paste as image with macabacus, or what?
The letters and numbers always get so disoriented when pasting as image, people at the firm don't seem to mind, but it's always so annoying personally seeing the letters stretched or clustered together. Any way to avoid this?
| +446 | Change My Mind: Banks Shouldn’t Hire Foreigners at All | 117 | 2h |
| +267 | Article - UBS’ Investment Bank Keeps Losing Ground | 36 | 12m |
| +210 | Don’t work at UBS - UBS Sucks | 19 | 20s |
| +81 | An Exhaustive Guide: How to Solve Every Single Accretion/Dilution Question | 7 | 1h |
| +59 | When to Leave Office as Intern | 8 | 2d |
| +44 | Best IB Group Overall? | 27 | 2h |
| +38 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 2d |
| +31 | STEM student lost in London IB recruiting | 17 | 1d |
| +30 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 23 | 18m |
| +23 | Should My Intern Get a Return Offer? | 9 | 2h |
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.
I prefer paste as image. My current firm prefers to link, which is super frustrating because links break all the time which means a lot of our older PPTs are unusable. You open them up and all the excel outputs are broken because the master file path changed….
It depends what your are doing. If I'm never recreating this same chart again, I paste as an image.
If this is a simple chart which I will be updating on a fairly regular basis, I embed the data but of course not linked to the original spreadsheet.
Paste as enhanced metafile. Lot more convenient.
In excel, Macabus has an export as table button. It's amazing I always use that. Will automatically take whatever you have highlighted and export it into whatever PPT slide you are currently on.
Wtf? You guys don't use PresLink?
Big fan of macabus
FS PressLink
At my bank we use UpSlide for all exports
Upslide is the GOAT, all places should use it. Genius and saves a ton of time.
Haven’t heard of this one!! Will check it out
We just have all output formatted in our models so we just paste the numbers from that into the template we have in ppt. Takes like less than - min to update a valuation slide
If it’s a part of a large deck I prefer to paste as an image to keep the file size smaller. But if it’s a smaller deck I like to paste in as a live sheet so if I need to make formatting changes that I normally wouldn’t want in the master excel file I can do it live in the PowerPoint slide (like removing grid lines or changing headers to make them easier to understand and flow better with verbatim in the rest of the presentation) only downside to this is that it makes your PowerPoint file size huge if you are doing this across a 50-70 slide deck.
So it seems like there is no "one standard approach" to this? Personally, I prefer to paste as chart with formatting, and then format the letters in the slide. Some people judged me in the office for this, but my numbers just look so much cleaner
Paste as img just because as a precaution and I am paranoid other ppl can go into the deck accidently misclick/type over the numbers to override which will mess me up when upper checks and say it's all wrong. Guess who gets the blame? Of course not me, I am blaming the analyst =)
We have a couple of PPT macros that help quickly paste excel tables and size them up the way we want it.
Alt H C P P
Eos dicta aliquam esse facilis ipsum. Deleniti omnis at provident a aut aut voluptas. Consequatur ut excepturi ullam qui.
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...