The Aggregate Function in Excel 2010

Описание к видео The Aggregate Function in Excel 2010

Learn how to use some of the new Aggregate function's 19 calculations and options to create a result that can exclude hidden rows, filtered rows, and cell errors. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values. In this video, you will learn the benefits of using the Aggregate function over the Subtotal function.

Комментарии

Информация по комментариям в разработке