Trending Content - Investment Banking Forum
| +200 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 50 | 9h |
| +101 | IB Energy Drink Tier List / Ranking | 70 | 1h |
| +88 | PJT M&A Group Selection 2026 | 13 | 1d |
| +73 | ONLY THESE BANKS OR YOU STRUCK OUT | 28 | 9h |
| +34 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 23 | 2d |
| +33 | Firm Thinks I'm Lying About Offer | 12 | 8m |
| +28 | Does BofA still pay its associates rat pellets? | 14 | 1d |
| +26 | Stay at Weak Dealflow Team or Lateral? | 6 | 11m |
| +19 | Updated JPM Group Rankings | 31 | 11h |
| +19 | VP Deal Origination Credit | 2 | 1d |
Career Resources
Ctrl + beer + Friday
Ctrl + Shift + sex
Alt + music
I was going to write something but it will be hard to top that one
building a match function into an index function
YES...and if you throw in a SUMIFS, hell, you can rule the world...
I use mac's so its gotta be
CMD + BJ
XIRR, especially when I like the result ;)
Proper()
blew my fucking mind.
Second this. And the match & lookup combos.
Also like the iferror(). No more long-ass IF statements combined with iserror, isnumber, isna...
Just found out about iferror() messing around in excel today. Felt like a boss.
yes yes, iferror is fucking boss.
Trim()
=bahttext(number)
=today()
I had this question asked during an interview, believe it or not. I answered with CONCATENATE. The interviewer had never heard of it so I think he was a bit thrown.
Command Q...means I am done for the day.
Ctrl-Z
I really like the {v,h}lookup and match like functions :)
only on WSO will there be a thread about your favorite excel function
hate em all
Is it sad that we've already had a 100+ post thread on excel shortcuts?
http://www.wallstreetoasis.com/forums/keyboard-shortcuts-im-a-huge-nerd
GetPivotData() is my baby
sumproduct!
I would say Proper () and Sumproduct ().
index(match())
Try INDEX(MATCH(),MATCH())
So much time saved.
Alt + F4 at the end of the day
Paste Special -- is this even a question?
God bless Iferror and Alt+E+S
Frankly don't get all these antiquated shortcuts. Does nobody use alt+h+v+f/r/v ?
boost power fill
F5 Alt+S O, X, G, E
Selects all hardcoded cells
love it!
F5 Find and replace: Ctrl + h
some other favorites:
=trim() =substitute()
=code()
... and when trim doesn't work: Ctrl + h, find alt + 255, replace w/ " ". Gets rid of strange leading characters you cant' see. now trim works.
Learned Ctrl+Shft+arrow key and alt+e+s on the same day. That was an awesome day.
Molestiae illum ipsam dolore. Dicta voluptas tempora ullam quia. Sed vitae aut autem sapiente laboriosam eaque. Tempora quaerat nostrum architecto vitae aspernatur quisquam nesciunt. Aut id est sunt ut deleniti animi. Voluptatem quos totam neque quia. Enim non et voluptatem assumenda nobis et.
Molestiae in quia mollitia. Est et velit magnam accusamus id. Voluptates non tempore et ea quam. Magnam minus ut harum tempora aut occaecati.
Deserunt ex quod blanditiis reiciendis velit. Dolorem minima quibusdam doloribus. Doloribus quia fugiat error quisquam soluta. Asperiores quia sint nihil. Eum est assumenda quia. Optio rerum recusandae eum eos.
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...
Nostrum explicabo voluptas dolorem. Sint est quae qui quia impedit fugiat aliquam rerum. Et veniam ad est sint hic reiciendis aliquam. Accusamus ipsam quibusdam qui sint omnis sint. Sint enim deserunt nesciunt alias aut. Quae recusandae sint vel veritatis perspiciatis dicta.
Qui commodi velit at eaque cum. Dolorum voluptatem aut eos sunt. Suscipit explicabo numquam nihil optio iste esse incidunt. Vero velit hic dicta maxime non aut.