It is useful sometimes to read a worksheet line-by-line and selectively take data from it. An example below shows how to do this.
The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
The following example manipulates the data by examining each row of email addresses and concatenating them into a single address line. While Excel has built-in Transpose functions, we intend...
Read more »
In the following article, let’s go through the 6 quick and awesome ways to switch between open Word document windows.
Now and then, it’s quite often to conduct multiple tasks at one time. And when it comes to Word, opening several documents at the same time is not unusual. However, living in an age when time is one of our greatest assets, to do things quick and fast is required everywhere. So, a little time squeezed can mean a lot to us. Now let’s take a look at how we can save time by...
Read more »
By default, in Outlook today window, we can only sort the tasks by Importance, Due Date, Start Date or Creation Date. But some users wish to sort them alphabetically, namely by subject. This article will introduce how to achieve it.
Many people prefer to start Outlook in Outlook Today window, in that they can easily check all the today’s tasks, appointments and new mails here. It looks like the following screenshot:
To change the order of tasks, you can click on the “Customize Outlook...
Read more »
