The SUBSTITUTE function in Excel replaces occurrences of specified text within a string. Its syntax is =SUBSTITUTE(text, old_text, new_text, [instance_num]), where instance_num specifies which occurrence to replace. Unlike the REPLACE function, which targets a position within a string, SUBSTITUTE replaces specified text regardless of its position. It is case-sensitive and useful for cleaning and modifying…
What is Excel ISBLANK Function? The ISBLANK Function is an Excel Information function that returns true if the argument cell has no information in it. ISBLANK checks a specified cell and tells us if it is blank or not. If it is blank, it will return TRUE; else, it will return FALSE. The function was introduced in…
What is the STDEV.S Function? The STDEV.S Function is an Excel Statistical function that will calculate the standard deviation that is based on a sample of the population. It will ignore logical values and text. While doing financial analysis, the STDEV.S function can be useful in, for example, measuring the income standard deviation representative of…
What is the STDEV.P Function? The STDEV.P Function is categorized under Excel Statistical functions. STDEV.P will calculate the standard deviation that is based on an entire population given as arguments. It will ignore logical values and text. As a financial analyst, the STDEV.P function can be useful in, for example, calculating deviations in revenue. Portfolio…
What is the TBILLYIELD Function? The TBILLYIELD Function is categorized under Excel FINANCIAL functions. It will calculate the yield on a Treasury bill. In financial analysis, TBILLYIELD can be useful in calculating the yield on a Treasury bill when we are given the start date, end date, and price. Formula =TBILLYIELD(settlement, maturity, pr) The TBILLYIELD…
What is the TBILLPRICE Function? The TBILLPRICE Function is categorized under Excel FINANCIAL functions. The function will calculate the fair market value of a Treasury bill / bond. In financial analysis, TBILLPRICE can be useful in determining the value of a bond and deciding if an investment should be made or not. It helps calculate…
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…
