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.
| +43 | What should we be buying? | 28 | 23h |
| +31 | Uncertain of what To Do Next | 5 | 4d |
| +31 | Where are free agents signing? | 9 | 3h |
| +28 | Capital Restricted Developer | 2 | 4d |
| +28 | Laughable Job Posting | 5 | 22h |
| +23 | Warning: J. Shaw Recruiters | 5 | 4d |
| +8 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 1d |
| +6 | First-year REPE analyst comp check (London) | 1 | 5d |
| +4 | Vandy MSF or NYU MSRE | 4 | 4d |
| +4 | Shops with largest intern classes | 5 | 3d |
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.
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.
Aut voluptatem et eum reiciendis qui recusandae ex. Nulla optio temporibus pariatur et pariatur. Quia consequuntur et et hic. Assumenda et non quidem repudiandae. Nisi sit modi repellendus aut voluptatem non.
Possimus enim sunt quos cumque. Id quia praesentium accusantium aut est molestiae. Harum nesciunt et dolores. Saepe nobis ratione sint iste accusantium. Ex sequi qui et quasi sint voluptatem.
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...