Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts

Wednesday, November 20, 2013

Using Mail Merge in Microsoft Word and Excel

I was trying to do a mail merge to send a letter a list of people. I tried to Google up the steps. After few uneasy explanations, I found this site with simple and yet elegant explanation of how to use mail merge.

http://www.wikihow.com/Mail-Merge-Address-Labels-Using-Excel-and-Word

Follow the above link to understand how to use mail merge.

Tuesday, November 12, 2013

Generate normal random number in Excel

Using Rand() function gives you a random number between 0 and 1. If you are to generate a random number which follows the normal distribution probability curve, then you can use the following code:-

= NormInv(Rand(), Mean, Stdev)

In place of Mean and Stdev, enter mean of the distribution and standard deviation of the distribution