If you name your cells in Excel…

Seriously, fuck off. You can't change my mind in anyway for any efficiencies it brings. What a God damn headache and nightmare for anyone trying to update your model. Literally the worst. I don't need you to name the Property Name that is on the Assumptions page as "Property Name". Wasting my time trying to locate your 5000 dumb ass cell names in Name Manager.

Comments (10)

Tracer85, what's your opinion? Comment below:

I had a junior who once failed a modelling test because the interviewer told him "You didn't use named ranges." Think it was some infra group, so bizarre.


Pierogi Equities, what's your opinion? Comment below:

we do it in infra and I kind of hate it for the reasons mentioned here

Quant (ˈkwänt) n: An expert, someone who knows more and more about less and less until they know everything about nothing.

God's sanest cokehead, what's your opinion? Comment below:

There's three cases for a named cell:

  • Unit conversion (ex. $mm to # of employees)
  • Share price

People who assign terminal figures as named cells anger me.

tellmehowtoplay, what's your opinion? Comment below:

Thanks for flagging this out. 

the only names in an excel should be FX rate, unit changes. THAT'S IT. 

notaballer, what's your opinion? Comment below:

Et optio dolore est porro dicta quia. Distinctio debitis eligendi modi in iure et. Architecto ea ex repellat aut libero consectetur. Facere voluptas doloremque rem. Et sed veniam soluta aspernatur.

Omnis rerum et fugit doloribus non. Eos vero numquam quibusdam minus iusto. Sed consequatur blanditiis voluptates voluptatem. Consequatur quis sapiente aliquid commodi impedit similique voluptatem.

Dolorum voluptatem dolore sed odio necessitatibus. In sed repudiandae minima quidem est adipisci. Pariatur aperiam amet dolores error aut. Voluptatem velit dolore vel sapiente voluptatibus optio dolores.

Start Discussion

Career Advancement Opportunities

August 2023 Investment Banking

  • Lincoln International 01 99.6%
  • Jefferies & Company 01 99.1%
  • William Blair 13 98.7%
  • Lazard Freres (++) 98.2%
  • Financial Technology Partners 02 97.8%

Overall Employee Satisfaction

August 2023 Investment Banking

  • William Blair 04 99.5%
  • Lincoln International 11 99.1%
  • DC Advisory 05 98.6%
  • Canaccord Genuity 18 98.2%
  • Stephens Inc 11 97.7%

Professional Growth Opportunities

August 2023 Investment Banking

  • Lincoln International 01 99.6%
  • Jefferies & Company 01 99.1%
  • Financial Technology Partners 06 98.7%
  • Lazard Freres 15 98.2%
  • UBS AG 16 97.8%

Total Avg Compensation

August 2023 Investment Banking

  • Director/MD (6) $592
  • Vice President (32) $396
  • Associates (154) $260
  • 3rd+ Year Analyst (12) $195
  • 2nd Year Analyst (96) $169
  • 1st Year Analyst (299) $168
  • Intern/Summer Associate (48) $167
  • Intern/Summer Analyst (213) $94
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..."

From 10 rejections to 1 dream investment banking internship

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