Excel - Standard functions file

Standard operators (e.g. + - / *) plus basic functions (e.g. SUM, MIN, MAX, AVERAGE) plus other generic functions cover most MS Excel user needs. The reference file contains tens of working examples of those other generic functions and more advanced random number generation.

Download MS Excel function reference file  (361kB - downloaded 2301 times)

Contents



*   File includes array formula examples. However, try to avoid using array formulas.
**  Nowadays this can be done by 'underlying' Excel PowerPivot.
*** MS Excel 2016 offers the histogram as a new standard chart.

Sneak preview