Month: December 2022

  • Excel Functions You’ve Never Heard of – Least Popular Excel Functions

    As 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…

    Read More: Excel Functions You’ve Never Heard of – Least Popular Excel Functions
  • Excel Tutorial – IMSUB

    The 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:…

    Read More: Excel Tutorial – IMSUB
  • Excel Tutorial – FVSCHEDULE

    The 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:…

    Read More: Excel Tutorial – FVSCHEDULE
  • Excel Tutorial – DBCS

    The 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…

    Read More: Excel Tutorial – DBCS
  • Excel Tutorial – CUBEKPIMEMBER

    The 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…

    Read More: Excel Tutorial – CUBEKPIMEMBER
  • Excel Tutorial – BESSELI

    The 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…

    Read More: Excel Tutorial – BESSELI
  • Excel Tutorial – FactDouble

    The 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…

    Read More: Excel Tutorial – FactDouble
  • Excel Tutorial – Evaluate

    The 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.…

    Read More: Excel Tutorial – Evaluate
  • Excel Tutorial – ROMAN

    The 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:…

    Read More: Excel Tutorial – ROMAN
  • Excel Tutorial – BAHTTEXT

    The BAHATTEXT function in Microsoft Excel is a financial function that converts a number to text in Thai Baht currency format. Here’s a step-by-step guide on how to use the BAHATTEXT function: Open your Microsoft Excel spreadsheet and select the cell where you want to display the converted number. Type the following formula into the…

    Read More: Excel Tutorial – BAHTTEXT