Welcome! Enter below articles or choose one from the menu above

Do Until Loop

In this article we are going to learn about programming DO UNTIL loops. First we are going to learn what loops are and why they are necessary. Then we are going to learn how to use a DO UNTIL LOOP.

Read more ...

Anova two factor with replication

Anova means Analysis of Variance. In this Excel tutorial you will teach yourself how to perform Anova in Excel. It will be Anova two factor with replication test.

Read more ...

How to compare columns to find duplicates?

In this lesson you will learn how to find duplicates in Excel. This is quick way to search bunch of data in just a second.

Read more ...

Correlation chart

Correlation helps to identify the pattern of change between two variables. It has two properties – strength and direction. It is a common statistics concept which can be easily represented in excel using a scatter plot and trend line.

Read more ...

Do while loop

In this article we are going to learn about programming DO WHILE loops. First we are going to learn what loops are and why they are necessary. Then we are going to learn how to use a DO WHILE LOOP.

Note: In excel VBA they are two types of DO LOOPS: DO WHILE and DO UNTIL. Our focus will be on the DO WHILE loop in this article

Read more ...