A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Keyboard shortcuts, quite surprisingly, are a blessing and a menace at the same time. On one hand, when they become second nature, they are bound to improve your efficiency dramatically. On the other, shortcuts can disrupt learning during workshops and webinars.
Jordan shares a funny perspective on this topic. Sometimes, when presenting in a workshop or webinar, using a keyboard shortcut might be a very small portion of what you are trying to impart. But the audience is so blown away by the shortcut, they forget all about everything else. So, what is it about shortcuts that’s so attractive?
With Jordan Goldmeier facilitating the session, we have Oz du Soleil, Rick Grantham and our special guest Dave Bruns of Exceljet.net on the panel.
According to Dave, the time saving aspect of keyboard shortcuts is what makes them attractive. Shortcuts for data navigation, paste special and other similar tasks can never be forgotten once picked up. In his experience, people are always looking for new Excel shortcuts.
Knowing that Oz hates keyboard shortcuts, Rick puts the spotlight on Oz without any hesitation. Oz normally deals with many different projects, different software and different machines. It is outright impractical to focus on learning and remembering keyboard shortcuts for all the possible combinations. Hence, to make life easier, he tries to stick to a few basic ones, like Copy and Paste.
Jordan mentioned that some people rip out the F1 button from their keyboard to avoid hitting it by mistake while using F2. All this just to avoid seeing a terrible help system pop up.
Is there a time when introducing shortcuts can be counter-productive while training?
Dave thinks that introducing people to multiple ways of achieving the same thing might be problematic, especially during basic Excel workshops. On the other hand, attendees are saved from wasting time right-clicking and finding stuff. He also highlighted that Microsoft Excel’s interface does not make it easy for shortcuts to be picked up fast.
His own technique of teaching shortcuts involves 2 steps:
Oz stressed on how knowing multiple ways of doing something can be a good thing and help move forward faster.
We would love to hear your take on keyboard shortcuts in Excel. Do leave your comments below. And remember to share this video with your friends or colleagues.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide