Array Formulas

$79.00 / year

Course Overview: 

This course covers array formulas. Array formulas are very powerful and enable you to perform calculations you can’t do with standard worksheet functions.

Key Topics:

  • What an array formula is and how to use them
  • How to find the smallest numbers in a range with array formulas
  • How to create custom functions such as MEDIANIF or STDEVIF
  • Using arrays to find unique entries in a range
  • How to use the TRANSPOSE function as an Array Function
  • The value of the FREQUENCY Function
  • How to multiply and invert matrices with arrays
  • The Linest Function

Who Will Benefit?

Any professional that uses Microsoft Excel. Array formulas and functions enable you to unleash the full power of Excel. This course will give you a solid understanding of array formulas and functions.