Advanced Module 17
Array Formulas: Hidden Gold

Discover how to create multi-faceted formulas that solve problems that regular formulas can't. A vastly under-utilised part of Excel, some of the things you can achieve with arrays include controlling logic, transposing data and creating histograms and frequency distributions.

 

Download the training notes (PDF)

7.1    Training Notes

17.2   Basic Array Formulas

17.3   Adding Logic To Arrays

17.4   Array Logic exercise - solutions

17.5   Using Arrays To Transpose Data

17.6   Frequency Distribution Using Arrays

17.7   Histograms Using Arrays


Privacy Terms Contact
Copyright © Two Rivers Software Training. All Rights Reserved