What is the YEAR Function? The YEAR Function is an Excel Date/Time function that is used for calculating the year number from a given date. The function will return an integer that is a four-digit year corresponding to a specified date. For example, if we use this function on a date such as 12/12/2017, it…
What is the SEARCH Function? The SEARCH Function is categorized under Excel TEXT functions. SEARCH will return the position of a specified character or sub-string within a supplied text string. In financial analysis, the SEARCH function can be useful if we wish to find the location of a text in a string. For example, we can…
How to Alternate Row Color in Excel? To alternate row color in excel, you can do so by applying conditional formatting, with a combination of functions. The ROW Function is an Excel TEXT function, that will return the first row within a given reference or the number of the current row. If you combine the ROW with…
What is the MAXA Function? The MAXA Function is categorized under Excel Statistical functions. MAXA will return the largest value in a given list of arguments. From a given set of numeric values, it will return the largest value. The function compares numbers, text, and logical values as TRUE or FALSE. In financial modeling, the…
What is the MAX Function? The MAX Function is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical…
What is a Stock Index? A stock index, also called a share index or stock market index, consists of constituent stocks used to provide an indication of an economy, market, or sector. A stock index is commonly used by investors as a benchmark to gauge the performance of their portfolio. Examples of stock indexes include…
What is the MEDIAN Function? The MEDIAN Function is categorized under Excel Statistical functions. The function will calculate the middle value of a given set of numbers. Median can be defined as the middle number of a group of numbers. That is, half the numbers return values that are greater than the median, and half…
What is a Bond Ladder? A bond ladder is an investment strategy that involves constructing a portfolio in which bonds or other fixed income securities mature continuously at equally spaced intervals. As the bonds closest to maturity expire, the investments are rolled over to the end. This keeps the investor’s position of holding bonds with…
What is the MODE Function? The MODE Function is categorized under Excel Statistical functions. MODE will calculate the most frequently occurring value from a list of supplied numbers. If there are two or more most frequently occurring values in the supplied data, the function returns the lowest of the values. In financial analysis, the function…
What is the MINA Function? The MINA function is categorized under Excel Statistical functions. The function will return the minimum value in a given list of arguments. From a given set of numeric values, it will return the smallest value. The MINA function compares numbers, text, and logical values as TRUE or FALSE. In financial…
