Function Categories

• Database - analyse, count, filter data stored in databases.

• Date and Time - enter and calculate dates and times.

• Engineering - complex numbers, conversions and measurements.

• External - retrieve data from external sources.

• Financial - depreciation, accrued interest, annuities, rates of return and future values.

• Information - identify cells and determine any errors or blanks.

• Logical - conditional analysis and logic.

• Lookup and Reference - locate cell references or specific values.

• Maths and Trigonometry - rounding, ranking, probabilities, logarithms, and much more.

• Statistical - standard deviation, distributions, square roots, average, median.

• Text - entering, searching, replacing and manipulating text strings.