Statistics

COUNT vs COUNTA vs COUNTBLANK in Excel: What’s the Difference?

COUNT counts numbers, COUNTA counts everything, COUNTBLANK counts the gaps. See the difference on a real list, then practise with a free online exercise.

Weighted and Exponential Moving Average in Excel

Give more weight to recent days: calculate a weighted moving average with SUMPRODUCT and an exponential one in Excel, and see which reacts faster.

GROUPBY function: The future of COUNTIF SUMIF

Find out how to build and use the GROUPBY function in Excel 365. Group data, calculate summaries, and update instantly.

Calculate Percentage Change in Excel

Learn how to calculate percentage change in Excel and gain valuable insights into your data trends and performance.

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.

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.

Calculate Moving Average in Excel

Calculate a moving average in Excel with the AVERAGE function: smooth out daily spikes, see the real trend on your chart, and avoid the $ trap.

Understand the Standard Deviation

Learn to calculate and interpret standard deviation to better understand your average results.

Statistics

Categories

Statistics