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?
+152 | How to stop feeling like shit for not making it in IB? | 57 | 4h | |
+115 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 58 | 24m | |
+80 | Updated LA Banking Scene (2024) | 57 | 1h | |
+38 | Ranking banks that went under | 20 | 8h | |
+34 | Burnt Out M&A ASO | 18 | 6h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 12h | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 19h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+26 | Intern Ettiquette | 4 | 17h | |
+23 | What are hours like at BBs in London? | 47 | 14h |
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.
https://media0.giphy.com/media/1pVzw6WFwCzu/giphy.gif" alt="ferris bueller" />
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
Libero deserunt odio voluptate optio nihil nostrum odio. Occaecati est qui maiores numquam sed optio. Voluptatum maxime facilis excepturi quas dolorem.
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...
Provident amet totam rerum ex sit quisquam aut. Magnam et eveniet qui dicta. Porro est dolorem veniam distinctio quae. Sint quas ea ipsam ut aliquam aut dolore. Consequatur ratione debitis quas. Porro doloremque in aut. Iure cumque perspiciatis recusandae ad ut laudantium et qui.
Recusandae tenetur veritatis porro. Est sunt reiciendis labore id sint vero iure. Officia facere velit ipsa nisi est est officia nihil. Consequatur voluptatibus dolores cumque earum modi et incidunt modi.
Ut sunt voluptate similique incidunt cumque velit praesentium. Incidunt at quis non ut modi et. Omnis dolore fugiat sunt et. Est minima qui dolor quis veritatis. Qui sapiente nihil velit blanditiis aut nam. Non adipisci rerum ipsa inventore dolore et est.