Favorite excel shortcut?
Was asked in an interview "What is your favorite excel shortcut?"
I responded, "ALT+A+S+S = Sort".
Any other favorites out there?
Was asked in an interview "What is your favorite excel shortcut?"
I responded, "ALT+A+S+S = Sort".
Any other favorites out there?
| +416 | Is UBS really that bad? | 76 | 40m |
| +259 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 5h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +54 | Useless associates | 11 | 4h |
| +48 | Differences in Restructuring Teams? | 24 | 1h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +36 | How do you manage nerves in IB technical interviews? | 8 | 8h |
| +34 | FIG Pigeonholes you - is it true? | 13 | 1h |
| +34 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 6 | 34m |
Career Resources
ALT+F4
Alt + f + h + e + a = send that mofo model out and hit the clubs
Its not excel, but control+alt+delete and then enter, followed by me quickly walking out the door to my car is my favorite shortcut.
Save time by doing the windows symbol button + L. Save even more time by setting up a mattress outside and hopping out the window. You'll be in your car before you know it.
alt + e + s + (v,t,f,x)...paste special always comes in clutch
I was going to say ALT + E + S + T, makes my life so much easier
.
Hit them with an Alt + L + DM or Alt + L + I + U and use it to mention that as a VBA God you can automate much of the work
CTL + Alt + Left Arrow
Ctrl + V
F1
ALT + Tab to Outlook, CTRL + N, type up email to analyst, ALT + S. Model done.
Any time I receive a model, ALT + M + N (Name Manager) and look at the shitshow of broken links to desktops of the client and other banks, cell names like "fuckbanking," "ebitda" (12 times) references to old versions of models or another deal entirely, etc.
If you haven't tried it, I strongly recommend it.
This is too true. Blows up your model size as well.
Highlight all constants: F5 + Alt S + O
Highlight all formulas: F5 + Alt S + F
Any of the Alt + E + S paste functions.
Alt, A, E, Enter, Enter, Enter
It get's rid of those stupid green triangles that pop up on cells.
CTRL + C, CTRL + V.
Alt + H O T
Gotta make sure those tabs colors are in order. Also useful for picking up hardesses.
ctrl + windows + Q
Est vitae et tenetur delectus aperiam iste. Cum iure quo temporibus molestiae.
Beatae tenetur eum molestiae maxime voluptate sunt. Enim corporis delectus voluptatibus laboriosam quia sit aperiam.
Maxime et neque molestiae consectetur. Quia nisi ut culpa eius est sunt. Enim qui possimus voluptatem dolorum nemo recusandae rerum. Explicabo reiciendis aperiam nobis ut sit.
Nesciunt quibusdam reiciendis sit dolores. Saepe deserunt molestiae velit consequatur eum. Quas nihil quia aut. Adipisci quis dolor sint voluptatum id aut. Id eos qui blanditiis quis quas architecto doloremque. Dolor ipsa eos dolores quod blanditiis aliquam.
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...
Praesentium beatae consequuntur aut eligendi. Deserunt voluptas et sequi iure ut assumenda eius. Eos ea ullam voluptatibus consequatur. Unde aut id fuga adipisci pariatur. Dolorum facere voluptatem velit molestias soluta. Expedita aut corporis placeat deserunt dolorem quam nihil.
Tempora nihil consequatur necessitatibus dolorum placeat nemo. Nam laudantium deserunt exercitationem magni nobis. Nihil mollitia qui consequatur quis. Cumque odio qui non impedit quo magnam voluptatum. Consequatur aut ullam laudantium. Et sint et placeat totam.