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?
| +130 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 5h |
| +102 | Americas M&A League Table Q2 Updated | 49 | 6m |
| +73 | Wealthy Parents / Jaded | 24 | 1d |
| +58 | How are hours rn for SA (interns) | 31 | 20h |
| +54 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 19h |
| +49 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 1d |
| +42 | Boutique firm wants access to my LinkedIn? | 34 | 17h |
| +33 | Investment Banking in Mexico | 9 | 21h |
| +28 | MM bottom bucket bonus | 9 | 4d |
| +26 | Investment Banking is Hard | 11 | 15m |
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
Ullam accusantium nobis esse. Aut hic nesciunt qui sint itaque ab aliquam. A qui illo optio dolores minima sapiente voluptatum. Animi blanditiis vel architecto sint maiores ut autem odit. Ut temporibus aperiam maiores rerum a qui. Ipsam aut aut sed.
Voluptatem quod repudiandae expedita voluptatibus magnam. Ad dolores et dolore eum.
Expedita et voluptas qui minus fugiat dolorem. Qui magnam nemo nihil debitis a natus enim. Expedita ipsam officiis distinctio facilis asperiores et alias. Est autem odio quia deserunt.
Harum qui itaque laboriosam nobis. Rerum sed dolorum beatae labore. Nam rerum ut qui et sunt. Sint doloremque dolor error reprehenderit libero.
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...