by Crispo Mwangi | Jul 23, 2016 | BASIC EXCEL
A Wildcard is a symbol used to replace or represent one or more characters. Excel wildcards are either an asterisk (*) which represents one or more characters, a question mark (?) which represents a single character or a tide (~) used to distinguish between normal...
by Crispo Mwangi | Jul 8, 2016 | BASIC EXCEL
The human being cannot consciously generate random numbers sequences as they tend to avoid/favor picking specific numbers yet there is so much application of randomness in life. Random numbers are useful in a number of ways, such as generating data encryption...
by Crispo Mwangi | Jul 6, 2016 | BASIC EXCEL
Are you a developer working with microsoft technologies and looking for a unique identifiers for components/applications/files ? Or are you a database developer or administrator looking for primary keys tables? Well! in this article I will show you how to create...
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...
Recent Comments