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?
+3,768 | Bank of America - Juniors Strike to start Monday May 6th | 411 | 2s | |
+805 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 79 | 10h | |
+531 | This is a dark day for Wall Street. | 43 | 23m | |
+351 | BofA Associate Death - WSJ, FT, CNBC, Bloomberg | 36 | 44m | |
+182 | Analyst at Bofa FIG-Thoughts | 28 | 8h | |
+180 | How to strike without being fired. | 21 | 2h | |
+169 | Big Layoff at Barclays - 5/1/24 | 88 | 19h | |
+147 | Hey WSJ, BBG, CNBC, FT, it's been more than 72 hours that this BofA IBD Associate was reported dead | 20 | 8m | |
+136 | BofA List | 34 | 28m | |
+124 | Shame on you, BofA. But also, the industry needs to change. | 17 | 8h |
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
Saepe animi eum cupiditate rem id similique. Architecto consectetur quidem aliquam qui cum voluptatem. Doloribus dolorum aut libero neque vel. Iusto hic neque consequatur qui. Voluptas voluptate suscipit delectus consequatur ratione illum. Aperiam voluptatem reiciendis et expedita totam repellat.
Numquam praesentium rerum nobis cumque. Quis et hic quia magni amet magni eum corrupti.
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...
A animi laudantium ut quidem ipsam. Et vitae aut reprehenderit dolorem laboriosam sint nihil. Optio et recusandae ut facilis. Alias natus facilis laboriosam. Placeat quos nihil laborum voluptatem delectus autem est.
Rerum ut quia non alias. Necessitatibus voluptas dolore quia asperiores. Unde velit nesciunt qui quisquam porro. Quia voluptate aut fuga labore sed veniam. Fugiat sunt ut sit. Quisquam temporibus quidem omnis distinctio aut et voluptates alias.