Interested in Learning Excel? Click Here for 50% off our Bestselling Course

## XLOOKUP – Excel Function

What it does: The XLOOKUP() Function allows you to look up and return values in corresponding columns or rows (!!). I have an

## RANDBETWEEN – Excel Function

What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than

## RAND – Excel Function

What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother

## AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

## SMALL – Excel Function

What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()

## LARGE – Excel Function

What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function

## COUNTIFS – Excel Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:

## DATE – Excel Function

What it does: The DATE() formula returns the serial number that represents a particular date. Plain English: This formula

## IF – Excel Function

What it does: The IF() Function evaluates an argument. If the argument is TRUE, the formula does one thing. If the argument