Efficiency Test 8: Excel: Scrolling Horizontally

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

Posted in Efficiency Test, Excel | Tagged , , | 2 Comments

Efficiency Test 7: Outlook : Sending mail to multiple contacts

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

Posted in Contacts, Efficiency Test, Outlook | Tagged , , | Leave a comment

Efficiency Test 6: Excel : Copying Formulas

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

Posted in Efficiency Test, Excel, Formulas | Tagged , , , | 1 Comment

Best Windows Customization (Tweaking)Tool

image Windows has a mind boggling number of settings and options.Ultimate Windows Tweaker makes it very easy to customize windows settings.Have a look and start using it.

Estimated reading time 10 min

Continue reading

Posted in Utility, Windows | Tagged , | Leave a comment

Using Touch is confusing? Solution: See the Touch!

image This article applies only to Windows touch devices.We often get confused while using Touch to perform actions on the screen.Sometimes the touch gestures don’t work as expected.Windows has a brilliant feature to help you.Estimated reading time 10 min.

Continue reading

Posted in Demo, Surface Pro | Tagged , , , | Leave a comment

Knowledge Pack: Data Analytics

image Data Analysis and Reports has been a major theme for my articles so far. 

Here is a collection of 51 articles, categorized and sorted in the recommended reading order.

 

Enjoy!

Continue reading

Posted in Analysis, Analytics, BI, Big data, Excel, Knowledge Pack, Pivot Tables | Tagged , , , , , , , | 1 Comment

Custom sorting in Pivot Table using Custom Lists

image This feature has been around for two decades.
It is high time you know it!

Decide the sort order once and use it lifelong.

 

Estimated reading time 10 min

Continue reading

Posted in Efficiency, Excel | Tagged , , , | 1 Comment