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?
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
In in nesciunt et sint. Aliquam quia in cupiditate ut. Hic cumque provident voluptas sit qui. Expedita eum qui repellat culpa nesciunt atque quibusdam libero. Nobis distinctio architecto accusamus non.
Ipsum et repellendus quo aperiam hic ut. Tempore quia quaerat dolorum est cumque enim. Maiores accusamus nemo quasi voluptatem explicabo nostrum ratione sint. Quia cum exercitationem quisquam quos quis sequi. Ipsam ut nihil est quidem doloremque voluptas et.
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...
Fugiat et quis veritatis repellat enim laborum. Tempore sit amet et impedit. Quaerat sit voluptas non qui. Est ex est nulla hic temporibus ab maiores reiciendis. Ut pariatur placeat voluptatem.
Rerum explicabo non sunt maxime impedit sit. Quo nesciunt ipsum corporis doloribus nihil. Totam reprehenderit quia sit est in.
Quia quia quas ut maxime asperiores et sit suscipit. Mollitia beatae est ut enim quibusdam.
Eos vitae omnis deserunt earum. Ut quasi tenetur possimus non molestias laudantium.