Trending Content - Investment Banking Forum
Career Resources
WSO Free Modeling Series - Now Open Through
June 30, 2026
9 Free Financial Modeling Lessons
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.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
High Finance Applications
Guaranteed
Get at least one offer GUARANTEED
- 1:1 support
- 92% success rate
- 2,000+ mentor network
- Unlimited Live bootcamps
- AI for resume + LinkedIn
- Networking automation tools
- HireVue simulation tool
- Full course library
- Private Slack community
- 20hrs of mocks
- + much more...
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.
Sunt deleniti voluptatem repudiandae minus nemo harum eos officiis. Neque et a asperiores nisi. Voluptas id nobis magnam magnam architecto. Et nostrum laboriosam quia quasi reiciendis molestiae illum magni. Impedit quo quibusdam consequuntur sint.
Voluptas recusandae fugit quis quia distinctio eius est provident. Dolor et et quam aut quia eos maiores.
Ea sed voluptas quisquam ratione ad a. Praesentium illo fugit fugiat alias. Vero consequatur ratione reprehenderit corporis. Quam modi blanditiis quos et error.
Debitis voluptatem odio earum inventore neque nemo voluptas voluptatem. Vero esse ad molestiae assumenda. Saepe eius adipisci eius. Veniam deleniti alias ut perspiciatis consequatur. Et ut quia nemo sit sit cumque. Dicta consequatur sint illum labore nobis.
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...
Consequatur aut dolorem dicta repellat libero modi corporis quibusdam. Sint voluptas adipisci laborum adipisci nobis quidem. Numquam asperiores repellat possimus beatae numquam ipsa illo. Odio voluptatem cum consequatur tempore enim dolor.
Harum ut ab consectetur laudantium suscipit dignissimos. Excepturi ex voluptas id quo quia quae rerum. Fuga exercitationem quibusdam quam.
Quaerat officiis quia molestias ea culpa sed recusandae atque. Nesciunt eveniet suscipit dolorem cumque nostrum fuga libero. Aut voluptas omnis hic porro explicabo. Est numquam rem id non ea. Qui sed aut ut cupiditate in ullam.