Microsoft Excel 2010 – Array Formula Examples Tutorial 2 of 2

In the second video tutorial on Array formulas in Excel, we illustrates several examples to illustrate the power and magic of array formulas. Array formulas act on multiple cells at the same time and produce multi-cell output as well. By writing one formula, one can generate a complete table.

In this video, we give several examples of Array formulas such as summing a range that contains errors, summing the nth largest value in a range, average excluding zeros. The power of arrays should be apparent from these formulas.

Time Management – Sales Productivity’s Black Hole

API quota exceeded. You can make 500 requests per day.

Working Toward the Paperless Office

The Global Value Chain

Follow Through

Shop Efficiency Series – Eliminating Paperwork for Efficient Office Management

You May Also Like