Excel RAND() and RANDBETWEEN Functions
The human being cannot consciously generate random numbers sequences as they tend to avoid/favor...
GUID Generator In Excel
Are you a developer working  with microsoft technologies and looking for a unique identifiers for...
RANDOMLY ASSIGN GROUPS
If your involves sampling, research, taking polls or working with control groups, then knowing how...
Generating Random Future Dates,Time & Datetime in Excel
In this article I will show you how to generate random future Dates, Time &Datetime in excel...
Generating Lottery Numbers In Excel
The chance of winning a lottery is usually infinitesimal but the magnitude of the rewards tends to...
Generating Strong Passwords or Encryption keys Using Excel
A strong password should be at least 16 characters long, include special characters, Numbers,...
Sumproduct with Wild Cards
The 3 wildcard characters (?*~) used in other excel formulas do not work with sumproduct. However,...
How to Update Date or Time in EXCEL
To update/extract the date or Time part separately in a DateTime Value is a lot easier  if you...
Excel WEEKDAY Function In-depth
Today we shall have an in-depth look at another underutilized yet powerful function, especially...
Excel’s WEEKDAY Function In-depth
Today we shall have an in-depth look at another underutilized yet powerful function, especially...
7 Overlooked Uses of Excel MOD Function
In Over 450 functions in Excel, MOD function is one of the highly overlooked. Generally, MOD...
How to Customize Number Formats In Excel
Looks matter both in life and data visualization—you never get a second chance to make a first...