At the beginning of each month, I will publish a tip to make easier & quicker your use of Excel.
I could not start by anything else but Excel shortcuts.
You can download here a very complete PDF for both Windows and Mac ( 😦 ) users.
Other useful resources :
I see two main reasons why you should use Excel shortcuts :
1. It is time-saving
With Excel shortcuts, you can do things more quickly without reducing their quality.
2. It gives you credibility
Indeed, using Excel shortcuts can make you upstanding and reliable in front of clients or your boss. In audit, consulting or while presenting an Excel model, you frequently face situations where you are using Excel next to other people. You have a chance to prove how comfortable you are using Excel.
Try it today ! During the next 30 minutes, put the mouse very far from you and only use it when it is mandatory !
My top 3 is :
- Ctrl * to select an entire table
- Ctrl Shift L to filter an array
- Alt Arrow Down to navigate through dropdown lists or filtered menus
What is yours ?
If you are working with 2 screens (or more !!) : Shift Windows Left/Right arrow will send your active window to the next screen.
Please feel free to share, like or comment. You can subscribe to the blog so you can keep up with the news!