## How to use the Substitute Function (Video)

If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:

## Using CONCAT and CONCATENATE in Microsoft Excel

While the CONCATENATE and CONCAT functions seem like they might be the same thing, there are small differences between the

30 Jun

## Top 5 Things to Know in Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

06 Oct

## 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

## Dates in Excel – Part 1

Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the

30 Sep

## 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