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.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

The Microsoft Excel Status Bar is now more advanced than before with the new ability to copy and paste values.

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by ...

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.