## How to Merge Cells in Excel (with Video)

Merging cells in Excel is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to

## How to Use the SUMIF Function

The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the

## Learn the LEFT, RIGHT, and MID Functions in Excel

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

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

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

## How to use Paste Special in Excel

Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values

## AVERAGE – Excel Function

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