INDEX Function
What is the INDEX Function? The INDEX Function is categorized under Excel Lookup and Reference functions. The function will return the value at a given position in a range or array. The INDEX function is often used with the MATCH function. We can say it is an alternative way to do VLOOKUP. As a financial…
ADDRESS Function
What is the Cell ADDRESS Function? The cell ADDRESS Function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or…
STANDARDIZE Function
What is the STANDARDIZE Z-Score Function? The STANDARDIZE Function is available under Excel Statistical functions. It will return a normalized value (z-score) based on the mean and standard deviation. A z-score, or standard score, is used for standardizing scores on the same scale by dividing a score’s deviation by the standard deviation in a data…
SLOPE Function
What is the SLOPE Function? The SLOPE Function is categorized under Excel Statistical functions. It will return the slope of the linear regression line through the data points in known_y’s and known_x’s. In financial analysis, the SLOPE function can be used to calculate the beta of a stock. Slope / Beta Formula =SLOPE(known_y’s, known_x’s) The…
RECEIVED Function
What is the Maturity RECEIVED Function? The RECEIVED Function is categorized under Excel Financial functions. It will calculate the amount received at maturity for a fully invested security. As a financial analyst, the RECEIVED function helps calculate the amount that we will get from an investment if the duration of the investment and interest rate…
F.DIST Function
What is the F Distribution Function? The F.DIST Function is categorized under Excel Statistical functions. It will calculate the probability density function or the Cumulative Distribution Function for the F Distribution. It measures the degree of diversity between two data sets. For example, if we wish to find out the variability in the IQ scores…
F.INV Function
What is the F.INV (Inverse F Distribution) Function? The F.INV Function is categorized under Excel Statistical functions. It will calculate the inverse of the Cumulative F Distribution for a supplied probability. As a financial analyst, the function is useful in understanding the variability of two data sets. One example is when we wish to analyze…
F.TEST Function
What is the F.TEST Probability Function? The F.TEST Function is categorized under Excel Statistical functions. It will return the result of an F-test for two given arrays or ranges. The function will return the two-tailed probability that the variances in the two supplied arrays are not significantly different. As a financial analyst, the function is…
How to “Insert Data From Picture” in Excel
What is the “Insert Data From Picture” Function? The “Insert Data From Picture” button is a function that can be found on the mobile version of Microsoft Excel. Using this function will open up the camera and allow the user to take a picture of numbers or text. This text will then be converted into spreadsheet…
