## Pivot Tables (Video)

A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.

## Tips for Better Pivot Tables with a Large Data Set (Video)

In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in

## Improve Your Pivot Table Workflow in Excel

In this quick video we take a look at how to improve your workflow around Pivot Tables in Excel. One of the best ways to

## How to Create a Named Range (Video)

In this video we’ll discuss What is a named range? How to create your first one How to use named ranges in a formula

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

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

## SMALL – Excel Function

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