by Crispo Mwangi | Jul 6, 2016 | INTERMEDIATE EXCEL
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 | INTERMEDIATE EXCEL
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 | BASIC EXCEL, INTERMEDIATE EXCEL
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 17, 2016 | INTERMEDIATE EXCEL
To update/extract the date or Time part separately in a DateTime Value is a lot easier  if you understand that excel stores dates as sequential serial numbers and time as a fractional portion of a 24 hour day. With the above understanding, you can combine INT and MOD...
by Crispo Mwangi | Jun 8, 2016 | INTERMEDIATE EXCEL
Today we shall have an in-depth look at another underutilized yet powerful function, especially when analyzing dates–WEEKDAY. I hope Part 1 of this series made you get acquainted with MOD function and it has become a favorite for you. Below are some of the uses...
by Crispo Mwangi | Jun 7, 2016 | BASIC EXCEL, INTERMEDIATE EXCEL
In Over 450 functions in Excel, MOD function is one of the highly overlooked. Generally, MOD function returns the remainder of two numbers after division. Functions like IF, SUM, COUNT, AVERAGE are well known by all excel users. Yet there are some functions...
Recent Comments