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.
Will never understand what reason these psychopaths do this.
They're trying to be coders so hard. Because if you *don't* clearly label your variables when coding you are a psychopath.
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.
we do it in infra and I kind of hate it for the reasons mentioned here
Literally the worst modeling policy ever, makes it an absolute fucking nightmare to audit for anyone who isn't already intimately familiar with the model. Should be removed from excel completely.
There's three cases for a named cell:
People who assign terminal figures as named cells anger me.
I use named cells to separate sections in models with shitloads of tabs so I don't have to spend 2 minutes spamming ctrl pgdn
Thanks for flagging this out.
the only names in an excel should be FX rate, unit changes. THAT'S IT.
Agreed. Thats why i was never a fan of BIWS training.
I love defining thousands and millions to save time with converting units and also factset auto colour is correct when these are named, otherwise they turn red, which is a pet peeve
its a best practice when using macros. ex: breaking circularity with a copy/paste macro
WSO modeling course?
Naming in Excel could be very useful if done correctly… unfortunately people still uses Excel at its low minimum capability (spreadsheets and formulas) while there’s a lot of power in it if you start to play with PowerQuery, PowerPivot and, most of all, you link your Excel database in PowerBi… these tools gives you access to an entire new world
The only genuine cases where a named cell makes sense is if you have something at the top of a sheet that gets referenced a ton. Like WACC/COE, something related to a macro, or a hard coded input that is used more than 20-30 times.
Otherwise just hit F4 lmao
It causes unnecessary bloat as well.
Use the Macabacus name scrubber. It unapplies all the names and then purges them.
Doloribus ipsam corrupti unde dolore. Eos et ea nobis eum. Occaecati incidunt commodi eum officia corrupti facilis.
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...