Excel Unlocked

In the previous blog, we used the MMULT Function to multiply two matrices. In this blog, we will learn another important function that works on a matrix. Matrix is simply a range of cells in Excel. MINVERSE Function in Excel is a type of Mathematical Function. So let's get started....

MINVERSE Function in Excel - Matrix Inverse In the previous blog, we used the MMULT Function to multiply two matrices. In this blog, we will learn another important function that works on a matrix. Matrix

In the previous blog, we did the usage of the T Function. In this blog, we would cover the entire work of the N Function in Excel. N Function is a type of Information function in Excel....

N Function in Excel - Usage and Examples In the previous blog, we did the usage of the T Function. In this blog, we would cover the entire work of the N Function in Excel. N Function is a type of Infor

MMULT Function in excel is an essential function. It can be categorized under Mathematical Functions of Excel. Let us see the usage of this function....

MMULT Function in Excel - Matrix Multiplication MMULT Function in excel is an essential function. It can be categorized under Mathematical Functions of Excel. Let us see the usage of this function. Whe

No matter how much of an expert we become, there are errors or bugs in every field we are working in. While using Formulas and Functions in Microsoft Excel, we end up facing errors as formula results. ERROR.TYPE Function in excel is used when we are having errors or we want to check for any error. Let us see how the function works!...

ERROR.TYPE Function in Excel - Error Codes,Examples No matter how much of an expert we become, there are errors or bugs in every field we are working in. While using Formulas and Functions in Microsoft Excel, we

In the previous blog, we did the usage of the GCD formula to calculate the Greatest Common Divisor. LCM Function in Excel is also a type of Mathematical Function. The function is the easiest to use. Let's start learning....

LCM Function in Excel - Usage, Errors Resolving In the previous blog, we did the usage of the GCD formula to calculate the Greatest Common Divisor. LCM Function in Excel is also a type of Mathematical Functio

GCD Function in Excel is used in calculations. It is an essential type of Mathematical Function in Excel. So let's start learning the usage of the function....

GCD Function in Excel - Usage with Examples GCD Function in Excel is used in calculations. It is an essential type of Mathematical Function in Excel. So let's start learning the usage of the function.

In the previous blog, we did the usage of the SQRT Function. In this article, we would cover the practical applications the SQRT Function in Excel. SQRT Function is a type of Mathematical Function, which is why it can be used in many mathematical formulas and concepts where we have the need to find the square root of a number....

Applications of SQRT Function in Excel In the previous blog, we did the usage of the SQRT Function. In this article, we would cover the practical applications the SQRT Function in Excel. SQRT Fu

The SQRT Function in Excel is a type of Mathematical function. The Function is useful for mathematical calculations. So let's start learning....

SQRT Function in Excel - Usage with Examples The SQRT Function in Excel is a type of Mathematical function. The Function is useful for mathematical calculations. So let's start learning. When to use

In our previous articles, we implemented the MODE and FREQUENCY Function in excel. The MEDIAN Function is an essential Statistical Function. Let's see the implementation of the MEDIAN Function in Excel....

MEDIAN Function in Excel - A Statistical Parameter In our previous articles, we implemented the MODE and FREQUENCY Function in excel. The MEDIAN Function is an essential Statistical Function. Let's see the imple

In the previous blog, we did the usage of the MODE Function in Excel. The FREQUENCY Function is also an essential type of Statistical Function. The Function is used in statistical analysis. Let's understand the working of the FREQUENCY Function in Excel....

FREQUENCY Function in Excel - Statistical Function In the previous blog, we did the usage of the MODE Function in Excel. The FREQUENCY Function is also an essential type of Statistical Function. The Function is

The CEILING.MATH Function is one of the important Mathematical Functions in Excel. The Function can be used in Excel 2003 and later on Excel Versions. Let's see how this function works When to Use CEILING.MATH Function? The CEILING.MATH Function finds out the upper-value round-off for a number. For Example:- =CELING.MATH(23.19) When we apply CEILING>MATH Function with 23.19 as input parament, it returns 24....

CEILING.MATH Function in Excel - Usage with Examples The CEILING.MATH Function is one of the important Mathematical Functions in Excel. The Function can be used in Excel 2003 and later on Excel Versions. Let's see

In the previous blog, we did the usage of the ISODD function in Excel. In this blog, we would cover the implementation of the ISEVEN Function in Excel. The ISEVEN Function is a type of Information function in excel. The information function returns some type of information regarding the cell content. The ISEVEN Function can be used in conditional formatting also....

ISEVEN Function in Excel - Usage with Examples In the previous blog, we did the usage of the ISODD function in Excel. In this blog, we would cover the implementation of the ISEVEN Function in Excel. The ISEV