Download Excel File: https://excelisfun.net/files/EMT1744.xlsx
Learn how to calculate the average while excluding the min and max values. See how to use TRIMMEAN function to exclude a given percentage of high and low data. points.

Trimmed Mean Calculation (Trimmean Function)
1. (00:00) Introduction
2. (00:23) Formula #1: SUM, MIN, MAX and COUNT aggregate functions.
3. (01:03) Formula #2: Learn how to use trimmean function to exclude a given percentage of high and low data points.
4. (02:09) Formula #3: TRIMMEAN to exclude only max and min values.
5. (02:27) Formula #4: How to enter multiple arguments into one argument using parentheses.
6. (03:23) Formula #5: AGGREGATE to simultaneously get MIN, MAX and SUM. See array formula tricks.
7. (04:54) Formula #6: LARGE and SEQUENCE functions inside AVERAGE function.
8. (05:51) Summary, Closing and Video Links