-
Excel Tutorials – LET
Read More: Excel Tutorials – LETExcel LET Stop repeating yourself. Start naming your intermediate calculations. What Even IS LET? Alright, picture this. You’ve got this formula. It calculates something. And in the middle of it, you need the same sub-calculation three different times. Like, you’re calculating a discount, and you need “price * quantity” for the subtotal, then again for…
-
Excel Tutorials – LAMBDA
Read More: Excel Tutorials – LAMBDAWhat Even IS LAMBDA? Alright, picture this. You’ve got this formula you use all the time. Maybe it calculates a letter grade from a percentage. Maybe it pulls the first name out of a full name. You copy it from cell to cell, sheet to sheet, and every time you tweak one little thing you…
-
Excel Tutorials – TEXTSPLIT
Read More: Excel Tutorials – TEXTSPLITWhat Is TEXTSPLIT? 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 the Text to Columns wizard. Syntax =TEXTSPLIT(text, [col_delimiter], [row_delimiter], [ignore_empty], [match_mode], [pad_with]) text — The…
-
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…
