short cut key for paste special values
anyone know this short cut?
anyone know this short cut?
+3,976 | Bank of America - Juniors Strike to start Monday May 6th | 416 | 2h | |
+842 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 79 | 21h | |
+592 | This is a dark day for Wall Street. | 46 | 11h | |
+425 | BofA Associate Death - WSJ, FT, CNBC, Bloomberg | 46 | 1h | |
+189 | How to strike without being fired. | 21 | 16h | |
+184 | Analyst at Bofa FIG-Thoughts | 28 | 23h | |
+169 | Big Layoff at Barclays - 5/1/24 | 88 | 1d | |
+164 | Hey WSJ, BBG, CNBC, FT, it's been more than 72 hours that this BofA IBD Associate was reported dead | 23 | 10h | |
+150 | BofA List | 37 | 7h | |
+128 | Reporters, please post your info in this thread for visibility so people can easily reach out. | 4 | 1h |
Career Resources
Alt-E-S-V
Alt + Ctrl + V if you're using the newest version (2007) I think
haha, all trained the same way!
i use the / key instead of alt. its the all the same.
I programmed simple macro and now have this under ctrl+w. Simpler than Alt+E+S+V...
How much macro do you guys use on a regular basis and is it taught during your IBD training?
If you're old enough to remember video recorders, it's just like the button with the round red dot.
Except that the picture doesn't get fuzzy when you play it back for the 153rd time. And you don't have to beat your brother up when he "accidentally" records over your Star Wars. Oh wait...
Quite a lot. I actually have a macro that posts all my comments on ibankingoasis. Come to think of it, pretty much all of my posts on the all nighetr are done by that macro as well - i call it "24/7 processing mode" :)
"Living the dream 24/7 on http://theallnighter.blogspot.com"
How useful/necessary is it to be familiar with crating macros using vba though? Obviously you can accomplish more complicated tasks that way but it seems like not many people are very comfortable with it.
it's extremely useful but not crucial (for most everyday work). If it's simple enough you can just record it.
However, if you need a certain spreadsheet to relink to different documents, do some v/h-lookup madness, create a new sheet for the day, access the bloomberg for some new prices, combine them, compare them, mark it against yesterday's numbers, create and update a mothly average, and then take a shit on your face, learn VBA.
I'd only suggest writing a macro you need to do something that would otherwise be extremely tedious. I know how to write them, but I almost never do.
I'm pretty set with the shortcuts from native Excel and from DealMaven.
There's always an engineer analyst or intern around when (once a year) anyone in the team needs some vba done.
I asked about vba because I'd likely be that "engineer analyst or intern" and I'm pretty comfortable writing a moderately complex macro. Is this something that's particularly appealing to employers? What's the best way to sell this skill if it is valuable?
For IBD it won't make you stand out in the application process, just have it on your CV alongside MS office.
It will get you noticed if you can build some relatively complex macros that everyone will use and save time with though (you'll have to search for those opportunities though, and have the time to build them).
Et maxime assumenda error at ea quia. Pariatur voluptas quas tempore eaque eum qui deleniti.
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...