Functions

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… Read Article

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.… Read Article

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… Read Article

The ISODD function in excel is one of the Information functions in Excel. The information function returns information regarding the cell content we pass as… Read Article

Mode is a handy parameter in statistical analysis. It is the term that occurs most frequently in a set of values. MODE Function helps us… Read Article

A Hyperlink is used to directly link the cell of an excel worksheet to different cells, named ranges, hard drive files, or URLs. We have… Read Article

In the previous blog, we learned about the RANK Function. RANK.AVG function in excel is an updated version of the RANK Formula. RANK.AVG function was… Read Article

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