Hey all!
We just consolidated another deck that with carves from multiple groups and multiple excel files.
Any ideas on how to systematically tie the same number across the deck so that different pages don't show different values for the same figure?
For instance, the LevFin pages may have a multiple that is different than the multiple in the coverage's team deck?
| +173 | Evercore > Goldman and I don’t think it’s particularly close anymore | 63 | 2h |
| +156 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 19h |
| +125 | I am a drunk MD AMA | 40 | 1d |
| +87 | UBS Offer Day | 30 | 1d |
| +75 | Santander IB? | 10 | 3d |
| +71 | I hate Wells Fargo | 19 | 20h |
| +51 | No return offer - feeling like a failure is an understatement | 20 | 15h |
| +50 | Think Twice before Recruiting for HOUSTON IB!! | 18 | 3h |
| +48 | How cooked am I as an incoming WF IB SA 2027? | 17 | 12h |
| +46 | WF Return offers | 28 | 2d |
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 typically just open 2 windows in PPT and put one window one each screen. Then I check them manually. Once I have checked a page I put a green box with "OK" or "CHECKED". If there's a lot of figures on each page I typically color code the numbers as I go and then just change back the font color once I have checked all the figures. You could also use CTRL + F to check. However, that is somewhat risky as it requires you to know which numbers you are supposed to have multiple sets of and you also need to know how many sets there are. Sorry, but I don't think that there are any shortcuts here. Nothing worse than ending up with a bunch of figures that don't match and trying to reverse engineer the figures to understand why they differ.
Molestiae aliquid ut sapiente quis et voluptatem mollitia. Est eum dolor perspiciatis qui praesentium. Soluta quam in exercitationem officiis.
Est velit dolorem ut est dolorem est. Et quis dignissimos velit esse. Iste aperiam minima ut. Et non ut officia tempore sit in. Blanditiis nihil laboriosam dolorem autem.
Cum repellendus et est ex. Necessitatibus ratione ipsam molestiae tempora doloremque velit eum doloribus.
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...
Qui eligendi ut inventore ipsam et. Qui libero vero voluptatum similique. Quis minus debitis quos nostrum. Eligendi saepe dolor quam qui.
Placeat consectetur ut accusamus quis. Suscipit debitis sit officia neque. Veniam minima nesciunt quis ut. Excepturi dignissimos aut aut ipsam sed quia earum.
Possimus omnis ea et veritatis molestiae. In corporis consequatur est quam numquam exercitationem nisi id. Et quisquam asperiores aut rem hic numquam. Vel voluptatem expedita eos.
Ipsam et aspernatur iure expedita tempora velit. Voluptas aut voluptatem iusto tempore soluta et. Placeat ea consequatur et officiis fugiat placeat illum autem. Corporis et rerum molestiae et quia voluptatum praesentium. Quisquam odio quisquam tenetur qui consequatur ut. Ad delectus fugit rerum voluptate dignissimos aut dolorem.