Functions

The RANK Function is one of the most easiest and useful excel functions. In this blog, we would learn the syntax and arguments required by… Read Article

In the previous blog, we learned what are named ranges in excel, how to use them, the types of named ranges, and a lot more.… Read Article

Named Ranges play a fundamental role in defining efficient and easy-to-read excel functions and formulas. It can also be used in Data Validation and hyperlinks.… Read Article

In the previous blog, we did the usage of OR Function. The XOR stands for exclusive OR and is very different from the OR Function.… Read Article

The T Function of Excel is used in exceptional cases. It is a type of Worksheet function. It is one of the most straightforward functions… Read Article

In the previous blog, we focused on understanding the basic usage of the SUMPRODUCT formula, its syntax and arguments, and some of the functions it… Read Article

The SUMPRODUCT function in Excel is a very versatile function that can replace the SUM Function, COUNTIF Function, and SUMIF Function. The SUMPRODUCT Function can… Read Article

In the previous blogs, we did the usage of INDEX and MATCH Function in Excel. The combined INDEX and MATCH Function use enables us to… Read Article

In the previous blog, we did the basic usage of the FILTER function in Excel. In this blog, we will learn some of the most… Read Article

UNIQUE Function in Excel is a quite easy-to-use function and is one of the useful Dynamic Array Functions. The usage of the UNIQUE Function is… Read Article

There can be a number of ways to sort the data in excel. We can do it either by using Excel sorting features or we… Read Article