Functions

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

In the previous blog, we did some of the Dynamic Array Functions like the UNIQUE and SORT Function of Excel. The FILTER function in excel… 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

Dynamic Array Formulas are real game changers when one knows how to use them! They are compatible with Microsoft Excel 365 and Excel 2022 versions.… Read Article

In the recent blogs, we did the usage of AVERAGE and STDEV.P Function in Excel. The parameters of NORM.DIST Function uses these two functions. Let… Read Article

In the earlier blogs, we did the usage of Relative and Absolute Referencing. Mixed Referencing is the third type of referencing we use while copying… Read Article