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
- How to create a pivot table using a named range

Skip to content
# Tag: Pivot Tables

## How to Create a Named Range

## Pivot Table Tutorial with Larger Data Set

## RANDBETWEEN – Excel Function

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
- How to create a pivot table using a named range

In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in the values, columns, rows, and filter boxes, how to format your pivot table, and some ways to spice up your visualizations.

**What it does: **The RANDBETWEEN() Function generates a random number between two integers.

**Plain English**: Rather than generating a random number between 0 and 1, RANDBETWEEN() generates an integer between a given range of integers that you provide. For example, you may want to pick 6 random lottery numbers between 1 and 35. This formula could help generate those.

**Arguments: RANDBETWEEN(lower number, higher number)**

- Lower number – the lowest integer possible you want to generate
- Higher number – the highest integer possible you want to generate

Blog Posts using RANDBETWEEN()

- Article 1

Videos using RANDBETWEEN()

- Video 1