How to Calculate a Trimmed Mean in Excel. A trimmed mean is much like a standard mean, which you can derive in Excel using the AVERAGE function. However, instead of using all of the data points to ...