Split text into words or characters: Macro

In the earlier post, we saw how boring text can be converted into interesting and high-impact slides. The only pending problem was that splitting text into words or characters needed to be done manually. That is a tedious process. Therefore, I wrote a macro to simplify this activity. Read on to find out how to download and use this macro.

Split Text Macro

Continue reading Split text into words or characters: Macro

Outlook: How to Add your own columns in Outlook with Outlook Custom Field

This quick video illustrates how you can enhance the usefulness of Outlook beyond your imagination by adding your own columns to Outlook.  We can achieve this with the useful little known feature in Outlook called Outlook Custom Field.  Watch this video to understand the power and practical applications of this great feature.  Learn how to allocate incoming mails in a helpdesk to engineers or how to allocate incoming CVs to different recruiters.

How to work on Excel when it is busy

This is a common requirement. We have started some time consuming operation like adding a field to a large pivot table, or fetching data from a database, or refreshing some complex calculations. In such cases Excel seems to be unresponsive. Not only the current file is unusable, other files opened are also not editable. Things just freeze till the time and resource consuming activity finishes.

Of course, that is a total waste of time. You want to do something else on another Excel file during this time. The solution is to create another instance of Excel.

  • When you are about to start a time consuming operation, make sure no other Excel files are open. Start the operation on the file and leave it alone.
  • Now right click on the Excel icon in the Taskbar and choose Excel (whichever version) again. This way you open an independent copy of Excel. This copy is not busy at all.Open an independent copy of Excel when it is busy processing another copy
  • Now you open other Excel files here and continue working while the other copy is executing the time consuming job. That’s it.

This concept is not applicable just to Excel. The same logic applies to any application which can get busy and block you from working on other files.

Ultimate Outlook client: TouchDown

I have been using this for many years. I resisted writing about it for so long. But now, it is time to explain the reality. If you want full functionality of Outlook (rather Exchange Mailbox) on your Android or iPhone, use TouchDown. It is comprehensive, resilient and versatile. It implements Exchange capabilities to the fullest possible extent. Here is a quick list of what it has to offer.

Outlook Touchdown

  1. All types of folders are supported. Including Tasks.
  2. Supports color categories
  3. Allows you to convert a mail to task
  4. Shows full conversation view
  5. Fully customizable feature set
  6. Mobile forms support
  7. Implements full Outlook mobility policy
  8. Supports 80% of desktop Outlook features (often easier)

If you have not tried it, try it NOW. In the App Store or Google Play, there will be two versions visible: TouchDown and TouchDown HD. Most of us should use the HD version, which is designed for Android (Honeycomb/ICS/JellyBean Tablets and Smartphones). Another version is available for older Android Phones.

The user interface may look dated. Nowadays, user interface “coolness” seems to be more important than functional benefits. In spite of that, you will appreciate the sheer flexibility and customizability of this product.

For technical folks, this is the best implementation of Exchange Web Services. I am saddened by the fact that Microsoft’s own clients for Outlook offer a very small subset of functionality of what TouchDown offers (in spite of many acquisitions).

Here is a screenshot of the advanced configuration options – just to give you a feel of the richness of this product.

Touchdown advanced settings

It offers a free trial for 30 days, after which you pay approx. 20  USD per year.
In my opinion, it is absolute value for money. The only other app which has such high ROI, in my opinion, is LastPass (which is 11 USD per year) – in terms of sheer value add.

Disclaimer: I have no commercial contract with TouchDown or Synamtech. I do not benefit in any way due to sales of this product.