-
Excel Tutorials – TEXTSPLIT
Read More: Excel Tutorials – TEXTSPLITUnderstanding the Excel TEXTSPLIT Function The TEXTSPLIT function (available in Excel 365 and Excel 2021) splits a text string into multiple columns and/or rows based on specified delimiters. It simplifies tasks that previously required complex formulas using LEFT, RIGHT, MID, FIND, or TEXT TO COLUMNS. Syntax =TEXTSPLIT(text, [col_delimiter], [row_delimiter], [ignore_empty], [match_mode], [pad_with]) text – The string you want to split. col_delimiter (optional) – Character(s)…
-
Excel Functions You’ve Never Heard of – Least Popular Excel Functions
Read More: Excel Functions You’ve Never Heard of – Least Popular Excel FunctionsAs a popular spreadsheet software, Microsoft Excel has a wide range of functions that can help users perform various tasks and calculations. While some functions like SUM and AVERAGE are widely used on a daily basis, there are many other functions that are not as commonly used. In this blog post, we will take a…
-
Excel Tutorial – IMSUB
Read More: Excel Tutorial – IMSUBThe IMSUB function in Microsoft Excel is an image function that subtracts two images. It takes two arguments: the first image and the second image. The IMSUB function returns an image that is the result of subtracting the second image from the first image. Here’s a step-by-step guide on how to use the IMSUB function:…
-
Excel Tutorial – FVSCHEDULE
Read More: Excel Tutorial – FVSCHEDULEThe FVSCHEDULE function in Microsoft Excel is a financial function that calculates the future value of an investment based on a schedule of periodic payments and interest rates. It takes three arguments: the rate of interest, the number of periods, and the payment schedule. Here’s a step-by-step guide on how to use the FVSCHEDULE function:…
-
Excel Tutorial – DBCS
Read More: Excel Tutorial – DBCSThe DBCS function in Microsoft Excel is a text function that returns the double-byte character set (DBCS) value of a character. It takes a single argument: the character for which you want to get the DBCS value. Here’s a step-by-step guide on how to use the DBCS function: Open your Microsoft Excel spreadsheet and select…
-
Excel Tutorial – CUBEKPIMEMBER
Read More: Excel Tutorial – CUBEKPIMEMBERThe CUBEKPIMEMBER function in Microsoft Excel is a database function that returns a key performance indicator (KPI) from a cube. It takes three arguments: the cube name, the KPI name, and the member name. Here’s a step-by-step guide on how to use the CUBEKPIMEMBER function: Open your Microsoft Excel spreadsheet and select the cell where…
-
Excel Tutorial – BESSELI
Read More: Excel Tutorial – BESSELIThe BESSELI function in Microsoft Excel is a math and trigonometry function that calculates the modified Bessel function of the first kind. It takes two arguments: the number for which you want to calculate the Bessel function, and the order of the function. Here’s a step-by-step guide on how to use the BESSELI function: Open…
-
Excel Tutorial – FactDouble
Read More: Excel Tutorial – FactDoubleThe FACTDOUBLE function in Microsoft Excel is a math and trigonometry function that calculates the double factorial of a number. The double factorial of a number is the product of all the integers from 1 up to the number, but only counting every other number. For example, the double factorial of 6 is 6 x…
-
Excel Tutorial – Evaluate
Read More: Excel Tutorial – EvaluateThe EVALUATE function in Microsoft Excel is a formula evaluation function that allows you to execute a formula or expression as a string. Here’s a step-by-step guide on how to use the EVALUATE function: Open your Microsoft Excel spreadsheet and select the cell where you want to display the result of the formula or expression.…
-
Excel Tutorial – ROMAN
Read More: Excel Tutorial – ROMANThe ROMAN function in Microsoft Excel is a math and trigonometry function that converts a number to Roman numerals. Here’s a step-by-step guide on how to use the ROMAN function: Open your Microsoft Excel spreadsheet and select the cell where you want to display the converted number. Type the following formula into the selected cell:…
