Formula to Remove the VAT in Excel

How to remove VAT? To solve this, you don't need a specific Excel function. A combination of additions and divisions do the job.

How to do a Cube Root in Excel?

There is no cube root function in Excel. But there is a solution to perform a cube root calculation with another Excel function.

Select the 5 top-bottom values in Excel

With the new Excel CHOOSEROWS function, it's easy to extract the top / bottom rows of your data. Let's discover how to build it.

The most useful Statistics Excel functions

Excel offers many statistical functions that are easy to use. This article will show you how to use them to analyze your data.

Percentage formula (increase or decrease)

What is the formula to calculate the percentage of increase or decrease between 2 cells is very simple in Excel.

How to calculate VAT in Excel?

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

Study Case with Excel Statistics functions

How to use Excel statistics functions? In this study case, we will analyze the wages of all the employees and what is the result.

Moving Average in Excel

Moving average is the easiest way to analyse your data and estimate forecast. Build a moving average is very easy with Excel

3D Formula in Excel

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

Dynamic SUM in Excel

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.

Calculate Percentage Increase with Excel

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

Round to the next decimal range

Discover the technique that will allow you to round up or down to the nearest decimal range.

Running Total in Excel

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

Round to the Nearest Ten, Hundred, Multiple..

You can easily round your number to the nearest tenth, hundredth or thousandth with the function ROUND

Most common number in my spreadsheet

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