Statistics

How to use the power of Statistical Excel’s functions? Many posts and many examples for you

Basic calculations with Excel

How to do a calculation or a formula in Excel? It's very simple but you have a few rules to know to avoid mistakes.

In Excel, you can build 3D formulas by making a relationship through many worksheets. Let's see how to build a 3D formula.

The MOD function of Excel is very helpful in many situations and you can use it as a result, as logical test or with condiitonnal formating

SUM is the most used Excel function. There is nothing complex to use this function but there is also tricks behind this function

With Excel, you can round easily your data in k$ or m$ without creating a single formula. What you have to do is to create a custom format number

There is 2 methods to create a dynamic SUM in Excel. The first one uses the technique with a Table, the second one uses the function INDEX.

If you want to turn your negative numbers with parentheses, you have to create a custom number format. Read how to do this here.

How to calculate the pourcentage of increase (or decrease) between 2 months

How to calculate VAT in Excel? It's very easy and doesn't need a specific function. Many examples in this article.

With Excel, you can easily round your numbers to the nearest tenth, hundredth, or thousandth. The technique explains in this article.

The standard deviation helps you to have a better understanding of the result of your averages. In this article, all the explanations.

You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL

A running total is a very useful mathematical operation which is very simply to build in Excel.

How to round up or down for decimals, like for instance, 10 cents, 25 cents, 50 cents? The different formulae explain in this article

Learn how to calculate a moving average in Excel. Use the AVERAGE function to smooth out data and identify trends.

1 2