Excel's "trimmean" function calculates the mean of the interior of a data set. You can tailor the function to calculate the interquartile mean.

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 ...