Find duplicates in Excel

One of the most common scenarios of data cleansing is finding duplicates in Excel. Below are the steps:

Select the data range in Excel in which you want to find the duplicate values.

Under Home Tab, select Conditional Formatting->Duplicate Values:

Click OK and observe the highlighted cells with duplicate values.

You can now filter the data based on color to quickly check the duplicate values. Short-cut to filter is select the header of the column or columns and then Alt+D+F+F on keyboard.

Insert hyperlink in gmail

While composing an e-mail, it is often a requirement to add hyperlinks to some website you may want to send the person you’re writing the e-mail to. However, the url you’re trying send them may be very long, so you would to add a hyperlink to a word which in general we write as “Click here”.

So, to add the hyperlink do as follows:

  1. Click on the red highlighted icon:

2. Copy and paste the URL in the text-box as shown below and Click OK:

The link becomes clickable as shown below:

Send the e-mail.

Here is my post on how to send email with