[Preview Mode] All links and videos on this page are inactive

Array Formulas: Hidden Magic

Take your skills beyond the standard Excel formulas and discover the magic of array formulas, 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 practice files

Download the Arrays practice files (zip format)

Download the training notes

1.    Array Formulas: Step-by-Step Training Notes

2.   Basic Array Formulas

3.   Adding Logic To Arrays

4.   Array Logic exercise - solutions

5.   Using Arrays To Transpose Data

6.   Frequency Distribution Using Arrays

7.   Histograms Using Arrays


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