Excel Unlocked

Excel Unlocked ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all other

In the previous blog, we used the MMULT Function to multiply two matrices. In this blog, we will learn another important...
08/08/2022

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

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...
31/07/2022

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

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 se...
30/07/2022

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 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 Formul...
28/07/2022

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!...

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 Exce...
25/07/2022

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

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...
24/07/2022

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 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 ...
23/07/2022

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

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 ...
20/07/2022

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

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 S...
10/07/2022

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

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 o...
09/07/2022

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

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 200...
08/07/2022

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

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 o...
08/07/2022

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

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

Address

Ahmedabad

Telephone

+919879513331

Website

Alerts

Be the first to know and let us send you an email when Excel Unlocked posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Excel Unlocked:

Shortcuts

Share

Category