What is the TRANSPOSE Function? The TRANSPOSE Function is categorized under Excel Lookup and Reference functions. It will flip the direction of a given range or array. The function will convert a horizontal range into a vertical range and vice versa. In financial analysis, the TRANSPOSE function is useful in arranging data in our desired…
What is the SMALL Function? The SMALL Function is categorized as an Excel Statistical function. It will return numeric values based on their position in a list, ranked by value. Essentially, it calculates and returns the k smallest value in a dataset. In financial analysis, the SMALL function can be useful in finding the smallest value…
What is the TODAY Function? The TODAY Function is categorized under Excel Date and Time functions. It will calculate and give the current date. It is updated continuously whenever a worksheet is changed or opened by a user. The function’s purpose is to get today’s date. As a financial analyst, the TODAY function can be…
What is the YIELDMAT Function? The YIELDMAT Function is categorized under Excel FINANCIAL functions. It will return the annual yield of a security that pays interest at maturity. In financial analysis, YIELDMAT can be useful in calculating the yield on a bond that pays interest at maturity. The annual yield is the total increase in…
What is the PROPER Function? The PROPER Function is categorized under Excel Text functions. PROPER will capitalize the first letter in a text string and any other letters in text that follow any character other than a letter. In financial analysis, we often import data from external sources. The PROPER function will help us convert…
What is the TYPE Function? The TYPE Function is categorized under Excel Information functions. It will return the type of a given value. The function will return a numeric code representing the type of value. As a financial analyst, we use many Excel functions in our financial analysis. The TYPE function is useful when the…
What is the VALUE Function? The VALUE Function is categorized under Excel Text functions. It will convert a text string that represents a number into a number. Thus, the function will convert text that appears in a recognized format (a number, date, or time format) into a numeric value. In financial analysis, the VALUE function…
What are Off-the-Run Treasuries? Off-the-run Treasuries refer to debt instruments issued by the US Treasury that are not the latest offering (of such debt instruments). Conversely, debt instruments issued by the US Treasury that are the latest offering (of such debt instruments) are known as on-the-run Treasuries. The market for off-the-run Treasuries is the secondary…
UPPER Function – How to Convert Text to All Capital Letters The UPPER Function is an Excel Text function, that will convert text to all capital letters (UPPERCASE). Thus, the function converts all characters in a supplied text string into upper case. In financial analysis, we often import data from external sources. The UPPER function…
What is the TRUE Function? The TRUE Function is categorized under Excel Logical functions. It will return the logical value of TRUE. The function is equivalent to using the Boolean value TRUE directly in a formula. In financial analysis, the TRUE function is often used with other logical functions such as IF, ERROR, etc. It…
