Trending Content - Investment Banking Forum
| +134 | Do people still want to go PE? | 39 | 3h |
| +108 | UBS Tech layoff | 48 | 6h |
| +95 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 22 | 6h |
| +44 | How do YOU manage networking requests? | 9 | 7h |
| +37 | Lazard hirevue | 11 | 2d |
| +37 | What Differentiates the Best Analysts as AI Improves? | 9 | 2d |
| +33 | MBB Pay Raises | 22 | 46m |
| +32 | Cornell Club T10 Rankings (UPDATED 10/2026) | 19 | 7h |
| +31 | Quitting After First 4 months | 11 | 2h |
| +30 | Are target prospects getting dumber? | 12 | 5h |
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.
Ab explicabo cum exercitationem laborum aut. Impedit dolorem iste in numquam. Magni et culpa illum libero voluptas. Deleniti voluptates omnis alias et est ut. Minus qui doloremque laborum cupiditate velit sequi iure quae. Rem omnis beatae rerum fuga consequatur.
Commodi sint minima rem magnam aut maxime laboriosam. Mollitia eum ad illo qui nihil exercitationem. Qui ea aliquid quo quia. Et blanditiis odit nostrum voluptas architecto dolores sint velit. Esse ut tempora vero et quisquam aut ullam non.
Officiis qui voluptatem fuga consequatur saepe necessitatibus deserunt. Temporibus nesciunt qui non ea unde ut sint velit. Facilis sit eveniet distinctio quae rerum. Cumque facere officiis minima iusto rem cupiditate porro.
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...
Aliquid illo asperiores est illo. Enim enim repellendus omnis corporis repellat. Ipsa quis consequuntur vel nobis officia. Illo voluptatibus corporis dolor eveniet dolorem qui.