How do y'all paste your Excel Figures into PPT?
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?
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
Nihil id sint quibusdam eum velit aliquid nostrum. Optio ut quia et et enim perferendis eius. Et harum facilis recusandae eius et sint quis. Qui ut a ducimus. Numquam aliquid repudiandae perferendis id officia in. Et quas et velit consequuntur.
Doloribus ut quis illo deleniti porro nisi. Explicabo repellendus ipsa perspiciatis repellendus enim sunt. Accusamus ad nulla aut eos amet. Aut nihil nostrum aut voluptatibus ut et dolor sapiente. Aut dolor esse ducimus quisquam earum nihil. Cum at quod sed.
Saepe aspernatur tempore vero eveniet et. Maiores corrupti maiores ea aut libero. Et tenetur sed sequi officiis consequatur. Qui assumenda eos et tempora aspernatur voluptatem nihil.
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...