Last year, I was approached by the sterling folks over at General Assembly, asking whether I would be interested in teaching a series of courses on Microsoft Excel. I happily obliged and have been overwhelmed with the demand for these classes; I’ve now taught live-stream and in-person sessions, and a series of quick-nibble Excel courses will soon appear on the Google for Entrepreneurs YouTube channel.
Indeed, Excel is one of those necessary evils for many business professionals — it seems like the learning curve for the software is relatively high, and – just like your typical programming language – it’s hard to practically discover some of Excel’s features until you’re in the thick of using it. It’s like learning to use a brake pedal while speeding down the BQE.One of the ways that Excel can become less of a burden and more of an asset is the use of Shortcuts.
During my in-person courses, I encourage students to “let go of the mouse” and attempt to navigate through their spreadsheets using only their keyboard. And while this takes time and practice, it’s certainly doable. (Ask some of your investment banking friends about this; they’ll probably laugh — then go into some mild form of PTSD reminiscing about their days as an analyst!)So, as a helpful resource to you all, here is a brief set of my favorite shortcuts in Excel — both for Windows and Mac! If you have any questions, feel free to comment below or send me a tweet!