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.
Statistics
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 Insert Icons in your cells
Excel allows you to add icons in your cells to show the trend of your data. Nothing is complex with the conditional formatting tool.
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
SUMIF Function in Excel
The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...
Running Total in Excel
A running total is a very useful mathematical operation which is very simply to build in Excel.
Understand the Standard Deviation
Calculate the standard deviation helps you to analyze the result of your AVERAGE calculation.
