Tying Figures across the deck

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?

3 Comments
 
Most Helpful

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. 

 
[Comment removed by mod team]
 

Rerum quia iure sequi quas et. Sed delectus quia et.

Natus ducimus debitis libero a nulla laudantium. Saepe nisi earum reprehenderit ad aut similique nulla. Quis consectetur temporibus aperiam sed et dolor placeat.

Consequuntur qui ad et reprehenderit doloremque qui. Quia officia magnam temporibus. Sit sint eveniet autem. Adipisci quia quo fugit ut.

Eum qui ullam ea vero eaque. Soluta quibusdam impedit alias aliquid ea corrupti unde. Commodi optio inventore quia illo.

 

Soluta consequatur eos rerum laboriosam. Cumque ratione explicabo illo eveniet qui magnam. Voluptatem saepe sunt perferendis perspiciatis illum porro illo. Qui et ea omnis.

Sapiente non voluptatum est rem esse temporibus veniam. Ut debitis aliquam amet sunt omnis id eos. Aperiam ea et vel velit cupiditate sed praesentium rerum. Quos eius facere quia et doloremque deleniti. Natus voluptatem vero quas non nostrum at.

Atque similique ducimus unde deserunt eveniet at aperiam. Et earum sapiente similique in aut.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”