Following is the list of all courses tagged as covering analysis by function and formula.  These courses will cover the use of the summarisation and aggregation functions, such as FILTER, FREQUENCY, SUMIF, SUMIFS, COUNTIF, COUNTIFS and the use of dynamic array formulas to calculate things such as weighted averages.  They may also demonstrate effective summarisation functions, such as BYCOL and BYROW.