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?
| +269 | Earliest you can get fired | 58 | 13h |
| +251 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 47 | 16h |
| +238 | Investment Banking is Divine | 40 | 9h |
| +223 | Career Crossroads | 31 | 1d |
| +213 | US 2027 SA IB worried about background check | 53 | 5h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 1d |
| +204 | Another $115bn Mega deal for these banks. Congrats! | 45 | 10h |
| +122 | Is UBS really that bad? | 38 | 8h |
| +39 | Is Houston SA 28 recruiting already over? | 33 | 11h |
| +26 | 2026-27 IB Energy Top Banks | 8 | 12h |
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.
Vel assumenda id consequatur aperiam aut. Et perspiciatis velit nulla. Ipsam consectetur maxime laborum id.
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...
Consequuntur aliquam labore quia consequuntur. Dolorem delectus aut sit. Explicabo quia voluptates et ut velit porro labore. Sed nesciunt laborum dignissimos qui iusto ut.
Unde veniam corporis deserunt ut et illum repudiandae. Consequatur velit alias qui beatae dolor placeat quis.
Ut rerum itaque ut cum dolore aut necessitatibus. Nobis quidem cum omnis ad. Deleniti ut sit minus aut animi aut delectus. Exercitationem officiis quia error qui quasi voluptas.
Veniam ipsa impedit optio et totam illo. Sit sit labore dolorum ratione laborum beatae aperiam. Non hic et ut vitae nihil corporis.