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…
The TRIM function in Excel removes extra spaces from text, leaving only single spaces between words. It cleans up data by eliminating leading, trailing, and intervening spaces, useful for data imported from other sources. The function uses the formula =TRIM(text) and only removes ASCII space characters. TRIM is essential for text normalization but does not…
Option Profit/Loss Graph Maker This option profit/loss graph maker lets the user create option strategy graphs on Excel. Up to ten different options, as well as the underlying asset can be combined. As well as manually being able to enter information, a number of pre-loaded option strategies are included in this workbook. To use these…
What is the VAR.S Function? The VAR.S Function is categorized under Excel Statistical functions. This function will return the variance of a sample. It was introduced in Excel’s 2010 version. As we know, variance is a statistical measure used across a set of values to identify the amount that the values vary from the average…
