This is the final blog in a series of three to help you save time when working in Excel:
- Save time with the best Excel shortcuts
- Save time with the Quick Access Toolbar
- Complete Excel tasks in a second (this blog)
You can complete Excel tasks in a second!
I have now adapted #SMED Single Minute Execution of Die for Excel… and speeded it up!
I call it #SSET = SINGLE SECOND EXECUTION OF TASK
🚀 Complete commonly performed Excel tasks in just a single second! 🚀
If you follow the advice in this blog, I estimate that you can easily save 10% of your time working in Excel. If you worked full-time in Excel, that would mean you would save four hours a week or 22 days a year!
Ready to learn?
On your marks, get SSET, go!
1) Preparation before the task is key
🖱 Quick Access Toolbar (QAT): For tasks where no shortcut is available, make sure you set up your QAT so that mouse-based tools and macros that you use regularly are lined up ready to use and always visible (no mouse clicks needed to show them!). In my blog I explain how.
⚡Automation: For multi-step repetitive tasks, set-up Power Query, an office script or a macro to automate the actions. Store commonly-used macros in your personal workbook, so they are always available for use in any workbook and add those you often use to your QAT.
💥 Add-ins: Install one or more add-ins to add extra one-step buttons to further speed up your work. For a very modest fee, you can purchase my toolKCit add-in with 19 useful commands at eloquens. Use the discount code HOW2EXCEL for 50% off.
Or check out these other add-ins:
https://www.numeritas.co.uk/download-nxt/ - workbook auditing
https://www.operisanalysiskit.com/ - OAK tool for workbook auditing
2) Use precise locations for everything
Ensure your keyboard is suitably placed in front of you so that you can easily use shortcuts. Similarly, ensure your mouse is suitably placed under your dominant hand to facilitate quick access to your Quick Access Toolbar (commonly used commands) and standard ribbon (infrequently used commands).
3) Follow a standardised procedure
For each task that you commonly perform, decide what your ONE method is: select this based upon speed and convenience
- Keyboard shortcut (if available) or
- Quick Access Toolbar or
- Automated solution - Power Query, office script or macro
In this way, you also save thinking time, which speeds up your work some more.
4) Practise, practise, practise
As the building site worker said to the old lady who asked, “How do I get to Carnegie Hall?”
“Lady, you gotta practise!”
- Use your keyboard shortcuts and your Quick Access Toolbar as often as possible to make their usage second nature.
- Practice common tasks such as navigating, selecting, formatting, inserting, copy and pasting cells, rows and columns.
5) Adapt the equipment
⌨ Keyboard shortcuts: Learn new ones, as necessary.
🖱 Quick Access Toolbar: Amend as necessary to speed up your work. For example, add any missing but commonly used commands, remove any unused commands (to reduce clutter and make space for others) or move commands in the list so that they are in an order that you find logical and easy to locate.
⚡Automation: Amend your Power Query, office scripts or macros, as necessary.
💥 Add-ins: Research, try out and install new add-ins.
6) Never stop looking for waste
Strive to learn new functionality and tricks and tips to save you time. Review tasks that you commonly perform but which take you time and try to identify improvements e.g., reduce the number of actions needed, use a new shortcut or a new button on your Quick Access Toolbar.
So now you know the secrets of how to complete Excel tasks in a second!
Put them into practice quickly!