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…
What is the VAR.P Function? The VAR.P Function is categorized under Excel Statistical functions. This function will return the variance of a given set of values. It was introduced in MS Excel’s 2010 version. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the…
What are the LOOKUP vs VLOOKUP Functions? Knowing the difference between LOOKUP vs VLOOKUP Functions in Excel enables users to take full advantage of the benefits of using each function. The LOOKUP function allows a user to search for a piece of data in a row or column and return a corresponding piece of data…
