Running total in Excel with AI

Excel's AI features can help you perform a running total without writing a formula. Use the Quick Analysis tool for seamless data analysis.

Return a result between 2 values

How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.

Function MOD (Modulo) of Excel

The MOD function of Excel is beneficial in many situations, and you can use it as a result, as a logical test, or with conditional formatting

Round to 10, 25, or 50 cents with Excel

How to round up by 10, 25 or 50 in Excel? This article gives you all the formulae to do this job with Excel.

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.

How to round in k$ with Excel?

Discover 3 techniques to round numbers in k in Excel. Learn how to use Paste Special, divide by formula, and create custom number formats.

Select the top 5 by formula 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.

TOP 10 Most Useful Statistical Functions for Data Analysis

Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.

Percentage change in Excel

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.

What is the Most Common Value in your Excel document.

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

Calculate Moving Average in Excel

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

Understand the Standard Deviation

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

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.

The SUM function – All Tricks

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

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.

Displaying Negative Numbers in Parentheses in Excel

Discover how to format negative numbers in Excel with parentheses. Improve the readability of your data with this simple technique.

Round to the next decimal range

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

Running Total in Excel

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

Rounding to the Nearest Tenth or Hundredth with Excel

Learn how to round numbers to the nearest tenth or hundredth using a single formula in Excel. Discover the secret behind the ROUND function.