STANDARDIZE Function
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...
RANK.AVG (RANK AVG) Function in Excel
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...
RANK EQ Excel Function (RANK.EQ)
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...
AVERAGEA in Excel
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...
Excel SIGN Function
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...
Excel ADDRESS Function – Find Cell References in Your Workbook
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...
Function: SECOND
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...
Function: MINUTE
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...
Function: HOUR
The Excel Hour function is a Date & Time formula that parses and returns the hour value from a time value. The return value is an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). In this guide, we’re going to show you how to use the Excel HOUR function and...