Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

It took all of 20 seconds to create and format a table in Excel. How to use a Total row for quick calculations. Next, ... Only the items with values between 200 and 300 in the Jan column now appear.