I use Pidgin as my primary chat client. Pidgin allows me to login to MSN, Yahoo!, Google as well Google Hosted accounts all at once, thus ensuring I don’t have too many clients running at the same time to fulfil my chatting needs.
Off late I’ve been hit by a steady and constant amount of chat [...]
Continue reading about How to prevent MSN Spam in Pidgin (Tutorial Thursday)
If there is one thing I strongly believe is tapping the power of the Internet to learn. It is with always with great happiness that everything I have learnt in the past ten years (since I got online) has been only through tutorial sites.
Here are a list of some of that where you can quickly [...]
Continue reading about Eight Places to Learn something New! (Tutorial Thursday)
Last year, as part of our admissions team duties, we were required to send out prospectus to students all over India. These ranged from a minimum of fifty envelopes to over 150 at a time. During a promotion campaign we printed around 90,000 labels!
Given the sheer number of labels to be printed, we decided to [...]
Continue reading about Creating Custom Labels in Microsoft Word 2007 (Tutorial Thursday)
Three weeks back I covered creating Single Variable Data Tables in Excel. As promised, in this tutorial I will cover creating a two variable data table. This tutorial assumes that you have read the earlier one and are comfortable with creating a single variable data table.
Create a new excel file as shown in the screenshot [...]
Continue reading about Two Variable Data Tables in Microsoft Excel (Tutorial Thursday)
If there is one thing I really don’t like to hear is any sound when I am starting up the computer. Windows Vista doesn’t allow you to customize the startup sound and you are stuck with the same version. Well, I chose to disable it.
And here is how you do it:
1. Right click on an [...]
Continue reading about Disable Windows Vista Startup Sound (Tutorial Thursday)
reddit_url = ‘http://techtites.com/2008/08/21/data-tables-in-excel-tutorial-thursday/’;
In my last Excel Tutorial, I covered using SUMIFS and SUMPRODUCT.
Data Tables is also an advanced topic in Microsoft Excel that falls under the category of What-If Analysis. What-If or Sensitivity Analysis is carried out to study the variation of the output to changes in the input variable.
Consider a case of compound interest, [...]
Continue reading about Data Tables in Excel (Tutorial Thursday)
Daniel asked the question What is a Blog? This is my answer.
In late 2003, I decided to try my hand at writing what was known as a blog. As I hesitantly installed WordPress on my first paid hosting account.
I remember telling people excitedly that I have started blogging only to be stared at as if [...]
The title of the post is a bit of a misnomer because the SUMIF function in Excel does not allow you to have more than condition.
Excel 2007 introduced the SUMIFS function which allowed for multiple conditions.
However, if you are using any version prior to Excel 2007 or if the persons who will be using your [...]
Continue reading about Excel Tutorial: SUMIF with Multiple Conditions
