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