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
Scrolling is inevitable. But there is a catch. If you press Page Down, the next screen of rows are shown. The problem is, we also need to scroll horizontally. What do you do then?
What is the most efficient way of scrolling horizontally?
Continue reading Efficiency Test 8: Excel: Scrolling Horizontally
Here is another test. Simple task. But that does not mean you know the most efficient method. Try it out. You will be surprised!
The test is simple. What is the most efficient way of sending a mail to all contacts from a specific company? (The contacts are already in your contacts folder).
Continue reading Efficiency Test 7: Outlook : Sending mail to multiple contacts
Yes, you have been copying formulas for decades. I know. But you don’t know the most efficient method – most probably! Try it out. Spend just 4 minutes of your time.
Continue reading Efficiency Test 6: Excel : Copying Formulas
The question is simple. How to delete notes across all the slides in the most efficient way? The answer will not only surprise you, it will protect your interests.
Estimated reading time 4 min
Continue reading Efficiency Test 5 Solution: PowerPoint : How to delete notes across all slides in 5 clicks
Here is a simple test. Suppose you have a presentation with 60+ slides. Many slides have notes. You want to send the presentation to a customer. But the notes contain information which is confidential. You make a copy of the presentation and now you want to remove all the notes (some accidental comments may also be there).
What is the smartest and fastest way of removing all notes and comments from a presentation?
Post your answers as comments to this post. Will publish the answer tomorrow.
Please read the earlier article Efficiency Test 4: Word. The challenge was to format Word tables in the most optimal way.
Here is the solution. You need a total of 10 clicks.
Reading time 10 min. (Why 10 minutes to understand 10 clicks? Because you are not just learning where to click. You are learning how to communicate with Word in a language it understands!)
Continue reading Efficiency Test 4 : Format Word Tables Solution
The first Word Efficiency test was very popular. So here is another one. This time we talk about commonly required table formatting. If you don’t know the efficient method, you will waste a lot of time. If you know the right way, it takes few seconds. Continue reading Efficiency Test 4: Word table formatting
This is the continuation of the article Efficiency Test: Excel Data Cleanup
The date cleanup challenge was to change all cells having dd-mm-yy formatting to dd-mmm-yy formatting across all sheets in the most efficient way. Continue reading Efficiency Test 3: Excel Date Cleanup : Solution
The Word and PowerPoint efficiency test have become very popular. So here is another one for Excel. It is a very interesting test. The problem looks simpler. But you will learn a lot while finding the solution. Continue reading Efficiency Test 3: Excel