by Crispo Mwangi | Jul 6, 2016 | Advanced Excel, TEMPLATES
If your involves sampling, research, taking polls or working with control groups, then knowing how to randomly assign groups is a key skill. Random assigning of groups ensures each participant or subject has an equal chance of being placed in any group and...
by Crispo Mwangi | Jun 25, 2016 | Advanced Excel, TEMPLATES
In this article I will show you how to generate random future Dates, Time &Datetime in excel using RAND(), RANDBETWEEN and WORKDAY.INTL functions. RANDBETWEEN function returns a random integer in a range of integers. = RANDBETWEEN(bottom, top) →→bottom(smallest...
by Crispo Mwangi | Jun 25, 2016 | Advanced Excel, TEMPLATES
The chance of winning a lottery is usually infinitesimal but the magnitude of the rewards tends to over shadow it. This is why millions of people play or fantasize about winning the lottery daily. Since most Lottery use pseudo-random numbers to pick a winner, I will...
by Crispo Mwangi | Jun 24, 2016 | Advanced Excel, TEMPLATES
A strong password should be at least 16 characters long, include special characters, Numbers, uppercase letters and lowercase letters. A mix of all these characters makes it hard for the password to crack. Most people find it hard to create a strong password but with...