Excel is a great software if you want to take your inventory system or management forward. It’s a great tool for small businesses that automates processes that are usually done by hand.

Read More

The Chi-Square test is a statistical test used to determine if there is a significant association between two categorical variables. In this Excel tutorial, you will learn how to calculate the Chi-Square test in Excel.

Read More

Factorials are widely used in Mathematical analysis. It has a simple calculation in Mathematical perspective and can be applied to real-world phenomena as well. However, factorial calculations can be executed with a simple built-in function in Excel, which is pretty straightforward.

Read More

Anova means Analysis of Variance. In this Excel tutorial, you will teach yourself how to perform Anova.

Read More

If we take samples from two populations and wish to ascertain whether the variations of both samples are equal, we can use the Variation Ratio test also known as the F-Ratio test to determine this.

Read More

In this Excel tutorial lesson, you will learn what skewness is and how to calculate skewness in Excel application.

Read More

In this Excel tutorial lesson, you will learn how to find the largest number, whether negative or positive, in a range of values. This is not obvious, but you need just one formula.

Read More

In this tutorial, you will teach yourself how to sum only positive or only negative numbers from your range.

Read More

In this Excel tutorial you will teach yourself how to count occurences of a character in a spreadsheet.

Read More

In this Excel tutorial, you will learn how to create a formula which returns the last value in a column.

Read More