The SUMIF function calculates the sum of specific cells according to a criterion, like a product, country, seller's name, ...
Excel allows you to add icons in your cells to show the trend of your data. Nothing is complex with the conditional formatting tool.
The standard deviation helps you to have a better understanding of the result of your averages. In this article, all the explanations.
A running total is a very useful mathematical operation which is very simply to build in Excel.
Learn how to calculate a moving average in Excel. Use the AVERAGE function to smooth out data and identify trends.
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 formula to calculate the percentage of increase or decrease between 2 cells is very simple in Excel.
Learn the top 10 most useful Excel statistical functions for data analysis, with clear explanations and examples.