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…
What is the WORKDAY.INTL Function? The WORKDAY.INTL Functionis categorized under Excel Date and Time functions. It is a robust modification of the WORKDAY function, as it works with customizable weekend parameters. WORKDAY.INTL will provide us with a date that is N working days in the future or in the past and allows us to determine…
What is the VARA Function? The VARA Function is categorized under Excel Statistical functions. VARA is very similar to the VAR function. It will calculate the sample variance of a given set of values. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the…
