Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Creating Running Totals in Regular Ranges To create a running total in an Excel range that isn't formatted as an Excel table, you need to use a combination of absolute and relative references.

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.