Functions

In Microsoft Excel, we have two different types of reference styles. By default, the reference style that everybody uses is the A1 reference style while… Read Article

In the previous article, we learned about how to make dynamic named ranges with the help of the OFFSET function. The disadvantage of the OFFSET… Read Article

Today, we are going to learn one of the advanced and important topics of excel which is to create dynamic named ranges. Let us see… Read Article

Previously, we implemented the COS Function. In this blog, we would learn the fundamentals of the SEC Function. It is an important type of Trigonometric… Read Article

In the earlier articles, we learned to find the Sin and Cosine of the angles using the functions in Excel. In this blog, we would… Read Article

In the previous blog, we implemented the SIN Function. In this blog, we would now learn another important Mathematical Function, which is the COS Function… Read Article

The SIN Function in Excel is an essential type of Mathematical Function The function is easiest to learn and implement. So let us begin learning… Read Article

Previously, we implemented the CHISQ.DIST Function. In this blog, we will learn another important function that is closely related is CHISQ.INV Function in Excel. So… Read Article

In the earlier blogs, we implemented the CHISQ.DIST Function. In this blog, we will now learn another related function known as CHISQ.DIST.RT. Let us see… Read Article

In the previous blogs, we implemented the NORM.DIST and BINOM.DIST Function. In this blog, we would learn another type of distribution with the help of… Read Article

In the previous blog, we implemented the COVARIANCE.S Function. In this article, we are going to implement another interesting and useful function which is COVARIANCE.P… Read Article

The COVARIANCE.S Function is an important Staticlal Function of Excel. It is easy to learn as well as implement. The Function has a very good… Read Article