Select Page

## How to remove file extension from filename in Excel

If you want to remove file extension from full file names, first you need to locate the period (.) which separates the filename and the extension. This action is fairly easy to do if your file names do not contain any periods other than the extension separator....

## Function: POWER

POWER is a Math and Trigonometry function that can calculate and returns the result of a number raised to a specified power. For other methods and finding different exponents, please see: How to find square root in Excel. In this guide, we’re going to show you how to...

## SQRT Excel Function

The Excel SQRT function is a Math and Trigonometry formula that can calculate and return the positive square root of the input value. This is essentially the formula approach to finding square root of a number in Excel. For other methods and finding different...

## Excel MOD Function

The Excel MOD function is a Math and Trigonometry formula which calculates and returns the remainder after the number is divided by the divisor. This is called a modulo operation. This operation sees frequent use in math problems and building a model, and you can use...

## How to count Excel TRUE FALSE values

TRUE and FALSE are logical (Boolean) values in Excel. They are special values that can be used in formulas as is – although both values looks like a regular text string, you can include them in formulas without the use of double quotes. This behavior may seem...

## Function: MINA

The MINA Excel function returns the minimum value in an array or range of cells. The function works similar to the MIN function. While the MINA function includes logical values in how it evaluates the values, the MIN function ignores them. In this guide, we’re going...

## Function: MAXA

The MAXA Excel function returns the maximum value in an array or range of cells. This function works in a similar way as the MAX function. While the MAXA includes logical values in the results, the MAX function ignores them. In this guide, we’re going to show you how...

## NORM.S.INV Function in Excel

The Excel NORM.S.INV function is a Statistical formula that calculates and returns the inverse of the standard normal cumulative distribution with a given probability. Frequently used in statistics and data analysis, the standard normal distribution is a normal...

## NORM.INV Function in Excel (NORM INV)

The Excel NORM.INV (Also known as NORM INV or NORMINV) function is a Statistical formula that calculates and returns the inverse of the normal cumulative distribution of a probability for a given mean (average) and standard deviation. In this guide, we’re going to...