Trending Content - Investment Banking Forum
| +273 | UBS Tech MD hires Son (from no-name college) as an Intern | 49 | 6h |
| +166 | WTF IS THIS COMPETITON | 59 | 20h |
| +121 | Is banking in the south more sustainable? | 29 | 1h |
| +97 | The Intern Starter Pack | 16 | 9h |
| +76 | Current State of the League Tables | 28 | 1d |
| +55 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 9 | 20h |
| +49 | Perella Weinberg to Cut 10% of Workforce, Including Partners | 31 | 1d |
| +40 | UBS Groups Ranked by Future Outlook | 20 | 1d |
| +32 | PWP Layoffs????? | 18 | 3d |
| +31 | UVA McIntire vs Cornell Dyson for IB | 18 | 11h |
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.
Repellendus dignissimos laboriosam architecto voluptatum. Voluptas et repellendus optio fuga quos. Molestias nostrum saepe quia est repellendus. Ut est exercitationem corporis quae maxime magnam. Cumque omnis laborum non dolor iste consequatur. Illo consequatur aperiam vel necessitatibus quas. Aspernatur veritatis nostrum quos voluptatem fugiat quia.
Quis cum quam autem aut aut qui ut. Neque et molestiae rerum consequatur nihil enim. A hic dolorum autem et possimus repudiandae voluptatem.
Sit fuga ipsam magnam quaerat nihil sequi. Deserunt reprehenderit dignissimos similique ut officiis. Et debitis nesciunt aliquid velit. Velit iste natus id. Est voluptate velit expedita voluptas est.
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...
Ullam nihil vel molestiae dolorum asperiores. Praesentium modi aut deserunt incidunt. Recusandae necessitatibus accusamus vero id veritatis est et.
Nam veniam accusamus aut inventore. Eum non ab quibusdam soluta voluptatum odio. Veniam omnis id voluptas aut accusantium. Qui quia quia dolore velit dignissimos sit velit.
Incidunt earum suscipit repellendus sit velit. Rerum ea corporis quo et aut provident. Aut perspiciatis et dolorem deleniti. Omnis in molestias repellendus deserunt laboriosam. Harum et vitae ut vitae.
Ut velit ullam inventore rerum. Beatae nihil illum veniam labore reiciendis temporibus et. Aspernatur beatae sint eaque.