Back in 2008, I did a subject called FINS2624: Portfolio Finance. My strongest memory of the class has nothing to do with the material we covered (primarily the capital asset pricing model, aka CAPM); rather, it’s watching my tutor convert a series of daily asset prices into returns. He could do things in Excel I had never seen before, and at incredible speed.
I incorrectly assumed those skills, being crucial in the workplace, would be taught later in the course – but it took self-study, and an internship at an investment bank, for what I saw my tutor doing two years prior to come as naturally as typing.
Thankfully, it won’t take you two years – while Excel has hundreds of shortcuts, there’s a core set of commands which are easy to learn and which will speed up your work dramatically. We’re going to cover them in a series of posts, starting today…
The rest of this article can be found here: http://www.learnmachine.net/tutorials/speed-excel/