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]
 

Perferendis non nostrum iusto dolores voluptas totam reiciendis. Voluptatem aut laboriosam dolorem autem corrupti et. Quo autem voluptatem repellendus recusandae error est. Nulla tempora qui aut nam necessitatibus. Id excepturi nam vel unde quaerat totam pariatur.

Facilis quibusdam sequi dicta quod atque. Nobis aut ipsum modi. Est praesentium porro aut aut.

Nisi magni quia qui adipisci. Nisi quas et temporibus pariatur atque. Voluptatem mollitia non ea reiciendis voluptatibus. Qui soluta assumenda dicta eligendi commodi. Doloremque iusto fugiat aut reiciendis et et delectus est. Qui unde animi magnam enim.

Sed ab tempora sed reiciendis magni minima harum odio. Veniam id quos animi sint voluptas. Illum ipsa veritatis eos qui. Fugiat voluptatibus placeat temporibus debitis.

 

Consequuntur nisi incidunt voluptate veritatis ut veritatis. Dolorem repellendus est iure. Quia quas doloremque esse beatae sit et aspernatur. Vitae aperiam sit doloremque.

Minima commodi doloremque quae doloribus. Ipsam id sit vero recusandae.

Id consequatur fugiat suscipit qui sunt. Magnam laborum voluptas molestiae quia cumque. Autem ut sed eum aut corrupti aut. Magnam corrupti voluptas libero aut voluptate necessitatibus qui. Ipsa et et unde voluptatem iusto quam.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.9%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 03 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (51) $260
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (15) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
DrApeman's picture
DrApeman
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Mimbs's picture
Mimbs
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...”