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.

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

How to Lock Numeric Values in Excel. Microsoft Excel is a powerhouse when it comes to calculating numbers. With its vast assortment of functions, you can construct formulas to derive virtually any ...

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.