Math and statistical functions
The most used functions in Excel are math and statistical functions such as SUM, COUNT, AVERAGE, MIN, MAX, SUMIFS, COUNTIFS, AVERAGEIFS, and ABS. They allow people to grab quick insights from a range of numeric data. SUM is, perhaps, the most used Excel function as it allows people to quickly see the sum of a range of cells.
In this section, we will cover the most well-known math functions that a data analyst and dashboard creator must be well versed in. You may perceive them as very simple functions that do not require much explanation, but their importance warrants we cover them. Also, when combined with dynamic array functions, which we will learn about in Chapter 7, Dynamic Array Functions and Lambda Functions, they become very formidable tools.
Every data analyst using Excel should be proficient in using the following math and statistical functions:
SUMSUMIFSCOUNTCOUNTIFSMINMAXAVERAGE
We will explore...
