Many people ask me to give them a secret list of most powerful keyboard shortcuts. They think knowing more shortcuts is the same as being more efficient. Unfortunately, it is not. Read this 3 min article to understand how to find out the shortcuts you need and how to learn them in a simple manner without stressing yourself.
Continue reading Which keyboard shortcuts should I learn?
Every menu item has a keyboard shortcut. You don’t even have to remember it. Just press and release ALT key and it is visible. Type what you see. No need to press key combinations. Just one key at a time. That’s it. You learnt it already!
Common requirement. With raw data and Pivot Tables. View or Filter. Here is how…
Continue reading Top 10 and 10% items: View and Filter
Yes. This LONG “short”cut actually works. Try it. In fact, just press Alt and choose the highlighted buttons in the Ribbon. All of them work. Just press and release Alt and then press buttons one by one. DON’T try some Yoga poses with your fingers
With Outlook 2016, This shortcut is now Alt N AF B. This is required because it offers to attach files from local PC as well as web locations (OneDrive). It also shows recently inserted attachments.
As we are using Microsoft Office for decades it is quite natural to ‘feel’ proficient in using it. But you have no idea how rampant the inefficiency is. To help you prove this to yourself, I have created simple Efficiency Tests. Try one or more of these tests and then you will realize the problem. Nobody needs to know the results – except yourself!
Continue reading (in)Efficiency Tests
Finally, here is a proven set of best practices to make your Excel usage simpler, faster and more accurate.
Continue reading Excel Tables 12 – Standard Operating Procedure
Like column names, table names can also be used in formulas. Read the previous article to understand the context.
Continue reading Excel Tables 10 – Everything is in a name
Readable formulas in Excel tables are so nice, you will curse yourself for not noticing earlier (since 8 years!). Teach this to everyone around you – NOW! Show off
Continue reading Excel Tables 9 – Readable Formulas in Calculated Columns
Yes. It is not only formulas which get copied when you extend a table. Everything gets copied. Read on to find out about Automatic copying and how much time you are wasting by not knowing this!
Continue reading Excel Tables 8 – Automatic copying of everything!