by Ilker | Jul 28, 2020 | Excel Formulas, Excel Tips & Tricks
You can use Excel formulas to populate a random number or string from a list. You can even build a logic to return numbers without any duplicates. In this article, we are going to show you how to select a random Item from a list in Excel. Download Workbook Although...
by Ilker | Jul 2, 2020 | Excel Formulas
The STANDARDIZE Excel function is a Statistical formla that calculates and returns normalized value (z-score) based on the mean and standard deviation of a data set. In this guide, we’re going to show you how to use the STANDARDIZE function and also go over some tips...
by Ilker | Nov 22, 2019 | Excel Formulas
RANK.AVG (RANK AVG) is a Statistical function that can return the rank of a given value, within the specified array of values. If there are values that share the same rank, the average rank of that set of values will be returned. In this guide, we’re going to show you...
by Ilker | Nov 22, 2019 | Excel Formulas
The RANK.EQ function is a Statistical formula that returns the rank of a given value, within the specified array of values. If there is more than one values that share the same rank, the higher rank of that set of values is going to be returned by the formula. In this...
by Ilker | Nov 21, 2019 | Excel Formulas
The AVERAGEA in Excel is a Statistical function that can calculate and return the average (arithmetic mean) of the values of a range of cells. AVERAGEA differs from the AVERAGE function in its ability to include numbers in string format and logical values in the...
by Ilker | Nov 1, 2019 | Excel Formulas
The Excel SIGN function is a Math & Trigonometry formula that returns the sign of the specified numeric value in its arguments. Need to identify outliers or any red flags in a data set? This function is perfect for that task! This function can be especially useful...
by Ilker | Nov 1, 2019 | Excel Formulas
The Excel ADDRESS function is a Lookup & Reference formula that returns the address of a cell based on its input arguments. The function also allows you to set the type and reference style of the address. In this guide, we’re going to show you how to use the Excel...
by Ilker | Nov 1, 2019 | Excel Formulas
The Excel SECOND function is a Date & Time formula that parses and returns the second value from a time value. The return value is an integer, ranging from 0 to 59. The outcome of this function resets for every 60 seconds of input. In this guide, we’re going to...
by Ilker | Nov 1, 2019 | Excel Formulas
The MINUTE Excel function is a Date & Time formula that returns the minute value from a specified time value. The return value is an integer, ranging from 0 to 59, and the minute values reset after 60 minutes. In this guide, we’re going to show you how to use the...
