Lookup & Reference(Microsoft Excel Function)

Includes how to use the SORT function, examples of its use, and how it differs from the SORT function.

Logical(Microsoft Excel Function)

Includes usage of the REDUCE function and examples of its use.

Math & Trig(Microsoft Excel Function)

Includes how to use the RANDARRAY function, examples of its use, and how it differs from the RANDBETWEEN function.

Logical(Microsoft Excel Function)

Includes usage of the LAMBDA function and examples of its use.

Statistical(Microsoft Excel Function)

Includes usage of the COUNTA function and examples of its use.

Text(Microsoft Excel Function)

Includes usage of the CONCAT function and examples of its use.

Lookup & Reference(Microsoft Excel Function)

Includes information on the VSTACK and HSTACK functions, examples of their use, and examples of combining them with o ...